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

Thu Jan 26 17:59:34 EST 2023

Hello,

Did you resolve this issue? I am having the same issue.
The resource already has archival objects, series and sub-series. I am now adding file level records to the different sub-series. Since there are not that many series, I might delete them all and do this one batch, but it would be nice if it was clear how to add child AOs to pre-existing AOs.
My first attempt, I put the resource URI in the column and under AP ref ID I added the # correlating to the AO I wanted the records to be added to as a child record. I put "2" in the level; I got this error.
[cid:image007.png at 01D931AE.24BF07F0]

[cid:image001.png at 01D931AD.BDF3E040]

I tried putting the AO URI in the ref-id column, nothing in the Ref ID column. It throws an error.
[cid:image008.png at 01D931AE.24BF07F0]

[cid:image002.png at 01D931AD.BDF3E040]

I visited the same page in the Help manual and added a comment requesting clarification (see highlighted text).
[cid:image009.png at 01D931AE.A9E57CC0]

Thanks
Cheers

[cid:image003.png at 01D931AD.476D29E0]

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

shand at ap.org<mailto:shand at ap.org>
ap.org<http://www.ap.org>
[cid:image004.png at 01D931AD.476D29E0]

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

[EXTERNAL]
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<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F1173913646%2FImport%2BArchival%2BObjects%2Bfrom%2BExcel%2Bor%2BCSV%2BFile%2Bfrom%2Bv2.8.1%3FfocusedCommentId%3D2870837249%23comment-2870837249&data=04%7C01%7Cshand%40ap.org%7C3f9864d685a74526723208d957557cd5%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637636847956864735%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=K73Rr9HInv5Rxg5%2B6BTLJK3jS0dq3BS3c1VOfHhmBj0%3D&reserved=0>

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:image005.png at 01D931AD.476D29E0]
I am ingesting at the level of a series, whose internal resource record number from URL is 5244.
[cid:image006.png at 01D931AD.476D29E0]

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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2F&data=04%7C01%7Cshand%40ap.org%7C3f9864d685a74526723208d957557cd5%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637636847956874730%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=cyJj6uA3P%2BtUNmswok8GY4CG3hUYmNeKY8ZGBp0LUOw%3D&reserved=0>
Exhibitions<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fexhibitions&data=04%7C01%7Cshand%40ap.org%7C3f9864d685a74526723208d957557cd5%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637636847956874730%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=enT8IbVeFdbSpk64nLcdVy2vZbNtu70qk95rTC2%2F%2BJI%3D&reserved=0> | Membership<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fsupport%2Fjoin%2Fmembership&data=04%7C01%7Cshand%40ap.org%7C3f9864d685a74526723208d957557cd5%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637636847956884723%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=C2l9sp1u2hVpCFtR%2FyJydayrhgZAJHmC%2FvKE2nJQLeI%3D&reserved=0> | Shop<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fshop.brooklynmuseum.org%2F&data=04%7C01%7Cshand%40ap.org%7C3f9864d685a74526723208d957557cd5%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637636847956894718%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2%2BAa%2BFnmEz8uo24oYjpjSjgSXHuq2qG7%2BnTo2z%2FHJJ0%3D&reserved=0> | Follow @brooklynmuseum

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 1094 bytes
Desc: image003.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 5548 bytes
Desc: image004.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 39189 bytes
Desc: image005.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 48251 bytes
Desc: image006.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 7635 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 6701 bytes
Desc: image002.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 4453 bytes
Desc: image007.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 4688 bytes
Desc: image008.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.png
Type: image/png
Size: 16539 bytes
Desc: image009.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230126/e254617b/attachment-0008.png>