From LinuxTVWiki
channels.conf
ABCHDTV:767625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:516:654:704
ABCTVQLD:767625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:512:650:705
ABC2:767625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:513:651:706
ABCDiGRadio:767625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_AUTO:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:0:690:710
ABCDiGJazz:767625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_AUTO:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:0:700:711
PRIMEGC:788625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:2600:2601:2360
PRIMEHD:788625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:4600:4602:2400
7Digital:704625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:1025:1026:1344
7HD:704625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:1089:1091:1348
7Guide:704625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:1121:1122:1350
NBNDigital:809625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:5000:5010:105
NBNHD:809625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:7500:7510:107
NBN2:809625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:5000:5010:110
NineGC:746625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:513:660:1137
NineHDGC:746625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:512:651:1138
NineGuide:746625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_3_4:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:517:700:1139
SC10GC:634625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_1_2:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:481:482:2063
MyTalk:634625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_1_2:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:2521:2522:2127
SC10HD:634625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_1_2:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:2511:2512:2095
TENHD:725625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_AUTO:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:514:672:1608
TEND:725625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_3_4:FEC_1_2:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_16:HIERARCHY_NONE:512:650:1605
SBSHD:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:102:103:816
SBS:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:161:81:817
SBSNEWS:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:162:83:818
SBS2:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:161:81:819
SBSRADIO1:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:0:201:830
SBSRADIO2:585625000:INVERSION_AUTO:BANDWIDTH_7_MHZ:FEC_2_3:FEC_2_3:QAM_64:TRANSMISSION_MODE_8K:GUARD_INTERVAL_1_8:HIERARCHY_NONE:0:202:831
channel2myth0.21.sh
cat channels.conf |awk -F: '
BEGIN{mplexsourceid=1; chid=5000; channum=300; mplexid=100};
{
if ( $11=="0" ){
tvformat="";
}else{
tvformat="Default";
}
if ( $11=="0" ){
tvformat="";
}else{
tvformat="Default";
}
if ( $5=="FEC_1_2" ){
hp_code_rate="1/2"
}else if ( $5=="FEC_2_3" ){
hp_code_rate="2/3"
}else if ( $5=="FEC_3_4" ){
hp_code_rate="3/4"
}else{
hp_code_rate="auto"
}
if ( $6=="FEC_1_2" ){
lp_code_rate="1/2"
}else if ( $6=="FEC_2_3" ){
lp_code_rate="2/3"
}else if ( $6=="FEC_3_4" ){
lp_code_rate="3/4"
}else{
lp_code_rate="auto"
}
if ( $9=="GUARD_INTERVAL_1_16" ){
guard_interval="1/16"
}else if ( $9=="GUARD_INTERVAL_1_8"){
guard_interval="1/8"
}else{
guard_interval="auto"
}
print "insert into dtv_multiplex"
print "( mplexid , sourceid , transportid , networkid , frequency , inversion , symbolrate , fec , polarity , modulation , bandwidth , lp_code_rate , transmission_mode , guard_interval , visible , constellation , hierarchy , hp_code_rate , sistandard , serviceversion , updatetimestamp)"
print "values"
print "( "mplexid", "mplexsourceid" , "$13" , NULL , "$2" ,\"a\" , NULL , NULL , NULL , NULL ,\"7\" ,\""lp_code_rate"\" ,\"8\" ,\""guard_interval"\" , 0 ,\"qam_64\" ,\"n\" ,\""hp_code_rate"\" ,\"dvb\" , NULL , sysdate() );"
print "insert into channel"
print "(chanid , channum , freqid , sourceid , callsign , name , icon , finetune , videofilters , xmltvid , recpriority , contrast , brightness , colour , hue , tvformat , commfree , visible , outputfilters , useonairguide , mplexid , serviceid , atscsrcid , tmoffset , atsc_major_chan , atsc_minor_chan, last_record, default_authority, commmethod )"
print "values"
print "("chid" ,\""channum"\", NULL , "mplexsourceid" ,\""$1"\",\""$1"\", \"\" ,NULL , \"\" , \"\" ,\"\" , 32768 , 32768 , 32768 , 32768 , \""tvformat"\" , 0 , 1 ,\"\" , 1 , "mplexid", "$13" , NULL , 0 , 0, 0, date(0000-00-00), \"\", -1);"
#print $1" "$2" "$11" "$12" "$13" "tvformat
chid++; channum++; mplexid++;
}'
