Personal Video Database

Hi,

So i am back on using PVD, among anything because there's no other movies catalog program with such a complete IMDB scraper (IMDB movie tags scraping is just a must for building an interesting movies database, period).
And i am rebuilding the database from scratch. Which shouldn't be no bother as i got IMDB IDs/URLs for all the entries.

But problem, i got some wanted duplicate entries (different DVD releases of the same movie).

Those got differenced names/titles when importing from CSV list, mainly just to skip the duplicate entry problem in question below at that stage. So PVD doesn't see those as duplicates when doing the CSV import.

But then when i import the infos from IMDB. It then change the title, putting the same one on both record (which is what i want, as i use the "release" field to differentiate those).

So please, tell me, where is the (hidden? .conf file only?) parameter to skip the "Duplicate record(s) found" window and always do "Preserve all copies"?

(it seems to only asks this on the first duplication detection for an entry, if i re-import IMDB infos on that same entry, it asks nothing, then just preserving all copies - so if there really is no option for this, maybe i can edit the DB directly to set the magic flag or value just after the CSV import)

Unchecking the "Show selection dialog if similar records are already in the database" doesn't prevent this window to appear. Actually, i wonder what this option changes.

I am using v1.0.2.7.

Many thanks in advance and thank again for PVD, still the best out there.

So i searched for a good FREE database GUI client/manager, FireBird Maestro working fine but being trial software.
And i found a really good one, DBeaver, a JAVA program (so you should install JAVA JRE 6).

Here is a kind of installation procedure (Windows oriented) for it to work with the PVD database file.

- Download latest DBeaver version.
- Depack the DBeaver archive in a directory of your choice.

- Download latest JayBird JDBC connector (atm: "Jaybird-2.2.0JDK_1.6.zip") and FireBird embedded mode libraries (atm: "Firebird-2.5.1.26351-0_Win32_embed.zip").
- Depack each of those archives into a subdirectory of the DBeaver directory, namely "jaybird/" and "firebird/".

- Create a "launch.bat" commands file in the DBeaver directory with the following content :
@echo off
SET PATH=%PATH%;%~dp0\firebird\;%~dp0\jaybird\
START dbeaver.exe
- Launch this "launch.bat", you should have DBeaver running.

- Add a "New" > "Connection", select FireBird databse type, confirm. It should ask if you want to download the FireBird JDBC Connector, press no.

- On the connection setting page, press "Edit Driver Settings".

- Change Sample URL to "jdbc:firebirdsql:embedded:{file}".
- On the "Libraries" tab, press "Add File" and go select "jaybird-full-2.2.0.jar" in the "jaybird/" subdirectory.
- On the "Connection Properties" tab, add a new property "lc_ctype" with "UNICODE_FSS" value.
- Press "OK".

- Now click "Browse ..." to your PVD database on the "Path:" setting. You should then have something like "jdbc:firebirdsql:embedded:d:\PVD\MOVIES.PVD" displayed in the "JDBC URL:" field.
- Leave "User name:" and "Password:" fields empty.
- You can "Test Connection ..." which should display "Success / Connected (XX ms)".
- Press "Finish".

- Now click on the "unfold" icon on the left of the connection you just created in the "Database Navigator" tab (don't enter any credential information).

- You can now access the database.

Enjoy the fine Eclipse style interface, the great bitmap BLOB viewer of this client (even with zoom options), tables relation graph display, etc...
And all this is free!