Whether you are launching a data cleanup project or simply want to verify that standards are being followed, there are times you want to be able to quickly and easily manage your data. In 5 (Often Forgotten) Productivity Tools I mentioned that are a great way to review data. In the first part of this …
Category :The Museum System
Looking for What Isn’t There
My coworkers seem to have an “infinite capacity to not know what can’t be done,” manifest in the myriad of queries they want to perform within TMS. Not satisfied with searching for records that meet a criteria, they’d rather look for records that don’t.
A Place for Everything: Part 2
Last time in A Place for Everything: Part 1, I introduced a script for adding an series of numeric units to a site/subsite in the , so in this follow-up, I’ll introduce a script that can add units that are marked by alphanumeric codes.
A Place for Everything: Part 1
My mother has always been a proponent of finding a place for everything, and putting everything in its place. Before you can use the sub-module to record where everything is placed, you must first use the to create the places in which everything can be placed. While easy to use, the is not always efficient …
Text Entries in a Single View
If you’re anything like me, you probably have a stack of SQL views just to simplify report writing. Since text entries are so pervasive to TMS’s operation, I find that I am constantly making use of them in various Crystal Reports. Here’s a time-saver: a SQL view that combines the four tables used for controlling …