[mythtv-users] Channel Management in the UK

Tue Feb 11 21:19:12 UTC 2014

Hi Chris,

> Just wondering what the latest advice is for managing channels in the UK.
> 
> I have a combined BE with twin DVB-t receiving channels from the Mendip
> Transmitter and and a twin DVB-S(2) receiving FTA channels from 28.2e.

I have a very similar setup that includes Freeview and Freesat UK channels.
Below is the current version of my own SQL script that I run against the MythTV database after any channel tuning (as and when the channel lineup changes are announced), and it works well for me. It's based loosely on the info at http://www.mythtv.org/wiki/UK_Channel_Assignments . (Actually, I maintain a channel spreadsheet, export it as a text file, then run my own perl script against it to automatically generate the SQL).

The channel numbering is more or less Freeview, with the Freesat channels squeezed into convenient gaps (I've not included the other non-UK channels that are specific to my setup). Even though I only use EIT I left the xmltvid's in from when I was experimenting with them. Also the icon names are specific to the icon files I have in my
 /home/mythtv/.mythtv/channels directory. I've commented out the line towards the end which is Crystal Palace specific - if you need to do any similar filtering to block out other weaker transmitters in your area, you should be able to find the details at http://www.ukfree.tv/transmitters.php . (Also watch out for some London-specific elements in the SQL commands for channels 1, 2, 3 and 33).

If you want to this approach a try you should certainly back up your channel table first.

Nick

# ========================================
# start of mychannels.sql script

# clear channel numbers, visibility and EIT from all channels
UPDATE channel SET channum='',visible=0,useonairguide=0;

# update the channels I want to keep
UPDATE channel SET channum=1, icon="bbc_one_london.jpg", xmltvid="london.bbc1.bbc.co.uk", name="BBC One", callsign="BBC One" WHERE name='BBC One' OR name='BBC 1 London' OR name='BBC ONE' OR name='BBC ONE Lon';
UPDATE channel SET channum=2, icon="bbc2.jpg", xmltvid="london.bbc2.bbc.co.uk", name="BBC Two", callsign="BBC Two" WHERE name='BBC Two' OR name='BBC 2 England' OR name='BBC TWO';
UPDATE channel SET channum=3, icon="itv_uk.jpg", xmltvid="london.itv1.itv.co.uk",
 name="ITV", callsign="ITV" WHERE name='ITV' OR name='ITV1';
UPDATE channel SET channum=4, icon="channel4.jpg", xmltvid="channel4.com", name="Channel 4", callsign="Channel 4" WHERE name='Channel 4';
UPDATE channel SET channum=5, icon="channel5_region1.jpg", xmltvid="channel5.co.uk", name="Channel 5", callsign="Channel 5" WHERE name='Channel 5';
UPDATE channel SET channum=6, icon="itv2.jpg", xmltvid="itv2.itv.co.uk", name="ITV2", callsign="ITV2" WHERE name='ITV2';
UPDATE channel SET channum=7, icon="bbc_three.jpg", xmltvid="bbcthree.bbc.co.uk", name="BBC Three", callsign="BBC Three" WHERE name='BBC Three' OR name='BBC THREE';
UPDATE channel SET channum=9, icon="bbc4.jpg", xmltvid="bbcfour.bbc.co.uk", name="BBC Four", callsign="BBC Four" WHERE name='BBC Four' OR name='BBC FOUR';
UPDATE channel SET channum=10, icon="itv3.jpg", xmltvid="itv3.itv.co.uk", name="ITV3", callsign="ITV3" WHERE name='ITV3';
UPDATE channel SET channum=11,
 icon="pick_tv.jpg", xmltvid="sky-three.sky.com", name="Pick", callsign="Pick" WHERE name='Pick' OR name='Pick FSAT';
UPDATE channel SET channum=12, icon="uktv_dave.jpg", xmltvid="dave.uktv.co.uk", name="Dave", callsign="Dave" WHERE name='Dave';
UPDATE channel SET channum=13, icon="channel4_plus1.jpg", xmltvid="tsod.plus-1.channel4.com", name="Channel 4+1", callsign="Channel 4+1" WHERE name='Channel 4+1' OR name='Channel 4 +1';
UPDATE channel SET channum=14, icon="more4.jpg", xmltvid="more4.channel4.com", name="More 4", callsign="More 4" WHERE name='More 4' OR name='More4';
UPDATE channel SET channum=15, icon="film4.jpg", xmltvid="filmfour.channel4.com", name="Film4", callsign="Film4" WHERE name='Film4';
UPDATE channel SET channum=16, icon="channel4_more4_uk_plus1.jpg", xmltvid="tsod.plus-1.more4.channel4.com", name="More4 +1", callsign="More4 +1" WHERE name='More4 +1';
UPDATE channel SET channum=17, icon="really_uktv.jpg",
 xmltvid="really.uktv.co.uk", name="Really", callsign="Really" WHERE name='Really';
UPDATE channel SET channum=19, icon="yesterday_uktv.jpg", xmltvid="yesterday.uktv.co.uk", name="Yesterday", callsign="Yesterday" WHERE name='Yesterday';
UPDATE channel SET channum=20, icon="drama.jpg", name="Drama", callsign="Drama" WHERE name='Drama';
UPDATE channel SET channum=21, icon="cbs_drama.jpg", xmltvid="drama.cbs.com", name="CBS Drama", callsign="CBS Drama" WHERE name='CBS Drama';
UPDATE channel SET channum=22, icon="cbs_reality.jpg", xmltvid="reality.cbs.com", name="CBS Reality", callsign="CBS Reality" WHERE name='CBS Reality';
UPDATE channel SET channum=23, icon="cbs_action.jpg", xmltvid="action.cbs.com", name="CBS Action", callsign="CBS Action" WHERE name='CBS Action';
UPDATE channel SET channum=24, icon="itv4.jpg", xmltvid="itv4.itv.co.uk", name="ITV4", callsign="ITV4" WHERE name='ITV4';
UPDATE channel SET channum=25,
 icon="itv4_plus1.jpg", xmltvid="tsod.plus-1.itv4.itv.co.uk", name="ITV4 +1", callsign="ITV4 +1" WHERE name='ITV4 +1' OR name='ITV4+1';
UPDATE channel SET channum=26, icon="cbs_reality.jpg", xmltvid="tsod.plus-1.reality.cbs.com", name="CBS Reality +1", callsign="CBS Reality +1" WHERE name='CBS Reality +1' OR name='CBS Reality+1';
UPDATE channel SET channum=27, icon="itv2_plus1.jpg", xmltvid="tsod.plus-1.itv2.itv.co.uk", name="ITV2 +1", callsign="ITV2 +1" WHERE name='ITV2 +1' OR name='ITV2+1';
UPDATE channel SET channum=28, icon="e4_uk.jpg", xmltvid="e4.channel4.com", name="E4", callsign="E4" WHERE name='E4';
UPDATE channel SET channum=29, icon="e4_plus1.jpg", xmltvid="tsod.plus-1.e4.channel4.com", name="E4+1", callsign="E4+1" WHERE name='E4+1';
UPDATE channel SET channum=30, icon="channel5_star.jpg", xmltvid="fiver.channel5.co.uk", name="5*", callsign="5*" WHERE name='5*';
UPDATE channel SET channum=31, icon="channel5_usa.jpg",
 xmltvid="fiveusa.channel5.co.uk", name="5 USA", callsign="5 USA" WHERE name='5 USA';
UPDATE channel SET channum=32, icon="moviemix.jpg", name="Movie Mix", callsign="Movie Mix" WHERE name='Movie Mix';
UPDATE channel SET channum=33, icon="itv_uk_plus1.jpg", xmltvid="tsod.plus-1.london-macro.itv1.itv.co.uk", name="ITV +1", callsign="ITV +1" WHERE name='ITV +1' OR name='ITV1 +1';
UPDATE channel SET channum=34, icon="itv3_plus1.jpg", xmltvid="tsod.plus-1.itv3.itv.co.uk", name="ITV3+1", callsign="ITV3+1" WHERE name='ITV3+1' OR name='ITV3+1';
UPDATE channel SET channum=35, icon="true_movies.jpg", xmltvid="1.truemovies.tv", name="True Movies 1", callsign="True Movies 1" WHERE name='True Movies 1' OR name='True Christmas';
UPDATE channel SET channum=36, icon="true_movies2.jpg", xmltvid="2.truemovies.tv", name="True Movies 2", callsign="True Movies 2" WHERE name='True Movies 2';
UPDATE channel SET channum=37, icon="movies_4_men.jpg",
 xmltvid="1.movies4men.co.uk", name="Movies4Men", callsign="Movies4Men" WHERE name='Movies4Men';
UPDATE channel SET channum=38, icon="quest.jpg", xmltvid="quest.discoveryeurope.com", name="QUEST", callsign="QUEST" WHERE name='QUEST';
UPDATE channel SET channum=39, icon="movies_4_men.jpg", xmltvid="tsod.plus-1.1.movies4men.co.uk", name="Movies4Men+1", callsign="Movies4Men+1" WHERE name='Movies4Men+1';
UPDATE channel SET channum=40, icon="more_movies_uk.jpg", name="more>movies", callsign="more>movies" WHERE name='more>movies';
UPDATE channel SET channum=41, icon="food_network_uk.jpg", xmltvid="freeview.foodnetwork.com", name="Food Network", callsign="Food Network" WHERE name='Food Network';
UPDATE channel SET channum=42, icon="channel5_usa.jpg", xmltvid="tsod.plus-1.fiveusa.channel5.co.uk", name="5 USA +1", callsign="5 USA +1" WHERE name='5 USA +1';
UPDATE channel SET channum=43, icon="channel5_star_plus1.jpg",
 xmltvid="tsod.plus-1.fiver.channel5.co.uk", name="5* +1", callsign="5* +1" WHERE name='5* +1';
UPDATE channel SET channum=44, icon="channel5_region1_plus1.jpg", xmltvid="tsod.plus-1.channel5.co.uk", name="Channel 5+1", callsign="Channel 5+1" WHERE name='Channel 5+1';
UPDATE channel SET channum=45, icon="film4_plus1.jpg", xmltvid="tsod.plus-1.filmfour.channel4.com", name="Film4+1", callsign="Film4+1" WHERE name='Film4+1' OR name='Film4 +1';
UPDATE channel SET channum=46, icon="challenge_tv.jpg", xmltvid="challengetv.co.uk", name="Challenge", callsign="Challenge" WHERE name='Challenge';
UPDATE channel SET channum=47, icon="channel4_seven_uk.jpg", xmltvid="4seven.channel4.com", name="4seven", callsign="4seven" WHERE name='4seven';
UPDATE channel SET channum=48, icon="true_entertainment.jpg", xmltvid="entertainment.truemovies.tv", name="True Entertainment", callsign="True Entertainment" WHERE name='True Entertainment' OR name='True
 Ent';
UPDATE channel SET channum=49, icon="food_network_uk.jpg", xmltvid="tsod.plus-1.foodnetwork.com", name="Food Network +1", callsign="Food Network +1" WHERE name='Food Network +1' OR name='Food Netwrk+1';
UPDATE channel SET channum=70, icon="cbbc.jpg", xmltvid="cbbc.bbc.co.uk", name="CBBC", callsign="CBBC" WHERE name='CBBC' OR name='CBBC Channel';
UPDATE channel SET channum=71, icon="bbc_cbeebies.jpg", xmltvid="cbeebies.bbc.co.uk", name="CBeebies", callsign="CBeebies" WHERE name='CBeebies';
UPDATE channel SET channum=72, icon="citv.jpg", xmltvid="citv.itv.co.uk", name="CITV", callsign="CITV" WHERE name='CITV';
UPDATE channel SET channum=73, icon="cbbc.jpg", xmltvid="hd.cbbc.bbc.co.uk", name="CBBC HD", callsign="CBBC HD" WHERE name='CBBC HD';
UPDATE channel SET channum=74, icon="bbc_cbeebies.jpg", xmltvid="hd.cbeebies.bbc.co.uk", name="CBeebies HD", callsign="CBeebies HD" WHERE name='CBeebies HD';
UPDATE channel SET channum=75,
 icon="pop_uk.jpg", xmltvid="popfun.co.uk", name="Pop", callsign="Pop" WHERE name='Pop' OR name='POP';
UPDATE channel SET channum=76, icon="pop_girl.jpg", name="PopGirl", callsign="PopGirl" WHERE name='PopGirl';
UPDATE channel SET channum=77, icon="tiny_pop.jpg", xmltvid="tinypop.com", name="Tiny Pop", callsign="Tiny Pop" WHERE name='Tiny Pop';
UPDATE channel SET channum=78, icon="kix_uk.jpg", name="Kix", callsign="Kix" WHERE name='Kix';
UPDATE channel SET channum=80, icon="bbc_news.jpg", xmltvid="news.bbc.co.uk", name="BBC News", callsign="BBC News" WHERE name='BBC News' OR name='BBC NEWS';
UPDATE channel SET channum=81, icon="bbc_world_news.jpg", xmltvid="worldnews.bbc.com", name="BBC World News", callsign="BBC World News" WHERE name='BBC World News';
UPDATE channel SET channum=82, icon="sky_news.jpg", xmltvid="sky-news.sky.com", name="Sky News", callsign="Sky News" WHERE name='Sky News';
UPDATE channel SET channum=83,
 icon="al_jazeera.jpg", xmltvid="freeview.aljazeera.net", name="Al Jazeera English", callsign="Al Jazeera English" WHERE name='Al Jazeera English' OR name='Al Jazeera Eng';
UPDATE channel SET channum=84, icon="euronews.jpg", xmltvid="euronews.com", name="Euronews", callsign="Euronews" WHERE name='Euronews';
UPDATE channel SET channum=85, icon="rt_english.jpg", name="RT", callsign="RT" WHERE name='RT' OR name='Russia Today';
UPDATE channel SET channum=95, icon="bbc2_wales.jpg", xmltvid="wales.bbc2.bbc.co.uk", name="BBC Two Wales", callsign="BBC Two Wales" WHERE name='BBC Two Wales' OR name='BBC 2 Wales';
UPDATE channel SET channum=96, icon="bbc2_scotland.jpg", xmltvid="scotland.bbc2.bbc.co.uk", name="BBC Two Scotland", callsign="BBC Two Scotland" WHERE name='BBC Two Scotland' OR name='BBC 1 Wales';
UPDATE channel SET channum=97, icon="bbc_one_wales.jpg", xmltvid="wales.bbc1.bbc.co.uk", name="BBC One Wales", callsign="BBC One Wales" WHERE
 name='BBC One Wales' OR name='BBC 2 Scotland';
UPDATE channel SET channum=98, icon="bbc_one_scotland.jpg", xmltvid="scotland.bbc1.bbc.co.uk", name="BBC One Scotland", callsign="BBC One Scotland" WHERE name='BBC One Scotland' OR name='BBC 1 Scotland';
UPDATE channel SET channum=99, icon="bbc_alba.jpg", xmltvid="alba.bbc.co.uk", name="BBC Alba", callsign="BBC Alba" WHERE name='BBC Alba' OR name='BBC ALBA';
UPDATE channel SET channum=101, icon="bbc_one_hd.jpg", xmltvid="hd.bbc1.bbc.co.uk", name="BBC One HD", callsign="BBC One HD" WHERE name='BBC One HD' OR name='BBC ONE HD';
UPDATE channel SET channum=102, icon="bbc_two_uk_hd.jpg", xmltvid="hd.bbc2.bbc.co.uk", name="BBC Two HD", callsign="BBC Two HD" WHERE name='BBC Two HD' OR name='BBC TWO HD';
UPDATE channel SET channum=103, icon="itv_uk_hd.jpg", xmltvid="hd.london-macro.itv1.itv.co.uk", name="ITV HD", callsign="ITV HD" WHERE name='ITV HD' OR name='ITV1 HD';
UPDATE channel SET
 channum=104, icon="channel4_hd.jpg", xmltvid="freeview.hd.channel4.com", name="Channel 4 HD", callsign="Channel 4 HD" WHERE name='Channel 4 HD';
UPDATE channel SET channum=105, icon="bbc_three.jpg", xmltvid="hd.bbcthree.bbc.co.uk", name="BBC Three HD", callsign="BBC Three HD" WHERE name='BBC Three HD' OR name='BBC THREE HD';
UPDATE channel SET channum=106, icon="bbc4.jpg", xmltvid="hd.bbcfour.bbc.co.uk", name="BBC Four HD", callsign="BBC Four HD" WHERE name='BBC Four HD' OR name='BBC FOUR HD';
UPDATE channel SET channum=107, icon="bbc_news.jpg", xmltvid="hd.news.bbc.co.uk", name="BBC News HD", callsign="BBC News HD" WHERE name='BBC News HD' OR name='BBC NEWS HD';
UPDATE channel SET channum=108, icon="al_jazeera.jpg", xmltvid="hd.aljazeera.net", name="Al Jazeera English HD", callsign="Al Jazeera English HD" WHERE name='Al Jazeera English HD' OR name='Al Jazeera Eng HD';
UPDATE channel SET channum=301, icon="bbc_i.jpg",
 xmltvid="interactive.sport.bbc.co.uk", name="BBC RB 301", callsign="BBC RB 301" WHERE name='BBC RB 301' OR name='301';
UPDATE channel SET channum=302, icon="bbc_i.jpg", xmltvid="interactive.sport.bbc.co.uk", name="BBC RB 302", callsign="BBC RB 302" WHERE name='BBC RB 302' OR name='302';

# hides Freeview channels (sourceid 1) from transmitters other than Crystal Palace
# UPDATE channel SET channum="" WHERE sourceid in (1) AND freqid NOT IN (22,23,25,26,28,29,30,33,35);

# reinstate visibility and EIT for all numbered channels
UPDATE channel SET visible=1,useonairguide=1 WHERE channum<>"";

# end of mychannels.sql script
# ========================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140211/3056a90f/attachment.html>