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 … 15 16 17 18 19 … 81 Next »
Channel name issue

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

Posting Freak

Ontario Canada
Posts: 47,307
Threads: 889
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: 309
Threads: 54
Joined: Dec 2016
#13
2022-11-03, 11:15 PM
Very helpful. Thanks!
artmetz
Offline

Senior Member

NW Montana
Posts: 309
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,922
Threads: 752
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
  Black bars when changing channel Sanbenito 2 27 Yesterday, 03:12 PM
Last Post: mvallevand
  is this a hardware issue with TV tuner? Gemma 1 99 2023-07-24, 11:18 PM
Last Post: sub
  NextPVR weird Zoom issue with Kodi three6zerocool 9 205 2023-07-20, 11:49 AM
Last Post: three6zerocool
  Recording playback fast forward / skip issue shaokong@gmail.com 11 263 2023-07-11, 01:40 AM
Last Post: sub
  NextPVR and 1080i issue. three6zerocool 19 419 2023-07-09, 10:16 PM
Last Post: three6zerocool
  How to update channel list Brucek2839 1 164 2023-06-05, 12:16 AM
Last Post: mvallevand
  Channel freezes , will not resume Brucek2839 6 142 2023-06-04, 05:33 PM
Last Post: Brucek2839
  NextPVR 6 Channel Import Not Working as Expected meccano 3 124 2023-05-27, 04:56 PM
Last Post: sub
  recorded show directory issue? eastavin 1 94 2023-05-20, 11:50 PM
Last Post: sub
  v6.1.2.230502 Will not Sleep after watching TV Channel Lao Pan 24 886 2023-05-13, 06:13 AM
Last Post: dawsonjw

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

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

Linear Mode
Threaded Mode