[mythtv-users] scte65scan .sql file (sourceid question)
bradallenfuller at gmail.com
Mon Jun 15 18:39:38 UTC 2009
On Mon, Jun 15, 2009 at 11:21 AM, Jeff Wormsley<daworm at comcast.net> wrote:
> Just a note...
> I had a similar issue with the script. I only have one tuner (and A-180)
> but it has been added and deleted several times since initial install, such
> that (with multirec) when I look at tuner status I see Tuner 5, Tuner 6,
> Tuner 7, Tuner 8 and Tuner 9. The script wasn't too happy with that,
> putting entries in for tuner 1, which doesn't exist (most people's setups
> probably don't have this problem).
I think in the resulting .sql file from scte65scan, we are dealing
with "sourceid" which is the video source (e.g. SchedulesDirect) not
the tuner. The identification for the tuner is "cardid". But, I could
> Also, one of my channels had a ' in the call sign/name field, which broke
> the generated SQL. I hand edited the file to change ' to '' (two single
> ticks, not a double) and it worked (well, aside from the above issue).
> Another issue: I checked my DTA box and found the VCT ID. When I looked at
> the generated tables, however, the channels that it named (like 18.1, 18.2
> etc) for that ID were not the same as the channels that a normal scan
> produced. For example, on 18, scan (in Myth, not the dvb-util command)
> showed I had 18#0 through 18#7 or so, but scte65scan said I had 18.1, 18.2
> and 18.3.
This is just the separated chosen in mythtv-setup. the author of
scte65scan must have just the peiod as the separator.
Also, if you have subchannels, you are scanning ATSC OTA, which is
different than cable. If you are scanning cable channels, I'm totally
> Scan had more, and on most channels there as a #0 entry, whereas
> scte65scan never reported any .0 channels (.1 being the lowest, always).
> Makes me think there is a programmer's 0 issue involved. The fact scan
> produced more channels than scte65scan may be the fact that I have extended
> digital service, and one cable box that is capable of getting several more
> channels than the DTA box. Perhaps those channels belong to that service
> tier, but I'm not sure. My box isn't hooked to a TV at the moment, its
> hooked to a HD-PVR waiting extremely patiently for official support (I'm
> really not comfortable with non-official repos or running trunk), so I can't
> easily see what it's VCT_ID is at the moment.
> Brad Fuller wrote:
> On Mon, Jun 15, 2009 at 9:11 AM, Mark Knecht<markknecht at gmail.com> wrote:
> On Mon, Jun 15, 2009 at 8:44 AM, Brad Fuller<bradallenfuller at gmail.com>
> On Mon, Jun 15, 2009 at 7:32 AM, Mark Knecht<markknecht at gmail.com> wrote:
> On Mon, Jun 15, 2009 at 7:24 AM, Brad Fuller<bradallenfuller at gmail.com>
> Thanks Roy. I didn't see a reference to sourceid in the link you gave.
> I guess my question should be a little less fuzzy. I fear that
> dtv_multiplex is a table that both pcHDTV3000 and HDHR (and any other
> digital card) uses and thus the sourceid in the resulting .sql file
> could be off. And, if I use \as is' I might delete my currect OTA HDHR
> or my pchdtv3000 table.
> Can anyone confirm that and if so, how do I tell?
> Could you back up your current database, run the command, and then
> look to see what happened?
> I could, but it would be a lot better to understand the dB from an expert.
> How will you determine whether the person who responds is a dB expert? ;-)
> Heck, I don't know. If Michael Dean spoke up, I would be pretty sure
> it was right ;-)
> Anyway, mythweb tools told me what sourceid is from what card (after I
> deciphered the channels numbers to what belonged to what sourceid)
> Here's how my tuners lineup:
> sourceid Tuner connected to
> 1 PVR-250 analog cable
> 2 pchdtv3000 ATSC OTA
> 3 HDHR 0 ATSC OTA
> 4 DCH3416 digital cable
> I'm want to insert a new table and the .sql that scte65scan created
> said to delete sourceid 1. That doesn't sound good to me.
> Note that I do have HDHR 1 in my mythtv-setup, but I've never scanned
> for channels and so I assume that's why there is not sourceid for it.
> Using the MySQL Query Browser, I see that there are two sourceid's in
> the dtv_multiplex table: 2 and 3. That makes sense to me since those
> are the two tuners connected to OTA. However, I don't know why the
> DCH3416 settop box isn't in there too, since it's digital cable. I can
> only guess it's in another table.
> AH... I just queried on cardinput table and I see:
> cardid sourceid displayname
> 1, 1, 'Comcast Analog'
> 2, 2, 'pcHDTV3000 ATSC'
> 3, 3, 'HDHR ATSC'
> 5, 4, 'DCH3416'
> 4, 4, ''
> I haven't smoked for 2 years, 9 months and 4 weeks, saving $4,651.29 and not
> smoking 31,008.63 cigarettes.
> mythtv-users mailing list
> mythtv-users at mythtv.org
More information about the mythtv-users