Thanks Jon! Will try that function Evelyn Fidler Collections Manager Gestionnaire des collections [cid:image003.png@01D37280.5D0F4AE0]<http://kingslanding.nb.ca/> @KingsLandingNB 506 476 1905 (c) kingslanding.nb.ca Kings Landing Kings Landing 5804 Route 102 5804 route 102 Prince William, NB Prince William, N.-B. E6K 0A5 E6K 0A5 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jon Thristan Sent: April 6, 2018 7:59 AM To: [log in to unmask] Subject: Re: constituent merge Just jumping here, in case people aren’t aware: you can also copy/delete Text Entries to current selection. Best wishes Jon Jon Thristan MBCS | Project Consultant [log in to unmask]<mailto:[log in to unmask]> | +44 20 7993 8402 GallerySystems | www.gallerysystems.com<http://www.gallerysystems.com/> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Fidler, Evelyn (KL) Sent: 06 April 2018 11:53 To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: constituent merge Thanks good to know! wish more fields were like that Evelyn Fidler Collections Manager Gestionnaire des collections [cid:image003.png@01D37280.5D0F4AE0]<http://kingslanding.nb.ca/> @KingsLandingNB 506 476 1905 (c) kingslanding.nb.ca Kings Landing Kings Landing 5804 Route 102 5804 route 102 Prince William, NB Prince William, N.-B. E6K 0A5 E6K 0A5 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Heikki Pauts Sent: April 6, 2018 7:40 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: constituent merge And also in Geography! Mr. Heikki Pauts | National Museum of Antiquities Registrar [Beschrijving: cid:image002.jpg@01CD372F.7F844D60] Rapenburg 28 (museum) | Papengracht 30 (office) P/O Box 11114 2301 EC Leiden T: +31(0)71-5163117 W: www.rmo.nl<http://www.rmo.nl/> P Please consider the nature before deciding to print this e-mail. Van: The Museum System (TMS) Users [mailto:[log in to unmask]] Namens Fidler, Evelyn (KL) Verzonden: Friday, April 6, 2018 12:36 PM Aan: [log in to unmask]<mailto:[log in to unmask]> Onderwerp: Re: constituent merge I just discovered the right click too. You can also use it in the attribute section Evelyn Fidler Collections Manager Gestionnaire des collections [cid:image003.png@01D37280.5D0F4AE0]<http://kingslanding.nb.ca/> @KingsLandingNB 506 476 1905 (c) kingslanding.nb.ca Kings Landing Kings Landing 5804 Route 102 5804 route 102 Prince William, NB Prince William, N.-B. E6K 0A5 E6K 0A5 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Sidse Buck Sent: April 6, 2018 5:52 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: SV: constituent merge WOW I didn’t know you could right click here : )) But that is perfect – we have recently upgraded to TMS2017 and we have some constituents cleaning to do so this is a great help. Thanks for sharing. All the best Sidse Fra: The Museum System (TMS) Users [mailto:[log in to unmask]] På vegne af Thomas Megaw Sendt: 6. april 2018 10:32 Til: [log in to unmask]<mailto:[log in to unmask]> Emne: Re: constituent merge It’s just with a right click on the chosen constituent. I only started cleaning constituents after our recent upgrade so that’s why I’m not sure if the functionality exists in older versions. Kind regards, Thomas From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Sidse Buck Sent: 06 April 2018 09:25 To: [log in to unmask]<mailto:[log in to unmask]> Subject: SV: constituent merge Where in the Constituent Assistent ? Would you mind sharing a screenshot Thomas? All the best Sidse Buck Bibliotekar | Librarian Fotoarkiv & Bibliotek | Photoarchive & Library M +45 3038 5844 [log in to unmask]<mailto:[log in to unmask]> [http://signature.louisiana.dk/signature.jpg]<http://www.louisiana.dk/> Fra: The Museum System (TMS) Users [mailto:[log in to unmask]] På vegne af Thomas Megaw Sendt: 6. april 2018 10:07 Til: [log in to unmask]<mailto:[log in to unmask]> Emne: Re: constituent merge I don’t know if this is a new feature of TMS2017 but the Constituent Assistant in Objects lets me “Copy to Entire Selection” and “Delete from Entire Selection”, which is a great help in swapping out duplicate constituents from a bunch of records to the correct one, although you do have to be mindful that the correct roles are being maintained. Thomas Thomas Megaw Documentation Officer Aberdeen Art Gallery & Museums Aberdeen City Council Aberdeen Treasure Hub, Granitehill Road, Aberdeen AB16 7AX Email [log in to unmask]<mailto:[log in to unmask]> Direct Dial 01224 523709 Tel 03000 200 293 www.aagm.co.uk<http://www.aagm.co.uk/> Aberdeen Art Gallery is undergoing a major redevelopment. Support our Inspiring Art and Music fundraising campaign today at www.aagm.co.uk/donate<http://www.aagm.co.uk/donate> Follow us @abdnartmuseums From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Garton, Susan Sent: 05 April 2018 21:08 To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: constituent merge Me too. Before the ConXrefDetails and CnXrefSets tables were added (TMS 2012), I always did it in Access. Though you had to be careful, it was really easy. Now I would never dare do it in Access! Sue Garton Data Administrator and Acting Head of Collections Information and Research Smithsonian National Portrait Gallery [log in to unmask]<mailto:[log in to unmask]> | 202.633.8554 [cid:image001.png@01D379B7.112FFCD0]<http://npg.si.edu/> npg.si.edu<http://npg.si.edu/> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Mahdi, Fatima Sent: Thursday, April 05, 2018 4:04 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: constituent merge I do just what Jeff does. Fatima Mahdi Collections Information Specialist/TMS Virginia Museum of Fine Arts 200 N. Boulevard Richmond, VA 23220-4007 T 804.340.1443 [log in to unmask]<mailto:[log in to unmask]> On Thu, Apr 5, 2018 at 12:32 PM, Smith, Jeffrey <[log in to unmask]<mailto:[log in to unmask]>> wrote: Despite training, we sometimes suffer from duplicate Constituents. I have found the safest way to swap them for a single, correct Constituent record is to add the word “DELETE” to the display name, then go to each instance and add the correct Constituent with desired role, etc. and delete the ones marked “DELETE.” Then go to the erroneous Constituent records, try to delete, and if there are still links, TMS will tell you where they are. You then have to track them down and swap them for the correct one. Swapping linked Constituent IDs via SQL can be done but is dangerous – you have to take into account the default Name ID and the two ConXrefDetails links. It’s too easy to overlook something and bollix it up. From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Carrie Hadley Sent: Thursday, April 05, 2018 8:43 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: constituent merge I would also be interested in this! Thanks! From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Diane Karlson Sent: Wednesday, April 04, 2018 4:38 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: constituent merge Hi- I I'm trying to merge two constituent records into one entry. One record is linked via loan and the other object. I tried F1, thinking there would be a clear answer provided but alas no. Do you have the touch to turn two (or three) into one? Can you share the method? Thanks in Advance- Diane Diane Karlson Museum Registrar William J. Clinton Presidential Library 1200 President Clinton Avenue<https://maps.google.com/?q=1200+President+Clinton+Avenue+%0D%0A+%0D%0A+%0D%0A+Little+Rock,+AR+72201&entry=gmail&source=g> Little Rock, AR 72201<https://maps.google.com/?q=1200+President+Clinton+Avenue+%0D%0A+%0D%0A+%0D%0A+Little+Rock,+AR+72201&entry=gmail&source=g> 501.244.2842 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. -- Fatima Mahdi Collections Information Specialist/TMS Virginia Museum of Fine Arts 200 N. Boulevard Richmond, VA 23220-4007 T 804.340.1443 [log in to unmask]<mailto:[log in to unmask]> 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]<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]<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]<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.