[Sesshoumaru]

Hi

I exported my video library to import it on another system (including migration to centralized SQL).
I checked all the entries in the database, and I could confirm that a many-many files entries are missing. The issue probably is that I organize my anime collection like "AnimeName/Season X/Filenames.mkv".
That means that the library only scrapes season 1, the others are not in the library, but they are in the files-table of the MyVideosXXX.db.

Is there a way to export this information as well? Even if the file is not logically liked to tv-shows or episodes, its still present in the files-table.

Thanks in advance

[Karellen]

The issue probably is that I organize my anime collection like "AnimeName/Season X/Filenames.mkv".

I don't see what the issue is. I assume the "Filenames" includes the S01E01 numbering added? If it doesn't, then its not going to work.

its still present in the files-table

That doesn't mean anything. All video files in a Source are added to the files table. You don't need to export that as your new setup should just scan them back.

[Sesshoumaru]

its still present in the files-table

That doesn't mean anything. All video files in a Source are added to the files table. You don't need to export that as your new setup should just scan them back.

Thats nice an dandy, but the files-Table is storing the "playcount" which is used to track the watch-status. If this table is lost, well... thats exactly what I do not want to lose...
I started to write myself a SQL tool which directly migrate the database - as I don't see another posibility to keep certain file-based info. Which is a pity, considering the backup-capabilties otherwise.

[Karellen]

but the files-Table is storing the "playcount" which is used to track the watch-status.

You should have mentioned your intent in the first post.
You can...
1. Export your library to Separate Files (nfo files). Then scan these into your new setup. This is the correct method to re-create libraries. It will give you an identical library. Don't export artwork if you already have local artwork.
2. If it is just the playcounts you are concerned about, then use the WatchedList addon which is in the repo.

[Sesshoumaru]

Kinda cool. Will try it out ... thanks for the advice

[Sesshoumaru]

I am just not lucky .. because I used AniDB as scrapper, it has no "thetvdb" set on the shows.
I may try to fiddle around with the Addon a bit or continue my own solution. Once you deviate from the "norm", you get in troubles when moving data