MythTVP5K dbChannelConfig

From LinuxTVWiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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++;
 }'