Personal Video Database

English => Support => Topic started by: kozzmik on May 25, 2011, 09:28:39 pm

Title: Any field swap scripts available?
Post by: kozzmik on May 25, 2011, 09:28:39 pm

I have a need to move the information in the "barcode" field to the "media label" field in over 500 movies and was wondering if anyone knows of a quicker way to accomplish this, instead of a couple of hours of manual editing. ouch

Title: Re: Any field swap scripts available?
Post by: rick.ca on May 25, 2011, 11:43:53 pm

This sort of thing can probably be done with SQL, but that's probably beyond your means (it certainly is mine). I would just export Barcode and then import it as Media label. In the export, be sure to include fields (other than Barcode) to uniquely identify the movie (normally, Title and Year would do). You'll want to get rid of the Barcode values as well. I'm not sure how that can be done. I doubt it's possible to overwrite them with a "null" but it might be possible with a space and certainly is with a ".".

Title: Re: Any field swap scripts available?
Post by: kozzmik on May 26, 2011, 08:24:57 am

//I would just export Barcode and then import it as Media label.//

That is a very good idea. Thanks much.

And it worked perfectly!