[solved] Update custom items

[fuser]

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.

[Nautilus2067]

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,3360.0.html
http://www.videodb.info/forum_en/index.php/topic,3357.0.html

[fuser]

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');

[Nautilus2067]

Haven't thought of manipulating PVD database directly but I will definitely try this and will report...

[Nautilus2067]

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.

[fuser]

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.