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.