[mythtv-users] Upcoming Channel Change by Rogers Cable

[R. G. Newbury]

Kevin Kuphal wrote:
> R. G. Newbury wrote:
>> I have received a notice from Rogers Cable that it is dropping some 
>> channels which I receive, and replacing the feed on that channel number 
>> with a different channel feed.
>>
>> As an example, CNN Headline News, which I get as channel 37 will be 
>> dropped, and will be replaced by BBC World News. The actual channel 
>> frequency and all tuning parameters will remain the same, but the 
>> xmltvid for the feed will be changed.
>>
>> This will mess up my Mythtv setup. I have looked through the 
>> documentation and the wiki and found no particular information about how 
>> this should be handled.
>>
>> I think I need to do something like the following:
>>
>> After the changeover by  Rogers:
>> (1)	modify my listing at zap2it to delete the old channels and add the 
>> new channels;
>>
>> (2)	delete from channel where chanid = 1037;
>>
>> (3)	delete from program where chanid = 1015; #clear old program data
>>
>> (4)	If and only if zap2it labs has recognized the changeover and shows 
>> the new channel against the old frequency:
>> 	mythfilldatabase --do-channel-updates	#which should work...
>>
>>
>> Have I missed anything? Any comments by anyone?
>> Should (2) instead be:
>>
>> update channel set (callsign,name.xmltvid) values ("BBCW","BBC World 
>> News",'123456');
>>
>>
>> This change will affect a large number of Rogers customers and will also 
>>   affect the half dozen of us, (at least) who use Mythtv in the Greater 
>> Toronto Area.
>>
>> I would like to prepare a script which will take care of the database 
>> changes, so that it becomes as easy as running the script, updating the 
>> DataDirect listing, and running mythfilldatabase.
>>
>>   
> I think all you need to do is update zap2it, re-download the listing 
> information in mythtv-setup, run mythfilldatabase with --refresh-all.  
> You might need to update any channel specific rules you have but that 
> should take care of it.  If not, you can always dump the program 
> information in mythtv-setup before running mythfilldatabase and it will 
> refresh everything.
> 
> Kevin

I would have thought that (re)downloading the listing info in 
mythtv-setup would choke because there is already information for that 
channel...basically only the call-sign, name and xmltvid are changing in 
the channel table....And --refresh-all might be best run only after 
-do-channel-update which is intended to fix (I think) this problem.

Geoff