[mythtv-users] HD Homerun Prime Scripting

[Kirk Bocek]

On 10/18/2011 8:54 AM, Ozzy Lash wrote:
> On Tue, Oct 18, 2011 at 10:48 AM, Kirk Bocek<t004 at kbocek.com>  wrote:
>>
>>
>> On 10/17/2011 10:27 PM, Ozzy Lash wrote:
>>> On Mon, Oct 17, 2011 at 11:51 PM, Kirk Bocek<t004 at kbocek.com>    wrote:
>>>>
>>>>
>>>> On 10/17/2011 5:32 PM, Gary Buhrmaster wrote:
>>>>> On Mon, Oct 17, 2011 at 23:57, Kirk Bocek<t004 at kbocek.com>      wrote:
>>>>> ....
>>>>>> So let me phrase it in terms of what seems like a widely used utility:
>>>>>> scte65scan. Bill Lash here extracted some simple SQL here for inserting
>>>>>> records into dtv_multiplex. Can I get anyone to comment on *that* code?
>>>>>
>>>>> I am not a MythTV developer, and therefore have no standing,  but.....
>>>>>
>>>>> I consider that I run it at my own risk, and should something "weird"
>>>>> happen with MythTV, it is all my fault, and until I reproduce any issues
>>>>> with a clean database, the presumption *should* be that I messed
>>>>> something up.  Full disclosure, I also occasionally use direct
>>>>> database updates.  The moment I type 'mysql' I consider that the
>>>>> MythTV database is "tainted" in the same terms that the Linux kernel
>>>>> developers do.  That is, I am completely and utterly on my own, and
>>>>> should ask no one for assistance.
>>>>>
>>>>> Gary
>>>>
>>>> Gary, I'm not sure if you're telling me I shouldn't be asking questions
>>>> here. I have a script that is certainly going to help *me*. It's going
>>>> to save broken recordings which is currently how I find out Comcast has
>>>> changed channels on me. If it's going to help me, it must also help
>>>> others if they choose to use it.
>>>>
>>>> I'd like that script to be as bullet-proof as possible and to play as
>>>> nicely as possible with Myth. It seems reasonable to ask for guidance on
>>>> what I'm doing. Robert has very good reasons for why that guidance is
>>>> not likely to come. I'm a little put off by that answer. So I'll
>>>> strengthen the warnings in my script, incorporate Robert's philosophy
>>>> about direct database manipulation and just put it out there and hope it
>>>> helps others.
>>>>
>>>> Kirk Bocek
>>>>
>>>
>>> While I understand Robert's concern, I think anyone using clear qam
>>> today is doing some sort of database manipulation to get the channels
>>> in the database.  I like his suggestion of trying to get what you are
>>> trying to do in mythtv itself, but I think there are some issues with
>>> that, since you are updating information for your clear qam sources
>>> with information from a cablecard source.
>>>
>>> I do think that you have a good script for maintaining clear qam
>>> channels.  I think it would be pretty easy to create something like
>>> scte65scan which would work using the hdhrcc to get an initial set of
>>> channels.  The process would be something like:
>>>
>>> 1. use hdhomerun_config to scan all the channels selecting any
>>> programs that aren't marked as encrypted.
>>> 2. tune to each of the non-encrypted channels using the frequency and
>>> programid from the initial scan, and get the vchannel, and other
>>> information (channel name, ...)
>>> 3. match the frequency up with the dtv_multiplex table
>>>
>>>
>>> I may be missing a few clear qam channels today that have crept in
>>> since my initial scte65scan.  My guess is, that they aren't channels
>>> that I care about, but there might be something there.
>>>
>>> Bill
>>
>> I think that's a good point, Bill. I was mulling over Robert's words but
>> couldn't quite pull it all together. Somehow I can't be the only one
>> having to muck about in the MySQL tables in order to get MythTV to work.
>> There's still a lot of manual maintenance work that needs to be done
>> here to keep MythTV working on a day-to-day basis.
>>
>> I'm going to charge ahead on put the dtv_multiplex code in my script,
>> thanks to your diving into scte65scan. I've got a simple method to test
>> it (and a back-out process too!) I'll ask you to help me test it in a
>> day or so.
>>
>> For new channels, you could use this script to add channels by manually
>> adding the new channel to the channel table but leaving a holder value
>> in mplexid and serviceid: anything other than zero. When you run my
>> script, those fields will get tuned with the proper values.
>>
>> But once again, we're in the same boat as my problem with dtv_multiplex
>> where there's a bunch of fields where I have no idea what they're for.
>> Is there a wiki page that explains the function of each of the fields?
>> How about some source code? I can RTFM. Really.
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
>
> Well, there is:
>
> http://www.mythtv.org/wiki/Dtv_multiplex_table
>
> and
>
> http://www.mythtv.org/wiki/Channel
>
> But I'm not sure how much extra info this gives.
>
> Bill

Well... thanks. <redfaced> I am ashamed I didn't bother to search for 
this first.

"I have no knowledge about what the fields mean or are used for with 
satellite reception."

Does anyone, or is this a bunch of historical leftovers for forgotten 
and unused tuners?

"For North American digital cable reception of non-encrypted channels 
(whether Standard Definition or High Definition) using a pcHDTV HD3000 
or similar, the only fields which need data are 
sourceid,frequency,modulation and sistandard"

There's my answer. I think I'll throw this link into the comments.