Question about episode number metadata

[craigrs84]

I noticed in the latest version of NPVR that episode number is no longer present in the event_detail column in the scheduled_recording table. Was this change intentional? I believe the episode number was present in the previous version although it was rarely accurate (not NPVR's fault though). Anyways, I was just curious, thanks.

Here's an example from the scheduled_recording table:

Code:

<Event>
  <OID>2795421</OID>
  <Title>Glee</Title>
  <SubTitle>Jagged Little Tapestry</SubTitle>
  <Description>Kurt and Rachel are faced with struggles as they try to rebuild and co-direct the glee club; Becky brings her new boyfriend to town, leaving Sue feeling concerned.</Description>
  <ChannelOID>7165</ChannelOID>
  <StartTime>2015-01-17T02:00:00.0000000Z</StartTime>
  <EndTime>2015-01-17T03:00:00.0000000Z</EndTime>
  <FirstRun>true</FirstRun>
  <OriginalAirDate>2015-01-16T00:00:00.0000000</OriginalAirDate>
  <Rating>TV-14</Rating>
  <Audio>stereo</Audio>
  <Aspect>16:9</Aspect>
  <Quality>HDTV</Quality>
  <Genres>
    <Genre>Comedy</Genre>
    <Genre>Episodic</Genre>
    <Genre>Series</Genre>
  </Genres>
  <Cast>
    <Member>Actor: Lea Michele</Member>
    <Member>Actor: Chris Colfer</Member>
    <Member>Actor: Darren Criss</Member>
    <Member>Actor: Chord Overstreet</Member>
    <Member>Actor: Jane Lynch</Member>
    <Member>Actor: Matthew Morrison</Member>
    <Member>Actor: Dot-Marie Jones</Member>
    <Member>Actor: Lauren Potter</Member>
  </Cast>
  <UniqueID>EP01141389.0117</UniqueID>
</Event>

And here's the matching EPG data:

Code:

<programme start="20150116200000 -0600" stop="20150116210000 -0600" channel="I43.195990776.microsoft.com">
        <title lang="en">Glee</title>
        <sub-title lang="en">Jagged Little Tapestry</sub-title>
        <desc lang="en">Kurt and Rachel are faced with struggles as they try to rebuild and co-direct the glee club; Becky brings her new boyfriend to town, leaving Sue feeling concerned.</desc>
        <credits>
            <actor>Lea Michele</actor>
            <actor>Chris Colfer</actor>
            <actor>Darren Criss</actor>
            <actor>Chord Overstreet</actor>
            <actor>Jane Lynch</actor>
            <actor>Matthew Morrison</actor>
            <actor>Dot-Marie Jones</actor>
            <actor>Lauren Potter</actor>
        </credits>
        <date>20150116</date>
        <category lang="en">Comedy</category>
        <category lang="en">Episodic</category>
        <category lang="en">Series</category>
        <episode-num system="onscreen">603</episode-num>
        <episode-num system="ms_progid">1.EP011413890117</episode-num>
        <episode-num system="dd_progid">EP01141389.0117</episode-num>
        <video>
            <aspect>16:9</aspect>
            <quality>HDTV</quality>
        </video>
        <audio>
            <stereo>stereo</stereo>
        </audio>
        <new />
        <subtitles type="teletext" />
        <rating system="VCHIP">
            <value>TV-14</value>
        </rating>
    </programme>

[rkulagow]

In the JSON data, that particular episode is Season 6, Episode 3.

{
"programID": "EP011413890117",
"titles": [
{
"title120": "Glee"
}
],
"eventDetails": {
"subType": "Series"
},
"descriptions": {
"description100": [
{
"descriptionLanguage": "en",
"description": "Kurt and Rachel are faced with struggles as they try to rebuild and co-direct the glee club."
}
],
"description1000": [
{
"descriptionLanguage": "en",
"description": "Kurt and Rachel are faced with struggles as they try to rebuild and co-direct the glee club; Becky brings her new boyfriend to town, leaving Sue feeling concerned."
}
]
},
"originalAirDate": "2015-01-16",
"genres": [
"Musical comedy"
],
"episodeTitle150": "Jagged Little Tapestry",
"metadata": [
{
"Tribune": {
"season": 6,
"episode": 3
}
}
],
"cast": [
{
"personId": "124445",
"nameId": "124445",
"name": "Lea Michele",
"role": "Actor",
"billingOrder": "01"
},
{
"personId": "540984",
"nameId": "563572",
"name": "Chris Colfer",
"role": "Actor",
"billingOrder": "02"
},
{
"personId": "556013",
"nameId": "579872",
"name": "Darren Criss",
"role": "Actor",
"billingOrder": "03"
},
{
"personId": "588109",
"nameId": "612727",
"name": "Chord Overstreet",
"role": "Actor",
"billingOrder": "04"
},
{
"personId": "221495",
"nameId": "224010",
"name": "Jane Lynch",
"role": "Actor",
"billingOrder": "05"
},
{
"personId": "281235",
"nameId": "284934",
"name": "Matthew Morrison",
"role": "Actor",
"billingOrder": "06"
},
{
"personId": "317108",
"nameId": "563101",
"name": "Dot-Marie Jones",
"role": "Actor",
"billingOrder": "07"
},
{
"personId": "559619",
"nameId": "583612",
"name": "Lauren Potter",
"role": "Actor",
"billingOrder": "08"
}
],
"crew": [
{
"personId": "188258",
"nameId": "189875",
"name": "Ryan Murphy",
"role": "Executive Producer",
"billingOrder": "01"
},
{
"personId": "200264",
"nameId": "202131",
"name": "Brad Falchuk",
"role": "Executive Producer",
"billingOrder": "02"
},
{
"personId": "306851",
"nameId": "310883",
"name": "Dante Di Loreto",
"role": "Executive Producer",
"billingOrder": "03"
}
],
"showType": "Series",
"hasImageArtwork": true,
"md5": "m8ZjJZkfUVZayff388SRhg"
}

[mvallevand]

SD JSON is the way to go, but the real question for sub is from the mc2xml data does he parse

<episode-num system="onscreen">603</episode-num>

to get that info. Since some shows have more than 99 episodes a year, it is odd syntax.

Martin

[craigrs84]

I'm not sure where NPVR is storing the JSON data. Can you point me in the right direction? Thanks.

[mvallevand]

It doesn't that would be using SchedulesDirect as your EPG source.

Martin

[craigrs84]

... the real question for sub is from the mc2xml data does he parse

<episode-num system="onscreen">603</episode-num>

to get that info. Since some shows have more than 99 episodes a year, it is odd syntax.

Martin

Yep, I agree this is really what my question boils down to. Thanks.

[sub]

It no longer attempts to parse the "onscreen" style of episode-number, since it's pretty much just random text that can be in any format, and varies wildly between different grabbers in different parts of the worlds. It does parse other styles of xmltv episode number, like "xmltv_ns", which has a defined format.

[craigrs84]

It no longer attempts to parse the "onscreen" style of episode-number, since it's pretty much just random text that can be in any format, and varies wildly between different grabbers in different parts of the worlds. It does parse other styles of xmltv episode number, like "xmltv_ns", which has a defined format.

Ok, thanks sub.