2021-10-08 ArchivesSpace Trainers Corps “Office Hour”

Date

Oct 8, 2021 – 2-3pm ET (11-12pm PT)

Date: October 8, 2021

Time: 2:00pm ET / 11:00am PT

Topic: Using the Load via Spreadsheet function in ArchivesSpace

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 ArchivesSpace Community-Wide Virtual Training .

Trainers in attendance:

Jodi Allison-Bunnell, Montana State University

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.

Agenda	Who	Notes

Agenda	Who	Notes
Welcome	Jessica Crouch
How to use the “Load via Spreadsheet” functionality in ArchivesSpace	Brittany Newberry, Atlanta University Center	Brittany demonstrated how to download the load via spreadsheet templates at You can find the templates for load via spreadsheet and all other import templates at Migration Tools and Data Mapping - ArchivesSpace Brittany demonstrated how to load via spreadsheet via ArchivesSpace. For ArchivesSpace members, there is documentation about using this functionality at https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/1173913646 Brittany also demonstrated the ability to upload and link container profiles through load via spreadsheet (as of v3.0). Documentation for this is available at https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2457075717 You will need to be logged into the Help Center to access Help Center links.
Discussion about the “Load via Spreadsheet” functionality	All trainers	Jodi Allison-Bunnell discussed data cleanup using open refine after uploading 6000 digital objects with links that did not render. She based her work on this documentation on using open refine for clean up https://www.orbiscascade.org/programs/ulc/archives-and-manuscripts-collections/archivesspace/openrefine/
Q&A	Everyone	If you would like to use other import templates available at Migration Tools and Data Mapping - ArchivesSpace , these will need to be invoked as background jobs, not through Load Via Spreadsheet. Keep in mind that they load via spreadsheet archival object template contains LOTS of fields, but it doesn’t contain all fields. Some fields have default settings that you may need to change after the fact. Specifically note label is one field that does not appear.