[Archivesspace_Users_Group] Importing and linking Top Containers via Spreadsheet?

Hand, Sarit shand at ap.org
Mon Feb 27 22:29:28 EST 2023

Hi Julie,

I have been overhauling our top containers listings for a move that I have had less than 2 months to prep, plan and do. This has included using the bulk importer for archival objects, top container bulk importer and the bulk updater. They all have their pros and cons, but I can tell you, that without them, I would never have been able to do what I have been doing.

There are several issues with the Top container importer. I ran through the scenarios with support at LYRASIS and I believe a ticket was opened. According to the instructions you should not need an EAD ID, only the AO ID and you must upload it within the resource. However, it does not work that way. So, if you do not use EAD, throw in an EAD ID in the resource record and the importer. Also, there are some minor issues if you try to import a box number if that box number is also included in another top container that has a range, i.e.  if you have a top container, boxes 4-9, and then try to create and link a box 4 or box 9, it does not like to do that. Also, for some reason, if you download the PDF log and try to open it, it does not work. And the messaging is poor for this function. I DID figure out how to create and link multiple top containers to one archival object!! So happy that worked.

That said, I did manage work arounds to get it do what I needed and am happy to have the capability.

The bulk updater is great! But it too has limitations. Basically, I found I had to think through what my end goal was and step through it logically to determine the feature I would use to accomplish my goal.
If you wish to discuss, I am always happy to.


Sarit Hand
Digital Archivist
AP Corporate Archives
200 Liberty Street
New York, NY 10281
T 212.621.7035

shand at ap.org

-----Original Message-----
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Julie Swierczek
Sent: Thursday, February 23, 2023 2:49 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: Re: [Archivesspace_Users_Group] Importing and linking Top Containers via Spreadsheet?



A former co-worker recommended I try loading the Top Containers via Spreadsheet on the publicly-accessible sandbox. I was able to load them there using the same methods I was using in my instance. I also tried a few bad loads in the sandbox and received much more informative error log messages in the sandbox.

I've shared the spreadsheets and messages with our host who will in turn share the info with the developers.

I also plan to try the as_spreadsheet_bulk_updater plug-in that Hudson Molonglo made for v.2.8.1. But I had to temporarily set this aside. Perhaps they'll discover the root cause before I pick it up again.

Thanks very much for the suggestions on what to check.


Julie C. Swierczek (SWER-check)
Associate Librarian for Collection Description and Imaging jswierczek at folger.edu | She/her/hers Folger Shakespeare Library | 201 East Capitol Street SE, Washington, D.C. 20003

Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email. Thank you.

More information about the Archivesspace_Users_Group mailing list