Chad Petrovay

Category: The Museum System

  • Accessioning Clean-up: Part 1

    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 List Views are a great way to review data. In the first part of this tutorial, we’ll design a List Views to help with a project to clean-up accessioning information. (more…)

  • Looking for What Isn’t There

    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. (more…)

  • 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 Locations Authority, so in this follow-up, I’ll introduce a script that can add units that are marked by alphanumeric codes. (more…)

  • 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 Location & Movement sub-module to record where everything is placed, you must first use the Locations Authority to create the places in which everything can be placed. While easy to use, the Locations Authority is not always efficient for adding a large number of new locations. In Part 1, I’ll introduce a script I use to add a series of numeric units to a site/subsite. (more…)

  • Text Entries in a Single View

    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 text entries and handling notes.

    (more…)