[mythtvnz] Sky is renumbering its channels on 1-May-2013

[David Shepherd]

> On Tue, 30 Apr 2013 16:46:56 +1200, you wrote:
>
>>The final working version of the Sky channel renumbering script is now
>>available here:
>>
>>  http://www.jsw.gen.nz/mythtv/skynz-renumber.tgz
>>
>>This has two options to set, one for automatically backing up the
>>mythconverg database before making the changes (BACKUPDB, defaults to
>>on), and one for setting testing mode where changes are made to a copy
>>of the channel table instead of making real changes in the actual
>>channel table (TESTING, defaults to on).
>>
>>Try running the script as is first (with TESTING on), and make sure it
>>works for you, and make any necessary adjustments for your system.
>>Then edit the TESTING setting to 0 to run it for real.
>>
>>I am lucky that I do not have any programmes recording from Sky until
>>well after midnight, so I have a couple of hours to fix things if
>>necessary.  I would recommend that anyone who does have a recording
>>scheduled on Sky over midnight reschedule it if possible.
>>
>>I do not know exactly what Sky needs to do to make the channel
>>renumbering happen, but I suspect it will only involve changing all
>>the ID data sent on their transponders, and changing all the EPG data
>>to match.  So that should only take around as long as running epgsnoop
>>to get all the EPG data does - a few minutes.  So you should be able
>>to run the renumbering script just after midnight and all should be
>>well.  I would suggest running it from an "at 00:00" command from a
>>root prompt.
>
> And you probably need to set up epgsnoop to use the new
> channels.conf.sky I posted.  The old one is rather out of date now.
> Remember to comment out any channels you do not have configured in
> your database, as epgsnoop adds in any channels it finds in the
> channels.conf file that it also finds in the EPG data.  If you are
> still using the unmodified channel.conf file that comes with epgsnoop,
> it will likely be adding in some invalid channels for you eg Fresh.
> The way it adds them does not cause any problems, but does clutter up
> your database.  They end up with NULL in the channum field, so you can
> easily find and delete them.  Incidentally, NULLs are not allowed in
> the channum field, so I am not sure how epgsnoop is managing to do
> that.
>
> However, I have not tested the new channels.conf.sky file yet - I am
> leaving that for tonight after I have all the channels renumbered
> safely.
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>
Thanks for that Stephen, I'll update my channels.conf.sky tonight and do
the database manually as I've only got a small subset of channels
configured to record from.