Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

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