Schedules Direct - "epg_event/rating" column empty

[daneo]

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.

Bingo! I'm looking for the age ratings - if you can fix for the next rev that would be wonderful!

[daneo]

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

Hi Martin,

thanks, but that would be less helpful for me - I aleady use Jellyfin to scrape upcoming movies (it's the long way round, but does a good job of enriching my data, and give me a decent NFO file to parse) and then create a super simple web page of the upcoming recordings based on merging what I have and discarding what I don't want - kind of like the attached screenshot.

[mvallevand]

Yes sorry about the confusion, I couldn't imagine adding every movie and having to delete the ones I don't want, so more information would definitely help. The reason I asked sub how he choose the rating is how rich the data is from SD. For the Dark Knight which you have FSK 16 and maps to what SD says but you can see it could be lots of different values. Your current method not using SD might be better.

Code:

"contentRating": [
            {
                "body": "Motion Picture Association",
                "code": "PG-13",
                "country": "USA"
            },
            {
                "body": "B.C. Film Classification Office",
                "code": "14A",
                "country": "CAN"
            },
            {
                "body": "Saskatchewan Film and Video Classification Board",
                "code": "14A",
                "country": "CAN"
            },
            {
                "body": "Manitoba Film Classification Board",
                "code": "PG",
                "country": "CAN"
            },
            {
                "body": "Maritime Film Classification Board",
                "code": "PG",
                "country": "CAN"
            },
            {
                "body": "Ontario Film Authority",
                "code": "14A"
            },
            {
                "body": "Régie du cinéma",
                "code": "G",
                "country": "CAN"
            },
            {
                "body": "Alberta's Film Classification Board",
                "code": "PG",
                "country": "CAN"
            },
            {
                "body": "Departamento de Justiça, Classificação, Títulos e Qualificação",
                "code": "12",
                "country": "BRA"
            },
            {
                "body": "Freiwillige Selbstkontrolle der Filmwirtschaft",
                "code": "16",
                "country": "DEU"
            },
            {
                "body": "Arcom",
                "code": "-10"
            },
            {
                "body": "Mediakasvatus- ja kuvaohjelmayksikkö",
                "code": "K12",
                "country": "FIN"
            },
            {
                "body": "Australian Classification Board",
                "code": "M 15+",
                "country": "AUS"
            },
            {
                "body": "Ministero della Cultura",
                "code": "T"
            },
            {
                "body": "Instituto Nacional de Cine y Artes Audiovisuales",
                "code": "SAM 13"
            },
            {
                "body": "Film & Publication Board",
                "code": "16",
                "country": "ZAF"
            },
            {
                "body": "Medietilsynet",
                "code": "15 år",
                "country": "NOR"
            },
            {
                "body": "UK Content Provider",
                "code": "12",
                "country": "GBR"
            },
            {
                "body": "Statens medieråd",
                "code": "Från 15 år"
            },
            {
                "body": "British Board of Film Classification",
                "code": "12",
                "country": "GBR"
            },
            {
                "body": "Dirección General de Radio, Televisión y Cinematografía",
                "code": "B",
                "country": "MEX"
            },
            {
                "body": "Instituto de Cinematografía y de las Artes Visuales",
                "code": "12",
                "country": "ARG"
            },
            {
                "body": "Medierådet",
                "code": "15"
            },
            {
                "body": "映倫",
                "code": "G"
            },
            {
                "body": "Kijkwijzer",
                "code": "16"
            },
            {
                "body": "Krajowa Rada Radiofonii i Telewizji",
                "code": "12"
            }
        ],
        "contentAdvisory": [
            "Adult Situations",
            "Violence"
        ],

[daneo]

Hi Martin,

it's actually not that bad - once you get started with a delete list, it kind of takes a life of its own.  The original sweep picks up every film OTA and sets it for recording, then a set of scripts prepare the list of what I have already tagged by SD or HD, as well as the DNR list and then removes the entries from scheduled_recording.  I can track what I have due to normalized metadata added to both epg_event and scheduled_recordings, which I keep in a new table called do_not_record.

I then export the scheduled plus the DNRs based on upcoming epg, and make some simple web pages hosted locally - with a powershell webservice script that can perform simple operations like creating a new do_not_record entry or updating some of the local metadata. I know it sounds clunky, but I use a lot of empty directories and zero-byte text files to track metadata as it's easier to use in batch and harder to delete all at once    you can see I'm speaking from experience...

I take the ratings data and normalize as best I can into Germany FSK levels - it's not as precise as it could be but good enough, as I'm really only wanting to track 16 and 18 ratings so I can ensure I collect uncut films instead of the early-evening variants.

I'm not a great programmer and never will be, but can script my way through a good number of scenarios and situations.  I am sure that there is a much more elegant way to do this, but I also wanted to rely on Sub's recording collision avoidance logic - I may work to improve the SQL scripts and the original search logic to avoid some of the more egregious deletions, but that's for another day.  I would have added a copy of my database if you were interested, but for whatever reason the uploader on the forums is not happy and refuses to complete the 10mb zip file.