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: edit field in multiple objects at once?
From:
"Delmas-Glass, Emmanuelle" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 1 Feb 2019 18:02:45 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (14 kB) , text/html (7 kB) , image002.jpg (14 kB) 
Hi Christine,



For the credit line bulk update, we are on TMS 2016 but I don't see the Maintenance--Database--Search and Replace screen. Am I looking in the wrong place?



This is what I get in Maintenance under Search and Replace.



[cid:image002.jpg@01D4BA2E.6B855870]



Thanks!


Emmanuelle

Emmanuelle Delmas-Glass
Collections Data Manager
Collections Information and Access
Yale Center for British Art
203-410-4069
http://britishart.yale.edu/collections/search
Connect on Facebook<https://www.facebook.com/YaleBritishArt/>, Twitter<https://twitter.com/YaleBritishArt>, Instagram<https://www.instagram.com/yalebritishart/>, YouTube<https://www.youtube.com/yalebritishart>, and Snapchat @yalebritishart. #YCBA






-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christine Droll
Sent: Friday, February 01, 2019 12:35 PM
To: [log in to unmask]
Subject: Re: edit field in multiple objects at once?



If you are on TMS2016 R2 or greater, then you can do this in one fell swoop.



On one record, enter the donor info in the acquisition-related role type on the constituent assistant screen, and then right-click to get the "Copy to Entire Selection" prompt.



For the credit line, this is in the Maintenance--Database--Search and Replace screen. (Table: Objects, Column: Credit Line) If the credit-line field is empty, tick the Equal To button. If there is existing text, tick the Contains button and enter the text.





-----Original Message-----

From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Liz Byrne

Sent: Friday, February 1, 2019 10:48 AM

To: [log in to unmask]<mailto:[log in to unmask]>

Subject: edit field in multiple objects at once?



I have 200 objects to which I need to add the same credit line and donor info. Is there an easy way to add the info to all those object records at once? Rather than pasting it in 200 times?



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.

ATOM RSS1 RSS2