Topic: Custom Reports in ArchivesSpace with demo of new custom reports functionality as of ArchivesSpace v3.2
Over the next year, the Trainers Corps will offer regularly scheduled trainings and office hours covering a variety of topics on all things ArchivesSpace. Registration for each training will be separate and registration will open closer to each training date. Information about this training program is available at https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/2331148319 .
Trainers in attendance:
Jodi Allison-Bunnell, Montana State University
Nancy Enneking, Getty
Noah Huffman, Duke University
Miloche Kottman, University of Kansas Libraries
Brittany Newberry, Atlanta University Center
Christine Di Bella, ArchivesSpace
Jessica Crouch, ArchivesSpace
This office hour will not be recorded. Notes from the office hour, including links to shared resources, will be provided below.
Demo - Custom reports and custom reports templates in ArchivesSpace
Jessica Crouch and Christine Di Bella
Christine provided context for the new custom reports functionality in ArchivesSpace which has been in development since 2018.
-Running custom reports is resource intensive, be mindful how how large your report is and how many linked records you are pulling in. It could over tax your system.
-To enable custom reports, you must ask your sysadmin or hosting provider to turn custom reports on in the config file. (Atlas Systems announced it would be turned “on” be default for their hosting clients.)
-To create, edit, delete or manage custom reports you must have the necessary permission enabled. This is already turned on for repository managers and archivists in the out of the box permission groups.
-To create a template, you can either go through the gear menu or create menu. (If you don’t have permission to manage templates, you won’t see the option in the gear menu.)
How we handle reports
Nancy Enneking demoed Crystal Reports, which Getty uses for their custom reports
Miloche Kottman discussed University of Kansas’s used of Access reports and making use of data dumped out of ArchivesSpace
Brittany Newberry at the Atlanta University Center uses the canned reports in ArchivesSpace and also makes use of the ability to download various CSVs out of ArchivesSpace and massages that data. Like many users, there are lots of spreadsheets involved. Brittany and several other meeting attendees recommend Airtable as a great free tool.