Channels in Austria

Satellite Astra 19,2 (Europe)

DVB-S bring a lot of channels, and their channel numbers are not in a useful order for daily use. You can change the channel numbers in MythWeb for some of your favourite programs, but as soon as you re-scan the channels (which you need to do every year or so, when the satellite provider re-positions one of your favourite programs), you will end up again in entropy.

Here is a solution, derived from a scenario for U.K. [1], for two receivers, one DVB-S for Astra 19,2 and one DVB-T. First, be sure, that you have scanned all your channels (see the german MythTV community page [2]).

Create a file chan_numbers_update_AT.sql with an SQL statement in each line like this:

USE mythconverg;
UPDATE channel SET channum=1 WHERE name='ORF1';
UPDATE channel SET channum=2 WHERE name='ORF2';
UPDATE channel SET channum=3 WHERE name='ORF2E';
UPDATE channel SET channum=4 WHERE name='GoTV';
UPDATE channel SET channum=5 WHERE name='ATV';
UPDATE channel SET channum=6 WHERE name='SAT.1 A';
UPDATE channel SET channum=7 WHERE name='ProSieben Austria';
UPDATE channel SET channum=8 WHERE name='PULS 4 AUSTRIA';
UPDATE channel SET channum=9 WHERE name='Kabel 1 Austria';
UPDATE channel SET channum=10 WHERE name='Super RTL';
UPDATE channel SET channum=11 WHERE name='Das Erste';
UPDATE channel SET channum=12 WHERE name='ZDF';
UPDATE channel SET channum=13 WHERE name='3SAT';
UPDATE channel SET channum=14 WHERE name='KIKA';
UPDATE channel SET channum=15 WHERE name='ZDFinfokanal';
UPDATE channel SET channum=16 WHERE name='ZDFdokukanal';
UPDATE channel SET channum=17 WHERE name='ZDFtheaterkanal';
UPDATE channel SET channum=18 WHERE name='EinsExtra';
UPDATE channel SET channum=19 WHERE name='EinsFestival';
UPDATE channel SET channum=20 WHERE name='EinsPlus';
UPDATE channel SET channum=21 WHERE name='NICK Germany';
UPDATE channel SET channum=22 WHERE name='MTV ENTERTAINMENT';
UPDATE channel SET channum=23 WHERE name='MTV Music';
UPDATE channel SET channum=24 WHERE name='VOX';
UPDATE channel SET channum=25 WHERE name='n-tv';
UPDATE channel SET channum=26 WHERE name='CNN Int.';
UPDATE channel SET channum=27 WHERE name='DW-TV';
UPDATE channel SET channum=28 WHERE name='BBC World';
UPDATE channel SET channum=29 WHERE name='Phoenix';
UPDATE channel SET channum=30 WHERE name='arte';
UPDATE channel SET channum=31 WHERE name='BR-alpha';
UPDATE channel SET channum=32 WHERE name='NDR FS HH';
UPDATE channel SET channum=33 WHERE name='SR Fernsehen';
UPDATE channel SET channum=34 WHERE name='DAS VIERTE';
UPDATE channel SET channum=35 WHERE name='MDR Sachsen';
UPDATE channel SET channum=38 WHERE name='TW1';
UPDATE channel SET channum=39 WHERE name='AUSTRIA 9 TV';
UPDATE channel SET channum=60 WHERE name='Kamasutra TV';
UPDATE channel SET channum=72 WHERE name='FRANCE 2';
UPDATE channel SET channum=73 WHERE name='FRANCE 3';
UPDATE channel SET channum=74 WHERE name='FRANCE 5';
UPDATE channel SET channum=75 WHERE name='2M Maroc';
UPDATE channel SET channum=76 WHERE name='TV5MONDE';
UPDATE channel SET channum=77 WHERE name='TV7';
UPDATE channel SET channum=78 WHERE name='RAI 1';
UPDATE channel SET channum=100 WHERE name='OE1 DD';
UPDATE channel SET channum=101 WHERE name='OE1';
UPDATE channel SET channum=102 WHERE name='OE2 V';
UPDATE channel SET channum=103 WHERE name='OE3';
UPDATE channel SET channum=104 WHERE name='FM4';
UPDATE channel SET channum=105 WHERE name='Ö1 International';
UPDATE channel SET channum=106 WHERE name='SWR1';
UPDATE channel SET channum=107 WHERE name='SWR2';
UPDATE channel SET channum=107 WHERE name='WDR 2 Klassik';

Extend as you like. For spelling the channel names correctly, you may want to look up your channels.conf file.

Open a terminal and enter

mysql -uroot -p mythconverg < chan_numbers_update_AT.sql > output.tab

You will be asked for the mySQL root password, which you have set at the MythTV installation process.

That's it. I needed to restart the MythTV backend and frontend and then LiveTV allowed me just to enter a number like 4 + Return to switch to GoTV.

Cable Provider Chello in Vienna

 frequencies: europe_west
 FREQ_CCIR_I_III,
 FREQ_CCIR_SL_SH,
 FREQ_CCIR_H,
 FREQ_CCIR_H2,
 FREQ_UHF

Name	Frequency	Austria Channel	Mythtv Channel	My Number
orf1	189,25	7	E7	1
orf2	217,25	11	E11	2
ATV+	203,25	9	E9	3
Puls TV	210,25	10	E10	90
UPC Info	182,25	6	E6	91
Okto	196,25	8	E8	8
W:24	799,25	62	62	92
Das Erste	511,25	26	E26	13
ZDF	479,25	22	E22	14
3sat	703,25	50	50	10
pro7	751,25	56	56	7
RTL	687,25	48	48	4
SAT.1	655,25	44	44	9
RTL II	719,25	52	52	5
KABEL 1	639,25	42	42	15
Super RTL	487,25	23	E23	6
VOX	238,25	S12	SE12	11
gotv	273,25	S17	SE17	31
BR	735,25	54	54	16
MDR	287,25	S19	SE19	17
swr	551,25	31	31	18
arte	471,25	21	E21	30
Eurosport	519,25	27	27	50
DSF	783,25	60	60	51
Kika	259,25	S15	SE15	12
CNN	623,25	40	40	40
das Vierte	767,25	58	58	19
n-tv	266,25	S16	SE16	41
Euronews	252,25	S14	SE14	42
MTV	294,25	S20	SE20	32
VIVA	527,25	28	28	33
HSE24	503,25	25	E25	93
TW1	543,25	30	30	94
BBC Prime	759,25	57	57	60
TV 5	280,25	S18	SE18	61
Rai uno	245,25	S13	SE13	62
TRT	535,25	29	29	63
qvc	743,25	55	55	95