<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
> So it's been a couple of weeks, but I finally got around to writing the<br>
> script that I had envisioned. The script actually tunes each defined<br>
> channel on the Prime, determines the QAM channel number and program<br>
> (multiplex), and searches the channel table for a corresponding HDHR<br>
> channel. If it finds it, it simply copies all the channel "metadata" from<br>
> the Prime channel.<br>
</div><div class="im">..<br>
> I went ahead and posted it on the Wiki:<br>
> <a href="http://www.mythtv.org/wiki/Prime2qam" target="_blank">http://www.mythtv.org/wiki/Prime2qam</a> I would love to get some feedback.<br>
</div>...<br>
<div class="im">> There is a "preview" option if you wish to test the script without actually<br>
> writing the changes to your DB. It simply outputs the SQL that it would use<br>
> to update the table instead of making the change.<br>
<br>
</div>Very cool! I just ran it in PREVIEW mode and it was able to match all<br>
the odd local access channels that I hadn't been able to identify.<br>
I'll take a closer look at the output before running it in normal<br>
mode.<br>
<br>
You had capital P in Print on your last line, so I edited the wiki to fix.<br>
<span class="HOEnZb"><font color="#888888"><br></font></span></blockquote><div><br></div><div>Thanks for the feedback, and correction. Please let me know if you see any room for improvement as you test it.</div><div><br>
</div><div>I have thought about making it more interactive, add some logging, provide more detail to the user as it runs, having it generate an sql file and only making the changes after prompting the user, and detecting a free tuner on the prime rather than specifying one. I also thought I could make it run much faster if I let it use multiple tuners in the Prime to scan the channels. But in its current form it met my needs.</div>
<div><br></div><div>I also would like to determine if accessing the DB directly is the best way. I know there is a MythTV API for python, but I'm not sure what it is capable of as I discovered it about 75% of the way through writing the script and haven't looked into it.</div>
</div>