NextPVR Forums
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR v4 Support (legacy versions) v
« Previous 1 … 10 11 12 13 14 … 431 Next »
manual recordings

manual recordings
artmetz
Offline

Junior Member

Posts: 43
Threads: 13
Joined: Dec 2016
#1
2019-11-25, 11:30 PM
I was hoping that when I export the recordings to xml, I could see the pending manual (one off) recordings somewhere. Is that list only available in the database?
In other words, how do I get a list of the manual (one off) recordings?
mvallevand
Offline

Posting Freak

Ontario Canada
Posts: 36,902
Threads: 727
Joined: May 2006
#2
2019-11-25, 11:48 PM
Do you mean manual or one-off?


Martin
artmetz
Offline

Junior Member

Posts: 43
Threads: 13
Joined: Dec 2016
#3
2019-11-26, 12:00 AM
one-off
mvallevand
Offline

Posting Freak

Ontario Canada
Posts: 36,902
Threads: 727
Joined: May 2006
#4
2019-11-26, 12:09 AM
They will all show in your Pending recordings mixed with your Recurring recordings in NextPVR, why is that a problem?

Martin
artmetz
Offline

Junior Member

Posts: 43
Threads: 13
Joined: Dec 2016
#5
2019-11-26, 01:55 PM
I'm talking about the xml files that are exported. I only see recurring recordings. I'm trying to get a list of the one off recordings so I can update a second system. Having them mixed in doesn't help either, somehow I need to filter them out. Either by querying the xml, the database or a feature enhancement.
mvallevand
Offline

Posting Freak

Ontario Canada
Posts: 36,902
Threads: 727
Joined: May 2006
#6
2019-11-26, 02:12 PM (This post was last modified: 2019-11-26, 02:12 PM by mvallevand.)
The database query is easy,
Code:
select * from SCHEDULED_RECORDING
where status = 1
and recurrence_oid = 0;

Martin
artmetz
Offline

Junior Member

Posts: 43
Threads: 13
Joined: Dec 2016
#7
2019-11-26, 03:07 PM
fyi "status = 1" causes only recordings in progress to show up.
mvallevand
Offline

Posting Freak

Ontario Canada
Posts: 36,902
Threads: 727
Joined: May 2006
#8
2019-11-26, 03:09 PM
(2019-11-26, 03:07 PM)artmetz Wrote: fyi "status = 1" causes only recordings in progress to show up.
Sorry I meant status 0

Martin
artmetz
Offline

Junior Member

Posts: 43
Threads: 13
Joined: Dec 2016
#9
2019-11-26, 03:23 PM
I wound up with this:
status = 0 and recurrence_oid = 0
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Most recordings are zero bytes virtualpaul 4 153 2021-01-29, 12:55 PM
Last Post: virtualpaul
  Recordings with Next PVR 4.2.5 (CL0116) have background music but no voice in record DavidF 4 197 2021-01-07, 08:47 AM
Last Post: sub
  Recordings not playing in browser FamilyGuyFan 1 243 2020-10-22, 10:18 PM
Last Post: mvallevand
  Recordings 1 minute off BobbyDing 7 576 2020-10-11, 08:07 PM
Last Post: mvallevand
  easy tools to remove adverts in recordings? V_J 6 1,487 2020-10-06, 02:37 AM
Last Post: Ehrlichia
  Black screen, no audio, & zero bit recordings mattman1968 1 311 2020-09-15, 12:19 AM
Last Post: mattman1968
  Recordings Date Format NumberFive 3 489 2020-05-14, 11:08 PM
Last Post: NumberFive
  Artefacts on random recordings march 20 1,341 2020-05-13, 11:04 AM
Last Post: Graham
  Manual Channel Scan ... How to add a channel Garmeister 10 4,218 2020-05-12, 06:05 PM
Last Post: mvallevand
Sad Recordings Are Always Size Zero hjjr78 22 1,557 2020-05-04, 02:37 AM
Last Post: hjjr78

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

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

Linear Mode
Threaded Mode