TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show Text 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 changing object number
From:
"Tselentakis, Chrisy" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Thu, 17 Aug 2017 21:41:16 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (1 lines) 
Caroline,

The Accession Lot tool is a feature within TMS, not a plugin. It can be useful. I use it to update Object Status in batches, HOWEVER, you can easily lose data using this tool. If you haven't used it before, I strongly recommend trying it out on test records first, not on your real data. There is documentation about how to use it in TMS Help file, but the documentation is not clear about several steps.

There is a set of fields that can be updated using this tool and a checklist where you can select to update one or more of these fields. The tool automatically selects all the fields for update. DESELECT all the checkboxes before running this tool. If a field is checked and that field was left blank because you didn’t want changes made, THIS FEATURE WILL DELETE YOUR DATA.

I'm not sure if you will get the results you want to batch update object numbers through Accession Lot, but wanted you to be aware of this issue in case you test it out.

Best,

Chrisy

Chrisy Tselentakis
Collections Database Specialist
The Frick Collection
1 East 70th Street
New York, NY 10021
[log in to unmask]









-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Caroline Im
Sent: Thursday, August 17, 2017 2:51 PM
To: [log in to unmask]
Subject: Re: batch changing object number

Thank you all for your responses- I'm glad I waited before using SQL. Is the Accession Lot tool a plugin? I created a new accession lot with the objects I wanted changed but I'm not sure how to edit them beyond this.

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.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

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