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

[Sarah J. Cassone]

I’m currently in the Aspace member forum webinar in which Valerie is presenting tips, and I believe I have your answer: you need to put the URI string, not just the URI ID, in that column. Quick screenshot I just took:

[cid:image001.jpg at 01D78917.7B7EF550]

Hope this helps,


Sarah Cassone
Metadata Librarian for Data Control
Hoover Institution Library & Archives
Stanford University
scassone at stanford.edu<mailto:scassone at stanford.edu>
(650) 725-3442



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 9:15 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Cc: Aida Garrido <Aida.Garrido at brooklynmuseum.org>
Subject: Re: [Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID

Thank you for the suggestion Kevin! We’re still getting the same error:

[image.png]

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

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

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Kevin W. Schlottmann
Sent: Wednesday, August 4, 2021 11:31 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID

Just a guess, but I think you want the resource URI (14), not the archival object URI.

On Wed, Aug 4, 2021 at 10:39 AM Molly Seegers <Molly.Seegers at brooklynmuseum.org<mailto:Molly.Seegers at brooklynmuseum.org>> wrote:
Posting this question on behalf of the Archives’ Summer Intern, Aida Garrido.

Hello,

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]
[image.png]
I am ingesting at the level of a series, whose internal resource record number from URL is 5244.
[image.png]

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

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

_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group


--
Kevin Schlottmann
Head of Archives Processing
Rare Book & Manuscript Library
Butler Library, Room 801
Columbia University
Pronouns: he/him/his
535 W. 114th St., New York, NY  10027
(212) 854-8483
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/11402ff6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 43093 bytes
Desc: image006.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/11402ff6/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 39189 bytes
Desc: image007.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/11402ff6/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 48251 bytes
Desc: image008.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/11402ff6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 29628 bytes
Desc: image001.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/11402ff6/attachment.jpg>