Keeping DB and Post Processed Files in Sync

[ChrisHammond56]

I need to check DNS as both my office PC and home PC cannot connect...

This site can’t be reached
Check if there is a typo in tvlistings.zap2it.com.
If spelling is correct, try running windows network Diagnostics.
DNS_PROBE_FINISHED_NXDOMAIN

ping tvlistings.zap2it.com
Ping request could not find host tvlistings.zap2it.com. Please check the name and try again.

I am looking to import roughly 600 recording.

[mvallevand]

What about

https://tvlistings.gracenote.com/api/sho...ryCode=USA

Also if you can PM me link to you npvr.db3 after the full import I can see what I can do for you in PreUpdateEpg.sh

Martin

[ChrisHammond56]

That link works and gives me the JSON response.

So, I can maybe use this with some additions. I have a known uid from a recording with unigue_id=EP009311820012 and seriesId=185554 and performed a lookup with a modified link:

https://tvlistings.gracenote.com/api/sho...ryCode=GBR

Response was:
{
"1": [
{
"programseriesid": "SH00027404",
"assetid": "p185554_b_v11_az",
"title": "The Big Bang Theory",
"connectorid": "SH000274040000",
"releaseyear": "2019"
},
{
"programseriesid": "SH01005209",
"assetid": "p185554_b_v11_az",
"title": "The Big Bang Theory",
"connectorid": "SH010052090000",
"releaseyear": "2019"
},
{
"programseriesid": "SH00931182",
"assetid": "p185554_b_v10_az",
"title": "The Big Bang Theory",
"connectorid": "SH009311820000",
"releaseyear": "2019"
},
{
"programseriesid": "SH01602008",
"assetid": "p185554_b_v10_az",
"title": "The Big Bang Theory",
"connectorid": "SH016020080000",
"releaseyear": "2017"
}
]
}

The third entry has an element of "programseriesid": "SH00931182" which matches the episode portion of the unique_id, and also "assetid": "p185554_b_v10_az" kind of matches the seriesId.

I need to expand on the search to find episodes and not series. Do you have any documentation on the call method you used to the Gracenote API. I cannot seem to find any info on showMovieSearch query (for example, how do I perform a 'showEpisodeSearch'?), via the Gracenote API. The Gracenote API I have takes the format http://data.tmsapi.com/v1.1 and not https://tvlistings.gracenote.com/api/

This link provides almost the same data as the search, but isn't using Gracenote...
http://data.tmsapi.com/v1.1/programs/sea...1234567890

[mvallevand]

No no documentation and I am not really interested in your project since as a said it is typically to time consuming and it is not a public API that I would use in an application for general users This might help get you started.

requests.post("https://tvlistings.zap2it.com/api/program/overviewDetails", data={'programSeriesID': uid, 'aid': 'gapzap'})

I was proposing updating NextTool to post process the EPG before they are recorded and it would check the Name, Season and Episode and they match a recording I would copy over the unique ID so it doesn't re-record.

Martin

[ChrisHammond56]

Hi Martin. Sorry for not responding as I have been away for the weekend.

I was proposing updating NextTool to post process the EPG before they are recorded and it would check the Name, Season and Episode and they match a recording I would copy over the unique ID so it doesn't re-record.

That seems like a good idea. With that idea I can now just import my recording XMLs and then let NextTool add the unique_id when the schedule sees the episode.

Just two questions

1. In my XMLs, should I leave the unique ID blank <UID /> or add a null one <UID>EP000000000000</UID> or no entry at all?
2. You mentioned the recording expiry setting in one of your previous posts, what is the setting in the conf file?

Thanks

[mvallevand]

I figured that that the automatic update would be applicable to most people, but that is why I wanted your database to make sure I can optimize it. The feature won't care what is there, if you have (Title + S/E and not EP....) or (Title + Year and not MV...) it will overwrite it.

If you plan to keep them as recordings then there isn't the same issue, it is the deleted ones that have a short memory of 90 days

DeletionHistoryDays>90</DeletionHistoryDays>

Martin

[ChrisHammond56]

Here is my DB for you to check your update against.

I am not sure the attachment has been added. This has to be one of the worst management systems I have come across. If I drop the attachment into the area specified, it uploads, but doesn't allow me to add (however, it says it will automatically add, but I don't see where). If I click the insert whilst uploading the file, then I get [attach=undefined] in the post.

Thanks

[mvallevand]

That's why I asked for a link. Attachments must be zipped and under 2MB.

Martin

[ChrisHammond56]

There you go.... https://cloud.peakprod.co.uk/s/93wmGQiE4Qso2N6

[mvallevand]

You don't have the old recordings imported yet, I need those to test the logic.

Martin