Media Location Batch Changing

[airmans]

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!

[FilmLuchs]

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


 

[nostra]

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