[mythtv-users] scte65scan .sql file (sourceid question)

[Brad Fuller]

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> wrote:
>> 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> wrote:
>>> <SNIP>
>>>>
>>>>
>>>> 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, ''


-- 
Brad Fuller