Hi, apologies if this has been asked beofre or if it is common knowledge. I did a search but could not find the specific answer.
I have been moving my media around between drives whilst gradually putting together my final and ideal setup. I have found that in doing so has meant going through my media in OSMC (Raspberry Pi connected to TV) and deleting/re-scanning media and manually setting ‘Watched’ on each video. This can be slow and laborious.
I have heard of different Library Managers. Is this the best way to edit source/metadata/watched statuses en masse?
The easiest thing for me would be a way of accessing the library data file(s) in OSMC via a separate Windows PC either directly or copying/exporting-importing the relevent files. For remote or offline editing.
I am about to move my entire media collection from a network shared PC drive to a central NAS so this is about be very relevant!
The “data files” are actually sqlite databases. Generally editing them manually is not that recommended. If you want to edit the databases from a windows PC I suggest to use a central mysql based setup.
If the NAS supports MySQL databases that would be a perfect place for it. If the NAS does not support MySQL, then the Pi is probably a better home for it.
Yes, http://kodi.wiki/view/Databases shows the whole database structure, if you search for “watched” you will see the fields where it is stored for each Media
For the watched status, if you install the trakt.tv app it will automatically sync your watched status across devices independently of kodi, including from sqlite on the pi to mysql on a nas. trakt.tv stores the data by movie title, and tv series/episode
Sorry if I’m being really stupid, but I am trying to edit my library using MediaElch and cannot get my existing library content up onto it.
It appears I have successfully connected to OSMC/Kodi using its webserver details, but I can’t see how to get my library content to be displayed in MediaElch.
I think you should ask such questions on the MediaElch support but from how I understand MediaElch you configure the network access to each source additionally to the access to Kodi