I am reasonably sure about the following. However, it may make the cat chase the dog, and make your hair fall out.... YMMV especially if you do not back up first.<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
I *think* that all you need to do is to change the xmltvid field in the channel table, from the 'wrong' number to the number of the channel whose scheduling you would like to use...<br>
<br>
ie you have a scanned channel CFMTDT, 47-1 with xmltvid "44788" (discovered through zap2it. but it has no entry in the schedules direct lineup for your area.<br>
<br>
There IS an entry for the analog version CFMT, channel 47, with xmltvid "10105".<br>
<br>
Change the xmltvd entries<br>
<br>
This example uses WUTV, which is the only pair like this that I have at present:<br>
<br>
$ mysql-u mythtv -pmythtv mythconverg<br>
<br>
mysql> select chanid, channum,callsign, xmltvid from channel where callsign like "WUTV%";<br>
+--------+---------+----------+---------+<br>
| chanid | channum | callsign | xmltvid |<br>
+--------+---------+----------+---------+<br>
| 1028 | 28 | WUTV | 11953 |<br>
| 2291 | 29-1 | WUTV-HD | 42945 |<br>
+--------+---------+----------+---------+<br>
2 rows in set (0.00 sec)<br>
<br>
mysql> update channel set xmltvid = "11953" where xmltvid = "42945";<br>
Query OK, 1 row affected (0.00 sec)<br>
Rows matched: 1 Changed: 1 Warnings: 0<br>
<br>
mysql> select chanid, channum,callsign, xmltvid from channel where callsign like "WUTV%";<br>
+--------+---------+----------+---------+<br>
| chanid | channum | callsign | xmltvid |<br>
+--------+---------+----------+---------+<br>
| 1028 | 28 | WUTV | 11953 |<br>
| 2291 | 29-1 | WUTV-HD | 11953 |<br>
+--------+---------+----------+---------+<br>
2 rows in set (0.00 sec)<br>
<br>
mysql> quit;<br>
<br>
<br>
Thereafter, 29-1 will be tuned using the digitial ATSC details connected to chanid 2291, but will download the listings from chanid 1028.<br>
<br>
<br>
At least, that's how I think it works.<br>
Please go play in the minefield, and tell us how it works out!<br>
<br>
Geoff<br><font color="#888888">
</font></blockquote><div><font color="#888888"><br></font>You would be much better off to enable your channels in schedules direct, then get the xmltvid and make the change either in mythtv-setup (channel editor), in the frontend by tuning to the station and pushing 'e' on your keyboard, or the best/easiest is to update it in Mythweb. (settings>TV>channel info)<br>
<br>GL,<br> </div></div>-- <br>Mitchell<br>