Comment 17 for bug 452779

Revision history for this message
CBee (cbeerse) wrote :

WORKAROUND (well, manual labor, the quick and dirty way)

I expect the channel scanning fails for more than me alone. My solution was to insert the frequencies manually. My shot was to use both mythweb and phpmyadmin. But I started setting the first channel in the mythtv-backend-setup. At Channel-Editor, I just added a channel with the details I could get hold of. The cable company provided me with a list of channels and their frequencies. I just got one going.

Then I used phpmyadmin to export table 'channel' in database 'mythconverg' to a sql file. This is an editable ascii file. I used my favorite ascii editor (vi for me, you can use yours). I searched for the line with my channel name in it and I replicated this line for every channel and frequency.

For 'ChanID' and 'ChanNum I used an ongoing number.

I ran xmltv as in their documentation until I got a list with channel names and numbers. These numbers are used with their channel name in the 'xmltvid' field.

Name and CallSign are the full name and abreviation.

For the SQL file: Each line must end with a comma (,) except for the last in the sequence, that ends with a semicolum (;)

Finally I imported the file using phpmyadmin.

Of course, I made some errors. For this I used mythweb. THerer at .../mythweb/settings, there at 'tv -> ChannelInfo' you see the same table as exported and imported above. Here you can update single fields as needed. For bulk edits much faster than the mythtv-backend-setup.