[xtrips]

Hello,

Is there any tool/mean in order to access the Zappiti database, whatever its format is?
The objective is to batch edit my library.
I mean how can you, for example:
- look for all the movies that do not have a genre?
- select a list of movies and tag them with a new genre?

These kind of stuff.
Any idea?

[petmal]

I think Zappiti uses the SQLite engine. The problem is that it is somehow encrypted... Any ideas on how to get in? I cannot find the encryption key which is suppesed to be in Zappiti.exe.config.

[petmal]

Got it! The database can be opened by SQLite2009 Pro. The encryption key is: U7t3RS6EiG (RSA mode).

[xtrips]

Originally Posted by petmal Got it! The database can be opened by SQLite2009 Pro. The encryption key is: U7t3RS6EiG (RSA mode).

Thank you! I got in, but, bad surprise...
I couldn't find a table where the movies showed up with the categories they belong to.
Do you know of any method that could help me batch edit the movie's categories?

Thanks