The Museum System (TMS) Users


Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Dave Pearce <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Thu, 20 Mar 2003 14:58:47 -0500
text/plain (68 lines)
Linda (and all),

I like what you're doing at MFA Boston with a not MFA site and I would love
to hear more about the routing you're running that updates the "On View"
check box for you in the data entry display mode.  Our curators and docents
would be thrilled to have that sort of information.  Is this an SQL stored
procedure that you did on your own or did you have help from Gallery?  Our
locations don't have a storage or exhibition marker like your "E" and "S" so
I'm wondering how we could define one for ourselves.


>>> [log in to unmask] 03/20/03 02:52PM >>>
We have a site named: Not MFA.

Under this there are sub-sites:
On Annual Loan
On Loan
Returned to Lender

For the sub-site "On Annual Loan" we have sub-locations (Unit type) for the
various institutions that we lend to long-term.
We do not do the same for the "On Loan" sub-site as they are too numerous.
This information can be seen by going to the linked loan record.

All of our storage and Not MFA sub-sites end in "S" for storage. Exhibition
areas end in "E." Each night a routine is run that clicks the On View button
on or off depending if an object is stored in an E or S location. That way
people who cannot see our locations can determine if an object is on view or

Linda Pulliam
Manager of Collections Information
Museum of Fine Arts, Boston

-----Original Message-----
From: Dave Pearce [mailto:[log in to unmask]]
Sent: Thursday, March 20, 2003 2:32 PM
To: [log in to unmask]
Subject: Objects out on loan

Hi all,

I was curious as to how everyone is handling locations for objects which
are currently out on loan.  We have 7 objects out on loan to LACMA right
and when an object goes out we update its current location to "On Loan"
that is a site in the loc hierarchy.  Most of our users can't see location
because its a security controlled field available only to registrars,
curators and conservation.  So we have a Status Flag that indicates that
object is out.  Is anyone doing anything differently?  I was considering
adding sub sites to the "On Loan" site that indicate the actual location
the object in the location authority.

For example
On Loan
     The Metropolitan Museum of Art, NY
     The Los Angeles County Museum of Art, LA
and so on.