External Email - Exercise Caution Yer Vang-Cohen - Yay - a report!! Would it be possible to share more about how it works? What tables/fields does it report on? How is it calculating 'longer than 10 weeks?' On Mon, Sep 25, 2023 at 2:26 PM Vang-Cohen, Yer <[log in to unmask]<mailto:[log in to unmask]>> wrote: External Email - Exercise Caution Hi Tim, We have a scheduled SSRS report that goes out monthly to our prints and drawings department that recaps works on paper that have been on view for longer than 10 weeks, records will continue to show up on the alert until the department has updated the TMS record. Feel free to contact me offline if you have specific questions. Best, Yer Vang-Cohen Data and Database Administrator Yale University Art Gallery 203-436-9563 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartgallery.yale.edu%2F&data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C52304a4b9bea42635c0208dbbdf649ac%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638312637727590060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=emhFtAQgfHGX04TPjLeMKb7bwjxc9YoQMuYaZqumEdM%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartgallery.yale.edu%2F&data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C52304a4b9bea42635c0208dbbdf649ac%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638312637727590060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=emhFtAQgfHGX04TPjLeMKb7bwjxc9YoQMuYaZqumEdM%3D&reserved=0> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Mahdi, Fatima (VMFA) Sent: Monday, September 25, 2023 1:57 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Rotating light sensitive objects and TMS External Email - Exercise Caution Hi Tim! Here at the VMFA we experimented with using the fields on the Documentation tab originally called "UserNumber1" and "UserNumber2" to hold the max number of months a work should be on view, and the min number of months it should rest before going on display again. With these numbers, and the location history, were were able to calculate which works in the collection had been on display too long, and which were ready for display. I can imagine that you could use a similar "Max Months on View" field -- either UserNumber1 or a flex field -- in combination with the location history to send you an alert in TMS, for example, a month before a work reached its maximum months on view, so rotation could be planned at that point. Looking forward to hearing what others are doing! -- Fatima Mahdi Collections Information Specialist/TMS Virginia Museum of Fine Arts 200 N. Arthur Ashe Boulevard Richmond, VA 23220 Tel. 804-340-1443 Pronouns: she/her/hers [cid:image001.png@01D9EFBC.06418E70] ________________________________ From: Tim Henbrey <[log in to unmask]<mailto:[log in to unmask]>> Sent: Monday, September 25, 2023 9:50 AM To: [log in to unmask]<mailto:[log in to unmask]> <[log in to unmask]<mailto:[log in to unmask]>> Subject: Rotating light sensitive objects and TMS External Email - Exercise Caution Hi TMS users Here at the National Gallery in London we are considering how we might best support the use/rotation of light sensitive objects in TMS. We have various works on paper, pastels etc. here that we need to limit the periods of time that are on display. At first glance there seem to be various ways of managing this in TMS – perhaps via scheduled locations, using the ‘Anticipated End Date’ or the ‘Tickler Date’. Or using something in the Conservation record somehow? Perhaps just using a flex field ‘alert date’ type of indicator that something needs to come off display? There are probably many other routes that might be possible…. But I was wondering if anyone out there has implemented a way to limit display of light sensitive objects in TMS? If so, how did you do this and any particular tips you would be willing to share? Really grateful for your thoughts! With best wishes Tim Tim Henbrey Collection Information Officer [log in to unmask]<mailto:[log in to unmask]> +44 020 7747 2475 I work part-time on Mondays, Tuesdays and on Wednesday mornings [The National Gallery, Trafalgar Square, London WC2N 5DN]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.nationalgallery.org.uk%2F&data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C52304a4b9bea42635c0208dbbdf649ac%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638312637727590060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Uh6Z0tXGcPkArhWRe9qk1%2BwvOtzK8DLCpfIIKlddLAA%3D&reserved=0> [The Credit Suisse Exhibition: Frans Hals]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nationalgallery.org.uk%2Fexhibitions%2Fthe-credit-suisse-exhibition-frans-hals&data=05%7C01%7CTMSUSERS%40si-listserv.si.edu%7C52304a4b9bea42635c0208dbbdf649ac%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638312637727590060%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NISddoUJ6oMSO7b0a3LqZ1npP9Yn1RZ3h1WeurtGHZA%3D&reserved=0> 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. -- Kimberly Koons, Museum Collections Officer Division of Museum Services National Archives & Records Administration 700 Pennsylvania Ave., NW Washington, D.C. 20408 NARA mobile: 301-832-0321 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.