English > Support

Any field swap scripts available?

(1/1)

kozzmik:
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

rick.ca:
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 ".".

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

That is a very good idea. Thanks much.

And it worked perfectly!

Navigation

[0] Message Index