View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 10 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: XMLTV data to system
PostPosted: Fri Aug 10, 2007 7:12 pm 
Offline
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location: Minneapolis, MN
Lets say for sake of argument/development purposes that I have continuously updated tv listing data (legally) in the form of an xmltv file saved on a Windows PC that is networked to my Mythtv. How can I tell my mythtv to grab a copy of that file from my windows PC on a nightly basis?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 10, 2007 11:10 pm 
Offline
Joined: Tue Nov 22, 2005 7:57 pm
Posts: 295
Location: Auckland, New Zealand
Use samba to access a shared drive on the Windows PC, and use a cron job to run a script which copies the file over to your myth box, and then runs mythfilldatabase in --file mode. This is what we use in NZ to get it from the web:

Code:
cd /home/mythtv
rm -f /home/mythtv/listings.xml
rm -f /home/mythtv/listings.xml.gz
wget http://epg.pvr.geek.nz/epg/listings.xml.gz
gzip -d listings.xml.gz
mythfilldatabase --file 1 -1 listings.xml --update

_________________
HP VL400 (PIII 866), Skystar2 2.6D, PVR350, Nvidia FX5200, 384MB, 200GB, KnoppMyth R5.5


Top
 Profile  
 
 Post subject:
PostPosted: Sat Aug 11, 2007 9:03 am 
Offline
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location: Minneapolis, MN
Thanks, I will give that a try.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 11:05 am 
Offline
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location: Minneapolis, MN
My xml file is saved locally as listings.xml. So I ran the command shown above, and this is my output:

Code:

mythtv@mythtv:~$ mythfilldatabase --file 1 -1 /home/mythtv/listings.xml
### bypassing grabbers, reading directly from file
2007-08-13 09:08:55.282 Using runtime prefix = /usr
2007-08-13 09:08:55.590 New DB connection, total: 1
2007-08-13 09:08:55.604 Connected to database 'mythconverg' at host: localhost
2007-08-13 09:08:56.013 New DB connection, total: 2
2007-08-13 09:08:56.014 Connected to database 'mythconverg' at host: localhost
2007-08-13 09:08:56.086 Updating icons for sourceid: 1
Updated programs: 0  Unchanged programs: 0
2007-08-13 09:08:57.831 New DB connection, total: 3
2007-08-13 09:08:57.832 Connected to database 'mythconverg' at host: localhost
2007-08-13 09:08:57.835 New DB connection, total: 4
2007-08-13 09:08:57.835 Connected to database 'mythconverg' at host: localhost
2007-08-13 09:08:57.924 Adjusting program database end times.
2007-08-13 09:08:57.950     0 replacements made
2007-08-13 09:08:57.950 Marking generic episodes.
2007-08-13 09:08:58.041     Found 0
2007-08-13 09:08:58.042 Marking repeats.
2007-08-13 09:08:58.122     Found 0
2007-08-13 09:08:58.122 Unmarking new episode rebroadcast repeats.
2007-08-13 09:08:58.207     Found 0
2007-08-13 09:08:58.207
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2007-08-13 09:08:58.209 Connecting to backend server: 192.168.0.7:6543 (try 1 of 5)
2007-08-13 09:08:58.216 Using protocol version 26
2007-08-13 09:08:58.243 mythfilldatabase run complete.
mythtv@mythtv:~$


So as you can see, nothing seems to update. Do I need to set someting up differently in mythtv-setup? Right now I just have it set with North America Data Direct through a zap2it account, I want to obviously bypass the zap2it listings with this data file. Thanks for the help.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 6:52 pm 
Offline
Joined: Tue Nov 22, 2005 7:57 pm
Posts: 295
Location: Auckland, New Zealand
You are running this as user mythtv, right?

Also, you need to check what your source is numbered. The first '1' in the mythfilldatabase command refers to the data source defined in the database for your channels. If you've created and deleted sources before, it will no longer be source 1. The easiest way to check it (to me) is to go into mythweb, settings, channels, and the source number is the first column.

_________________
HP VL400 (PIII 866), Skystar2 2.6D, PVR350, Nvidia FX5200, 384MB, 200GB, KnoppMyth R5.5


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 9:07 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
Of course nothing got updated. The backend isn't running. Start the backend and try again.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 11:08 pm 
Offline
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location: Minneapolis, MN
Wow, I feel privileged that Cecil himself is helping out with this one. Thanks everyone. Well I am running the command as myth user, and I confirmed that the source ID is actually source 2. So I re-ran the command with that in mind while the backend was running, and this is what I got:


Code:
mythtv@mythtv:~$ mythfilldatabase --file 2 -1 listings.xml --update
### bypassing grabbers, reading directly from file
2007-08-14 00:07:41.049 Using runtime prefix = /usr
2007-08-14 00:07:41.059 New DB connection, total: 1
2007-08-14 00:07:41.061 Connected to database 'mythconverg' at host: localhost
2007-08-14 00:07:41.487 New DB connection, total: 2
2007-08-14 00:07:41.488 Connected to database 'mythconverg' at host: localhost
2007-08-14 00:07:41.564 Updating icons for sourceid: 2
Updated programs: 0  Unchanged programs: 0
2007-08-14 00:07:41.983 New DB connection, total: 3
2007-08-14 00:07:41.984 Connected to database 'mythconverg' at host: localhost
2007-08-14 00:07:41.997 New DB connection, total: 4
2007-08-14 00:07:41.998 Connected to database 'mythconverg' at host: localhost
2007-08-14 00:07:42.001 Adjusting program database end times.
2007-08-14 00:07:42.262     0 replacements made
2007-08-14 00:07:42.262 Marking generic episodes.
2007-08-14 00:07:42.354     Found 0
2007-08-14 00:07:42.354 Marking repeats.
2007-08-14 00:07:42.437     Found 0
2007-08-14 00:07:42.437 Unmarking new episode rebroadcast repeats.
2007-08-14 00:07:42.522     Found 0
2007-08-14 00:07:42.548
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2007-08-14 00:07:42.574 Connecting to backend server: 192.168.0.7:6543 (try 1 of 5)
2007-08-14 00:07:42.581 Using protocol version 26
2007-08-14 00:07:44.658 mythfilldatabase run complete.



I went back into my mythfronend and confirm that the guide was not updated. I also confirmed that my xml file is in the correct location. I also confirmed the content of the file with nano. Any other ideas?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Aug 13, 2007 11:28 pm 
Offline
Joined: Tue Nov 22, 2005 7:57 pm
Posts: 295
Location: Auckland, New Zealand
Do the XMLTVID numbers in the file (channel identifiers) match those defined in your database (also easy to check via mythweb)?

_________________
HP VL400 (PIII 866), Skystar2 2.6D, PVR350, Nvidia FX5200, 384MB, 200GB, KnoppMyth R5.5


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 14, 2007 12:06 am 
Offline
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location: Minneapolis, MN
Nickread,

After reading your post, I went ahead and opened my xml file and copied all the xmltvid tags and copies them into mythweb. I then confirmed the tag in mythtv-setup. I ran the command shown above again and got the same output.

When I am setting up these channels as a new video source in mythtv-setup, what do I leave in the XMLTV grabber field? Data Direct? I cannot tell if that is screwing up this process. It does not give me the option to leave it blank.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 14, 2007 1:27 am 
Offline
Joined: Tue Nov 22, 2005 7:57 pm
Posts: 295
Location: Auckland, New Zealand
I just use the 'EIT option' or whatever its called. It doesn't really matter as the grabber isn't called when you use a file for the listings. If you change the XMLTVID to match the ones used in the file then it will most likely break the grabber anyway.

_________________
HP VL400 (PIII 866), Skystar2 2.6D, PVR350, Nvidia FX5200, 384MB, 200GB, KnoppMyth R5.5


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu