[mythtvnz] Problem with mythfilldatabase

[Stephen Worthington]

On Sun, 05 Jun 2016 15:06:56 +1200, you wrote:

>On Sun, 05 Jun 2016 12:43:04 +1200, you wrote:
>
>>Hi all
>>
>>I have been having trouble with schedule updates over the last week.I use  
>>a script run by cron to update with freeview.xml
>>data.I decided to try to get tv_grab_nz-py to work.This was unsuccessful  
>>(again).
>>In the process I deleted and recreated my video sources and  
>>rescanned.Re-entered xmltv id for each channel in the channel editor.
>>
>>The problem is: when I run mythfilldatabase I get:
>>
>>  2016-06-05 12:29:16.181688 N  Unknown xmltv channel identifier:  
>>tv2.freeviewnz.tv - Skipping channel.
>>
>>messages for every channel.
>>
>>I think I may have missed a step in the process but I can find what.
>>
>>Any suggestions?
>>
>>_Paul
>
>Youn need to have a .xmltv config file in /home/<mythtv user>/.mythtv
>for each source.  So for my FreeviewHD source, I have this file:
>
>root at mypvr:/home/stephen/.mythtv# cat FreeviewHD.xmltv
>channel=tv1.freeviewnz.tv
>channel=tv2.freeviewnz.tv
>channel=tv3.freeviewnz.tv
>channel=four.freeviewnz.tv
>channel=maori-tv.freeviewnz.tv
>channel=tv1-plus1.freeviewnz.tv
>channel=tv2-plus1.freeviewnz.tv
>channel=tv3-plus1.freeviewnz.tv
>channel=four-plus1.freeviewnz.tv
>channel=duke.freeviewnz.tv
>channel=edge-tv.freeviewnz.tv
>channel=prime.freeviewnz.tv
>channel=choice.freeviewnz.tv
>channel=shopping-channel.freeviewnz.tv
>channel=parliament.freeviewnz.tv
>channel!hope-channel.freeviewnz.tv
>channel=aljazeera.freeviewnz.tv
>channel=te-reo.freeviewnz.tv
>channel!shine.freeviewnz.tv
>channel=firstlight.freeviewnz.tv
>channel=sommet-sports.freeviewnz.tv
>channel=tvsn-shopping-channel.freeviewnz.tv
>channel=chinese-tv8.freeviewnz.tv
>channel=tv33.freeviewnz.tv
>channel=yes-shop.freeviewnz.tv
>channel=apna.freeviewnz.tv
>channel=rnz-national.freeviewnz.tv
>channel=rnz-concert.freeviewnz.tv
>channel=basefm.freeviewnz.tv
>channel!georgefm.freeviewnz.tv
>channel!tvnz7.freeviewnz.tv
>channel!tv9.freeviewnz.tv
>
>The = sign says to include the EPG data for that channel, and the ! to
>exclude it.

You can make your .xmltv file like this:

root at mypvr:/home/stephen/.mythtv# mysql -s -N -p
Enter password:
mysql> tee /tmp/FreeviewHD.xmltv
Logging to file '/tmp/FreeviewHD.xmltv'
mysql> select concat('channel=',xmltvid) from channel where
sourceid=1;
channel=aljazeera.freeviewnz.tv
channel=apna.freeviewnz.tv
channel=basefm.freeviewnz.tv
channel=chinese-tv8.freeviewnz.tv
channel=choice.freeviewnz.tv
channel=duke.freeviewnz.tv
channel=edge-tv.freeviewnz.tv
channel=firstlight.freeviewnz.tv
channel=four-plus1.freeviewnz.tv
channel=four.freeviewnz.tv
channel=maori-tv.freeviewnz.tv
channel=parliament.freeviewnz.tv
channel=prime.freeviewnz.tv
channel=rnz-concert.freeviewnz.tv
channel=rnz-national.freeviewnz.tv
channel=shopping-channel.freeviewnz.tv
channel=te-reo.freeviewnz.tv
channel=tv1-plus1.freeviewnz.tv
channel=tv1.freeviewnz.tv
channel=tv2-plus1.freeviewnz.tv
channel=tv2.freeviewnz.tv
channel=tv29.freeviewnz.tv
channel=tv3-plus1.freeviewnz.tv
channel=tv3.freeviewnz.tv
channel=tv33.freeviewnz.tv
channel=tvnz7.freeviewnz.tv
channel=tvsn-shopping-channel.freeviewnz.tv
channel=yes-shop.freeviewnz.tv
mysql> notee
Outfile disabled.
mysql> quit

You have to edit the file to remove the notee command on the end, then
move it to the right directory.