Chad Petrovay

Tag: batch assign

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

  • Assign Status Flags using an Object Package

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