Add if new to Pending recordings

[p37307]

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.

[mvallevand]

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

[jcole998]

Dots? :confused: I don't think I've ever seen them.

I also do not know of "dots." Can someone please explain?

[Graham]

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.

[BrettB]

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.

[johnsonx42]

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".

[mvallevand]

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

[sub]

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).

[p37307]

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". [ATTACHMENT NOT FOUND]
[ATTACHMENT NOT FOUND]

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?

[mvallevand]

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