Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21

Thread: Add if new to Pending recordings

  1. #11
    Join Date
    Jul 2016
    Location
    USA
    Posts
    80
    My main recorder is a WinTV-quadHD on Computer A. On computer B I used to have a usb-HVR-955Q for live TV and incidental non-recurring recordings and it died. I can (and do if I am going to be away overnight or longer) dedicate one of the 4 tuners on the quad until I can get 955Q replaced. My MCEBuddy runs on Computer B as well as my main desktop computing activities.

    If the dots showed up in the Pending Recording view, that would work for me. Right now they appear on the "what's New" and "Ready Recording" if you do the sqlite3 code above. Does the "First Run" tag ever turn off with the blue dots?

    I could take some of the channels out of one of the quads removing the most offending channels that may record at a time that is not good for me.

    I was hoping since the "First Run" tag was in the code already that it would be a simple skin adjustment to get the "new" to appear in the pending. I don't want to accidentally cancel a pending recording just because I got in a hurry.
    ~Paul

    Setup: NextPVR, Serviio, WinTV-quadHD and WinTV-HVR-955Q. Custom Roku channel developer. Feeding Tube Advocate. About me or http://chambers.pw.

    If you haven't broken it at least once, you're not doing it right.

  2. #12
    Join Date
    May 2006
    Location
    Canada
    Posts
    25,191
    Quote Originally Posted by p37307 View Post
    If the dots showed up in the Pending Recording view, that would work for me. Right now they appear on the "what's New" and "Ready Recording" if you do the sqlite3 code above. Does the "First Run" tag ever turn off with the blue dots?
    Yes it did in my test of that code I posted behind Pending. They are still new so it won't turn off but once recorded you could manually flip them or remove it for all recordings (status != 0)

    I was hoping since the "First Run" tag was in the code already that it would be a simple skin adjustment to get the "new" to appear in the pending. I don't want to accidentally cancel a pending recording just because I got in a hurry.
    First Run isn't a field on recordings and right now it is not exposed to the skin.

    Martin

  3. #13
    Join Date
    Jun 2015
    Location
    Dutchess County, NY USA
    Posts
    132
    Quote Originally Posted by HarryH3 View Post
    Dots? I don't think I've ever seen them.
    I also do not know of "dots." Can someone please explain?
    Later...JohnC

    System Status: Humming
    Desktop: Intel DX38BT MB - Intel Q9650 3GHz Quad - AMD HD6670 Video
    Software: Win 10 Pro - NextPVR - WinTV8 - Total Media Extreme - VLC
    Video: Verizon FiOS - Hauppauge DCR-3250 - Hauppauge HDPVR

  4. #14
    Join Date
    Dec 2005
    Location
    UK
    Posts
    2,354
    Quote Originally Posted by mvallevand View Post
    That being said running a sqlite script to do update dots except in-progress in post update epg is trivial. FWIW I guess even in-progress could be done in parallel/post processing.

    ie
    Code:
    sqlite3.exe  c:\Users\Public\NPVR\npvr.db3 "update scheduled_recording set blue='Y'  where event_details like '%%<FirstRun>true</FirstRun>%%';"
    Martin
    Is there a version of this SQL that would do, but with correct syntax, ... update scheduled_recording set title="New" + title where event_details like '%%<FirstRun>true</FirstRun>%%';"

    But ... I'm not sure that having "New" at the start of the show title actually helps the OP.
    AMD A75, 4 Gig, 1000 Gig, Nvidia N210
    1 x Hauppauge WinTV QuadHD DVB-T2
    1 x TBS 6281 dual DVB-T2
    2 x Hauppauge Nova-t PCI

  5. #15
    Join Date
    Jun 2007
    Location
    St. Paul, MN, USA
    Posts
    1,008
    Quote Originally Posted by jcole998 View Post
    I also do not know of "dots." Can someone please explain?
    When you have a recording selected in a list of recordings in What's New and Recordings view (I'm not sure about Pending view and don't have access to my system to test that right now.), you can press the Red, Yellow, Green, and Blue buttons on the remote (or Alt-R, Alt-Y, Alt-G, Alt-B on the keyboard) to toggle the corresponding dot to be displayed with that recording. The user(s) can assign any meaning they want to the dots.

    In our household, there are 2 main users that watch recordings. We use the following meanings:
    Green dot: I've watched the recording
    Blue dot: My roommate has watched the recording
    Yellow dot: Warning that there is some sort of problem with the recording
    Red dot: Do not delete the recording--one of us wants to permanently keep the recording
    When either of us finishes watching a recording, if the Red dot is not set and the other person's dot (Green or Blue) is set, then we will delete the recording since we've both watched it and it is not marked to be kept permanently.

    I also sometimes overload the red dot to indicate that I've partially watched the recording, so I should "Resume" rather than "Play" it when I want to pick it back up where I left off.
    Last edited by BrettB; 2016-12-23 at 02:56 PM. Reason: Add deletion process

  6. #16
    Join Date
    Sep 2008
    Location
    California
    Posts
    7,090
    I rarely understand Martin's objections to my ideas, we just have a different way of looking at things. If the program currently displays dots according to one set of arbitrary flags in the database, I don't understand any qualitative objection to having an option to display the dots according to a different set of arbitrary flags in the database. Having to hack on-the-fly changes to the existing flags with DIY SQL statements seems fraught with peril.

    Yes, it is true that the dots were not originally imagined to exist on a Pending recording, so the Pending recording screen would need a little tweak to show the dots without overlapping "Pending".
    NPVR Tech Support Sticky - - http://forums.nextpvr.com/showthread...931#post480931
    ---------------------------
    my server: NPVR 3.9.2/Win10Pro 32-bit/AMD A6-7400K/hvr-2250 & hvr-1250 with Winegard Flatwave antenna/Schedules Direct
    playback client: Google Nexus Player running Android 7.1.1/Kodi 16.1 & X-NEWA 2.5.1

  7. #17
    Join Date
    May 2006
    Location
    Canada
    Posts
    25,191
    I don't object to the idea of more information the dots just seem the wrong way of doing it. You shouldn't need a legend to use a feature especially something as obscure as highlighting pending one off recordings.

    Martin

  8. #18
    Join Date
    Nov 2003
    Location
    NextPVR HQ, Wellington, New Zealand
    Posts
    83,387
    If I was doing this, I'd be sticking the word 'new' there somewhere, rather than trying to use the colors (which would mean nothing to most people).

  9. #19
    Join Date
    Jul 2016
    Location
    USA
    Posts
    80
    Quote Originally Posted by sub View Post
    If I was doing this, I'd be sticking the word 'new' there somewhere, rather than trying to use the colors (which would mean nothing to most people).
    For now I edited the blue.png in the recording directory added the word "new". Name:  blue.png
Views: 25
Size:  1,013 Bytes
    Name:  new2.jpg
Views: 25
Size:  19.1 KB

    At some point they won't be new anylonger and I assume the recordings will always be marked new in the other places the dots works forever. Every time it is launched it mark all first run shows in the database blue (new).

    I looked at the skin and saw where the dots are listed. Maybe we can add a dot named new.png with the word 'New' and still be able to keep whatever the blue dot's purpose was. I don't know anything about the backend that makes writes the dot option appear other than now I know it is in the database field as true.

    Since the code is
    Code:
    sqlite3.exe"  c:\Users\Public\NPVR\npvr.db3 "update scheduled_recording set blue='Y'  where event_details like '%%<FirstRun>true</FirstRun>%%';"
    and it has "update scheduled_recording set blue"

    is there code we can run to look for recorded shows in the database to unset the blue dot while at the same time still using the code marking the scheduled recordings blue?
    Attached Images Attached Images  
    Last edited by p37307; 2016-12-24 at 03:31 AM. Reason: clarified last sentence
    ~Paul

    Setup: NextPVR, Serviio, WinTV-quadHD and WinTV-HVR-955Q. Custom Roku channel developer. Feeding Tube Advocate. About me or http://chambers.pw.

    If you haven't broken it at least once, you're not doing it right.

  10. #20
    Join Date
    May 2006
    Location
    Canada
    Posts
    25,191
    Quote Originally Posted by p37307 View Post
    is there code we can run to look for recorded shows in the database to unset the blue dot while at the same time still using the code marking the scheduled recordings blue?
    Yes first clean out the blues

    Code:
    sqlite3.exe"  c:\Users\Public\NPVR\npvr.db3 "update scheduled_recording set blue=''  where event_details like '%%<FirstRun>true</FirstRun>%%';"
    then modify the postupdateepg

    Code:
    sqlite3.exe"  c:\Users\Public\NPVR\npvr.db3 "update scheduled_recording set blue='Y'  where event_details like '%%<FirstRun>true</FirstRun>%%' and status = 0;"
    and use this in postprocessing.bat to clean it up after recording.

    Code:
    sqlite3.exe"  c:\Users\Public\NPVR\npvr.db3 "update scheduled_recording set blue=''  where oid=%1;"
    You don't have to use new.png. If it was me i would modify the skin to show the word Pending as a different colour.

    Martin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •