On 4/26/05, Kelly <[EMAIL PROTECTED]> 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 _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
