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

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.