[mythtv-users] Script to check/fix Sky (UK) channel numbers

Alastair Kerr alastair.kerr at ed.ac.uk
Mon Jan 19 13:48:34 UTC 2009


Neil Bird wrote:
>
>   As promised, here's an alpha of my script to sanitise Sky channel 
> numbers.  I didn't get a chance to revisit it over the W/E, but I did 
> re-run it to double-check the output.
>
>   I'm not sure how practical it's going to be to get it to update the 
> d/b itself, as I can't see myself trusting it enough (at least until 
> such time as I/someone generates a definitive Sky#<->xmltvid list) 
> [e.g., E4 is, apparently, on a diff. channel for NI to the rest of the 
> UK, but it's difficult to cater for that from the digitialspy site].
>
>   As it stands, edit the details at the top (to get d/b host/user/pass 
> and also [important!] the specific source_id for your Sky input.  Run 
> it, and it should print some SQL that, in principal, will fix 
> mis-matched channel numbers.
>
>   You probably want to go through ones you care about and check them 
> manually before fixing anything!  Also, it [currently] presumes that 
> both the channum AND freqid are the Sky number (as that's how I have 
> it).  Also not sure how well it'll work with the radio channels (4 
> digit with '0' prefix) as they seem to be coming through too.
>
>   Any thoughts or improvements welcome!
>
Thanks for this Neil,
I will be away from my machine for a week but I am keen to try this when 
I get home.
cheers
-Alastair


-- 
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.



More information about the mythtv-users mailing list