Author Topic: Media Location Batch Changing  (Read 4356 times)

0 Members and 1 Guest are viewing this topic.

Offline airmans

  • Member
  • *
  • Posts: 5
    • View Profile
Media Location Batch Changing
« 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!

Offline FilmLuchs

  • Member
  • *
  • Posts: 9
    • View Profile
Re: Media Location Batch Changing
« Reply #1 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


 

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Media Location Batch Changing
« Reply #2 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...
Gentlemen, you can’t fight in here! This is the War Room!

 

anything