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

Molly Seegers Molly.Seegers at brooklynmuseum.org
Thu Aug 5 15:50:52 EDT 2021

Thank you Sara, Sarah, and Valerie for your assistance! How fortuitous that this was covered in the session yesterday.

We had searched the help center and user guide, but couldn't find that the entire string is the URI, not just the number, spelled out. Did I miss it or is there some way to add this information to the documentation or help center?

Thank you again!
From: archivesspace_users_group-bounces at lyralists.lyrasis.org [archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of Valerie Addonizio [vaddonizio at atlas-sys.com]
Sent: Thursday, August 05, 2021 1:02 PM
To: Archivesspace Users Group
Cc: Aida Garrido; Aida Garrido
Subject: Re: [Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID

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 --------------
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/ce795cb9/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/ce795cb9/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/ce795cb9/attachment-0002.png>

More information about the Archivesspace_Users_Group mailing list