Comcast is transitioning away from analog to digital. For those customers not upgrading to digital TV's, they are providing free digital to analog converters (DTA's). Traditionally, their full featured set top boxes (STB's) received all sorts of information such as encryption keys, guide data, etc via an out of band (OOB) POD interface. This is a special receiver that tunes frequencies outside of the normal TV frequencies. One of the pieces of information that's transmitted is a table that maps station callsigns and virtual channels (the integer channels that the STB's present to the user and are used by TV Guide, Schedules Direct, zap2it, etc) to RFchannel.program number that clearQAM TV's use. For example, Schedules Direct and Comcast may say FOODTV is channel 35 but a clearQAM capable TV plugged directly into the line will report it as 78.4. This would also traditionally require one to use the MythTV channel editor and manually input the frequency and program number for each channel and associate the xmltvid. Since Comcast is handing out DTA's for free, they are severely cost reduced and don't have a POD interface. In its stead, they are transmitting the virtual channel table in-band (i.e. tuneable with a conventional clearQAM tuner) to allow the DTA's to do the virtual channel mapping.
The scte65scan tool
scte65scan is a utility that will read the in-band virtual channel tables and automate the mapping of frequencies and program numbers to virtual channels and xmltvids.
A quick overview of the process is as follows:
- Find the VCT_ID for your lineup. This can be done by obtaining a DTA or STB and reading it from the diagnostic page. Alternatively, it can also sometimes be found by inspection through an examination of the text-mode output of scte65scan
- Generate SQL for importing into MythTV (e.g. `scte65scan -f3 -V your_VCT_ID itfile > vct.sql`
- If you seem to be missing channels (e.g. your local broadcast HD), try the -p option to scan the full channel table (e.g. via HDHomeRun `scan -H FFFFFFFF -p -f3,9 -V 3092 us-Cable-Standard-center-frequencies-QAM256 > vct.sql`)
- Import the SQL into MythTV (e.g. `mysql mythconverg < vct.sql`)
The next time it is run, mythfilldatabase will detect the virtual channel number in the 'freqid' and/or 'channum' field of the imported SQL and fill in the xmltvid for you if you are using Schedules Direct. Be sure to enable the channels at Schedules Direct prior to running mythfilldatabase. Alternatively, you can use the following SQL, which will also help by setting the callsigns to the same so that they don't double up in the UI:
SET @scte_source = <<scte source id>>; SET @sd_source = <<SD source id>>;
UPDATE channel SET callsign=REPLACE(REPLACE(REPLACE(callsign, ' HD', 'DT'), '-HD', 'DT'), '-DT', 'DT') WHERE sourceid=@scte_source;
UPDATE channel AS c1, channel AS c2 SET c1.channum = c2.channum, c1.xmltvid = c2.xmltvid, c1.name = c2.name, c1.icon = c2.icon WHERE c1.sourceid = @scte_source AND c2.sourceid = @sd_source AND c1.callsign = c2.callsign;
UPDATE channel AS c1, channel AS c2 SET c1.callsign = c2.callsign, c1.xmltvid = c2.xmltvid, c1.name = c2.name, c1.icon = c2.icon WHERE c1.sourceid = @scte_source AND c2.sourceid = @sd_source AND c1.channum = c2.channum;
There are several things that are tricky about this.
- The SQL that scte65scan generates assumes that it can start the mplexids for the transports can start at 1, which only works if this is the only DVB source in the database. The latest SVN deals with this by multiplying the sourceid by 1000 and adding it to the RF channel number to generate mplexid's much like mythtv generates channel ID's by multiplying the sourceid by 1000 and adding it to the cable channel number. Otherwise you'll get conflicts, so you'll have to manually adjust the mplexid values to an unused range.
For more information, visit the scte65scan project page
How to determine VCT_ID using a Full Set Top Box
For those without DTAs, it is still possible to determine the VCT_ID using most set top boxes. This method is tested on Motorola DCH-3200s and DCH-6200s, but should work for other Motorola models as well.
- Power on your box.
- Press "Power" on the remote to turn off the box. IMMEDIATELY press "OK" on the remote. You should see a long list of menus numbered d01-d18.
- Select option d6, "Current Channel Status."
- You should see VCT ID listed on this page. It may only be one or two digits, which should correspond to the last one or two digits in the VCT_ID. You can run the scte65scan tool with no options to see the available tables. If the VCT_ID on your set top box is "10" and the scte65scan program shows that one of the VCTs is 3010, then this is your VCT_ID. Take note of both the decimal and hex VCT_ID and enter them in the table below.
How to determine VCT_ID using the Pace DC50X
- Make sure the unit is on.
- Hold down the INFO button until you see the diagnostics screen.
- Press +/- until you see the VCT_ID. This should be the 2nd screen
Here are screenshots and unboxing:
Here is the mythtv-user post about scte65scan:
Update 10/31/09: Pace DC50X box you get from comcast may no longer have the screens listed in the screen shots above. Step 3 above will be different. Use the channel up or down button to go to the Virtual Channel Map and press enter on the remote, it will give you the channel list, complete with frequencies. (along the top of the screen will give the VCT ID)
VCT_ID by Location
Please post your Zip code, city, and VCT_ID in the table below to allow others without DTAs to determine a probable/possible VCT_ID choice.
Important! All locales will see multiple VCT_IDs, only one of them applies to your locale. That is the point of this table. See the instructions above and only post one VCT_ID: the one for your exact location. Please do not post all the VCT_IDs you see! Rarely, the same ZIP code can overlap locales and have different VCT_IDs. This is why it is essential that you provide all information to distinguish one from the next.
Note: Please put each ZIP code in a new entry. Adding extra ZIP codes to an existing entry breaks sorting of the table. Please do not leave any fields blank. Figuring out the decimal and hex values are explained above.
|State||City||Zip Code||VCT_ID (decimal)||VCT_ID (hex)|