update of the media database

[kfmf]

Hi
Is there a possibility how I can update the media database to avoid multiple recordings.
Because of a new installation of nextpvr, it seems all the old recordings were no longer recognized by the system. 
(Movies which are already captured are now planning for a capture again in the future.)
Would be great to know how which approach is the best to tackle that issue.
 
Thanks!

[mvallevand]

I explaing to you already the next time it happens post the zipped logs.

Martin

[kfmf]

Yes I understood. - Thanks you! - I will post it after it happened again.
This is another topic with my database. (of already recorded movies..)

Would be great if you could help to fix it also!

Thanks

[mvallevand]

Actually I thought about it and if you want to PM me a link to your database (it will contain sensitive IPTV account data) I would be able to tell from your deleted entries.

Martin

[kfmf]

Hi Martin, how can I give you the link to the database? Where can I find it? Or is there an option to scan all the movies in the recording folder and subfolders to avoid multiple recordings? (I think this feature would be very helpful not only in case of a new installation. It would be great to hear from you. - Thanks.

[mvallevand]

The issue seems to be determining if a movie is unique,

The file itself in a typical Linux installation will be /var/opt/nextpvr/npvr.db3 Windows users have access to OneDrive perhaps you have a it on another PC but there are other transfer mechanisms like GoogleDrive and filetransfer.io Sites like filetransfer.io allow setting a password but do you trust that? You call also just password protect a zip file and put that on filetransfer.io. Then you can PM me a link and a password.

Martin

[kfmf]

OK - I will zip the file and send you a link. - Thanks

[mvallevand]

Ok the database is fine and I think I partially misunderstood the question.  This is probably not new behaviour in v7 it a  general question.

Basically the issue is what I have been saying to you, are getting minimal data from some source no year and no genre so NextPVR can't  tell in a safe way that is unique.  Substitute "The Simpsons" in that first example  block as an example.

Code:

<OID>343543448</OID>
  <Title>Mission: Impossible</Title>
  <SubTitle></SubTitle>
  <Description>Ethan Hunt is framed for the deaths of his espionage team and attempts to flee government assassins.</Description>
  <ChannelOID>29813</ChannelOID>
  <StartTime>2024-11-05T18:38:47.0000000Z</StartTime>
  <EndTime>2024-11-05T20:42:48.0000000Z</EndTime>
  <FirstRun>true</FirstRun>
  <Rating>PG-13</Rating>
  <DeferredArtwork>http://redacted/b37b3141d2eda3f2958c192aaec72408.jpeg</DeferredArtwork>
</Event>
and

<Event>
  <OID>306814962</OID>
  <Title>Mission: Impossible II</Title>
  <SubTitle></SubTitle>
  <Description>Ethan Hunt, returns and partners up with the beautiful Nyah Hall to stop renegade agent Sean Ambrose</Description>
  <ChannelOID>28518</ChannelOID>
  <StartTime>2024-07-30T23:22:02.0000000Z</StartTime>
  <EndTime>2024-07-31T01:41:51.0000000Z</EndTime>
  <FirstRun>true</FirstRun>
  <Rating>PG-13</Rating>
  <DeferredArtwork>http://redacted/images/bb15b96af51e39a5fcc21d6c79a2dbcd.jpeg</DeferredArtwork>
</Event>

vs working

Code:

<Event>
  <OID>330934163</OID>
  <Title>Mission: Impossible -- Fallout</Title>
  <SubTitle></SubTitle>
  <Description>2018 ● FSK: 12 ● TMS Rating: ★★★★★
Ethan Hunt sein Team schließen sich mit dem CIA-Attentäter August Walker zusammen, um eine Katastrophe epischen Ausmaßes zu verhindern. Der Waffenhändler John Lark und eine Gruppe von Terroristen planen, drei Plutoniumkerne für einen nuklearen Angriff auf den Vatikan, Jerusalem und Mekka, Saudi-Arabien, zu verwenden. Als die Waffen verloren gehen, befinden sich Ethan und seine Crew in einem verzweifelten Wettlauf gegen die Zeit, um zu verhindern, dass sie in die falschen Hände geraten.

Director(s):

Christopher McQuarrie

Actor(s):

Tom Cruise
Henry Cavill
Ving Rhames</Description>
  <ChannelOID>28945</ChannelOID>
  <StartTime>2024-10-08T18:15:00.0000000Z</StartTime>
  <EndTime>2024-10-08T21:25:00.0000000Z</EndTime>
  <FirstRun>true</FirstRun>
  <OriginalAirDate>2018-01-01T00:00:00.0000000</OriginalAirDate>
  <Rating>12</Rating>
  <StarRating>3.5/4</StarRating>
  <Genres>
    <Genre>Adventure / Western / War</Genre>
    <Genre>Detective / Thriller</Genre>
    <Genre>Movie</Genre>
  </Genres>
  <Cast>
    <Member>Actor: Tom Cruise</Member>
    <Member>Actor: Henry Cavill</Member>
    <Member>Actor: Ving Rhames</Member>
  </Cast>
  <UniqueID>Mission: Impossible -- Fallout2018</UniqueID>
  <DeferredArtwork>http://redacted/images/fa1a5c4285eec94e8c839fa566bec7e6.jpg</DeferredArtwork>
</Event>

<Event>
  <OID>233637990</OID>
  <Title>Mission: Impossible - Phantom Protokoll</Title>
  <SubTitle></SubTitle>
  <Description>2011 ● FSK: 12 ● TMS Rating: ★★★★☆
Ethan Hunt ist erneut in Moskau im Einsatz. Doch als ein Bombenanschlag auf den Kreml verübt wird, machen die Terroristen sein Team dafür verantwortlich. Für Ethan Hunt und seine Agenten beginnt ein Wettlauf gegen die Zeit, denn sollten sie den Drahtzieher des Anschlags nicht rechtzeitig finden, steht ein Atomkrieg bevor. Doch um Recherchen anstellen zu können, muss Ethan im Untergrund agieren und in dunkle Machenschaften vordringen.

Director(s):

Brad Bird

Actor(s):

Tom Cruise
Jeremy Renner
Simon Pegg</Description>
  <ChannelOID>23413</ChannelOID>
  <StartTime>2024-02-09T19:15:00.0000000Z</StartTime>
  <EndTime>2024-02-09T22:05:00.0000000Z</EndTime>
  <FirstRun>true</FirstRun>
  <OriginalAirDate>2011-01-01T00:00:00.0000000</OriginalAirDate>
  <Rating>12</Rating>
  <StarRating>3/4</StarRating>
  <Genres>
    <Genre>Movie</Genre>
  </Genres>
  <Cast>
    <Member>Actor: Tom Cruise</Member>
    <Member>Actor: Jeremy Renner</Member>
    <Member>Actor: Simon Pegg</Member>
  </Cast>
  <UniqueID>MV006848190000</UniqueID>
  <DeferredArtwork>https://ondemo.tmsimg.com/assets/p8493689_v_h10_bi.jpg?w=1920&amp;h=1080</DeferredArtwork>
</Event>

The only way you might be able to able to create and experiment with a sqlite3 script that runs in PostLoadEpg.sh before NextPVR does it's scheduling that fakes in the unique_id for your situation.  Condition might be length or perhaps MPAA codes based on that one example.

Code:

update epg_event set unique_id = title where unique_id = "" and condition 

Note when I look at this I think you have bad sql here

Code:

<AdvancedRules>(title like '%Indiana Jones AND description like '%Harrison Ford%')</AdvancedRules></Rules>

Martin

[kfmf]

Hi Martin,

I will take a look on it. Thank you for the help.
Sorry, but it seems I need help again.
My previous question on that post was quite different. I'm searching on the solutions / possibility to let the database know what for movies are already recorded and should not record again. (especially with rules for recording)
It seems that after a new installation (a new database) the system don't know what for movie were recorded and stored on the hard drive on the previous system. That's also a reason why movies were captured twice.
What can I do to avoid it?

Thanks !

[mvallevand]

This seems like a trick question, with an empty database how would you expect NextPVR to know what movies you have stored on hard disks or watched and erased?

Truth be told there is a way but you would need to manually import your existing recordings with the NextTool utility
https://github.com/sub3/NextPVR/wiki/NextTool If these are NextPVR recordings and you have enabled saving external XML file files to save the metadata with the recording it should work. If not assuming the files have been named the why the utility expects the Moviename (year) they will be imported, but the utility doesn't set the unique id but I will address that for the upcoming release.

Martin