fix event_details

[SteveTyrakowski]

Hi,

I trashed my scheduled Recordings table. I was trying to manually change the filename and description in event_details for the Saturday night live special about Prince since the EPG had the wrong data for a repeat episode that was originally scheduled.

I used SQLLite2000Pro to try and update it interactively but the changes wouldn't stick, so I wrote a SQL UPDATE command to update the table, but I was too quick and forgot to add the WHERE OID = nnn clause. So as you may guess, all 3521 entries now point to that same recording with the same event details.

I have a backup of the database from October 2015, so I can write a program to match up OIDs and fix all the entries older than that. The newer entries are almost all in the season/episode format, so I was hoping that with a list of all the files in the recordings directory I can figure out the program logic to update the filenames for the remaining bad entries.

So the last piece of the puzzle is update the event_details field for those. Is there any description of what needs to be in that field or hopefully some way to grab info from THETVDB.COM and build the XML from that? I should be able to parse the program name, season and episode from the filenames of the videos.

Thanks for any help,
Steve Tyrakowski

[ElihuRozen]

Does you C:\Users\Public\NPVR contain recording-backup.xml (possibly .1 and .2, as well) that has everything you need?

If so, just import that on the Recordings tab of the Settings. Backup your current database first. You might need to remove all recrodings before the import so you don't have duplicates.

If not, you might be able to import the individual .ts files. I think there is a way to do it from a command line. If it is possible, you could create a batch file to find all your recordings & import each.

[SteveTyrakowski]

Does you C:\Users\Public\NPVR contain recording-backup.xml (possibly .1 and .2, as well) that has everything you need?

If not, you might be able to import the individual .ts files. I think there is a way to do it from a command line. If it is possible, you could create a batch file to find all your recordings & import each.

I wish I asked a day earlier. I did this on Sunday and the oldest backup xml is just after the problem when i did an epg update.

any idea where to find that command line utility? otherwise I'm looking for info on how to populate the event_details field.

I'm a database programmer, so I'm comfortable using Delphi to manipulate the tables. My biggest issue with Delphi is that it wants to enforce the varchar(50) so I might need to do some fiddling to work-around that.

Thanks,
Steve T.

[ElihuRozen]

any idea where to find that command line utility?

Thanks,
Steve T.

Apparently you can use the main executable. I've never tried this myself. See http://www.nextpvr.com/nwiki/pmwiki.php?...ineOptions . This seems to document using it for an xml, but I think you can pass in the .ts file if it was recorded by NPVR.