[mythtv-users] UK: managing Freeview and Freesat

Wed Apr 6 08:52:47 UTC 2011

On Tue, Apr 5, 2011 at 11:15 PM, Daniel Carter <dantheperson at gmail.com>wrote:

> What happens after a rescan, do you loose all the customisations and
> have to run the script again?
>
> On 2 November 2010 09:51, Stephen Robertson <stephengrobertson at gmail.com>
> wrote:
> > On Mon, Nov 1, 2010 at 9:44 PM, Richard Morton
> > <richard.e.morton at gmail.com> wrote:
> >>So my questions:
> >> - how do other people arrange the numbering in a mixed
> >>Freeview/Freesat system to get a concise tv guide and yet keep it easy
> >>to maintain. The database update scripts on the wiki are only for
> >>either freeview or freesat not combined systems.
> >
> > I have exactly the same setup and as far as I can tell the same
> > aspirations.  I have used the sql below (which I found in a similar
> > form somewhere online a while ago) after the last few scans and it has
> > organised everything well for me.  Every channel that is not listed is
> > set to channel 1 and then hidden.  This stops it being displayed or
> > used for recordings.
> >
> > It sets up the regional  BBC variant and fixes up some of the
> > discrepancies in naming between freeview and freesat.  Even though I
> > have BBC ONE HD listed I have not tried it since it started
> > broadcasting so the naming there may need to change.
> >
> >>- if I make a channel not visible; is it still used for scheduling?
> >> If i make the callsigns the same between different broadcasts of
> >>the same channel, how do you set a preference for it to use the HD
> >>version if a suitable tuner is available?
> >
> > Setting HDTVRecPriority to one and using Any time on any channel rules
> > works pretty well.  If it's on BBC ONE and BBC HD then it will be
> > recorded on BBC HD if it can.  I've not tried setting ITV1HD to the
> > same as ITV1, mainly because we are in the anomaly that is the STV
> > region so they do not always broadcast the same so setting the
> > callsigns of STV and ITV1HD would not be appropriate.
> >
> >
> >> - If I make two or more channels have the same callsign and number
> >>does this achieve everything I have stated above or does that cause
> >>other problems. For instance set ITV1 on freeview, ITV1meridian on
> >>freesat and itv1hd all called itv1 and channum 3... how do I set a
> >>preference for it to use the HD channel for some shows and will
> >>mythweb report correctly that one of the channels is recording a show
> >>even though for most of the channels it is a duplicate?
> >
> > Setting the callsigns and channel numbers of freeview and freesat
> > versions of the same channel eg ITV (not HD) to the same will achieve
> > what you want
> >
> >> - as an aside, how can i get mythtv to prefer to record the first
> >>possible showing of a programme (with a preference for HD if
> >>available) even if that causes conflicts?
> >
> > Do you mean "Sooner" beats "Later even if HD" but if tied for "Sooner"
> > then prefer HD?
> >
> > Stephen
> >
> >
> > USE mythconverg;
> >
> > UPDATE channel SET channum = 1;
> >
> > -- Fix Names for your region;
> > UPDATE channel SET name='BBC One', callsign='BBC One' WHERE name='BBC
> > 1 Scotland';
> > UPDATE channel SET name='BBC One', callsign='BBC One' WHERE name='BBC ONE
> Scot';
> > UPDATE channel SET name='BBC Two', callsign='BBC Two' WHERE name='BBC
> > 2 Scotland';
> > UPDATE channel SET name='BBC Two', callsign='BBC Two' WHERE name='BBC TWO
> Scot';
> >
> > -- Fix Names;
> > UPDATE channel SET name='STV', callsign='STV' WHERE name='STV';
> > UPDATE channel SET name='ITV', callsign='ITV' WHERE name='ITV1 Granada';
> > UPDATE channel SET name='ITV', callsign='ITV' WHERE name='ITV1';
> > UPDATE channel SET name='ITV2 +1', callsign='ITV2 +1' WHERE
> name='ITV2+1';
> > UPDATE channel SET name='ITV3 +1', callsign='ITV3 +1' WHERE
> name='ITV3+1';
> > UPDATE channel SET name='ITV4 +1', callsign='ITV4 +1' WHERE
> name='ITV4+1';
> > UPDATE channel SET name='Sky3', callsign='Sky3' WHERE name='SKY THREE';
> > UPDATE channel SET name='Channel 4 +1', callsign='Channel 4 +1' WHERE
> > name='Channel 4+1';
> > UPDATE channel SET name='More4', callsign='More4' WHERE name='More 4';
> > UPDATE channel SET name='E4', callsign='E4' WHERE name='e4';
> > UPDATE channel SET name='Virgin 1', callsign='Virgin 1' WHERE
> name='Virgin1';
> > UPDATE channel SET name='Virgin 1 +1', callsign='Virgin 1 +1' WHERE
> > name='Virgin1+1';
> > UPDATE channel SET name='Zone Horror +1', callsign='Zone Horror +1'
> > WHERE name='Zone Horror+1';
> > UPDATE channel SET name='CBS Reality +1', callsign='CBS Reality +1'
> > WHERE name='CBS Reality+1';
> > UPDATE channel SET name='CBBC', callsign='CBBC' WHERE name='CBBC
> Channel';
> > UPDATE channel SET name='Jazeera Children', callsign='Jazeera
> > Children' WHERE name='jazeerachildren';
> > UPDATE channel SET name='POP Girl', callsign='POP Girl' WHERE
> name='POPGirl';
> > UPDATE channel SET name='Movies4Men 2 +1', callsign='Movies4Men 2 +1'
> > WHERE name='mov4men2 +1';
> > UPDATE channel SET name='RT', callsign='RT' WHERE name='Russia Today';
> > UPDATE channel SET name='Al Jazeera English', callsign='Al Jazeera
> > English' WHERE name='Al Jazeera Eng';
> > UPDATE channel SET name='Bloomberg Television', callsign='Bloomberg
> > Television' WHERE name='Bloomberg';
> > UPDATE channel SET name='Sky Sports News', callsign='Sky Sports News'
> > WHERE name='Sky Spts News';
> > UPDATE channel SET name='CNN International', callsign='CNN
> > International' WHERE name='CNN';
> > UPDATE channel SET name='Teacher\'s TV', callsign='Teacher\'s TV'
> > WHERE name='Teachers TV';
> > UPDATE channel SET name='BBC Asian Network', callsign='BBC Asian
> > Network' WHERE name='BBC Asian Net.';
> > UPDATE channel SET name='BBC World Service', callsign='BBC World
> > Service' WHERE name='BBC World Sv.';
> > UPDATE channel SET name='BBC Radio 1Xtra', callsign='BBC Radio 1Xtra'
> > WHERE name='BBC 1Xtra';
> > UPDATE channel SET name='BBC Radio 5 Live Sports Extra', callsign='BBC
> > Radio 5 Live Sports Extra' WHERE name='BBC R5SX';
> > UPDATE channel SET name='BBC Radio 5 Live', callsign='BBC Radio 5
> > Live' WHERE name='BBC R5L';
> >
> > -- Entertainment;
> > UPDATE channel SET channum=101 WHERE name='BBC One';
> > UPDATE channel SET channum=102 WHERE name='BBC Two';
> > UPDATE channel SET channum=103 WHERE name='STV';
> > UPDATE channel SET channum=104 WHERE name='Channel 4';
> > UPDATE channel SET channum=105 WHERE name='Five';
> > UPDATE channel SET channum=106 WHERE name='BBC Three';
> > UPDATE channel SET channum=107 WHERE name='BBC Four';
> > UPDATE channel SET channum=108 WHERE name='BBC HD';
> > UPDATE channel SET channum=109 WHERE name='BBC ONE HD';
> > UPDATE channel SET channum=110 WHERE name='BBC Alba';
> > UPDATE channel SET channum=111 WHERE name='Dave'; #Freeview
> > UPDATE channel SET channum=112 WHERE name='Dave ja vu'; #Freeview
> >
> > UPDATE channel SET channum=113 WHERE name='ITV2';
> > UPDATE channel SET channum=114 WHERE name='ITV2 +1';
> > UPDATE channel SET channum=115 WHERE name='ITV3';
> > UPDATE channel SET channum=116 WHERE name='ITV3 +1';
> > UPDATE channel SET channum=117 WHERE name='ITV4';
> > UPDATE channel SET channum=118 WHERE name='ITV4 +1';
> > UPDATE channel SET channum=119 WHERE name='ITV1 HD';
> >
> > UPDATE channel SET channum=120 WHERE name='S4C Digidol';
> > UPDATE channel SET channum=121 WHERE name='Channel 4 +1';
> > UPDATE channel SET channum=122 WHERE name='E4';
> > UPDATE channel SET channum=123 WHERE name='E4+1';
> > UPDATE channel SET channum=124 WHERE name='More4';
> > UPDATE channel SET channum=125 WHERE name='More4 +1';
> > UPDATE channel SET channum=126 WHERE name='Channel One'; #Freeview
> > UPDATE channel SET channum=127 WHERE name='Virgin 1 +1'; #Freeview
> > UPDATE channel SET channum=128 WHERE name='Quest'; #Freeview
> > UPDATE channel SET channum=129 WHERE name='Yesterday'; #Freeview
> > UPDATE channel SET channum=130 WHERE name='G.O.L.D.'; #Freeview
> > UPDATE channel SET channum=131 WHERE name='Sky3'; #Freeview
> > UPDATE channel SET channum=132 WHERE name='Fiver'; #Freeview
> > UPDATE channel SET channum=133 WHERE name='Five USA'; #Freeview
> >
> > UPDATE channel SET channum=134 WHERE name='CBS Drama';
> > UPDATE channel SET channum=135 WHERE name='CBS Reality';
> > UPDATE channel SET channum=136 WHERE name='CBS Reality +1';
> > UPDATE channel SET channum=137 WHERE name='CBS Action';
> > UPDATE channel SET channum=138 WHERE name='Zone Horror';
> > UPDATE channel SET channum=149 WHERE name='Zone Horror +1';
> > UPDATE channel SET channum=140 WHERE name='BET';
> > UPDATE channel SET channum=141 WHERE name='BET +1';
> > #142 True Entertainment
> > UPDATE channel SET channum=143 WHERE name='Men and Movies';
> >
> > -- News and Sport
> > UPDATE channel SET channum=200 WHERE name='BBC News';
> > UPDATE channel SET channum=201 WHERE name='BBC Parliament';
> > UPDATE channel SET channum=202 WHERE name='S4C2';
> > UPDATE channel SET channum=203 WHERE name='Al Jazeera English';
> > UPDATE channel SET channum=204 WHERE name='EuroNews';
> > UPDATE channel SET channum=205 WHERE name='France 24';
> > UPDATE channel SET channum=206 WHERE name='RT';
> > UPDATE channel SET channum=207 WHERE name='CNN International';
> > UPDATE channel SET channum=208 WHERE name='Bloomberg Television';
> > UPDATE channel SET channum=209 WHERE name='NHK World TV';
> > UPDATE channel SET channum=210 WHERE name='CNBC';
> > UPDATE channel SET channum=211 WHERE name='Sky News'; #Freeview
> > UPDATE channel SET channum=212 WHERE name='Sky Sports News'; #Freeview
> > UPDATE channel SET channum=213 WHERE name='ESPN'; #Freeview
> > UPDATE channel SET channum=214 WHERE name='BBC World Service'; #Freeview
> > UPDATE channel SET channum=215 WHERE name='TV News'; #Freeview
> >
> > -- Movies;
> > UPDATE channel SET channum=300 WHERE name='Film4';
> > UPDATE channel SET channum=301 WHERE name='Film4 +1';
> > UPDATE channel SET channum=302 WHERE name='True Movies';
> > UPDATE channel SET channum=303 WHERE name='True Movies 2';
> > UPDATE channel SET channum=304 WHERE name='Movies4Men';
> > #Movies4Men + 1
> > UPDATE channel SET channum=306 WHERE name='Movies4Men 2';
> > UPDATE channel SET channum=307 WHERE name='Movies4Men 2 +1';
> > UPDATE channel SET channum=308 WHERE name='Film24';
> >
> > -- Lifestyle;
> > UPDATE channel SET channum=400 WHERE name='Wedding TV';
> > UPDATE channel SET channum=401 WHERE name='Wedding TV Asia';
> > UPDATE channel SET channum=402 WHERE name='Information TV';
> > UPDATE channel SET channum=403 WHERE name='Rural TV';
> > UPDATE channel SET channum=405 WHERE name='Food Network';
> > UPDATE channel SET channum=406 WHERE name='Food Netwrk +1';
> > UPDATE channel SET channum=450 WHERE name='Men & Motors';
> >
> > -- Music;
> > UPDATE channel SET channum=500 WHERE name='Chart Show TV';
> > UPDATE channel SET channum=501 WHERE name='The Vault';
> > UPDATE channel SET channum=502 WHERE name='Flava';
> > UPDATE channel SET channum=503 WHERE name='VIVA';
> > UPDATE channel SET channum=504 WHERE name='B4U Music';
> > UPDATE channel SET channum=505 WHERE name='4Music';
> > UPDATE channel SET channum=509 WHERE name='Zing';
> > UPDATE channel SET channum=514 WHERE name='Clubland TV';
> > UPDATE channel SET channum=515 WHERE name='NME TV';
> >
> > -- Children;
> > UPDATE channel SET channum=600 WHERE name='CBBC';
> > UPDATE channel SET channum=601 WHERE name='CBeebies';
> > UPDATE channel SET channum=602 WHERE name='CITV';
> > UPDATE channel SET channum=603 WHERE name='POP';
> > UPDATE channel SET channum=604 WHERE name='Pop Girl';
> > UPDATE channel SET channum=605 WHERE name='Tiny Pop';
> > UPDATE channel SET channum=606 WHERE name='Kix!';
> > UPDATE channel SET channum=607 WHERE name='Jazeera Children';
> >
> > -- Special Interest;
> > UPDATE channel SET channum=650 WHERE name='Teacher\'s TV';
> > UPDATE channel SET channum=690 WHERE name='Inspiration';
> > UPDATE channel SET channum=691 WHERE name='Dayster TV';
> > UPDATE channel SET channum=692 WHERE name='Genesis TV';
> >
> > -- Radio;
> > UPDATE channel SET channum=700 WHERE name='BBC Radio 1';
> > UPDATE channel SET channum=701 WHERE name='BBC Radio 1Xtra';
> > UPDATE channel SET channum=702 WHERE name='BBC Radio 2';
> > UPDATE channel SET channum=703 WHERE name='BBC Radio 3';
> > UPDATE channel SET channum=704 WHERE name='BBC Radio 4';
> > UPDATE channel SET channum=705 WHERE name='BBC Radio 5 Live';
> > UPDATE channel SET channum=706 WHERE name='BBC Radio 5 Live Sports
> Extra';
> > UPDATE channel SET channum=707 WHERE name='BBC 6 Music';
> > UPDATE channel SET channum=708 WHERE name='BBC Radio 7';
> > UPDATE channel SET channum=709 WHERE name='BBC Asian Network';
> > UPDATE channel SET channum=710 WHERE name='BBC Radio 4 LW';
> > UPDATE channel SET channum=711 WHERE name='BBC World Service';
> > UPDATE channel SET channum=712 WHERE name='BBC Radio Scotland';
> > UPDATE channel SET channum=713 WHERE name='BBC Radio nan Gaidheal';
> > UPDATE channel SET channum=714 WHERE name='BBC Radio Wales';
> > UPDATE channel SET channum=715 WHERE name='BBC Radio Cymru';
> > UPDATE channel SET channum=716 WHERE name='BBC Radio Ulster';
> > UPDATE channel SET channum=718 WHERE name='BBC Radio London';
> > UPDATE channel SET channum=719 WHERE name='Capital 95.8';
> > UPDATE channel SET channum=720 WHERE name='Choice FM';
> > UPDATE channel SET channum=721 WHERE name='Classic FM';
> > UPDATE channel SET channum=722 WHERE name='Gold';
> > UPDATE channel SET channum=723 WHERE name='Xfm London';
> > UPDATE channel SET channum=724 WHERE name='Absolute Radio';
> > UPDATE channel SET channum=725 WHERE name='Absolute Classic Rock';
> > UPDATE channel SET channum=726 WHERE name='Absolute 80s';
> > UPDATE channel SET channum=727 WHERE name='NME Radio';
> > UPDATE channel SET channum=728 WHERE name='WRN Radio';
> > UPDATE channel SET channum=729 WHERE name='Jazz FM';
> > UPDATE channel SET channum=730 WHERE name='Planet Rock';
> > UPDATE channel SET channum=731 WHERE name='Talksport';
> > UPDATE channel SET channum=732 WHERE name='Q';
> > UPDATE channel SET channum=733 WHERE name='Magic';
> > UPDATE channel SET channum=734 WHERE name='The Hits Radio';
> > UPDATE channel SET channum=735 WHERE name='Smooth Radio';
> > UPDATE channel SET channum=736 WHERE name='Kerrang!';
> > UPDATE channel SET channum=737 WHERE name='heat';
> > UPDATE channel SET channum=738 WHERE name='Kiss';
> > UPDATE channel SET channum=738 WHERE name='Heart';
> > UPDATE channel SET channum=738 WHERE name='Smash Hits!';
> > UPDATE channel SET channum=750 WHERE name='RTE Radio 1';
> > UPDATE channel SET channum=751 WHERE name='RTE Radio 2fm';
> > UPDATE channel SET channum=752 WHERE name='RTE Radio lyric fm';
> > UPDATE channel SET channum=753 WHERE name='RTE Radio na Gaeltacta';
> > UPDATE channel SET channum=777 WHERE name='Insight Radio';
> > UPDATE channel SET channum=786 WHERE name='BFBS Radio';
> > UPDATE channel SET channum=790 WHERE name='TWR';
> >
> > -- Shopping;
> > UPDATE channel SET channum=800 WHERE name='QVC';
> > UPDATE channel SET channum=801 WHERE name='price-drop tv';
> > UPDATE channel SET channum=802 WHERE name='bid tv';
> > UPDATE channel SET channum=803 WHERE name='Pitch TV';
> > UPDATE channel SET channum=804 WHERE name='Gems TV';
> > UPDATE channel SET channum=805 WHERE name='TV Shop';
> > UPDATE channel SET channum=806 WHERE name='JML Home & DIY';
> > UPDATE channel SET channum=808 WHERE name='JML Direct';
> > UPDATE channel SET channum=809 WHERE name='JML Cookshop';
> > UPDATE channel SET channum=810 WHERE name='Thane Direct';
> > UPDATE channel SET channum=812 WHERE name='Ideal World';
> > UPDATE channel SET channum=813 WHERE name='Create and Craft';
> > UPDATE channel SET channum=814 WHERE name='speed auction tv';
> > UPDATE channel SET channum=815 WHERE name='The Jewellery Channel';
> >
> > -- Gaming and Dating;
> > UPDATE channel SET channum=851 WHERE name='Netplay TV';
> > UPDATE channel SET channum=861 WHERE name='Gala TV';
> >
> > -- Adult;
> > #UPDATE channel SET channum=869 WHERE name='READ ME';
> > #UPDATE channel SET channum=870 WHERE name='Babestation';
> > #UPDATE channel SET channum=874 WHERE name='Filth';
> >
> > -- Testing;
> > UPDATE channel SET channum=900 WHERE name='BBC Red Button';
> > UPDATE channel SET channum=901 WHERE name='Home';
> >
> > -- Delete all excess channels;
> > UPDATE channel SET visible=false WHERE channum > 999 OR channum < 100;
> >
> > -- Mark BBC channals as addfree
> > UPDATE channel set commmethod=-2 WHERE name LIKE '%BBC%' OR name =
> 'CBeebies';
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

Cool,

That looks like my script from (
http://ubuntuforums.org/showthread.php?p=8814633) good to see it is being
used :)

I have an updated version of it at home. Is there a place in the wiki where
I can update it?

Is there anyway to get a script like this as an option after scanning. For
example:
1. Scan for channels.
2. Select auto channel arrange
3. Select country
4. Select region
5. Channels ordered.

That way we could pre define all the different regions and could have a
centralised channel order script to use. It would help newbies (like me)
from having to go through the pain of badly labelled channels.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110406/4383bdd7/attachment-0001.html 