Malaysia TV Program Guide grabber for Mythtv

Posted Under:

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

Tags , , , ,

Related Post

3 Responses

  1. Uncle Foobar says:

    Hey! Thanks for this! Great walkthrough.

    I just downloaded and played with this myself
    for the first time, and i enjoy getting directions
    for stuff to look at.

    Another alternative to the two part USB files:
    in the readthisfirst file, there is a list of mirrors
    to the ISO worldwide.

    Also: i did the wget app download (you might
    want to “blank out” the first failed attempt)

    Question: where is the “app store” for
    Android stuff? is it an app? is it like Cydia
    for jailbroke iphones?

    I want to walk around in the softs a bit.

    thanks!

    Foob

    Reply ↓
    • namran says:

      Uncle Foobar : ok.. had ‘blank out’ the first failed attempt on the app installation due to typo error of the app url..

      App store for Google Android is available at http://www.android.com/market/

      however.. it may not available at your mobile due to some TELCO / countries restriction..
      please check the local Android user community..
      or just go to http://developer.android.com/community/

      😎

      Reply ↓
  2. ahstod says:

    App Store is not open-sourced, hence not in these kind of builds. You need to have some agreement with google to distribute it on your “phones”.

    You can browse what’s available in the market through the following hack http://www.cyrket.com from the same guy who brought you cydia on the iphone.

    Having said that … those who have rooted android phones … can probably download an app from the market and “share” it with you …

    Reply ↓

Leave a Reply to ahstod Cancel reply

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