Schedules Direct - "epg_event/rating" column empty

[daneo]

Hi Sub & Team,

Running 6.1.1.221110

the column rating in the epg_event table used to be populated by SD with the content rating data however recently I noticed that this is no longer the case.  How can I begin to debug whether this is an import issue in NextPVR or an issue where the data is not being provided by SD?  Typically the data would be expressed as a decimal value of 16 or 18 for parental guidance films.

All other data from SD comes thru fine to populate epg_event, it's just this one lick of data long missing.  I use the rating column with some SQL scripting to determine if a re-recording of a previously recorded film should be performed (sometimes I got a 16 recording locally, but an uncut 18 event is upcoming), otherwise if there's no rating - or a lower rating - then the planned recording is deleted.

I am in Germany, postcode 60318 using the Horizon TV SD-JSON lineup.

Is there anyway to easily get the raw SD data from NextPVR and start to work backwords from the front-end?

Thanks,
 Dane

[mvallevand]

There does appear to be an issue data from Schedules Direct for some data fields. Ratings seems never to be populated and star_ratings are only occasionally populated. Some fields, like audio and aspect are mixed even for the same unique_id and md5 which makes me think the problem could be in the md5 cache.

The source SDJSON still has the data so this is for sub.

Martin

[daneo]

There does appear to be an issue data from Schedules Direct for some data fields. Ratings seems never to be populated and star_ratings are only occasionally populated.  Some fields, like audio and aspect are mixed even for the same unique_id and md5 which makes me think the problem could be in the md5 cache.

The source SDJSON still has the data so this is for sub.

Martin

Thanks - it helps to have confirmed I'm not crazy - the data was there some time ago when I first expanded the scripting, maybe about 12 months - I would want to check if the OTA data is any better.

[mvallevand]

Depending on the priority sub gives on looking at this, I could probably add a postupdate epg utility to add ratings to movies. I already made one for v4 that changes them to the IMDB rating from Gracenote used by SD so it shouldn't be too hard, if I can find the source.

Martin

[sub]

I've fixed the SD rating data for the next build.

[mvallevand]

Thanks, he uses star rating not rating. Out of curiousity which rating do you take by default?

Martin

[sub]

Thanks, he uses star rating not rating.  Out of curiousity which rating do you take by default?

Martin

I'm pretty sure he's talking about rating (age rating), not star rating. (since he's referring to the "16" vs "18 uncut version)

I did check star rating too, but it's only available on movies, and only very sporadically.

[mvallevand]

Right you are, I was think star rating because that is what I care about. The age rating is meaningless here since on broadcast TV they don't match the release rating.

I checked a few movies that didn't have a star rating in NextPVR and I say them all using the API. There was an issue with audio and aspect are definitely inconsistent in NextPVR even with the same unique_id.

Martin

[sub]

I’m away now for a couple of days, but I can double check when I’m back.

Looking in json for the 20 or so channels this morning, it definitely had very few movies with the star rating data. I was surprised how few had it.

[mvallevand]

Ok, I reset my EPG and I got a lot more there may have been a glitch on SD that carried forward. Most of the missing are 2022 plus a lot of Hallmark style romance and Christmas movies, so I think it is pretty code today.

Martin