Malaysia TV Program Guide grabber for Mythtv

First of all have to determine the sourceid from.. the MySQL.. and make it look like this one..

# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3905
Server version: 5.0.45 Source distribution
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> use mythconverg;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> select sourceid,name,xmltvid from channel;
+----------+------+-----------------------+
| sourceid | name | xmltvid               |
+----------+------+-----------------------+
|        2 | TV1  | M038-101.astro.com.my | 
|        2 | TV3  | M046-103.astro.com.my | 
|        2 | NTV7 | M036-107.astro.com.my | 
|        2 | 8TV  | M057-708.astro.com.my | 
|        2 |      |                       | 
|        2 | TV9  |                       | 
+----------+------+-----------------------+
6 rows in set (0.00 sec)

and this the bash file that i use to run it daily..

#!/bin/sh
#DATE=`date '+%d/%B/%y'
DATE=`date '+%Y%m%d'`
TOMORROW=`date -d1day '+%Y%m%d'`
cd /home/mythtv/mythguide/update
# TV1
wget http://mythastro.hostrator.com/M038-101.astro.com.my_$DATE.xml --output-document M038-101.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M038-101.astro.com.my_$DATE.xml > M038-101.astro.com.my1_$DATE.xml
mythfilldatabase --update --refresh-all --file 2 M038-101.astro.com.my1_$DATE.xml


wget http://mythastro.hostrator.com/M038-101.astro.com.my_$TOMORROW.xml --output-document M038-101.astro.com.my_$TOMORROW.xml 
sed s/-0800/+0800/g M038-101.astro.com.my_$TOMORROW.xml >  M038-101.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M038-101.astro.com.my1_$TOMORROW.xml

# TV3
wget http://mythastro.hostrator.com/M046-103.astro.com.my_$DATE.xml --output-document M046-103.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M046-103.astro.com.my_$DATE.xml > M046-103.astro.com.my1_$DATE.xml 
mythfilldatabase --update --refresh-all --file 2 M046-103.astro.com.my1_$DATE.xml

wget http://mythastro.hostrator.com/M046-103.astro.com.my_$TOMORROW.xml --output-document M046-103.astro.com.my_$TOMORROW.xml
sed s/-0800/+0800/g M046-103.astro.com.my_$TOMORROW.xml > M046-103.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M046-103.astro.com.my1_$TOMORROW.xml
# NTV7
wget http://mythastro.hostrator.com/M036-107.astro.com.my_$DATE.xml --output-document M036-107.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M036-107.astro.com.my_$DATE.xml > M036-107.astro.com.my1_$DATE.xml

mythfilldatabase --update --refresh-all --file 2 M036-107.astro.com.my1_$DATE.xml 

wget http://mythastro.hostrator.com/M036-107.astro.com.my_$TOMORROW.xml --output-document M036-107.astro.com.my_$TOMORROW.xml 
sed s/-0800/+0800/g M036-107.astro.com.my_$TOMORROW.xml >  M036-107.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M036-107.astro.com.my1_$TOMORROW.xml

# 8TV
wget http://mythastro.hostrator.com/M057-708.astro.com.my_$DATE.xml --output-document M057-708.astro.com.my_$DATE.xml
sed s/-0800/+0800/g M057-708.astro.com.my_$DATE.xml >  M036-107.astro.com.my1_$TOMORROW.xml

mythfilldatabase --update --refresh-all --file 2 M057-708.astro.com.my1_$DATE.xml


wget http://mythastro.hostrator.com/M057-708.astro.com.my_$TOMORROW.xml --output-document M057-708.astro.com.my_$TOMORROW.xml 
sed s/-0800/+0800/g M057-708.astro.com.my_$TOMORROW.xml > M057-708.astro.com.my1_$TOMORROW.xml
mythfilldatabase --update --refresh-all --file 2 M057-708.astro.com.my1_$TOMORROW.xml

-bash-3.2$ crontab -l
* 5 * * * /home/mythtv/bin/mythguide-update2.sh > /dev/null

it might be buggy at the moment..
but at least..I got something like this..

program-listing
heheh..mouse over the program will tell the program description..

program-listing-mouse-over

click on it to record..
mythtv-record-lah

nice..

thanks to the XML uploader..

p/s: all this stuff only viable after a great journey earlier… 😎

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Like

Related Post

3 Responses

  1. HawkEYE says:

    I got better one after a few minute..
    by adding this two line before line 602 (/usr/share/system-config-network/netconfpkg/gui/maindialog.py)


    if (not isinstance (host.Hostname, str)):
    continue

    now it works like charms again.. hehe.. 😎

    Reply
  2. UncleOp says:

    This was helpful. Summary: if the /etc/hosts file is not well-formed, the python script doesn’t handle it well. In my case, somehow a long entry that was commented out got “line wrapped”, leaving some uncommented garbage on the next line. Fixing the hosts file or adding the above patch “worked”. It seems that some complaint to the user should be generated in such a case, though.

    Reply
    • HawkEYE says:

      @UncleOp , Glad it help.. thanks for dropping by..

      Reply

Anything to add?

X