[mythtv-users] Changing channel station names

[James L. Paul]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Does there exist any tool or method for updating the names of channels
in the database? It's easy enough to change the xmltv config file so
that name changes don't result in the channel being skipped by XMLTV due
to not being recognized, but that just causes multiple channels in the
database.

Is it safe to just delete a row in the table for the unwanted (and
incorrect) duplicate when a channel changes it's name, or will that
cause other problems?

I have about a dozen channels that I care about that change names in
Tribune's listing twice or 4 times a year, so it would be nice to have
the database key off the channel number rather than the name.

For example, last week my listing for TBS changed to TBSP, and now my
MythTV EPS has two channel 45's, one named TBS and one named TBSP, and
the TBSP one is correct. It's recording shows at the wrong time, perhaps
because TBS is first in the table right now.

For a bit of background, Tribune often forgets to update listings for
Hawaii, at programming season changes and daylight savings time changes.
~ When somebody prods them to correct things, they prepend or append
P,O,HI to station names for part of the year and change them back again.
The Food channel might be FOOD, OFOOD, or FOODP depending on the time of
year. It's not consistent for all the channels either, right now we have
HITLC, FOODP, and even HIUSAP which currently has additions at both ends ;)

This also breaks the little station logo icons, but I'm sure that's easy
to fix in a table somewhere, I just haven't looked for it yet, it's more
important right now to make it work first. :)

Anyway, it sure would be nice to have a simple way to rename a channel
without losing any recording schedules, since this happens a lot here.

Am I missing something obvious?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE/im16T8BYaKRUpkQRAnn8AKCVhSrcxypJHw2qXIWc69KWXH4VuQCgm5Mw
QgzxhX8GXjqyeKAKUfNd1dI=
=e+kL
-----END PGP SIGNATURE-----