Assuming you are changing it to all the same credit line, you could also use the Accession Lot tool. Helpful if you don't have access to your server. If not part of the same number lot, you could create a faux lot with an Object Package, and as long as the items aren't part of another Accession Lot, you can do the update - just being sure that the credit line is the only thing you update so you don't change anything in the original records.
Diane.
Date: Tue, 24 Feb 2015 11:56:18 -0500
From: [log in to unmask]
Subject: Re: Batch Updating Credit Lines
To: [log in to unmask]
If you're fixing a problem, say a typo was copied to 100 records, you can use the Search & Replace option: query up the batch you need to fix, go to Maintenance > Database > Search and Replace.
If you're needing to overwrite a bunch of different things, or insert missing info, you'd use a SQL update (or ask your IT or database manager to). Let's pretend this is a whole set of photos whose Object Numbers are something like PhotographsABC.1, PhotographsABC.2, PhotographsABC.3 ... PhotographsABC.1000. Here is what your SQL would look like:
Update ObjectsSet CreditLine = ' your correct credit info 'where ObjectNumber like 'PhotographsABC.%'
On Tue, Feb 24, 2015 at 11:46 AM, LaNore, Ruth, DCA <[log in to unmask]> wrote:
I’d love to know this too!
Ruth LaNore
Registrar
Museum of International Folk Art
P.O. Box 2087
Santa Fe, NM 87504
505.476.1218
www.moifa.org
Subscribe to MOIFA E-News
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Sara Patrello
Sent: Tuesday, February 24, 2015 9:46 AM
To: [log in to unmask]
Subject: Batch Updating Credit Lines
Hello All,
Has anyone successfully batch-updated object credit lines in TMS on records that were previously made? If so, could you let me know what your process was?
Thank you!
Sara
—
Sara Patrello
Assistant Registrar
Smart Museum of Art
The University of Chicago
5550 S. Greenwood Avenue
Chicago, IL 60637
[log in to unmask]
773.702.9549
smartmuseum.uchicago.edu
Celebrating 40 years in 2014–2015
To unsubscribe, send an email to
[log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|