External Email - Exercise Caution Kira, Email notifications are not feature in TMS, but rather a function of the database server (MS SQL Server) that hosts the TMS database. Your database administrator needs to configure DB Mail first. Once a profile is configured then they have to write SQL that will query the database, and format/send the email. This script is then saved in a job in SQL Agent, which has a schedule for execution. This is overly simplistic, but your DBA should understand. Chad On Fri, Jul 30, 2021, 10:58 Kira Kikla <[log in to unmask]<mailto:[log in to unmask]>> wrote: External Email - Exercise Caution Can you explain how use alerts to notify registrars? This is an issue that has plagued my institution for a while. Kira Kikla, Registrar and Digital Initiatives Manager Louisiana State Museum PO Box 2448 New Orleans, LA 70176 (504) 568-6984 [log in to unmask]<mailto:[log in to unmask]> LouisianaStateMuseum.org<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.louisianastatemuseum.org%2F&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Caf3766ea13354ed4edeb08d9536bdeb9%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637632545042583685%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=FjG3EfmjKno0iKqEXaju703lGTpZRjM2pxM%2Bofs7UfM%3D&reserved=0> [LSM_Logo_Horizontal_2597BLK-2] From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Smith, Jeffrey Sent: Thursday, July 29, 2021 7:48 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Tracking Loan Expiration EXTERNAL EMAIL Please do not click on links or attachments unless you know the content is safe. We use the Loans module, and the loan renewed date field, with a Loans flex field group set up to record prior loan renewals, if a long-term loan. Loan begin and end dates are easily viewed and sorted via the List View, and alerts can be set up to notify Registrars when a loan is nearing the end of its loan period. Jeffrey Smith Assistant Registrar for Collections Information Collections Department Freer Gallery of Art and Arthur M. Sackler Gallery Smithsonian Institution [cid:image003.jpg@01D78529.650E7A80] From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Chad Petrovay Sent: Wednesday, July 28, 2021 11:31 PM To: ListServ tmsusers <[log in to unmask]<mailto:[log in to unmask]>> Subject: Re: Tracking Loan Expiration External Email - Exercise Caution Sounds like a decent use case for a flex field. On Wed, Jul 28, 2021, 11:53 Weathers, Kaitlyn <[log in to unmask]<mailto:[log in to unmask]>> wrote: External Email - Exercise Caution Hi all, I’m looking for some insight as to how you and your institutions track loan expirations in TMS. Unfortunately, we have not made full use of the loans module, so most of our information is living in the objects module. We currently use attributes to track expiration year with status flags that include the month of expiration. I’m hoping that we can establish a system so that we can develop a report that can be run to let us know when renewals are due. Right now what we’re doing does not work for us. Any suggestions you all have would be appreciated! Best, Kaitlyn Kaitlyn Gardy Weathers Associate Registrar for Loans and Exhibtions Colonial Williamsburg Foundation Mailing: PO Box 1776 | Shipping: 309 First Street Williamsburg, VA 23185 Phone: 757.220.7548 | Fax: 757.565.8752 [Image removed by sender. colonialwilliamsburg.org/give/other-ways-giving/donate/?Code=BGNB01]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcolonialwilliamsburg.org%2Fgive%2Fother-ways-giving%2Fdonate%2F%3FCode%3DBGNB01&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Caf3766ea13354ed4edeb08d9536bdeb9%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637632545042583685%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=17C4YINc03bqpDHVrdISpNzlNN68fg7mJQPOYPNl9TQ%3D&reserved=0> Help support the Colonial Williamsburg Foundation, a private, not-for-profit 501(c)(3) educational institution. 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.