Personal Video Database
English => Support => Topic started by: fuser on May 28, 2013, 06:29:51 pm
-
How do one update/import custom items in existing database with rebuilding it from scratch?
My DB contains posters, so CSV/EXCEL export, update and reimport is out of question.
-
Hi fuser,
do you want to export from PVD into another database or the other way round? I am migration data from and to other databases via xml files and locally saved images. You can easily adapt existing scripts to take care of your custom fields. Have a look at the scripts I published in the template and scripts forum lately. If you need any assistance or if I should write a script for you, don't hesitate to ask.
Oliver
http://www.videodb.info/forum_en/index.php/topic,3359.0.html (http://www.videodb.info/forum_en/index.php/topic,3359.0.html)
http://www.videodb.info/forum_en/index.php/topic,3360.0.html (http://www.videodb.info/forum_en/index.php/topic,3360.0.html)
http://www.videodb.info/forum_en/index.php/topic,3357.0.html (http://www.videodb.info/forum_en/index.php/topic,3357.0.html)
-
Since PVD file is Firebird database, one can use a GUI tool to open PVD file and execute SQL command(s) against database to modify data in DB.
Example:
1) GUI tool: FirebirdMaestro (Flamerobin didn't work for me)
2) SQL command: INSERT INTO CUSTOM_VALUES_SHORTSTR VALUES(cmfid,mid,'custom value');
-
Haven't thought of manipulating PVD database directly but I will definitely try this and will report...
-
Since PVD file is Firebird database, one can use a GUI tool to open PVD file and execute SQL command(s) against database to modify data in DB.
Example:
1) GUI tool: FirebirdMaestro (Flamerobin didn't work for me)
2) SQL command: INSERT INTO CUSTOM_VALUES_SHORTSTR VALUES(cmfid,mid,'custom value');
Firebird Maestro is commercial software and costs 99$ for non commercial use. This is a little bit too expensive just to have a look inside the PVD database.
-
Firebird Maestro is commercial software and costs 99$ for non commercial use. This is a little bit too expensive just to have a look inside the PVD database.
Just to have a look inside the PVD DB, you have to manage with trial version. Flamerobin is open source.