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.