Channel name issue

[mvallevand]

I know you don't use Kodi but you can use it to correct the recordings, if sqlite proves challenging.

Martin

[latenighter]

(Spotted this thread when creating a new thread.)

I faced a similar challenge with my multiple Recurring Recordings specific to channels when I have to re-tune after the UK Freeview service changes channel line-ups and (recently) removed a mux and re-distributed some channels among the remaining muxes. Such changes seem to happen to Freeview every year or so. I have three SQL statements I use in a SQLite project to identify and update the Recurring Recordings to take into account the new channel_oid values and, possibly, updated channel names.

To identify Recurring Recordings that need to be changed:

SELECT RECURRING_RECORDING.*, SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12, INSTR(SUBSTR(RECURRING_RECORDING.match_rules,
INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12), '</ChannelOID>') - 1) AS 'Extracted Channel OID', SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules,
'<ChannelName>') + 13, INSTR(SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules, '<ChannelName>') + 13), '</ChannelName>') - 1) AS 'Extracted Channel Name'
FROM RECURRING_RECORDING
LEFT JOIN CHANNEL ON SUBSTR(RECURRING_RECORDING.match_rules,INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12,INSTR(SUBSTR(RECURRING_RECORDING.match_rules,
INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12), '</ChannelOID>') - 1) = CHANNEL.oid
WHERE CHANNEL.oid IS NULL AND SUBSTR(RECURRING_RECORDING.match_rules,INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12,INSTR(SUBSTR(RECURRING_RECORDING.match_rules,
INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12), '</ChannelOID>') - 1) <> '0';

And if you're brave enough to use SQL to update the NPVR database:

For Channel OIDs

UPDATE RECURRING_RECORDING
SET match_rules = SUBSTR(RECURRING_RECORDING.match_rules, 1, INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 11) || 'New Channel OID'
|| SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules, '</ChannelOID>'))
WHERE SUBSTR(RECURRING_RECORDING.match_rules,INSTR(RECURRING_RECORDING.match_rules, '<ChannelOID>') + 12,INSTR(SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules,
'<ChannelOID>') + 12), '</ChannelOID>') - 1) = 'Old Channel OID';

And for Channel Names

UPDATE RECURRING_RECORDING
SET match_rules = SUBSTR(RECURRING_RECORDING.match_rules, 1, INSTR(RECURRING_RECORDING.match_rules, '<ChannelName>') + 12) || 'New Channel Name'
|| SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules, '</ChannelName>'))
WHERE SUBSTR(RECURRING_RECORDING.match_rules,INSTR(RECURRING_RECORDING.match_rules, '<ChannelName>') + 13,INSTR(SUBSTR(RECURRING_RECORDING.match_rules, INSTR(RECURRING_RECORDING.match_rules,
'<ChannelName>') + 13), '</ChannelName>') - 1) = 'Old Channel Name';


Enjoy,

[artmetz]

Very helpful. Thanks!

[artmetz]

sub,
Would it be possible to have a "Record New Episodes, Any Channel" option?
Art

Which client?  A change like this has a ripple effect on all the other clients, sub would need to change 5.  Technically now that you have changed oid's it is acting like a all channels though and that is how I show it in Kodi. 

Note too you can create an All Channels New recording in Kodi, but if you modify it in any other client, it could break.

Martin

Martin,
Does this mean I could manually create (or modify) a recording in the database that is "All Channels New recording"?
Any tips if so?
Art

[sub]

Another way you can probably do it, is click one of the shows in the TV Guide web page, click Advanced, set the Recording Type to 'Record Series (All Episodes, All Channels)', and click Save to create the recurring recording. Then head to the Scheduler -> Recurring page, and click the recurring recording, and edit the 'Advanced' field to add "and first_run = 'Y'"

ie, if Advanced says:

title like 'Extreme Cake Makers'

change it to be:

title like 'Extreme Cake Makers' and first_run = 'Y'