Difference between revisions of "Migrating to Schedules Direct in the UK"
(Marvel's Agents of SHIELD name change) |
(Correct channel editor version 2.01) |
||
(12 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
This is a write up from memory of the main steps taken to set up | This is a write up from memory of the main steps taken to set up | ||
− | + | Schedules Direct (SD) for a UK configuration, especially with respect to | |
converting old Radio Times (RT) or Atlas feed configurations, both of which will | converting old Radio Times (RT) or Atlas feed configurations, both of which will | ||
be becoming unavailable at time of writing. | be becoming unavailable at time of writing. | ||
Line 33: | Line 33: | ||
* Copied blib/script/tv_grab_sd_json to /usr/local/bin (I did it this way because the Debian packages haven't picked up sd_json yet so this is just a stopgap until they do. | * Copied blib/script/tv_grab_sd_json to /usr/local/bin (I did it this way because the Debian packages haven't picked up sd_json yet so this is just a stopgap until they do. | ||
---- | ---- | ||
+ | |||
+ | ------------------ | ||
+ | I'll expand on that because it is a bit tortuous: | ||
+ | |||
+ | The download http://snapshot.xmltv.org/ gives you a zip file which needs expanding. | ||
+ | That reveals a README which is very useful. | ||
+ | |||
+ | If you try | ||
+ | ./Makefiles.PL | ||
+ | it may well mention missing dependences which will prevent the generation of tv_grab_sd_json. | ||
+ | |||
+ | With Ubuntu I had to do: | ||
+ | <pre> | ||
+ | sudo apt-get install XMLTV | ||
+ | sudo apt-get install libdatetime-format-dateparse-perl | ||
+ | |||
+ | cpan | ||
+ | > install XML::TreePP | ||
+ | > install Lingua::EN::Numbers::Ordinate | ||
+ | > exit | ||
+ | </pre> | ||
+ | Only then did this work: | ||
+ | |||
+ | <pre> | ||
+ | ./Makefile.pl | ||
+ | make | ||
+ | make test | ||
+ | make install | ||
+ | </pre> | ||
+ | That worked and the grabber was then in a sub directory: | ||
+ | |||
+ | grab/sd_json/tv_grab_sd_json | ||
+ | |||
+ | |||
+ | Copy that to /usr/bin and | ||
+ | |||
+ | chmod 755 tv_grab_sd_json | ||
+ | ---------------------------------- | ||
+ | |||
+ | |||
+ | |||
==Configure your feeds for the first time== | ==Configure your feeds for the first time== | ||
Line 39: | Line 80: | ||
.. and answer its questions. | .. and answer its questions. | ||
* Ask for MythTV format channel IDs (5-digits), if only because that's what I used and appears in my mappings below. | * Ask for MythTV format channel IDs (5-digits), if only because that's what I used and appears in my mappings below. | ||
− | * Where it asks for the country, I used ''GBR'' but apparently if you know the | + | * Where it asks for the country, I used ''GBR'' but apparently if you know the specific feed (and the list it offers after your post-code doesn't contain what you want (raise a ticket with SD in this case, they're very good as responding) you can enter the full line-up code (''e.g.'', GBR-0001172-DEFAULT). See [http://article.gmane.org/gmane.comp.tv.xmltv.devel/11247 http://article.gmane.org/gmane.comp.tv.xmltv.devel/11247] for a [https://json.schedulesdirect.org/20141201/transmitters/GBR list of codes for UK transmitters]. |
− | specific feed (and the list it offers after your post-code doesn't contain | + | * ''If you can, use the code provided by the above link for your DVB-T transmitter.'' The post-code-based one (“OTA”) is actually likely not what you want (although it will offer the correct Satellite options). |
− | what you want (raise a ticket with SD in this case, they're very good as | ||
− | responding) you can enter the full line-up code (''e.g.'', | ||
− | GBR-0001172-DEFAULT). See | ||
− | [http://article.gmane.org/gmane.comp.tv.xmltv.devel/11247 | ||
− | http://article.gmane.org/gmane.comp.tv.xmltv.devel/11247] for a | ||
− | [https://json.schedulesdirect.org/20141201/transmitters/GBR list of codes for | ||
− | UK transmitters]. | ||
* For your post-code, only enter first part, as it otherwise gets confused and only offers you limited (non-localised) sources. | * For your post-code, only enter first part, as it otherwise gets confused and only offers you limited (non-localised) sources. | ||
− | * Ask for individual channels, not the full line-up, as it'll give you a chance | + | * Ask for individual channels, not the full line-up, as it'll give you a chance to diagnose channel list issues, & disable channels (in the config file it creates, via “channel!12345” instead of “channel=12345”). For my BSkyB listings, the full set was ~600 channels, and I don't use anything like that many. |
− | to diagnose channel list issues, & disable channels (in the config file it | ||
− | creates, via “channel!12345” instead of “channel=12345”). For my BSkyB | ||
− | listings, the full set was ~600 channels, and I don't use anything like that | ||
− | many. | ||
− | You should get a viable | + | You should get a viable configuration file out of it, in '''~/.xmltv/tv_grab_sd_json.conf''', and see the list of xmltvids you have available. The file has configuration information at the head (eg username and password) followed by lines of the form ''channel=12345'' . |
==Do a trial run== | ==Do a trial run== | ||
Line 62: | Line 92: | ||
tv_grab_sd_json --config-file ~/.xmltv/tv_grab_sd_json.conf --output /tmp/sd.xml | tv_grab_sd_json --config-file ~/.xmltv/tv_grab_sd_json.conf --output /tmp/sd.xml | ||
Make sure the grabber runs OK and the output file looks sane. | Make sure the grabber runs OK and the output file looks sane. | ||
+ | |||
+ | The file has entries like this: | ||
+ | <channel id="30644"> | ||
+ | <display-name>BBC One (London)</display-name> | ||
+ | <display-name>BBC1LDN</display-name> | ||
+ | <display-name>001</display-name> | ||
+ | </channel> | ||
+ | In this case, it is saying that the XMLTVID for BBC One (London) is 30644. | ||
+ | |||
+ | |||
==Update MythTV== | ==Update MythTV== | ||
Line 81: | Line 121: | ||
Either use the ''mythtvsetup'' editor or the SQL command line. See the | Either use the ''mythtvsetup'' editor or the SQL command line. See the | ||
''xmltvid'' mappings below. | ''xmltvid'' mappings below. | ||
+ | |||
+ | Alternatively, [[Channel Editor]] version 2.01 (8 July 2016) has code which will read the huge file above, allow manual matching of the channels which do not match automatically and insert the ids into the database. It will do this and lots more which you would expect of a channel editor. | ||
If you use the script below, search your setup for channel IDs that still | If you use the script below, search your setup for channel IDs that still | ||
Line 101: | Line 143: | ||
<pre><nowiki> | <pre><nowiki> | ||
update oldrecorded set programid='' where \ | update oldrecorded set programid='' where \ | ||
− | programid rlike '^EP[0-9]+$' or \ | + | programid rlike '^EP[0-9]+[a-z]?$' or \ |
− | programid rlike '^MV[0-9]+$' or \ | + | programid rlike '^MV[0-9]+[a-z]?$' or \ |
− | programid rlike '^SH[0-9]+$' or \ | + | programid rlike '^SH[0-9]+[a-z]?$' or \ |
− | programid rlike '^SP[0-9]+$'; | + | programid rlike '^SP[0-9]+[a-z]?$'; |
update recorded set programid='' where \ | update recorded set programid='' where \ | ||
− | programid rlike '^EP[0-9]+$' or \ | + | programid rlike '^EP[0-9]+[a-z]?$' or \ |
− | programid rlike '^MV[0-9]+$' or \ | + | programid rlike '^MV[0-9]+[a-z]?$' or \ |
− | programid rlike '^SH[0-9]+$' or \ | + | programid rlike '^SH[0-9]+[a-z]?$' or \ |
− | programid rlike '^SP[0-9]+$'; | + | programid rlike '^SP[0-9]+[a-z]?$'; |
update recordedprogram set programid='' where \ | update recordedprogram set programid='' where \ | ||
− | programid rlike '^EP[0-9]+$' or \ | + | programid rlike '^EP[0-9]+[a-z]?$' or \ |
− | programid rlike '^MV[0-9]+$' or \ | + | programid rlike '^MV[0-9]+[a-z]?$' or \ |
− | programid rlike '^SH[0-9]+$' or \ | + | programid rlike '^SH[0-9]+[a-z]?$' or \ |
− | programid rlike '^SP[0-9]+$'; | + | programid rlike '^SP[0-9]+[a-z]?$'; |
</nowiki></pre> | </nowiki></pre> | ||
Line 138: | Line 180: | ||
>> $HOME/.mythtv/Freeview.xmltv | >> $HOME/.mythtv/Freeview.xmltv | ||
+ | |||
+ | It may be simpler to use [[Channel Editor]] which has a routine to generate all the SOURCENAME.xmltv files automatically. It will generate a file for each source, with channels marked for inclusion (with = ) which are non-UseEIT, are visible are in the appropriate source and have a non blank XMLTVID. Other channels are marked for exclusion (with ! ). After manual inspection, they simply need copying over from current working directory to ~/.mythtv. | ||
+ | |||
+ | |||
==Perform your first update== | ==Perform your first update== | ||
If you just go with the flow, it should be as simple as: | If you just go with the flow, it should be as simple as: | ||
Line 166: | Line 212: | ||
The IDs may also be old ones which the RT grabber aliased when the channels changed; my setup dates back to 2004. | The IDs may also be old ones which the RT grabber aliased when the channels changed; my setup dates back to 2004. | ||
− | 1.movies4men.co.uk 46306 # Movies4Men | + | ''EDIT'' - Unlike the RT UK IDs, some channels will possibly have different SD IDs depending upon their source; I initially made this focussed on a Sky channel listing, but a couple are not present in DVB-T line-ups (selected from the [https://json.schedulesdirect.org/20141201/transmitters/GBR transmitter-based list] as opposed the the script-0proferred post-code based list). I've updated the list below, but not the SQL conversion script after it. You'll have to adjust those manually. '''Check the output of running ''tv_grab_sd_json'' for unrecognised channel IDs.''' |
− | 1.truemovies.tv 50011 # True Movies 2 | + | |
− | 2.jr.nickelodeon.co.uk 50269 # Nick Jr 2 | + | 1.movies4men.co.uk 46306 # Movies4Men |
− | 2.truemovies.tv 44717 # True Movies 1 | + | 1.truemovies.tv 50011 # True Movies 2 |
− | 4music.channel4.com 31786 # 4Music | + | 2.jr.nickelodeon.co.uk 50269 # Nick Jr 2 |
− | 4seven.channel4.com 75804 # 4seven | + | 2.truemovies.tv 44717 # True Movies 1 |
− | 6music.radio.bbc.co.uk 30166 # BBC 6 Music | + | 4music.channel4.com 31786 # 4Music |
− | action.cbs.com 73970 # CBS Action | + | 4seven.channel4.com 75804 # 4seven |
− | alibi.uktv.co.uk 21258 # Alibi | + | 6music.radio.bbc.co.uk 30166 # BBC 6 Music |
− | animalplanet.discoveryeurope.com 20707 # Animal Planet | + | action.cbs.com 73970 # CBS Action |
− | arts.sky.com 24919 # Sky Arts | + | alibi.uktv.co.uk 21258 # Alibi |
− | atlantic.sky.com 70434 # Sky Atlantic | + | animalplanet.discoveryeurope.com 20707 # Animal Planet |
− | b4utv.com 25529 # B4U Movies | + | arts.sky.com 24919 # Sky Arts |
− | base.mtv.co.uk 24217 # MTV Base | + | atlantic.sky.com 70434 # Sky Atlantic |
− | bbcfour.bbc.co.uk 20684 # BBC FOUR | + | b4utv.com 25529 # B4U Movies |
− | bloomberg.com 20711 # Bloomberg Television | + | base.mtv.co.uk 24217 # MTV Base |
− | boomerang.cartoonnetwork.com 24341 # Boomerang | + | bbcfour.bbc.co.uk 20684 # BBC FOUR |
− | british.eurosport.com 18337 # British Eurosport | + | bloomberg.com 20711 # Bloomberg Television |
− | cbbc.bbc.co.uk 29324 # CBBC | + | boomerang.cartoonnetwork.com 24341 # Boomerang |
− | cbeebies.bbc.co.uk 29325 # CBeebies | + | british.eurosport.com 18337 # British Eurosport |
− | central.itv1.itv.co.uk 21832 # ITV 1 London (Carlton) | + | cbbc.bbc.co.uk 29324 # CBBC |
− | challengetv.co.uk 17454 # TLC | + | cbeebies.bbc.co.uk 29325 # CBeebies |
− | channel4.com 17155 # Channel 4 | + | central.itv1.itv.co.uk 21832 # ITV 1 London (Carlton) |
− | channel5.co.uk 17157 # Channel 5 | + | challengetv.co.uk 17454 # TLC |
− | citv.itv.co.uk 49452 # CITV | + | channel4.com 17155 # Channel 4 |
− | comedycentral.com 17420 # Comedy Central | + | channel5.co.uk 17157 # Channel 5 |
− | communitychannel.org 24677 # Community Channel | + | citv.itv.co.uk 49452 # CITV |
− | dance.mtv.co.uk 25976 # MTV Dance | + | comedycentral.com 17420 # Comedy Central |
− | dave.uktv.co.uk 24305 # Dave | + | communitychannel.org 24677 # Community Channel |
− | discoveryeurope.com 17444 # Discovery Channel | + | dance.mtv.co.uk 25976 # MTV Dance |
− | disneychannel.disney.co.uk 18377 # Disney Channel | + | dave.uktv.co.uk 24305 # Dave |
− | drama.cbs.com 57827 # CBS Drama | + | discoveryeurope.com 17444 # Discovery Channel |
− | e4.channel4.com 25117 # E4 | + | disneychannel.disney.co.uk 18377 # Disney Channel |
− | eden.uktv.co.uk 35806 # Eden | + | drama.cbs.com 57827 # CBS Drama |
− | eentertainment.com 32195 # E! Entertainment | + | e4.channel4.com 25117 # E4 |
− | encore.itv.com 89886 # ITV Encore | + | eden.uktv.co.uk 35806 # Eden |
− | + | eentertainment.com 32195 # E! Entertainment | |
− | europe.cnbc.com 16230 # CNBC Europe | + | encore.itv.com 89886 # ITV Encore |
− | europe.cnn.com 68053 # CNN International | + | entertainment.truemovies.tv 57747 # True Entertainment |
− | extra.5live.radio.bbc.co.uk 29920 # BBC 5L SportsX | + | euronews.com 82432 # Euronews |
− | extra.comedycentral.com 34230 # Comedy Central Extra | + | europe.cnbc.com 16230 # CNBC Europe |
− | filmfour.channel4.com 21494 # Film4 | + | europe.cnn.com 68053 # CNN International |
− | fiver.channel5.co.uk 52336 # 5* | + | extra.5live.radio.bbc.co.uk 29920 # BBC 5L SportsX |
− | fiveusa.channel5.co.uk 52335 # 5 USA | + | extra.comedycentral.com 34230 # Comedy Central Extra |
− | freeview. | + | filmfour.channel4.com 21494 # Film4 |
− | fxuk.tv 35484 # Fox | + | fiver.channel5.co.uk 52336 # 5* |
− | gold.uktv.co.uk 17442 # Gold | + | fiveusa.channel5.co.uk 52335 # 5 USA |
− | goodfood.uktv.co.uk 28634 # Good Food | + | freeview.communitychannel.org 24677 # Community |
− | hd.bbc1.bbc.co.uk 69387 # BBC ONE HD | + | freeview.foodnetwork.com 44718 # Food Network |
− | hd.bbc2.bbc.co.uk 50059 # BBC TWO HD | + | freeview.hd.channel4.com 50716 # Channel 4 HD |
− | hd. | + | fxuk.tv 35484 # Fox |
− | hd. | + | gold.uktv.co.uk 17442 # Gold |
− | + | goodfood.uktv.co.uk 28634 # Good Food | |
− | + | hd.aljazeera.net 97267 # Al Jazeera Eng HD | |
− | + | hd.bbc1.bbc.co.uk 69387 # BBC ONE HD | |
− | + | hd.bbc2.bbc.co.uk 50059 # BBC TWO HD | |
− | + | hd.bbcfour.bbc.co.uk 83282 # BBC FOUR HD | |
− | + | hd.cbbc.bbc.co.uk 83281 # CBBC HD | |
− | + | hd.cbeebies.bbc.co.uk 83283 # CBeebies HD | |
− | + | hd.five.tv 50717 # Channel 5 HD | |
− | + | hd.news.bbc.co.uk 83285 # BBC NEWS HD | |
− | jr.nickelodeon.co.uk 24025 # Nick Jr | + | hd.southeast-macro.itv1.itv.co.uk 67073 # ITV HD |
− | kerrang.com 25627 # Kerrang! TV | + | health.discovery.com 24657 # Discovery Home & Health |
− | kiss-tv.kiss100.com 25605 # Kiss TV | + | history.discoveryeurope.com 24280 # Discovery History |
− | living.sky.com 17443 # Sky Living | + | hits.mtv.co.uk 24214 # MTV Hits |
− | magictv.co.uk 25607 # Magic | + | home.uktv.co.uk 21257 # Home |
− | meridian.itv1.itv.co.uk 21826 # ITV1 | + | horror.cbs.com 42762 # Horror Channel |
− | more4.channel4.com 47657 # More 4 | + | idealworld.tv 24669 # Ideal World |
− | motors.tv 30141 # Motors TV | + | itv2.itv.co.uk 20630 # ITV2 |
− | mtv.co.uk 58695 # MTV UK | + | itv3.itv.co.uk 44643 # ITV3 |
− | nationalgeographic.co.uk 21592 # National Geographic | + | itv4.itv.co.uk 48020 # ITV4 |
− | news.bbc.co.uk 19037 # BBC NEWS | + | jr.nickelodeon.co.uk 24025 # Nick Jr |
− | news.eurosport.com 27413 # British Eurosport 2 | + | kerrang.com 25627 # Kerrang! TV |
− | news.sports.sky.com 20643 # Sky Sports News | + | kiss-tv.kiss100.com 25605 # Kiss TV |
− | nickelodeon.co.uk 17419 # Nickelodeon UK | + | living.sky.com 17443 # Sky Living |
− | northern-ireland.bbc2.bbc.co.uk 29046 # BBC 2 Northern Ireland | + | magictv.co.uk 25607 # Magic |
− | parliament.bbc.co.uk 20685 # BBC Parliament | + | meridian.itv1.itv.co.uk 21826 # ITV1 |
− | playboy.com 69376 # Playboy TV | + | more4.channel4.com 47657 # More 4 |
− | plus-1.1.movies4men.co.uk 59406 # Movies4Men +1 | + | motors.tv 30141 # Motors TV |
− | plus-1.comedycentral.com 47480 # Comedy Central +1 | + | mtv.co.uk 58695 # MTV UK |
− | plus-1.meridian.itv1.itv.co.uk 65161 # ITV1 +1 | + | nationalgeographic.co.uk 21592 # National Geographic |
− | plus-1.quest.discoveryeurope.com 65394 # Quest +1 | + | news.bbc.co.uk 19037 # BBC NEWS |
− | plus-1.science.discoveryeurope.com 56266 # Discovery Science +1 | + | news.eurosport.com 27413 # British Eurosport 2 |
− | plus-1.universalchannel.co.uk 60936 # Universal +1 | + | news.sports.sky.com 20643 # Sky Sports News |
− | plus-1.xd.disney.co.uk 24073 # Disney XD +1 | + | nickelodeon.co.uk 17419 # Nickelodeon UK |
− | quest.discoveryeurope.com 62391 # Quest | + | northern-ireland.bbc2.bbc.co.uk 29046 # BBC 2 Northern Ireland |
− | qvcuk.com 21810 # QVC | + | parliament.bbc.co.uk 20685 # BBC Parliament |
− | radio-1.bbc.co.uk 24434 # BBC Radio 1 | + | playboy.com 69376 # Playboy TV |
− | radio-2.bbc.co.uk 24435 # BBC Radio 2 | + | plus-1.1.movies4men.co.uk 59406 # Movies4Men +1 |
− | radio-3.bbc.co.uk 24436 # BBC Radio 3 | + | plus-1.comedycentral.com 47480 # Comedy Central +1 |
− | radio-4.bbc.co.uk 24437 # BBC Radio 4 | + | plus-1.meridian.itv1.itv.co.uk 65161 # ITV1 +1 |
− | radio-5.bbc.co.uk 24438 # BBC R5 Live | + | plus-1.quest.discoveryeurope.com 65394 # Quest +1 |
− | reality.cbs.com 31756 # CBS Reality | + | plus-1.science.discoveryeurope.com 56266 # Discovery Science +1 |
− | really.uktv.co.uk 45828 # Really | + | plus-1.universalchannel.co.uk 60936 # Universal +1 |
− | sat.2.travelchannel.co.uk 32286 # Travel Channel +1 | + | plus-1.xd.disney.co.uk 24073 # Disney XD +1 |
− | sat.travelchannel.co.uk 17453 # Travel Channel | + | popfun.co.uk 33638 # POP |
− | science.discoveryeurope.com 24282 # Discovery Science | + | quest.discoveryeurope.com 62391 # Quest |
− | scuzz.tv 32669 # Scuzz | + | qvcuk.com 21810 # QVC |
− | setindia.com 57603 # Sony Entertainment TV Asia | + | radio-1.bbc.co.uk 24434 # BBC Radio 1 |
− | sky-news.sky.com 16234 # Sky News | + | radio-2.bbc.co.uk 24435 # BBC Radio 2 |
− | sky-one.sky.com 16235 # Sky One | + | radio-3.bbc.co.uk 24436 # BBC Radio 3 |
− | sky-three.sky.com 48021 # Pick TV | + | radio-4.bbc.co.uk 24437 # BBC Radio 4 |
− | sky-two.sky.com 32151 # Sky 2 | + | radio-5.bbc.co.uk 24438 # BBC R5 Live |
− | smashhits.net 26084 # Smash Hits! TV | + | reality.cbs.com 31756 # CBS Reality |
− | sonytv.com 31759 # Sony TV | + | really.uktv.co.uk 45828 # Really |
− | south | + | sat.2.travelchannel.co.uk 32286 # Travel Channel +1 |
− | south | + | sat.travelchannel.co.uk 17453 # Travel Channel |
− | + | science.discoveryeurope.com 24282 # Discovery Science | |
− | + | scuzz.tv 32669 # Scuzz | |
− | + | setindia.com 57603 # Sony Entertainment TV Asia | |
− | + | sky-news.sky.com 16234 # Sky News | |
− | + | sky-one.sky.com 16235 # Sky One | |
− | + | sky-three.sky.com 48021 # Pick TV | |
− | + | sky-two.sky.com 32151 # Sky 2 | |
− | + | smashhits.net 26084 # Smash Hits! TV | |
− | + | sonytv.com 31759 # Sony TV | |
− | + | south.bbc1.bbc.co.uk 24326 # BBC One (South) | |
− | + | south.bbc2.bbc.co.uk 17154 # BBC Two | |
− | tsod.plus-1. | + | south-east.bbc1.bbc.co.uk 24337 # BBC ONE S East |
− | tsod.plus-1. | + | south-east.bbc2.bbc.co.uk 17154 # BBC TWO |
− | tsod.plus-1. | + | spike.com 97330 # Spike |
− | tsod.plus-1. | + | tcm.turner.com 88256 # TCM |
− | tsod.plus-1. | + | televisionx.co.uk 47738 # Television X |
− | tsod.plus-1. | + | theadultchannel.co.uk 66975 # The Adult Channel |
− | tsod.plus-1. | + | thebox.co.uk 21492 # The Box |
− | tsod.plus-1. | + | thehistorychannel.co.uk 21558 # History Channel |
− | tsod.plus-1. | + | tinypop.com 34087 # Tiny Pop |
− | tsod.plus-1. | + | too.cartoonnetwork.com 31760 # Cartoonito |
− | tsod.plus-1. | + | toons.nickelodeon.co.uk 31168 # Nicktoons TV |
− | tsod.plus-1. | + | tsod.plus-1.alibi.uktv.co.uk 45509 # Alibi +1 |
− | tsod.plus-1. | + | tsod.plus-1.animalplanet.discoveryeurope.com 26098 # Animal Planet +1 |
− | tsod.plus-1. | + | tsod.plus-1.boomerang.cartoonnetwork.com 48928 # Boomerang +1 |
− | tsod.plus-1. | + | tsod.plus-1.challengetv.co.uk 45283 # Challenge +1 |
− | tsod.plus-1.itv3.itv.co.uk | + | tsod.plus-1.channel4.com 56892 # Channel 4 +1 |
− | tsod.plus-1. | + | tsod.plus-1.channel5.co.uk 56888 # Channel 5 +1 (Sky) |
− | tsod.plus-1. | + | tsod.plus-1.channel5.co.uk 97294 # Channel 5 +1 (DVB-T) |
− | tsod.plus-1. | + | tsod.plus-1.dave.uktv.co.uk 44855 # Dave ja vu |
− | tsod.plus-1. | + | tsod.plus-1.discoveryeurope.com 21557 # Discovery Channel +1 |
− | tsod.plus-1. | + | tsod.plus-1.disneychannel.disney.co.uk 50587 # Disney Channel +1 |
− | tsod.plus-1. | + | tsod.plus-1.e4.channel4.com 33882 # E4 +1 |
− | tsod.plus-1. | + | tsod.plus-1.eden.uktv.co.uk 35945 # Eden +1 |
− | tsod.plus-1. | + | tsod.plus-1.filmfour.channel4.com 25630 # Film4 +1 |
− | tsod.plus-1. | + | tsod.plus-1.fiveusa.channel5.co.uk 56890 # 5 USA +1 |
− | + | tsod.plus-1.freeview.dave.uktv.co.uk 44855 # Dave ja vu | |
− | + | tsod.plus-1.freeview.itv3.itv.co.uk 98366 # ITV3+1 | |
− | + | tsod.plus-1.freeview.itv4.itv.co.uk 61806 # ITV4+1 | |
− | + | tsod.plus-1.gold.uktv.co.uk 31351 # Gold +1 | |
− | universalchannel.co.uk 24671 # Universal | + | tsod.plus-1.goodfood.uktv.co.uk 34898 # Good Food +1 |
− | vh1.co.uk 17745 # VH1 | + | tsod.plus-1.health.discovery.com 46490 # Discovery Home & Health +1 |
− | wales.bbc2.bbc.co.uk 28573 # BBC 2 Wales | + | tsod.plus-1.home.uktv.co.uk 29969 # Home +1 |
− | watch.uktv.co.uk 61458 # Watch | + | tsod.plus-1.itv2.itv.co.uk 53059 # ITV2 +1 |
− | wild.nationalgeographic.co.uk 23305 # National Geographic Wild | + | tsod.plus-1.itv3.itv.co.uk 53060 # ITV3+1 (Sky) |
− | xd.disney.co.uk 18379 # Disney XD | + | tsod.plus-1.itv3.itv.co.uk 98366 # ITV3+1 (DVB-T) |
− | xtra.1.radio.bbc.co.uk 31266 # 1Xtra BBC | + | tsod.plus-1.living.sky.com 31949 # Sky Living +1 |
− | yesterday.uktv.co.uk 31783 # Yesterday | + | tsod.plus-1.more4.channel4.com 47658 # More 4 +1 |
+ | tsod.plus-1.mtv.co.uk 35370 # MTV +1 | ||
+ | tsod.plus-1.nationalgeographic.co.uk 24112 # National Geographic +1 | ||
+ | tsod.plus-1.quest.discoveryeurope.com 65394 # QUEST+1 | ||
+ | tsod.plus-1.reality.cbs.com 45510 # CBS Reaity +1 | ||
+ | tsod.plus-1.southeast-macro.itv1.itv.co.uk 65161 # ITV +1 | ||
+ | tsod.plus-1.thehistorychannel.co.uk 24699 # History Channel +1 | ||
+ | tsod.plus-1.uk.syfy.com 49969 # SyFy +1 | ||
+ | tsod.plus-1.watch.uktv.co.uk 61459 # Watch +1 | ||
+ | tsod.plus-1.yesterday.uktv.co.uk 35706 # Yesterday +1 | ||
+ | tsod.plus-24.channel5.co.uk 97294 # Channel 5+24 | ||
+ | turbo.discoveryeurope.com 24284 # Discovery Turbo | ||
+ | tv5.org 21495 # TV5Monde Europe | ||
+ | uk.cartoonnetwork.com 17667 # Cartoon Network | ||
+ | uk.syfy.com 17431 # SyFy | ||
+ | uk.viva.tv 31787 # VIVA | ||
+ | universalchannel.co.uk 24671 # Universal | ||
+ | vh1.co.uk 17745 # VH1 | ||
+ | wales.bbc2.bbc.co.uk 28573 # BBC 2 Wales | ||
+ | watch.uktv.co.uk 61458 # Watch | ||
+ | wild.nationalgeographic.co.uk 23305 # National Geographic Wild | ||
+ | xd.disney.co.uk 18379 # Disney XD | ||
+ | xtra.1.radio.bbc.co.uk 31266 # 1Xtra BBC | ||
+ | yesterday.uktv.co.uk 31783 # Yesterday | ||
===SQL script to convert the xmltvids in the database=== | ===SQL script to convert the xmltvids in the database=== | ||
Line 365: | Line 434: | ||
update channel set xmltvid='32195' where xmltvid='eentertainment.com'; -- E! Entertainment | update channel set xmltvid='32195' where xmltvid='eentertainment.com'; -- E! Entertainment | ||
update channel set xmltvid='89886' where xmltvid='encore.itv.com'; -- ITV Encore | update channel set xmltvid='89886' where xmltvid='encore.itv.com'; -- ITV Encore | ||
+ | update channel set xmltvid='57747' where xmltvid='entertainment.truemovies.tv'; -- True Entertainment | ||
update channel set xmltvid='82432' where xmltvid='euronews.com'; -- Euronews | update channel set xmltvid='82432' where xmltvid='euronews.com'; -- Euronews | ||
update channel set xmltvid='16230' where xmltvid='europe.cnbc.com'; -- CNBC Europe | update channel set xmltvid='16230' where xmltvid='europe.cnbc.com'; -- CNBC Europe | ||
Line 373: | Line 443: | ||
update channel set xmltvid='52336' where xmltvid='fiver.channel5.co.uk'; -- 5* | update channel set xmltvid='52336' where xmltvid='fiver.channel5.co.uk'; -- 5* | ||
update channel set xmltvid='52335' where xmltvid='fiveusa.channel5.co.uk'; -- 5 USA | update channel set xmltvid='52335' where xmltvid='fiveusa.channel5.co.uk'; -- 5 USA | ||
+ | update channel set xmltvid='24677' where xmltvid='freeview.communitychannel.org'; -- Community | ||
+ | update channel set xmltvid='44718' where xmltvid='freeview.foodnetwork.com'; -- Food Network | ||
update channel set xmltvid='50716' where xmltvid='freeview.hd.channel4.com'; -- Channel 4 HD | update channel set xmltvid='50716' where xmltvid='freeview.hd.channel4.com'; -- Channel 4 HD | ||
update channel set xmltvid='35484' where xmltvid='fxuk.tv'; -- Fox | update channel set xmltvid='35484' where xmltvid='fxuk.tv'; -- Fox | ||
update channel set xmltvid='17442' where xmltvid='gold.uktv.co.uk'; -- Gold | update channel set xmltvid='17442' where xmltvid='gold.uktv.co.uk'; -- Gold | ||
update channel set xmltvid='28634' where xmltvid='goodfood.uktv.co.uk'; -- Good Food | update channel set xmltvid='28634' where xmltvid='goodfood.uktv.co.uk'; -- Good Food | ||
+ | update channel set xmltvid='97267' where xmltvid='hd.aljazeera.net'; -- Al Jazeera Eng HD | ||
update channel set xmltvid='69387' where xmltvid='hd.bbc1.bbc.co.uk'; -- BBC ONE HD | update channel set xmltvid='69387' where xmltvid='hd.bbc1.bbc.co.uk'; -- BBC ONE HD | ||
update channel set xmltvid='50059' where xmltvid='hd.bbc2.bbc.co.uk'; -- BBC TWO HD | update channel set xmltvid='50059' where xmltvid='hd.bbc2.bbc.co.uk'; -- BBC TWO HD | ||
+ | update channel set xmltvid='83282' where xmltvid='hd.bbcfour.bbc.co.uk'; -- BBC FOUR HD | ||
update channel set xmltvid='83281' where xmltvid='hd.cbbc.bbc.co.uk'; -- CBBC HD | update channel set xmltvid='83281' where xmltvid='hd.cbbc.bbc.co.uk'; -- CBBC HD | ||
+ | update channel set xmltvid='83283' where xmltvid='hd.cbeebies.bbc.co.uk'; -- CBeebies HD | ||
+ | update channel set xmltvid='50717' where xmltvid='hd.five.tv'; -- Channel 5 HD | ||
+ | update channel set xmltvid='83285' where xmltvid='hd.news.bbc.co.uk'; -- BBC NEWS HD | ||
update channel set xmltvid='67073' where xmltvid='hd.southeast-macro.itv1.itv.co.uk'; -- ITV HD | update channel set xmltvid='67073' where xmltvid='hd.southeast-macro.itv1.itv.co.uk'; -- ITV HD | ||
update channel set xmltvid='24657' where xmltvid='health.discovery.com'; -- Discovery Home & Health | update channel set xmltvid='24657' where xmltvid='health.discovery.com'; -- Discovery Home & Health | ||
Line 414: | Line 491: | ||
update channel set xmltvid='60936' where xmltvid='plus-1.universalchannel.co.uk'; -- Universal +1 | update channel set xmltvid='60936' where xmltvid='plus-1.universalchannel.co.uk'; -- Universal +1 | ||
update channel set xmltvid='24073' where xmltvid='plus-1.xd.disney.co.uk'; -- Disney XD +1 | update channel set xmltvid='24073' where xmltvid='plus-1.xd.disney.co.uk'; -- Disney XD +1 | ||
+ | update channel set xmltvid='33638' where xmltvid='popfun.co.uk'; -- POP | ||
update channel set xmltvid='62391' where xmltvid='quest.discoveryeurope.com'; -- Quest | update channel set xmltvid='62391' where xmltvid='quest.discoveryeurope.com'; -- Quest | ||
update channel set xmltvid='21810' where xmltvid='qvcuk.com'; -- QVC | update channel set xmltvid='21810' where xmltvid='qvcuk.com'; -- QVC | ||
Line 434: | Line 512: | ||
update channel set xmltvid='26084' where xmltvid='smashhits.net'; -- Smash Hits! TV | update channel set xmltvid='26084' where xmltvid='smashhits.net'; -- Smash Hits! TV | ||
update channel set xmltvid='31759' where xmltvid='sonytv.com'; -- Sony TV | update channel set xmltvid='31759' where xmltvid='sonytv.com'; -- Sony TV | ||
+ | update channel set xmltvid='24326' where xmltvid='south.bbc1.bbc.co.uk'; -- BBC One (South) | ||
+ | update channel set xmltvid='17154' where xmltvid='south.bbc2.bbc.co.uk'; -- BBC Two | ||
update channel set xmltvid='24337' where xmltvid='south-east.bbc1.bbc.co.uk'; -- BBC ONE S East | update channel set xmltvid='24337' where xmltvid='south-east.bbc1.bbc.co.uk'; -- BBC ONE S East | ||
update channel set xmltvid='17154' where xmltvid='south-east.bbc2.bbc.co.uk'; -- BBC TWO | update channel set xmltvid='17154' where xmltvid='south-east.bbc2.bbc.co.uk'; -- BBC TWO | ||
Line 442: | Line 522: | ||
update channel set xmltvid='21492' where xmltvid='thebox.co.uk'; -- The Box | update channel set xmltvid='21492' where xmltvid='thebox.co.uk'; -- The Box | ||
update channel set xmltvid='21558' where xmltvid='thehistorychannel.co.uk'; -- History Channel | update channel set xmltvid='21558' where xmltvid='thehistorychannel.co.uk'; -- History Channel | ||
+ | update channel set xmltvid='34087' where xmltvid='tinypop.com'; -- Tiny Pop | ||
update channel set xmltvid='31760' where xmltvid='too.cartoonnetwork.com'; -- Cartoonito | update channel set xmltvid='31760' where xmltvid='too.cartoonnetwork.com'; -- Cartoonito | ||
update channel set xmltvid='31168' where xmltvid='toons.nickelodeon.co.uk'; -- Nicktoons TV | update channel set xmltvid='31168' where xmltvid='toons.nickelodeon.co.uk'; -- Nicktoons TV | ||
Line 457: | Line 538: | ||
update channel set xmltvid='25630' where xmltvid='tsod.plus-1.filmfour.channel4.com'; -- Film4 +1 | update channel set xmltvid='25630' where xmltvid='tsod.plus-1.filmfour.channel4.com'; -- Film4 +1 | ||
update channel set xmltvid='56890' where xmltvid='tsod.plus-1.fiveusa.channel5.co.uk'; -- 5 USA +1 | update channel set xmltvid='56890' where xmltvid='tsod.plus-1.fiveusa.channel5.co.uk'; -- 5 USA +1 | ||
+ | update channel set xmltvid='44855' where xmltvid='tsod.plus-1.freeview.dave.uktv.co.uk'; -- Dave ja vu | ||
+ | update channel set xmltvid='98366' where xmltvid='tsod.plus-1.freeview.itv3.itv.co.uk'; -- ITV3+1 | ||
+ | update channel set xmltvid='61806' where xmltvid='tsod.plus-1.freeview.itv4.itv.co.uk'; -- ITV4+1 | ||
update channel set xmltvid='31351' where xmltvid='tsod.plus-1.gold.uktv.co.uk'; -- Gold +1 | update channel set xmltvid='31351' where xmltvid='tsod.plus-1.gold.uktv.co.uk'; -- Gold +1 | ||
update channel set xmltvid='34898' where xmltvid='tsod.plus-1.goodfood.uktv.co.uk'; -- Good Food +1 | update channel set xmltvid='34898' where xmltvid='tsod.plus-1.goodfood.uktv.co.uk'; -- Good Food +1 | ||
Line 467: | Line 551: | ||
update channel set xmltvid='35370' where xmltvid='tsod.plus-1.mtv.co.uk'; -- MTV +1 | update channel set xmltvid='35370' where xmltvid='tsod.plus-1.mtv.co.uk'; -- MTV +1 | ||
update channel set xmltvid='24112' where xmltvid='tsod.plus-1.nationalgeographic.co.uk'; -- National Geographic +1 | update channel set xmltvid='24112' where xmltvid='tsod.plus-1.nationalgeographic.co.uk'; -- National Geographic +1 | ||
+ | update channel set xmltvid='65394' where xmltvid='tsod.plus-1.quest.discoveryeurope.com'; -- QUEST+1 | ||
update channel set xmltvid='45510' where xmltvid='tsod.plus-1.reality.cbs.com'; -- CBS Reality +1 | update channel set xmltvid='45510' where xmltvid='tsod.plus-1.reality.cbs.com'; -- CBS Reality +1 | ||
+ | update channel set xmltvid='65161' where xmltvid='tsod.plus-1.southeast-macro.itv1.itv.co.uk'; -- ITV +1 | ||
update channel set xmltvid='24699' where xmltvid='tsod.plus-1.thehistorychannel.co.uk'; -- History Channel +1 | update channel set xmltvid='24699' where xmltvid='tsod.plus-1.thehistorychannel.co.uk'; -- History Channel +1 | ||
update channel set xmltvid='49969' where xmltvid='tsod.plus-1.uk.syfy.com'; -- SyFy +1 | update channel set xmltvid='49969' where xmltvid='tsod.plus-1.uk.syfy.com'; -- SyFy +1 | ||
update channel set xmltvid='61459' where xmltvid='tsod.plus-1.watch.uktv.co.uk'; -- Watch +1 | update channel set xmltvid='61459' where xmltvid='tsod.plus-1.watch.uktv.co.uk'; -- Watch +1 | ||
update channel set xmltvid='35706' where xmltvid='tsod.plus-1.yesterday.uktv.co.uk'; -- Yesterday +1 | update channel set xmltvid='35706' where xmltvid='tsod.plus-1.yesterday.uktv.co.uk'; -- Yesterday +1 | ||
+ | update channel set xmltvid='97294' where xmltvid='tsod.plus-24.channel5.co.uk'; -- Channel 5+24 | ||
update channel set xmltvid='24284' where xmltvid='turbo.discoveryeurope.com'; -- Discovery Turbo | update channel set xmltvid='24284' where xmltvid='turbo.discoveryeurope.com'; -- Discovery Turbo | ||
update channel set xmltvid='21495' where xmltvid='tv5.org'; -- TV5Monde Europe | update channel set xmltvid='21495' where xmltvid='tv5.org'; -- TV5Monde Europe | ||
update channel set xmltvid='17667' where xmltvid='uk.cartoonnetwork.com'; -- Cartoon Network | update channel set xmltvid='17667' where xmltvid='uk.cartoonnetwork.com'; -- Cartoon Network | ||
update channel set xmltvid='17431' where xmltvid='uk.syfy.com'; -- SyFy | update channel set xmltvid='17431' where xmltvid='uk.syfy.com'; -- SyFy | ||
+ | update channel set xmltvid='31787' where xmltvid='uk.viva.tv'; -- VIVA | ||
update channel set xmltvid='24671' where xmltvid='universalchannel.co.uk'; -- Universal | update channel set xmltvid='24671' where xmltvid='universalchannel.co.uk'; -- Universal | ||
update channel set xmltvid='17745' where xmltvid='vh1.co.uk'; -- VH1 | update channel set xmltvid='17745' where xmltvid='vh1.co.uk'; -- VH1 | ||
Line 485: | Line 573: | ||
update channel set xmltvid='31783' where xmltvid='yesterday.uktv.co.uk'; -- Yesterday | update channel set xmltvid='31783' where xmltvid='yesterday.uktv.co.uk'; -- Yesterday | ||
</nowiki></pre> | </nowiki></pre> | ||
+ | |||
+ | [[Category:EPG Providers]] |
Revision as of 20:13, 10 July 2016
This is a write up from memory of the main steps taken to set up Schedules Direct (SD) for a UK configuration, especially with respect to converting old Radio Times (RT) or Atlas feed configurations, both of which will be becoming unavailable at time of writing.
Back up your database. I take no responsibility for mistake or errors below or on your part - double check everything!
Contents
Create an account on Schedules Direct
Go to http://schedulesdirect.org/ and create an account; you get a 7 day free trial, which you can and should extend by a year (US$25) once you know it works for you. You'll need your username and password.
You do not need to do anything else on their website, the line-up configuration is all done by the grabber script.
Acquire XMLTV with tv_grab_sd_json
This step, which is beyond the scope of this article (somewhat unfortunately since it's not a small step) is to acquire the initial snapshot version of XMLTV containing a working tv_grab_sd_json (http://snapshot.xmltv.org/). This is required at time of writing (2016/05/22) - post xmltv release 0.5.67 - so it should be in 0.5.68 onwards.
I built both CentOS-6 and Fedora 23 RPMs; my Myth box is on CentOS-6 but that has a version of perl UserAgent too old to work with the configuration side of the grabber, so I had to do the config. on my Fedora box. Listing fetching works OK on CentOS-6 though.
You may find this brief installation process posted on the xmltv mailing list useful (courtesy of Ian Campbell):
- Grabbed https://github.com/knowledgejunkie/XMLTV.git (which is a mirror of the official CVS, but seems to be up to date enough)
- "perl Makefile.pl && make"
- Copied blib/script/tv_grab_sd_json to /usr/local/bin (I did it this way because the Debian packages haven't picked up sd_json yet so this is just a stopgap until they do.
I'll expand on that because it is a bit tortuous:
The download http://snapshot.xmltv.org/ gives you a zip file which needs expanding. That reveals a README which is very useful.
If you try ./Makefiles.PL it may well mention missing dependences which will prevent the generation of tv_grab_sd_json.
With Ubuntu I had to do:
sudo apt-get install XMLTV sudo apt-get install libdatetime-format-dateparse-perl cpan > install XML::TreePP > install Lingua::EN::Numbers::Ordinate > exit
Only then did this work:
./Makefile.pl make make test make install
That worked and the grabber was then in a sub directory:
grab/sd_json/tv_grab_sd_json
Copy that to /usr/bin and
chmod 755 tv_grab_sd_json
Configure your feeds for the first time
Run:
tv_grab_sd_json --configure
.. and answer its questions.
- Ask for MythTV format channel IDs (5-digits), if only because that's what I used and appears in my mappings below.
- Where it asks for the country, I used GBR but apparently if you know the specific feed (and the list it offers after your post-code doesn't contain what you want (raise a ticket with SD in this case, they're very good as responding) you can enter the full line-up code (e.g., GBR-0001172-DEFAULT). See http://article.gmane.org/gmane.comp.tv.xmltv.devel/11247 for a list of codes for UK transmitters.
- If you can, use the code provided by the above link for your DVB-T transmitter. The post-code-based one (“OTA”) is actually likely not what you want (although it will offer the correct Satellite options).
- For your post-code, only enter first part, as it otherwise gets confused and only offers you limited (non-localised) sources.
- Ask for individual channels, not the full line-up, as it'll give you a chance to diagnose channel list issues, & disable channels (in the config file it creates, via “channel!12345” instead of “channel=12345”). For my BSkyB listings, the full set was ~600 channels, and I don't use anything like that many.
You should get a viable configuration file out of it, in ~/.xmltv/tv_grab_sd_json.conf, and see the list of xmltvids you have available. The file has configuration information at the head (eg username and password) followed by lines of the form channel=12345 .
Do a trial run
Run the grabber and check you get something sensible. If you have the default initial channel list this might give quite a large XML file.
tv_grab_sd_json --config-file ~/.xmltv/tv_grab_sd_json.conf --output /tmp/sd.xml
Make sure the grabber runs OK and the output file looks sane.
The file has entries like this:
<channel id="30644"> <display-name>BBC One (London)</display-name> <display-name>BBC1LDN</display-name> <display-name>001</display-name> </channel>
In this case, it is saying that the XMLTVID for BBC One (London) is 30644.
Update MythTV
Backup your database now! If you don't use /usr/share/mythtv/mythconverg_backup.pl on a regular basis, start now.
Change the grabber configuration in mythtvsetup
You should probably edit your sources in mythtvsetup (remember you need to stop mythbackend when running that) to use tv_grab_sd_json. It is not believed that the built-in SD option in Myth works outside of the US as we think it still uses the XML API from SD, not the new JSON one, and only that has non-US feeds.
I haven't yet done that, as I run a script that fetches and injects the listings outside of Myth instead of getting it to do it off its own back for various reasons.
Update the channel database to use the SD channel IDs
Well, you can do this manually, or use a version of the SQL script below. Either use the mythtvsetup editor or the SQL command line. See the xmltvid mappings below.
Alternatively, Channel Editor version 2.01 (8 July 2016) has code which will read the huge file above, allow manual matching of the channels which do not match automatically and insert the ids into the database. It will do this and lots more which you would expect of a channel editor.
If you use the script below, search your setup for channel IDs that still aren't the 5-digit SD format, as you'll need to convert those yourself (and please add them to the list below for others!)
Remove old program IDs from the database
This is optional, and your call. I did it, and it mostly worked out OK.
It looks like if we change data source (and get different programme IDs) we might have to delete the programme IDs for all previously recorded episodes. If both previous and upcoming episodes have IDs, MythTV only uses them to detect duplicates, and thus will re-record everything it comes across. If one of the other is missing, it falls back to the usual mechanism (title/subtitle/etc.).
I used the following within mysql to delete old program IDs that XMLTV had injected (the patterns hopefully exclude those added by over-the-air EIT listings which will carry on as normal).
update oldrecorded set programid='' where \ programid rlike '^EP[0-9]+[a-z]?$' or \ programid rlike '^MV[0-9]+[a-z]?$' or \ programid rlike '^SH[0-9]+[a-z]?$' or \ programid rlike '^SP[0-9]+[a-z]?$'; update recorded set programid='' where \ programid rlike '^EP[0-9]+[a-z]?$' or \ programid rlike '^MV[0-9]+[a-z]?$' or \ programid rlike '^SH[0-9]+[a-z]?$' or \ programid rlike '^SP[0-9]+[a-z]?$'; update recordedprogram set programid='' where \ programid rlike '^EP[0-9]+[a-z]?$' or \ programid rlike '^MV[0-9]+[a-z]?$' or \ programid rlike '^SH[0-9]+[a-z]?$' or \ programid rlike '^SP[0-9]+[a-z]?$';
Even after this, I still found a whole load of re-recordings appear, but I think it would have been worse without doing it. If you skip this step, you'll probably just have to perform a little more upcoming-recordings maintenance for a while.
Set up the xmltv config
Copy ~/.xmltv/tv_grab_sd_json.conf over your previous ~/.mythtv/SOURCENAME.xmltv file(s), or maybe even creat the symbolic link to the xmltv original.
I actually copy the config. to a SOURCE.xmltv.hdr, and delete all the channel lines. Then, in my fetch script, I extend the config file (each time) with just the channels I have in my database, so that if I fiddle with channels, I don't have to remember to update the xmltv files (which I used to pretty much forget every time!).
# For the Freeview source, which is sourceid 1 in my setup cp -f $HOME/.mythtv/Freeview.xmltv.hdr $HOME/.mythtv/Freeview.xmltv mysql -NB -u DBUSER --password=DBPASS mythconverg -e \ 'select distinct concat("channel=",xmltvid) from channel where sourceid = 1 and xmltvid <> "" order by xmltvid' \ >> $HOME/.mythtv/Freeview.xmltv
It may be simpler to use Channel Editor which has a routine to generate all the SOURCENAME.xmltv files automatically. It will generate a file for each source, with channels marked for inclusion (with = ) which are non-UseEIT, are visible are in the appropriate source and have a non blank XMLTVID. Other channels are marked for exclusion (with ! ). After manual inspection, they simply need copying over from current working directory to ~/.mythtv.
Perform your first update
If you just go with the flow, it should be as simple as:
mythfilldatabase
At least initially, I recommend the following, to prevent extra rogue channels from your lineup being added. I always automatically check for and delete automatically added channels after the fetch (those without a channum field).
mythfilldatabase --only-update-guide --dont-refresh-tba
If you do things manually, follow your own modified process to do the deed.
Problems?
Try searching both the mythtv-users and xmltv-users mailing lists. If you want to post something, xmltv-users would be best solely for issues with the grabber, otherwise you should head to the mythtv-users list.
Please update this page with error fixes or other useful information!
Gotchas
- “Marvel's Agents of SHIELD” now comes down (correctly) as “Marvel's Agents of S.H.I.E.L.D.” so existing rules likely won't match.
Appendices
Mapping of old RT IDs to new SD IDs
Please amend as you see fit, this is only the list of channels matching my set-up (South-East Freeview and BSkyB). Take the channel names with a bit of a pinch of salt - they could be well out of date as these things tend to change on a regular basis, and also reflect my preferences over advertised channel names(!).
The IDs may also be old ones which the RT grabber aliased when the channels changed; my setup dates back to 2004.
EDIT - Unlike the RT UK IDs, some channels will possibly have different SD IDs depending upon their source; I initially made this focussed on a Sky channel listing, but a couple are not present in DVB-T line-ups (selected from the transmitter-based list as opposed the the script-0proferred post-code based list). I've updated the list below, but not the SQL conversion script after it. You'll have to adjust those manually. Check the output of running tv_grab_sd_json for unrecognised channel IDs.
1.movies4men.co.uk 46306 # Movies4Men 1.truemovies.tv 50011 # True Movies 2 2.jr.nickelodeon.co.uk 50269 # Nick Jr 2 2.truemovies.tv 44717 # True Movies 1 4music.channel4.com 31786 # 4Music 4seven.channel4.com 75804 # 4seven 6music.radio.bbc.co.uk 30166 # BBC 6 Music action.cbs.com 73970 # CBS Action alibi.uktv.co.uk 21258 # Alibi animalplanet.discoveryeurope.com 20707 # Animal Planet arts.sky.com 24919 # Sky Arts atlantic.sky.com 70434 # Sky Atlantic b4utv.com 25529 # B4U Movies base.mtv.co.uk 24217 # MTV Base bbcfour.bbc.co.uk 20684 # BBC FOUR bloomberg.com 20711 # Bloomberg Television boomerang.cartoonnetwork.com 24341 # Boomerang british.eurosport.com 18337 # British Eurosport cbbc.bbc.co.uk 29324 # CBBC cbeebies.bbc.co.uk 29325 # CBeebies central.itv1.itv.co.uk 21832 # ITV 1 London (Carlton) challengetv.co.uk 17454 # TLC channel4.com 17155 # Channel 4 channel5.co.uk 17157 # Channel 5 citv.itv.co.uk 49452 # CITV comedycentral.com 17420 # Comedy Central communitychannel.org 24677 # Community Channel dance.mtv.co.uk 25976 # MTV Dance dave.uktv.co.uk 24305 # Dave discoveryeurope.com 17444 # Discovery Channel disneychannel.disney.co.uk 18377 # Disney Channel drama.cbs.com 57827 # CBS Drama e4.channel4.com 25117 # E4 eden.uktv.co.uk 35806 # Eden eentertainment.com 32195 # E! Entertainment encore.itv.com 89886 # ITV Encore entertainment.truemovies.tv 57747 # True Entertainment euronews.com 82432 # Euronews europe.cnbc.com 16230 # CNBC Europe europe.cnn.com 68053 # CNN International extra.5live.radio.bbc.co.uk 29920 # BBC 5L SportsX extra.comedycentral.com 34230 # Comedy Central Extra filmfour.channel4.com 21494 # Film4 fiver.channel5.co.uk 52336 # 5* fiveusa.channel5.co.uk 52335 # 5 USA freeview.communitychannel.org 24677 # Community freeview.foodnetwork.com 44718 # Food Network freeview.hd.channel4.com 50716 # Channel 4 HD fxuk.tv 35484 # Fox gold.uktv.co.uk 17442 # Gold goodfood.uktv.co.uk 28634 # Good Food hd.aljazeera.net 97267 # Al Jazeera Eng HD hd.bbc1.bbc.co.uk 69387 # BBC ONE HD hd.bbc2.bbc.co.uk 50059 # BBC TWO HD hd.bbcfour.bbc.co.uk 83282 # BBC FOUR HD hd.cbbc.bbc.co.uk 83281 # CBBC HD hd.cbeebies.bbc.co.uk 83283 # CBeebies HD hd.five.tv 50717 # Channel 5 HD hd.news.bbc.co.uk 83285 # BBC NEWS HD hd.southeast-macro.itv1.itv.co.uk 67073 # ITV HD health.discovery.com 24657 # Discovery Home & Health history.discoveryeurope.com 24280 # Discovery History hits.mtv.co.uk 24214 # MTV Hits home.uktv.co.uk 21257 # Home horror.cbs.com 42762 # Horror Channel idealworld.tv 24669 # Ideal World itv2.itv.co.uk 20630 # ITV2 itv3.itv.co.uk 44643 # ITV3 itv4.itv.co.uk 48020 # ITV4 jr.nickelodeon.co.uk 24025 # Nick Jr kerrang.com 25627 # Kerrang! TV kiss-tv.kiss100.com 25605 # Kiss TV living.sky.com 17443 # Sky Living magictv.co.uk 25607 # Magic meridian.itv1.itv.co.uk 21826 # ITV1 more4.channel4.com 47657 # More 4 motors.tv 30141 # Motors TV mtv.co.uk 58695 # MTV UK nationalgeographic.co.uk 21592 # National Geographic news.bbc.co.uk 19037 # BBC NEWS news.eurosport.com 27413 # British Eurosport 2 news.sports.sky.com 20643 # Sky Sports News nickelodeon.co.uk 17419 # Nickelodeon UK northern-ireland.bbc2.bbc.co.uk 29046 # BBC 2 Northern Ireland parliament.bbc.co.uk 20685 # BBC Parliament playboy.com 69376 # Playboy TV plus-1.1.movies4men.co.uk 59406 # Movies4Men +1 plus-1.comedycentral.com 47480 # Comedy Central +1 plus-1.meridian.itv1.itv.co.uk 65161 # ITV1 +1 plus-1.quest.discoveryeurope.com 65394 # Quest +1 plus-1.science.discoveryeurope.com 56266 # Discovery Science +1 plus-1.universalchannel.co.uk 60936 # Universal +1 plus-1.xd.disney.co.uk 24073 # Disney XD +1 popfun.co.uk 33638 # POP quest.discoveryeurope.com 62391 # Quest qvcuk.com 21810 # QVC radio-1.bbc.co.uk 24434 # BBC Radio 1 radio-2.bbc.co.uk 24435 # BBC Radio 2 radio-3.bbc.co.uk 24436 # BBC Radio 3 radio-4.bbc.co.uk 24437 # BBC Radio 4 radio-5.bbc.co.uk 24438 # BBC R5 Live reality.cbs.com 31756 # CBS Reality really.uktv.co.uk 45828 # Really sat.2.travelchannel.co.uk 32286 # Travel Channel +1 sat.travelchannel.co.uk 17453 # Travel Channel science.discoveryeurope.com 24282 # Discovery Science scuzz.tv 32669 # Scuzz setindia.com 57603 # Sony Entertainment TV Asia sky-news.sky.com 16234 # Sky News sky-one.sky.com 16235 # Sky One sky-three.sky.com 48021 # Pick TV sky-two.sky.com 32151 # Sky 2 smashhits.net 26084 # Smash Hits! TV sonytv.com 31759 # Sony TV south.bbc1.bbc.co.uk 24326 # BBC One (South) south.bbc2.bbc.co.uk 17154 # BBC Two south-east.bbc1.bbc.co.uk 24337 # BBC ONE S East south-east.bbc2.bbc.co.uk 17154 # BBC TWO spike.com 97330 # Spike tcm.turner.com 88256 # TCM televisionx.co.uk 47738 # Television X theadultchannel.co.uk 66975 # The Adult Channel thebox.co.uk 21492 # The Box thehistorychannel.co.uk 21558 # History Channel tinypop.com 34087 # Tiny Pop too.cartoonnetwork.com 31760 # Cartoonito toons.nickelodeon.co.uk 31168 # Nicktoons TV tsod.plus-1.alibi.uktv.co.uk 45509 # Alibi +1 tsod.plus-1.animalplanet.discoveryeurope.com 26098 # Animal Planet +1 tsod.plus-1.boomerang.cartoonnetwork.com 48928 # Boomerang +1 tsod.plus-1.challengetv.co.uk 45283 # Challenge +1 tsod.plus-1.channel4.com 56892 # Channel 4 +1 tsod.plus-1.channel5.co.uk 56888 # Channel 5 +1 (Sky) tsod.plus-1.channel5.co.uk 97294 # Channel 5 +1 (DVB-T) tsod.plus-1.dave.uktv.co.uk 44855 # Dave ja vu tsod.plus-1.discoveryeurope.com 21557 # Discovery Channel +1 tsod.plus-1.disneychannel.disney.co.uk 50587 # Disney Channel +1 tsod.plus-1.e4.channel4.com 33882 # E4 +1 tsod.plus-1.eden.uktv.co.uk 35945 # Eden +1 tsod.plus-1.filmfour.channel4.com 25630 # Film4 +1 tsod.plus-1.fiveusa.channel5.co.uk 56890 # 5 USA +1 tsod.plus-1.freeview.dave.uktv.co.uk 44855 # Dave ja vu tsod.plus-1.freeview.itv3.itv.co.uk 98366 # ITV3+1 tsod.plus-1.freeview.itv4.itv.co.uk 61806 # ITV4+1 tsod.plus-1.gold.uktv.co.uk 31351 # Gold +1 tsod.plus-1.goodfood.uktv.co.uk 34898 # Good Food +1 tsod.plus-1.health.discovery.com 46490 # Discovery Home & Health +1 tsod.plus-1.home.uktv.co.uk 29969 # Home +1 tsod.plus-1.itv2.itv.co.uk 53059 # ITV2 +1 tsod.plus-1.itv3.itv.co.uk 53060 # ITV3+1 (Sky) tsod.plus-1.itv3.itv.co.uk 98366 # ITV3+1 (DVB-T) tsod.plus-1.living.sky.com 31949 # Sky Living +1 tsod.plus-1.more4.channel4.com 47658 # More 4 +1 tsod.plus-1.mtv.co.uk 35370 # MTV +1 tsod.plus-1.nationalgeographic.co.uk 24112 # National Geographic +1 tsod.plus-1.quest.discoveryeurope.com 65394 # QUEST+1 tsod.plus-1.reality.cbs.com 45510 # CBS Reaity +1 tsod.plus-1.southeast-macro.itv1.itv.co.uk 65161 # ITV +1 tsod.plus-1.thehistorychannel.co.uk 24699 # History Channel +1 tsod.plus-1.uk.syfy.com 49969 # SyFy +1 tsod.plus-1.watch.uktv.co.uk 61459 # Watch +1 tsod.plus-1.yesterday.uktv.co.uk 35706 # Yesterday +1 tsod.plus-24.channel5.co.uk 97294 # Channel 5+24 turbo.discoveryeurope.com 24284 # Discovery Turbo tv5.org 21495 # TV5Monde Europe uk.cartoonnetwork.com 17667 # Cartoon Network uk.syfy.com 17431 # SyFy uk.viva.tv 31787 # VIVA universalchannel.co.uk 24671 # Universal vh1.co.uk 17745 # VH1 wales.bbc2.bbc.co.uk 28573 # BBC 2 Wales watch.uktv.co.uk 61458 # Watch wild.nationalgeographic.co.uk 23305 # National Geographic Wild xd.disney.co.uk 18379 # Disney XD xtra.1.radio.bbc.co.uk 31266 # 1Xtra BBC yesterday.uktv.co.uk 31783 # Yesterday
SQL script to convert the xmltvids in the database
This script should convert the xmltvid values in your database from RT ones to SD ones. I prefer to save this sort of thing off as a file, and then running it into a command-liane manually, as it allows you to test it with a copy of the file with just a single line in case of problems. If you save it as xmltv-map.sql then:
mysql --default-character-set=utf8 -u DBUSER --password=DBPASS mythconverg < xmltv-map.sql
Amend the same as per the mappings above! You don't have to remove any channels you don't have, as the SQL commands for those will simply do nothing on your system.
update channel set xmltvid='46306' where xmltvid='1.movies4men.co.uk'; -- Movies4Men update channel set xmltvid='50011' where xmltvid='1.truemovies.tv'; -- True Movies 2 update channel set xmltvid='50269' where xmltvid='2.jr.nickelodeon.co.uk'; -- Nick Jr 2 update channel set xmltvid='44717' where xmltvid='2.truemovies.tv'; -- True Movies 1 update channel set xmltvid='31786' where xmltvid='4music.channel4.com'; -- 4Music update channel set xmltvid='75804' where xmltvid='4seven.channel4.com'; -- 4seven update channel set xmltvid='30166' where xmltvid='6music.radio.bbc.co.uk'; -- BBC 6 Music update channel set xmltvid='73970' where xmltvid='action.cbs.com'; -- CBS Action update channel set xmltvid='21258' where xmltvid='alibi.uktv.co.uk'; -- Alibi update channel set xmltvid='20707' where xmltvid='animalplanet.discoveryeurope.com'; -- Animal Planet update channel set xmltvid='24919' where xmltvid='arts.sky.com'; -- Sky Arts update channel set xmltvid='70434' where xmltvid='atlantic.sky.com'; -- Sky Atlantic update channel set xmltvid='25529' where xmltvid='b4utv.com'; -- B4U Movies update channel set xmltvid='24217' where xmltvid='base.mtv.co.uk'; -- MTV Base update channel set xmltvid='20684' where xmltvid='bbcfour.bbc.co.uk'; -- BBC FOUR update channel set xmltvid='20711' where xmltvid='bloomberg.com'; -- Bloomberg Television update channel set xmltvid='24341' where xmltvid='boomerang.cartoonnetwork.com'; -- Boomerang update channel set xmltvid='18337' where xmltvid='british.eurosport.com'; -- British Eurosport update channel set xmltvid='29324' where xmltvid='cbbc.bbc.co.uk'; -- CBBC update channel set xmltvid='29325' where xmltvid='cbeebies.bbc.co.uk'; -- CBeebies update channel set xmltvid='21832' where xmltvid='central.itv1.itv.co.uk'; -- ITV 1 London (Carlton) update channel set xmltvid='17454' where xmltvid='challengetv.co.uk'; -- TLC update channel set xmltvid='17155' where xmltvid='channel4.com'; -- Channel 4 update channel set xmltvid='17157' where xmltvid='channel5.co.uk'; -- Channel 5 update channel set xmltvid='49452' where xmltvid='citv.itv.co.uk'; -- CITV update channel set xmltvid='17420' where xmltvid='comedycentral.com'; -- Comedy Central update channel set xmltvid='24677' where xmltvid='communitychannel.org'; -- Community Channel update channel set xmltvid='25976' where xmltvid='dance.mtv.co.uk'; -- MTV Dance update channel set xmltvid='24305' where xmltvid='dave.uktv.co.uk'; -- Dave update channel set xmltvid='17444' where xmltvid='discoveryeurope.com'; -- Discovery Channel update channel set xmltvid='18377' where xmltvid='disneychannel.disney.co.uk'; -- Disney Channel update channel set xmltvid='57827' where xmltvid='drama.cbs.com'; -- CBS Drama update channel set xmltvid='25117' where xmltvid='e4.channel4.com'; -- E4 update channel set xmltvid='35806' where xmltvid='eden.uktv.co.uk'; -- Eden update channel set xmltvid='32195' where xmltvid='eentertainment.com'; -- E! Entertainment update channel set xmltvid='89886' where xmltvid='encore.itv.com'; -- ITV Encore update channel set xmltvid='57747' where xmltvid='entertainment.truemovies.tv'; -- True Entertainment update channel set xmltvid='82432' where xmltvid='euronews.com'; -- Euronews update channel set xmltvid='16230' where xmltvid='europe.cnbc.com'; -- CNBC Europe update channel set xmltvid='68053' where xmltvid='europe.cnn.com'; -- CNN International update channel set xmltvid='29920' where xmltvid='extra.5live.radio.bbc.co.uk'; -- BBC 5L SportsX update channel set xmltvid='34230' where xmltvid='extra.comedycentral.com'; -- Comedy Central Extra update channel set xmltvid='21494' where xmltvid='filmfour.channel4.com'; -- Film4 update channel set xmltvid='52336' where xmltvid='fiver.channel5.co.uk'; -- 5* update channel set xmltvid='52335' where xmltvid='fiveusa.channel5.co.uk'; -- 5 USA update channel set xmltvid='24677' where xmltvid='freeview.communitychannel.org'; -- Community update channel set xmltvid='44718' where xmltvid='freeview.foodnetwork.com'; -- Food Network update channel set xmltvid='50716' where xmltvid='freeview.hd.channel4.com'; -- Channel 4 HD update channel set xmltvid='35484' where xmltvid='fxuk.tv'; -- Fox update channel set xmltvid='17442' where xmltvid='gold.uktv.co.uk'; -- Gold update channel set xmltvid='28634' where xmltvid='goodfood.uktv.co.uk'; -- Good Food update channel set xmltvid='97267' where xmltvid='hd.aljazeera.net'; -- Al Jazeera Eng HD update channel set xmltvid='69387' where xmltvid='hd.bbc1.bbc.co.uk'; -- BBC ONE HD update channel set xmltvid='50059' where xmltvid='hd.bbc2.bbc.co.uk'; -- BBC TWO HD update channel set xmltvid='83282' where xmltvid='hd.bbcfour.bbc.co.uk'; -- BBC FOUR HD update channel set xmltvid='83281' where xmltvid='hd.cbbc.bbc.co.uk'; -- CBBC HD update channel set xmltvid='83283' where xmltvid='hd.cbeebies.bbc.co.uk'; -- CBeebies HD update channel set xmltvid='50717' where xmltvid='hd.five.tv'; -- Channel 5 HD update channel set xmltvid='83285' where xmltvid='hd.news.bbc.co.uk'; -- BBC NEWS HD update channel set xmltvid='67073' where xmltvid='hd.southeast-macro.itv1.itv.co.uk'; -- ITV HD update channel set xmltvid='24657' where xmltvid='health.discovery.com'; -- Discovery Home & Health update channel set xmltvid='24280' where xmltvid='history.discoveryeurope.com'; -- Discovery History update channel set xmltvid='24214' where xmltvid='hits.mtv.co.uk'; -- MTV Hits update channel set xmltvid='21257' where xmltvid='home.uktv.co.uk'; -- Home update channel set xmltvid='42762' where xmltvid='horror.cbs.com'; -- Horror Channel update channel set xmltvid='24669' where xmltvid='idealworld.tv'; -- Ideal World update channel set xmltvid='20630' where xmltvid='itv2.itv.co.uk'; -- ITV2 update channel set xmltvid='44643' where xmltvid='itv3.itv.co.uk'; -- ITV3 update channel set xmltvid='48020' where xmltvid='itv4.itv.co.uk'; -- ITV4 update channel set xmltvid='24025' where xmltvid='jr.nickelodeon.co.uk'; -- Nick Jr update channel set xmltvid='25627' where xmltvid='kerrang.com'; -- Kerrang! TV update channel set xmltvid='25605' where xmltvid='kiss-tv.kiss100.com'; -- Kiss TV update channel set xmltvid='17443' where xmltvid='living.sky.com'; -- Sky Living update channel set xmltvid='25607' where xmltvid='magictv.co.uk'; -- Magic update channel set xmltvid='21826' where xmltvid='meridian.itv1.itv.co.uk'; -- ITV1 update channel set xmltvid='47657' where xmltvid='more4.channel4.com'; -- More 4 update channel set xmltvid='30141' where xmltvid='motors.tv'; -- Motors TV update channel set xmltvid='58695' where xmltvid='mtv.co.uk'; -- MTV UK update channel set xmltvid='21592' where xmltvid='nationalgeographic.co.uk'; -- National Geographic update channel set xmltvid='19037' where xmltvid='news.bbc.co.uk'; -- BBC NEWS update channel set xmltvid='27413' where xmltvid='news.eurosport.com'; -- British Eurosport 2 update channel set xmltvid='20643' where xmltvid='news.sports.sky.com'; -- Sky Sports News update channel set xmltvid='17419' where xmltvid='nickelodeon.co.uk'; -- Nickelodeon UK update channel set xmltvid='29046' where xmltvid='northern-ireland.bbc2.bbc.co.uk'; -- BBC 2 Northern Ireland update channel set xmltvid='20685' where xmltvid='parliament.bbc.co.uk'; -- BBC Parliament update channel set xmltvid='69376' where xmltvid='playboy.com'; -- Playboy TV update channel set xmltvid='59406' where xmltvid='plus-1.1.movies4men.co.uk'; -- Movies4Men +1 update channel set xmltvid='47480' where xmltvid='plus-1.comedycentral.com'; -- Comedy Central +1 update channel set xmltvid='65161' where xmltvid='plus-1.meridian.itv1.itv.co.uk'; -- ITV1 +1 update channel set xmltvid='65394' where xmltvid='plus-1.quest.discoveryeurope.com'; -- Quest +1 update channel set xmltvid='56266' where xmltvid='plus-1.science.discoveryeurope.com'; -- Discovery Science +1 update channel set xmltvid='60936' where xmltvid='plus-1.universalchannel.co.uk'; -- Universal +1 update channel set xmltvid='24073' where xmltvid='plus-1.xd.disney.co.uk'; -- Disney XD +1 update channel set xmltvid='33638' where xmltvid='popfun.co.uk'; -- POP update channel set xmltvid='62391' where xmltvid='quest.discoveryeurope.com'; -- Quest update channel set xmltvid='21810' where xmltvid='qvcuk.com'; -- QVC update channel set xmltvid='24434' where xmltvid='radio-1.bbc.co.uk'; -- BBC Radio 1 update channel set xmltvid='24435' where xmltvid='radio-2.bbc.co.uk'; -- BBC Radio 2 update channel set xmltvid='24436' where xmltvid='radio-3.bbc.co.uk'; -- BBC Radio 3 update channel set xmltvid='24437' where xmltvid='radio-4.bbc.co.uk'; -- BBC Radio 4 update channel set xmltvid='24438' where xmltvid='radio-5.bbc.co.uk'; -- BBC R5 Live update channel set xmltvid='31756' where xmltvid='reality.cbs.com'; -- CBS Reality update channel set xmltvid='45828' where xmltvid='really.uktv.co.uk'; -- Really update channel set xmltvid='32286' where xmltvid='sat.2.travelchannel.co.uk'; -- Travel Channel +1 update channel set xmltvid='17453' where xmltvid='sat.travelchannel.co.uk'; -- Travel Channel update channel set xmltvid='24282' where xmltvid='science.discoveryeurope.com'; -- Discovery Science update channel set xmltvid='32669' where xmltvid='scuzz.tv'; -- Scuzz update channel set xmltvid='57603' where xmltvid='setindia.com'; -- Sony Entertainment TV Asia update channel set xmltvid='16234' where xmltvid='sky-news.sky.com'; -- Sky News update channel set xmltvid='16235' where xmltvid='sky-one.sky.com'; -- Sky One update channel set xmltvid='48021' where xmltvid='sky-three.sky.com'; -- Pick TV update channel set xmltvid='32151' where xmltvid='sky-two.sky.com'; -- Sky 2 update channel set xmltvid='26084' where xmltvid='smashhits.net'; -- Smash Hits! TV update channel set xmltvid='31759' where xmltvid='sonytv.com'; -- Sony TV update channel set xmltvid='24326' where xmltvid='south.bbc1.bbc.co.uk'; -- BBC One (South) update channel set xmltvid='17154' where xmltvid='south.bbc2.bbc.co.uk'; -- BBC Two update channel set xmltvid='24337' where xmltvid='south-east.bbc1.bbc.co.uk'; -- BBC ONE S East update channel set xmltvid='17154' where xmltvid='south-east.bbc2.bbc.co.uk'; -- BBC TWO update channel set xmltvid='97330' where xmltvid='spike.com'; -- Spike update channel set xmltvid='88256' where xmltvid='tcm.turner.com'; -- TCM update channel set xmltvid='47738' where xmltvid='televisionx.co.uk'; -- Television X update channel set xmltvid='66975' where xmltvid='theadultchannel.co.uk'; -- The Adult Channel update channel set xmltvid='21492' where xmltvid='thebox.co.uk'; -- The Box update channel set xmltvid='21558' where xmltvid='thehistorychannel.co.uk'; -- History Channel update channel set xmltvid='34087' where xmltvid='tinypop.com'; -- Tiny Pop update channel set xmltvid='31760' where xmltvid='too.cartoonnetwork.com'; -- Cartoonito update channel set xmltvid='31168' where xmltvid='toons.nickelodeon.co.uk'; -- Nicktoons TV update channel set xmltvid='45509' where xmltvid='tsod.plus-1.alibi.uktv.co.uk'; -- Alibi +1 update channel set xmltvid='26098' where xmltvid='tsod.plus-1.animalplanet.discoveryeurope.com'; -- Animal Planet +1 update channel set xmltvid='48928' where xmltvid='tsod.plus-1.boomerang.cartoonnetwork.com'; -- Boomerang +1 update channel set xmltvid='45283' where xmltvid='tsod.plus-1.challengetv.co.uk'; -- Challenge +1 update channel set xmltvid='56892' where xmltvid='tsod.plus-1.channel4.com'; -- Channel 4 +1 update channel set xmltvid='77749' where xmltvid='tsod.plus-1.channel5.co.uk'; -- Channel 5 +1 update channel set xmltvid='44855' where xmltvid='tsod.plus-1.dave.uktv.co.uk'; -- Dave ja vu update channel set xmltvid='21557' where xmltvid='tsod.plus-1.discoveryeurope.com'; -- Discovery Channel +1 update channel set xmltvid='50587' where xmltvid='tsod.plus-1.disneychannel.disney.co.uk'; -- Disney Channel +1 update channel set xmltvid='33882' where xmltvid='tsod.plus-1.e4.channel4.com'; -- E4 +1 update channel set xmltvid='35945' where xmltvid='tsod.plus-1.eden.uktv.co.uk'; -- Eden +1 update channel set xmltvid='25630' where xmltvid='tsod.plus-1.filmfour.channel4.com'; -- Film4 +1 update channel set xmltvid='56890' where xmltvid='tsod.plus-1.fiveusa.channel5.co.uk'; -- 5 USA +1 update channel set xmltvid='44855' where xmltvid='tsod.plus-1.freeview.dave.uktv.co.uk'; -- Dave ja vu update channel set xmltvid='98366' where xmltvid='tsod.plus-1.freeview.itv3.itv.co.uk'; -- ITV3+1 update channel set xmltvid='61806' where xmltvid='tsod.plus-1.freeview.itv4.itv.co.uk'; -- ITV4+1 update channel set xmltvid='31351' where xmltvid='tsod.plus-1.gold.uktv.co.uk'; -- Gold +1 update channel set xmltvid='34898' where xmltvid='tsod.plus-1.goodfood.uktv.co.uk'; -- Good Food +1 update channel set xmltvid='46490' where xmltvid='tsod.plus-1.health.discovery.com'; -- Discovery Home & Health +1 update channel set xmltvid='29969' where xmltvid='tsod.plus-1.home.uktv.co.uk'; -- Home +1 update channel set xmltvid='53059' where xmltvid='tsod.plus-1.itv2.itv.co.uk'; -- ITV2 +1 update channel set xmltvid='53060' where xmltvid='tsod.plus-1.itv3.itv.co.uk'; -- ITV3+1 update channel set xmltvid='31949' where xmltvid='tsod.plus-1.living.sky.com'; -- Sky Living +1 update channel set xmltvid='47658' where xmltvid='tsod.plus-1.more4.channel4.com'; -- More 4 +1 update channel set xmltvid='35370' where xmltvid='tsod.plus-1.mtv.co.uk'; -- MTV +1 update channel set xmltvid='24112' where xmltvid='tsod.plus-1.nationalgeographic.co.uk'; -- National Geographic +1 update channel set xmltvid='65394' where xmltvid='tsod.plus-1.quest.discoveryeurope.com'; -- QUEST+1 update channel set xmltvid='45510' where xmltvid='tsod.plus-1.reality.cbs.com'; -- CBS Reality +1 update channel set xmltvid='65161' where xmltvid='tsod.plus-1.southeast-macro.itv1.itv.co.uk'; -- ITV +1 update channel set xmltvid='24699' where xmltvid='tsod.plus-1.thehistorychannel.co.uk'; -- History Channel +1 update channel set xmltvid='49969' where xmltvid='tsod.plus-1.uk.syfy.com'; -- SyFy +1 update channel set xmltvid='61459' where xmltvid='tsod.plus-1.watch.uktv.co.uk'; -- Watch +1 update channel set xmltvid='35706' where xmltvid='tsod.plus-1.yesterday.uktv.co.uk'; -- Yesterday +1 update channel set xmltvid='97294' where xmltvid='tsod.plus-24.channel5.co.uk'; -- Channel 5+24 update channel set xmltvid='24284' where xmltvid='turbo.discoveryeurope.com'; -- Discovery Turbo update channel set xmltvid='21495' where xmltvid='tv5.org'; -- TV5Monde Europe update channel set xmltvid='17667' where xmltvid='uk.cartoonnetwork.com'; -- Cartoon Network update channel set xmltvid='17431' where xmltvid='uk.syfy.com'; -- SyFy update channel set xmltvid='31787' where xmltvid='uk.viva.tv'; -- VIVA update channel set xmltvid='24671' where xmltvid='universalchannel.co.uk'; -- Universal update channel set xmltvid='17745' where xmltvid='vh1.co.uk'; -- VH1 update channel set xmltvid='28573' where xmltvid='wales.bbc2.bbc.co.uk'; -- BBC 2 Wales update channel set xmltvid='61458' where xmltvid='watch.uktv.co.uk'; -- Watch update channel set xmltvid='23305' where xmltvid='wild.nationalgeographic.co.uk'; -- National Geographic Wild update channel set xmltvid='18379' where xmltvid='xd.disney.co.uk'; -- Disney XD update channel set xmltvid='31266' where xmltvid='xtra.1.radio.bbc.co.uk'; -- 1Xtra BBC update channel set xmltvid='31783' where xmltvid='yesterday.uktv.co.uk'; -- Yesterday