NextPVR Forums
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Support Windows v
« Previous 1 … 10 11 12 13 14 … 76 Next »
Channel name issue

 
  • 0 Vote(s) - 0 Average
Channel name issue
mvallevand
Offline

Posting Freak

Ontario Canada
Posts: 46,177
Threads: 875
Joined: May 2006
#11
2022-11-03, 07:38 PM
I know you don't use Kodi but you can use it to correct the recordings, if sqlite proves challenging.

Martin
latenighter
Offline

Junior Member

Posts: 26
Threads: 3
Joined: Dec 2018
#12
2022-11-03, 10:02 PM
(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
Offline

Senior Member

NW Montana
Posts: 307
Threads: 54
Joined: Dec 2016
#13
2022-11-03, 11:15 PM
Very helpful. Thanks!
artmetz
Offline

Senior Member

NW Montana
Posts: 307
Threads: 54
Joined: Dec 2016
#14
2022-11-04, 03:56 PM
(2022-11-02, 04:22 PM)mvallevand Wrote:
(2022-11-02, 04:02 PM)artmetz Wrote: 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
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 103,065
Threads: 749
Joined: Nov 2003
#15
2022-11-04, 04:58 PM
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'
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)

Pages (2): « Previous 1 2


Possibly Related Threads…
Thread Author Replies Views Last Post
  NextPVR 6 Channel Import Not Working as Expected meccano 3 47 2023-05-27, 04:56 PM
Last Post: sub
  recorded show directory issue? eastavin 1 50 2023-05-20, 11:50 PM
Last Post: sub
  v6.1.2.230502 Will not Sleep after watching TV Channel Lao Pan 24 679 2023-05-13, 06:13 AM
Last Post: dawsonjw
  Version 5 install issue with Ceton Tuner??? Pctravel 20 5,101 2023-05-08, 05:00 PM
Last Post: mvallevand
  No channel icons Dotball 5 169 2023-04-11, 02:53 AM
Last Post: Dotball
  organising the channel list ciccio 1 112 2023-03-13, 12:21 PM
Last Post: jcjefferies
  Can't add a channel with web app SilverTiger 7 109 2023-02-26, 01:17 AM
Last Post: mvallevand
  Windows EPG Issue sburgess73 2 167 2023-02-20, 09:04 PM
Last Post: sub
  What should I see on an ATSC 3.0 channel? arlingtoner 5 213 2023-02-12, 01:53 AM
Last Post: arlingtoner
  Settings menu font issue ceandra 3 101 2023-02-07, 06:21 PM
Last Post: ceandra

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode