[mythtv-users] channels script

Sam Jacobs samlists at ijacobs.co.uk
Tue May 13 17:26:28 UTC 2014


On Tue, May 13, 2014 at 4:30 PM, jacek burghardt
<jaceksburghardt at gmail.com> wrote:
> I see there is a script to rename channels for UK freeview.
> I wonder if there is a script that will copy call signs to channel name
> field if empty ?

Hmm. I don't know why you're ending up with empty Freeview channel
names, but this SQL will do what you want:

UPDATE channel SET name=callsign WHERE name="" AND sourceid=1;

Sam


-- 
Sam Jacobs on MythTV 0.27, UK Freeview SD & Freesat HD, EIT-only EPG
Mac mini, MBE+FE: OS X Mavericks, bundled FE, macports BE
Acer Aspire L310, SBE: Debian testing, Elgato EyeTV for DTT Stick
(Hauppauge Nova-T USB Stick in disguise!) & DVBSky S960 DVB-S2 USB


More information about the mythtv-users mailing list