Channels in Austria

From MythTV Official Wiki
Revision as of 11:10, 26 October 2009 by Rasos (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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