Greetings all, 

I'm very interested in hearing responses to this as well. We're establishing a workflow process that repurposes fields in TMS so select users may electronically sign-off on object treatments. Ideally, this process would be fully automatic, where once X field is filled in/'signed', then an email is sent to a specific group of people alerting them to login to TMS and look at the records, and approve or disprove the request. 

I had heard that SQL Server 2005 will allow the programming of email ticklers/triggers, but I'm not sure if this can happen within TMS. Any ideas from folks out there or GS support? 

Thanks in advance,
 
 Kate Diggle
 Collections Database Administrator
 National Postal Museum
 Smithsonian Institution
 Tel: (202) 633-5512
 [log in to unmask]
 www.arago.si.edu


 -----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Dorothy Davila
Sent: Friday, June 05, 2009 11:19 AM
To: [log in to unmask]
Subject: Art handling work flow application

Dear colleagues,

As our museum moves away from a model where 
curatorial staff manage their own storage spaces 
to one where Collections Management facilitates 
access to storage, we have begun to look about 
for an existing work flow application to 
integrate with our TMS database. Ideally this 
application would facilitate art handling 
requests, formalizing the process beyond 
email/phone calls/hallway conversations to 
provide our curatorial and conservation staff 
with a user-friendly solution for their requests. 
Specifically we envision staff using the 
application to refer to TMS object packages when 
making requests for object 
movement/installation/mounts/study appointments, 
etc. Requests would trigger email(s) to the 
appropriate staff and create a secure, manageable 
list with deadlines for our chief preparator to 
oversee. Does anyone have any recommendations for 
an out-of-the-box or home grown system that they 
would be willing to share? We would be most grateful!

Best wishes,

Dorothy Dávila
Associate Registrar for Collections
617-495-0474 direct
617-495-2379 general line
617-495-9936 fax
[log in to unmask]

Harvard Art Museum
32 Quincy Street, Cambridge, MA 02138
www.harvardartmuseum.org