As corporate philosophy continues to integrate itself into museum administration, greater emphasis is placed on the quantification of staff activities. Thus, I often find myself in the role not only of Database Administrator, but also of bean counter. This tutorial outlines how to create a Crystal Report that provides statistics drawn from TMS. (more…)
Blog
-
5 (Often Forgotten) Productivity Tools in TMS
Schools are closing, and temperatures are rising: Summer is arriving. As end-users are preparing to leave for the traditional family vacation, here are five (often forgotten) tools to help them work smarter.
(more…) -
Return to Sender: Address Unknown
Outside a cubicle at the Walters Art Museum hangs an envelope from a letter, mailed from the UK, bearing the institution’s Baltimore, Maryland address and a prominent stamp “Missent to Thailand.” I’m not sure which is more amusing: that the letter was sent to Thailand, or that this happens with such frequency that the Royal Mail has a dedicated stamp for just this situation. With institutions emphasizing data standards when cataloging cultural objects, are we also instituting standards for constituent addresses?
(more…) -
Assign Status Flags using an Object Package
Object Packages are a great way to collect together disparate artifact records, for whatever reason the package creator decides. By the same token, Status Flags are a great way to identify artifact records with special attributes, or that require special attention. A great time saver would be if you could mass assign a status flag to the contents of an object package. You can, with this little SQL script…
(more…) -
Get Location Authority Statistics
The Usage Report feature is a great way to keep track of what authority terms have or haven’t been used within TMS. The problem is that the Usage Report feature sometimes isn’t extensive enough – in this case covering the Location Authority. I designed this SQL query to help.
(more…)