MythTVP5K dbChannelConfig

From LinuxTVWiki
Revision as of 15:06, 7 May 2009 by Jimbley (talk | contribs) (Added category: Software)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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