Personal Video Database

English => Support => Topic started by: fuser on May 28, 2013, 06:29:51 pm

Title: [solved] Update custom items
Post 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.

Title: Re: Update custom items
Post by: Nautilus2067 on May 28, 2013, 08:59:52 pm

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)

Title: Re: Update custom items
Post by: fuser on May 31, 2013, 06:58:16 pm

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

Title: Re: [solved] Update custom items
Post by: Nautilus2067 on June 01, 2013, 03:21:58 pm

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

Title: Re: Update custom items
Post by: Nautilus2067 on June 13, 2013, 08:10:54 am

Quote from: fuser on May 31, 2013, 06:58:16 pm

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.

Title: Re: Update custom items
Post by: fuser on June 15, 2013, 05:35:21 pm

Quote from: Nautilus2067 on June 13, 2013, 08:10:54 am

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.