Author Topic: Any field swap scripts available?  (Read 6066 times)

0 Members and 1 Guest are viewing this topic.

Offline kozzmik

  • Member
  • *
  • Posts: 13
    • View Profile
Any field swap scripts available?
« 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

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Any field swap scripts available?
« Reply #1 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 ".".

Offline kozzmik

  • Member
  • *
  • Posts: 13
    • View Profile
Re: Any field swap scripts available?
« Reply #2 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!
« Last Edit: May 26, 2011, 07:08:01 pm by kozzmik »