TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Batch Updating Credit Lines
From:
David Lowe <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 24 Feb 2015 11:56:18 -0500
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2413 bytes) , text/html (8 kB) 
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
> <http://www.internationalfolkart.org/about/mailing-list.html>*
>
>
>
> *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
>
> [image: So Smart. From the Start] <http://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.

ATOM RSS1 RSS2