[mythtv-users] DVB Channel setup

[Paul Leppert]

On 4/26/05, Kelly <navykel at gmail.com> wrote:
<snip>
> For all you non-MySQL comand line comandos
> http://www.phpmyadmin.net/home_page/index.php
> It took me about 5 min to get it, install it and start using it.
> Because I had both data sets from my DVB scan and Zap, I took the Zap
> xmltvid and saved it off. I went into setup deleted channels and
> rescanned DVB. I then went into myphpadmin and edit the xmltvid from
> zap into my new scan. While there I renamed my channels. All is
> working now.
> 

I just created a file with various update commands on it and then
execute it within mysql (after the scan, but before running
mythfilldatabase).

I don't have the script in front of me, but from memory, I just set
the freqid = channum, and hardcoded the channum and xmltvid.  Since
I'm using OTA, I only had to set it up for something like 23 channels.

update channel set freqid=21, channum=2, xmltvid=xxxxx where channum=21;
update channel set freqid=51, channum=5, xmltvid=xxxxx where channum=51;
update channel set freqid=52, channum='5-2', xmltvid=xxxxx where channum=52;
etc.

Save the file and then just copy and paste it into mysql (or run from
the command line).  If you have multiple capture cards, you can always
add sourceid to the above to be more exact (e.g., if your DVB capture
is sourceid 1, then use 'where channum=21 and sourceid=1;')

It would be nice if zap2it could update their information to match
their callsigns with what the stations are actually broadcasting
(since I'm assuming DVB is getting the callsign from the broadcast
stream).

Just my $0.02...

phlepper
-- 
I hear and I forget. I see and I remember. I do and I understand.  --  Confucius