Personal Video Database

English => Support => Topic started by: airmans on January 21, 2011, 02:56:24 pm

Title: Media Location Batch Changing
Post by: airmans on January 21, 2011, 02:56:24 pm

Hi!
I have more than 1000 movies about 500 Discs. I saved the Disc No. at Media Location space.
My DVD case is full and I buy a new one and I like sign my movies, the location is the newest or oldest box.

My problem is I can put an "A" sign before all media location records: exemple now is 0001, after it will be A0001.
I hope I can it make a batch script, and I can't suffer it one by one.

Sorry, but I'm not a developer, I am a simple user.

Anyone, could you tell me any solution for this?

Thank you!

Title: Re: Media Location Batch Changing
Post by: FilmLuchs on January 21, 2011, 04:09:36 pm

Hi

you need to use SQL;

1. ! make a backup of your database !
2. start PVD with the --debug option (viddb --debug)
3. In the menu click Help->SQL
4. Paste the following command:

update locations set "value" = 'A' || locations."value"

5. click "execute"

Now ALL of your location entries have the prefix "A"

Don't forget to make a backup before the update


 

Title: Re: Media Location Batch Changing
Post by: nostra on January 21, 2011, 10:17:34 pm

or you can select records that need to be changed, click on Edit button and set the new value in Multiple Movies Editor...