Chad Petrovay

Category: SQL Scripting

  • 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…)

  • Avoiding an “Invalid Property Array Index” Error

    In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. However, the TMS interface expects the SQL view to return only one row per selected record. If your table joins create more than one row per record, then TMS will truncate the SQL view results. If your table join excludes records, then TMS will repeat rows in the SQL view results. Either way, you get an Invalid property array index error and confused end-users. Here’s how to avoid it altogether.

    (more…)
  • Statistics at a Glance Report

    Statistics at a Glance Report

    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…)