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… 😎

Related Post

3 Responses

  1. Anggi says:

    Thanks for installing CentOS guide

    Reply
  2. abhijit says:

    It is very good artical, but it didn’t contain the information about how to install CentOS 5.3 on Windows OS like win 7 if it is already installed it.

    Reply
  3. shivu says:

    thanks

    Reply

Leave a Reply to ahstod Cancel reply

Your email address will not be published. Required fields are marked *