Many thanks!
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of David Lowe
Sent: Tuesday, February 24, 2015 11:56 AM
To: [log in to unmask]
Subject: Re: Batch Updating Credit Lines
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]<mailto:[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<tel:505.476.1218>
www.moifa.org<http://cp.mcafee.com/d/k-Kr6h0i6jqb2r0UQsK6zAQsI6XCQrTd7bP3WtQjqdXCzBVxZdZwSzuVEVuovjKCrhLsQsLcfFLK6ZfBr-8lCpB05h_k9g8HdA3VmlrFXqL00jsvR2k2aPp0-lBmWuSHM04SwOxJLovW_fFCzDHTbFILLsqemhTbnjIyyHsszOEuvkzaT0QSyrodTV5MQsFIT7e6zBcTsS02lH9Tu00CWC8v4Ldmztfzg5kAnfBitfypWAKZ1ISyUMY-r1vF6y0pStypEw2qO6PB0yq81afEiCq80Ha7QdIECPpgitxf>
Subscribe to MOIFA E-News<http://cp.mcafee.com/d/5fHCNEp3xASyMCMed7bxEVd7b1KVJ6ZPhOYM-Dt4SzuVEVuovjvodETKqenC7QXFCQrTd7bP3WrXxLjVm_y5pCpg1kvR2k2aPp0-lBmWuSHM04T7ZgB0yISgfBplKDJGY01dEcErrS7-LPWpEVWZOWrbXT6zBAtORQX8EGT78YG7DR8OJMddFCS3t-hsd7ardNPxEVjdTdw0FgDYoreloquXkYHIpY01Pi5mVU9OwhbDOFfwsrGoxYiYRqdQ-d0lihs-l9Q-9DGiXQ6Pqbz3PVI5-Aq81DpS9Cy09H8rek29Ew4E-xapEw2IEvgSOyrKkbg>
From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Sara Patrello
Sent: Tuesday, February 24, 2015 9:46 AM
To: [log in to unmask]<mailto:[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]<mailto:[log in to unmask]>
773.702.9549<tel:773.702.9549>
smartmuseum.uchicago.edu<http://cp.mcafee.com/d/5fHCN8e4zqb2r0UQsK6zAQsI6XCQrTd7bP3WtQjqdXCzBVxZdZwSzuVEVuovjKCrhLsQsLcfFLK6ZfBr-8lCpB05h_k9g8HdA3VmlrFXqL00jsvR2k2aPp0-lBmWuSHM04SwOxJLovW_fFCzDHTbFILLsqemhTbnjIyyHsszOEuvkzaT0QSOrodTV5MQsFIT7e6zBcTsS03EHIpGJQZJnCX4VmQznLgrMTkN3UBVGQrFYq0GAyVYGjFYjfkBTEdCQn67DPobZ8Qg3ePIjd40jmgSsE4jh09hZ2kPh05pg-xJB4TSo8e3bB>
[Image removed by sender. So Smart. From the Start]<http://cp.mcafee.com/d/k-Kr40Ue4xESyMCMed7bxEVd7b1KVJ6ZPhOYM-Dt4SzuVEVuovjvodETKqenC7QXFCQrTd7bP3WrXxLjVm_y5pCpg1kvR2k2aPp0-lBmWuSHM04T7ZgB0yISgfBplKDJGY01dEcErrS7-LPWpEVWZOWrbXT6zBAtORQX8EGT78YG7DR8OJMddI6S3t-hsd7ardNPxEVjdTdw0WaX6qHtfrlVKNelJ8RXQ6YdRcg-9uqJ6Wv6waF8KvaAWv4PR9tW3pJ5NxVYS2_id40PIX4Ph04RAdDa14Qg2kvgBcQg1mkfErphdwKCb2M89>
Celebrating 40 years in 2014–2015
To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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.
|
