[mythtv-users] need help with scte65scan, PSIP, and HD channels

[Jim Beckett]

Matt W wrote:
> Hi all--
>
> finally upgraded the TV and I noticed that I'm getting some local
> broadcast in HD over my Comcast hybrid (the analog/digital) cable
> service.  I'd like to get these channels loaded into MythTV but I'm
> having trouble with scte65scan and its SQL generation for PSIP info.
>
> I run the full scan with the -p flag and I get PSIP info at the end of
> the scan output:
>
> top...
> VCT_ID 3013 (0x0bc5) at 351012500hz, version 0
>   VC CD.PROG M# NAME
> ====================
>    2   93.1   4 KTVU
>    3   80.1   4 KNTV
>    4   93.2   4 KRON
>    5   93.3   4 KPIX
>    6   80.2   4 KICU
>    7   93.4   4 KGO
> [snip]
>
> bottom...
>
> PSIP channels
>    VC     NAME  FREQUENCY   MODULATION PROG
> ===========================================
>  38.2    SINO   261012500hz QAM_256     7456
> 236.1     KICU  561000000hz QAM_256      2
> 265.1     KKPX  561000000hz QAM_256      5
> 254.1     KTEH  561000000hz QAM_256      4
>  48.1     KSTS  561000000hz QAM_256      3
> 211.1     KNTV  561000000hz QAM_256      1
>  11.3  KNTV US  609000000hz QAM_256      3
>  11.1  KNTV-HD  609000000hz QAM_256      1
>  11.2  NBC Wea  609000000hz QAM_256      2
>  65.1  ION_KKP  609000000hz QAM_256      6
> 209.1     KQED  639000000hz QAM_256      5
> 204.1     KRON  639000000hz QAM_256      2
> 207.1      KGO  639000000hz QAM_256      4
> [snip]
>   7.1   KGO-HD  753000000hz QAM_256      1
> [snip]
>
> but looking for say, KGO in HD in the SQL update output, I'm assuming
> it's not being parsed correctly...
>
> $ grep -i kgo myth-scte65update-20100203.sql
> UPDATE channel SET mplexid=93,serviceid=4,channum='7',callsign='KGO'
> WHERE freqid=7 AND sourceid=1;
> UPDATE channel SET mplexid=117,serviceid=8,channum='195',callsign='KGO
> Weather' WHERE freqid=195 AND sourceid=1;
> UPDATE channel SET callsign='KGO',serviceid=4,mplexid=(SELECT mplexid
> FROM dtv_multiplex WHERE frequency=639000000) WHERE channum='207.1'
> AND sourceid=1;
>
>
> I've tried going ahead with loading this into mysql and then running
> mythfilldatabase, but nothing seems to change.  I still have all the
> standard definition channels, and no HD channels.  I tried adding the
> local broadcast lineup to SchedulesDirect before I ran the
> mythfilldatabase, but still no change.
>
> Can someone steer me in the right direction with this?  Obviously the
> signal is on the wire and I'm getting good PSIP data.  But I just
> don't know how to get it into myth.  Thanks for any help on this!!
>
> -Matt
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>   
Matt,

I know that you stated you used the -p option to get the PSIP info when 
you created the table file, but did you include it in the sql generation 
command?

scte65scan -p -V 3013 -f4 us-Cable-Standard-center-frequencies-QAM256 > myth-svct.sql


I just ran through it on my system, and the PSIP channels show up in my 
sql file. (VCT_ID 3003):

$ ./scte65scan -p -V 3003 -f4 us-Cable-Standard-center-frequencies-QAM256 > myth-svct.sql

$ cat myth-svct.sql 

-- VCT_ID 3003 (0x0bbb) at 123012500hz, version 19

UPDATE channel SET mplexid=15,serviceid=1,channum='2',callsign='KATU   (abc)' WHERE freqid=2 AND sourceid=1;

UPDATE channel SET mplexid=15,serviceid=3,channum='3',callsign='KRCW   (wb)' WHERE freqid=3 AND sourceid=1;

<snip>

UPDATE channel SET mplexid=100,serviceid=391,channum='3900',callsign='dta_cdl' WHERE freqid=3900 AND sourceid=1;

<snip>

-- PSIP section

UPDATE channel SET callsign='OPB-HD',serviceid=13,mplexid=(SELECT mplexid FROM dtv_multiplex WHERE frequency=123012500) WHERE channum='10.1' AND sourceid=1;

UPDATE channel SET callsign='OPBPlus',serviceid=14,mplexid=(SELECT mplexid FROM dtv_multiplex WHERE frequency=123012500) WHERE channum='10.3' AND sourceid=1;

<snip>  

I'm using scte65scan-0.2.1 if the version might be a problem...

-Jim