[Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID

Valerie Addonizio vaddonizio at atlas-sys.com
Thu Aug 5 13:02:38 EDT 2021

Hi Molly and Aida!

The URI you need there will be for the Resource record you are attempting to add an archival object to, not the AO. AS knows which AO you want to add to if your first highlight the AO that you want to add to, then click the spreadsheet importer. But the template is looking for the Resource URI.

URIs look like this:


But, pro-tip, depending on which version you're on, every record's URI is listed at the top of the record when in View mode, next to the audit info:

[cid:image003.png at 01D789FA.28E69B70]

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Molly Seegers
Sent: Wednesday, August 4, 2021 10:38 AM
To: archivesspace_users_group at lyralists.lyrasis.org
Cc: Aida Garrido <Aida.Garrido at brooklynmuseum.org>; Aida Garrido <agarrkoch at gmail.com>
Subject: [Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID

Posting this question on behalf of the Archives' Summer Intern, Aida Garrido.


I'm testing the following feature with one archival object: https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/1173913646/Import+Archival+Objects+from+Excel+or+CSV+File+from+v2.8.1?focusedCommentId=2870837249#comment-2870837249

I want to add an item to a series, i.e. an archival object child to another archival object. I get the following error:
Row 6: ERROR Row 6 will not be processed due to errors: Input resource's URI [] does not match row's URI [5244]
[cid:image004.png at 01D789FA.28E69B70]
I am ingesting at the level of a series, whose internal resource record number from URL is 5244.
[cid:image005.png at 01D789FA.28E69B70]

That is the exact number I wrote for the resource URI column. For hierarchical relationship I wrote down 2 and for description level I wrote item.
>From the error I get, it looks as though the import is not picking up where I'm ingesting from - the brackets are being left blank.
What might I be doing wrong?
I have also attached the excel sheet I'm importing.
Thank you.

Molly Seegers
Museum Archivist
Brooklyn Museum
200 Eastern Parkway, Brooklyn, NY 11238-6052
P 718-501-6119
Pronouns: she/her

Exhibitions<https://www.brooklynmuseum.org/exhibitions> | Membership<https://www.brooklynmuseum.org/support/join/membership> | Shop<https://shop.brooklynmuseum.org/> | Follow @brooklynmuseum

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210805/dd25a0d7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 4073 bytes
Desc: image003.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210805/dd25a0d7/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 39189 bytes
Desc: image004.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210805/dd25a0d7/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 48251 bytes
Desc: image005.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210805/dd25a0d7/attachment-0002.png>

More information about the Archivesspace_Users_Group mailing list