Author |
Message |
tama102
|
Posted: Fri Aug 10, 2007 7:12 pm |
|
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 |
|
 |
nickread
|
Posted: Fri Aug 10, 2007 11:10 pm |
|
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 |
|
 |
tama102
|
Posted: Sat Aug 11, 2007 9:03 am |
|
Joined: Wed May 24, 2006 9:10 am
Posts: 107
Location:
Minneapolis, MN
|
Thanks, I will give that a try.
|
|
Top |
|
 |
tama102
|
Posted: Mon Aug 13, 2007 11:05 am |
|
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 |
|
 |
nickread
|
Posted: Mon Aug 13, 2007 6:52 pm |
|
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 |
|
 |
cecil
|
Posted: Mon Aug 13, 2007 9:07 pm |
|
 |
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 |
|
 |
tama102
|
Posted: Mon Aug 13, 2007 11:08 pm |
|
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 |
|
 |
nickread
|
Posted: Mon Aug 13, 2007 11:28 pm |
|
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 |
|
 |
tama102
|
Posted: Tue Aug 14, 2007 12:06 am |
|
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 |
|
 |
nickread
|
Posted: Tue Aug 14, 2007 1:27 am |
|
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 |
|
 |