NPVR database questions

[mvallevand]

Ok, if you every think you can "complete" in the future to allow this would help so consider it a wishlist I guess. I'm liking NEWA's search but I end up doing deletes after recording, and wasting a tuner so this would help

Martin

[mvallevand]

The ratings files seems to be overloaded and can either be film star-rating or something else. Most likely NPVR just takes the last one. This one I have have as "Adult Situations"

Code:

<programme start="20100731010000 +0000" stop="20100731023000 +0000" channel="28460374">
    <title lang="en">Paranormal Activity</title>
    <duration units="minutes">90</duration>
    <desc lang="en">A young couple (Katie Featherston, Micah Sloat) move into their first new home but are disturbed by what appears to be a supernatural presence that is most active at night.</desc>
    <episode-num system="dd_progid">MV002635320000</episode-num>
    <credits>
      <actor>Katie Featherston</actor>
      <actor>Micah Sloat</actor>
      <actor>Amber Armstrong</actor>
      <actor>Mark Fredrichs</actor>
      <actor>Ashley Palmer</actor>
      <director>Oren Peli</director>
    </credits>
    <date>2007</date>
    <premiere />
    <video>
      <quality>HD Simulcast</quality>
      <aspect>16:9</aspect>
    </video>
    <audio>
      <stereo>stereo</stereo>
    </audio>
    <subtitles type="teletext" />
    <rating system="MPAA">
      <value>R</value>
      <icon src="C:\bin32\epg\Common\RatingIcons\MPAA\R.gif" />
    </rating>
    <star-rating>
      <value>3.0/4</value>
      <icon src="C:\bin32\epg\RatingIcons\Star\3.0.gif" />
    </star-rating>
    <rating system="advisory">
      <value>Language</value>
    </rating>
    <rating system="advisory">
      <value>[b]Adult Situations[/b]</value>
    </rating>
    <category>Movie</category>
    <category>Horror</category>
    <category>Suspense</category>
  </programme>

Is there any way to tell the XMLTV import to prefer <star-rating> if it is available? Also I'd assume that the system="MPAA" attribute would be the most appropriate content rating if a filter is required.

Martin

[sub]

I dont really have any answer for you on that at this stage. I'd need to do some more work in future. There seemed to be too many variations to the types of data stored in those fields in the wider world, so I largely ignored it.

[mvallevand]

No real harm I guess, this just calls for some xsl practise while pre-processing

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="http://www.w3.org/1999/xhtml">

<xsl:output method="xml" encoding="UTF-8" indent="yes" />
    <xsl:template match="node()|@*">
      <xsl:copy>
         <xsl:apply-templates select="node()|@*"/>
      </xsl:copy>
    </xsl:template>
    <xsl:template match="rating"/>
</xsl:stylesheet>

Martin

[mvallevand]

In the SCHEDULED_RECORDING table, do zero values for pre and post padding (probably not) and quality (maybe) get set at defaults at time of recording service startup or what do they mean?

Martin

[sub]

zero values for pre and post padding effectively means 'dont use any pre or post padding for this recording'.

zero for quality effectively means use the default bitrate (for the device). This is ignored for digital devices though, since the bitrate is always whatever the broadcaster supplies.

[mvallevand]

Sorry - I meant for upcoming recordings. Completed recordings are left in the database.

I don't know if this is a design change or not (hopefully it's a bug), but it looks like Completed files are now removed from the database. Among other things I was working on have the season episode fields available for the file renamer that I am conceptualizing.

Martin

[mvallevand]

Sub further to my previous post was this a design change?

Martin

[sub]

I don't know if this is a design change or not (hopefully it's a bug), but it looks like Completed files are now removed from the database.

When are they being removed? Pending recordings are removed and recreated when the epg is updated. When I updated the epg just now, all my completed recordings were still there.

Maybe what you saw was the logic that auto removes recordings from the database if the file has been deleted from disk?

[mvallevand]

No, maybe my command is wrong in my xmltv import. I use

"C:\Program Files\NPVR\NextPVR.exe" -updateepgonly

The lowest oid in epg_event is larger than the OID in the XML for any of my scheduled recording saved files, and I cannot find them by searching the title. They are all on disk, except one failure reason that the service wasn't started.

Martin