v15 Handling of recorded files in DB
#1
Dear all,

after successfully moving from WMC to Kodi 15, I'm now at the final stage of config. Evderything works well so far, including integration of MP TV Server, handling my 4 Digital Device DVBC Tuners and TV Movie EPG Plugin. Of course, I'm looking very much forward to Kodi 16 because of the handling of TV Series....
However, there is one issue I'd like to ask you for your advise:
Since I do pretty much of recordings (shows, movies, series), I once a week pull the recorded files from the local hard disk of my HTPC on my workstation to cut them and to sort them to series / movies location on my NAS.
Now, after removing both (.ts and .xml) files, I would expect that Kodi is able to recognize that the recorded files are no longer existing and does not show them on the list of recorder TV shows - but this doesn't work. As well, refreshing or cleaning up Video Library doesn't do the job. The only way I found was to delete the respective shows manually by using the context menu.
Is there any way to update the list of recorded TV files automatically?

Any suggestion welcome!

Best regards,

Flo
Reply
#2
This is not really a problem of Kodi but of MediaPortal's TVServer.
If you move the recordings in Windows, the TVServer doesn't realize this and you have to clean up the database in TVServer Configuration - Recordings.
The reason for this behaviour is, if you have your recordings on a NAS that isn't always available, TVServer would clean up the hole database!

In MediaPortal's client there's also an option to clean up recordings manually, but i don't know if it's possible to implement something similar in Kodi.
@margro ?
Reply
#3
Open up the TV server client configuration for media portal and go to the recorded tab. The last tab is called database import. Find your files and import them. This is where the recorded stuff is sent to Kodi. It will show recordings physically on the drive, but not in the database . If thge recordings are not in the database, Kodi doesn't know they are there. If they show up and are not there physically, the database needs to be updated. The database is located here: C:\ProgramData\MySQL\MySQL Server 5.6\data\mptvdb
Reply
#4
Hi Flo,

MediaPortal TV Server Setup>Recording>Recorded Tab - there is button Remove invalid entries. This is what you seek. This one removes all database records which miss physical files (.xml or .ts) in the recording folder. However, record by record with the necessary confirmation of each one. Sad Deleting database records will be completed after the TV Server Setup closing. Reuse in one session causes an error.

JiRo
Client/TV Server: 1x Asrock Beebox - LE 9.2.0 + Kodi 18.5 + Tvheadend Backend 4.2 + 4x DVB-T+500 GB HDD + Harmonny One
Clients: 3x diverse PC - W10 - Kodi 18.5, 1x Android Mobile - Kodi 18.4, TVH, Yatse
Data & Media Server: Asustor 8 TB
Reply
#5
Hi JiRo, fishersman,

thanks, this works as described. However, this is not really handy... Maybe there is a way to update the db using a script - or Mediaportal might add an automatic update function in one of their future releases ... I'll post a respective proposal in their forum.

Cheers,

Flo
Reply



Logout Mark Read Team Forum Stats Members Help
Handling of recorded files in DB0
This forum uses Lukasz Tkacz MyBB addons.