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 Objects
Set 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

So Smart. From the Start 

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.