Difference between revisions of "Migrating to Schedules Direct in the UK"

From MythTV Official Wiki
Jump to: navigation, search
(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
SchedulesDirect (SD) for a UK configuration, especially with respect to
+
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 config. file out of it, in '''~/.xmltv/tv_grab_sd_json''', and see the list of channels you have available.
+
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
  euronews.com                                    82432       # Euronews                      
+
  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.hd.channel4.com                        50716       # Channel 4 HD                  
+
  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.cbbc.bbc.co.uk                              83281      # CBBC HD                        
+
  fxuk.tv                                        35484      # Fox
  hd.southeast-macro.itv1.itv.co.uk               67073       # ITV HD                        
+
  gold.uktv.co.uk                                17442      # Gold
  health.discovery.com                            24657       # Discovery Home & Health       
+
  goodfood.uktv.co.uk                            28634      # Good Food
  history.discoveryeurope.com                    24280      # Discovery History             
+
hd.aljazeera.net                                97267      # Al Jazeera Eng HD
hits.mtv.co.uk                                 24214       # MTV Hits                       
+
  hd.bbc1.bbc.co.uk                              69387      # BBC ONE HD
  home.uktv.co.uk                                 21257       # Home                           
+
  hd.bbc2.bbc.co.uk                              50059      # BBC TWO HD
  horror.cbs.com                                 42762       # Horror Channel                 
+
  hd.bbcfour.bbc.co.uk                            83282      # BBC FOUR HD
  idealworld.tv                                  24669       # Ideal World                   
+
hd.cbbc.bbc.co.uk                              83281      # CBBC HD
  itv2.itv.co.uk                                  20630       # ITV2                           
+
  hd.cbeebies.bbc.co.uk                           83283       # CBeebies HD
  itv3.itv.co.uk                                  44643       # ITV3                           
+
  hd.five.tv                                      50717       # Channel 5 HD
  itv4.itv.co.uk                                  48020       # ITV4                           
+
  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-east.bbc1.bbc.co.uk                       24337       # BBC ONE S East                 
+
  sat.2.travelchannel.co.uk                      32286      # Travel Channel +1
  south-east.bbc2.bbc.co.uk                       17154      # BBC TWO                       
+
  sat.travelchannel.co.uk                        17453      # Travel Channel
  spike.com                                      97330      # Spike                         
+
  science.discoveryeurope.com                    24282      # Discovery Science
tcm.turner.com                                  88256      # TCM                           
+
  scuzz.tv                                        32669      # Scuzz
televisionx.co.uk                               47738       # Television X                   
+
  setindia.com                                    57603      # Sony Entertainment TV Asia
  theadultchannel.co.uk                           66975       # The Adult Channel             
+
  sky-news.sky.com                                16234      # Sky News
  thebox.co.uk                                    21492       # The Box                       
+
  sky-one.sky.com                                16235      # Sky One
  thehistorychannel.co.uk                        21558       # History Channel               
+
  sky-three.sky.com                              48021      # Pick TV
  too.cartoonnetwork.com                          31760       # Cartoonito                     
+
  sky-two.sky.com                                32151      # Sky 2
  toons.nickelodeon.co.uk                         31168       # Nicktoons TV                   
+
  smashhits.net                                  26084      # Smash Hits! TV
  tsod.plus-1.alibi.uktv.co.uk                   45509       # Alibi +1                       
+
  sonytv.com                                      31759      # Sony TV
  tsod.plus-1.animalplanet.discoveryeurope.com   26098       # Animal Planet +1               
+
  south.bbc1.bbc.co.uk                           24326       # BBC One (South)
  tsod.plus-1.boomerang.cartoonnetwork.com       48928       # Boomerang +1                   
+
  south.bbc2.bbc.co.uk                           17154      # BBC Two
  tsod.plus-1.challengetv.co.uk                   45283       # Challenge +1                  
+
  south-east.bbc1.bbc.co.uk                       24337       # BBC ONE S East
  tsod.plus-1.channel4.com                       56892       # Channel 4 +1                  
+
  south-east.bbc2.bbc.co.uk                       17154       # BBC TWO
  tsod.plus-1.channel5.co.uk                      77749       # Channel 5 +1                  
+
  spike.com                                      97330       # Spike
  tsod.plus-1.dave.uktv.co.uk                     44855       # Dave ja vu                     
+
  tcm.turner.com                                  88256       # TCM
  tsod.plus-1.discoveryeurope.com                 21557       # Discovery Channel +1          
+
  televisionx.co.uk                              47738       # Television X
  tsod.plus-1.disneychannel.disney.co.uk         50587       # Disney Channel +1              
+
  theadultchannel.co.uk                           66975       # The Adult Channel
  tsod.plus-1.e4.channel4.com                    33882       # E4 +1                          
+
  thebox.co.uk                                   21492       # The Box
  tsod.plus-1.eden.uktv.co.uk                    35945       # Eden +1                       
+
  thehistorychannel.co.uk                        21558      # History Channel
  tsod.plus-1.filmfour.channel4.com               25630       # Film4 +1                      
+
tinypop.com                                     34087       # Tiny Pop
  tsod.plus-1.fiveusa.channel5.co.uk             56890       # 5 USA +1                      
+
  too.cartoonnetwork.com                         31760      # Cartoonito
  tsod.plus-1.gold.uktv.co.uk                     31351       # Gold +1                        
+
toons.nickelodeon.co.uk                        31168       # Nicktoons TV
  tsod.plus-1.goodfood.uktv.co.uk                 34898       # Good Food +1                  
+
  tsod.plus-1.alibi.uktv.co.uk                   45509       # Alibi +1
  tsod.plus-1.health.discovery.com               46490       # Discovery Home & Health +1    
+
  tsod.plus-1.animalplanet.discoveryeurope.com   26098       # Animal Planet +1
  tsod.plus-1.home.uktv.co.uk                     29969       # Home +1                        
+
  tsod.plus-1.boomerang.cartoonnetwork.com        48928       # Boomerang +1
  tsod.plus-1.itv2.itv.co.uk                     53059       # ITV2 +1                       
+
  tsod.plus-1.challengetv.co.uk                   45283       # Challenge +1
  tsod.plus-1.itv3.itv.co.uk                     53060       # ITV3+1                        
+
  tsod.plus-1.channel4.com                       56892       # Channel 4 +1
  tsod.plus-1.living.sky.com                      31949       # Sky Living +1                  
+
  tsod.plus-1.channel5.co.uk                     56888       # Channel 5 +1 (Sky)
  tsod.plus-1.more4.channel4.com                  47658       # More 4 +1                      
+
  tsod.plus-1.channel5.co.uk                      97294       # Channel 5 +1 (DVB-T)
  tsod.plus-1.mtv.co.uk                           35370       # MTV +1                        
+
  tsod.plus-1.dave.uktv.co.uk                    44855       # Dave ja vu
  tsod.plus-1.nationalgeographic.co.uk            24112       # National Geographic +1        
+
  tsod.plus-1.discoveryeurope.com                 21557       # Discovery Channel +1
  tsod.plus-1.reality.cbs.com                     45510       # CBS Reality +1                
+
  tsod.plus-1.disneychannel.disney.co.uk         50587       # Disney Channel +1
  tsod.plus-1.thehistorychannel.co.uk             24699       # History Channel +1            
+
  tsod.plus-1.e4.channel4.com                     33882       # E4 +1
  tsod.plus-1.uk.syfy.com                        49969       # SyFy +1                        
+
  tsod.plus-1.eden.uktv.co.uk                     35945       # Eden +1
  tsod.plus-1.watch.uktv.co.uk                   61459       # Watch +1                      
+
  tsod.plus-1.filmfour.channel4.com               25630       # Film4 +1
  tsod.plus-1.yesterday.uktv.co.uk                35706       # Yesterday +1                  
+
  tsod.plus-1.fiveusa.channel5.co.uk             56890       # 5 USA +1
  turbo.discoveryeurope.com                       24284       # Discovery Turbo               
+
  tsod.plus-1.freeview.dave.uktv.co.uk           44855       # Dave ja vu
  tv5.org                                        21495       # TV5Monde Europe                
+
  tsod.plus-1.freeview.itv3.itv.co.uk             98366       # ITV3+1
uk.cartoonnetwork.com                          17667      # Cartoon Network               
+
  tsod.plus-1.freeview.itv4.itv.co.uk            61806       # ITV4+1
uk.syfy.com                                    17431       # SyFy                           
+
  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!

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