[Archivesspace_Users_Group] [External Email]Re: Archival object batch import, excel sheet, URI ID

Wed Aug 4 13:37:04 EDT 2021

Hi,

Kevin is right that you need the resource URI in that field. When I do it, I use the longer form that is located here - I don't know if using just the resource number will work.

[Graphical user interface, text, application, email  Description automatically generated]

The other issue is that you need to include the hierarchy level 1 object if you are going to import a level 2 object, otherwise your import will not work. So you would need to include the series information. However, I believe that would duplicate the existing series rather than adding to it. I don't think there is a way to add archival objects to an existing series using the spreadsheet import (someone please correct me if I am wrong!!)

[https://www.aphis.usda.gov/js/USDA-Logo.jpg]
Sara Szakaly, MLS
Archivist & Records Manager
APHIS Wildlife Services (WS)
WS National Wildlife Research Center
4101 Laporte Ave
Fort Collins, CO 80521
P: 970-266-6021
Sara.J.Szakaly at usda.gov<mailto:Sara.J.Szakaly at usda.gov>

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

[External Email]
If this message comes from an unexpected sender or references a vague/unexpected topic;
Use caution before clicking links or opening attachments.
Please send any concerns or suspicious messages to: Spam.Abuse at usda.gov<mailto:Spam.Abuse at usda.gov>
Thank you for the suggestion Kevin! We're still getting the same error:

[cid:image005.png at 01D78920.78E01870]

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

brooklynmuseum.org<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2F&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038015622%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LdnnVqerJ4oh10bQbpmEUWQRfv%2Bygfb0EZWHMWokwio%3D&reserved=0>
Exhibitions<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fexhibitions&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038025571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=R38HZZ72WSNzvNRVc%2FrqC8da9RyDvZSnvd%2BB8oc64Ko%3D&reserved=0> | Membership<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fsupport%2Fjoin%2Fmembership&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038025571%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=A43ncplU4S1GYyjQJKe2l%2BM%2BlVlf1mk3ET6bmNgScgc%3D&reserved=0> | Shop<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fshop.brooklynmuseum.org%2F&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038035527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=wY%2BYOEnnd4GcxdCw6YsxXs3%2FURYJhLHxtrV%2By6%2BP1b8%3D&reserved=0> | 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<https://gcc02.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%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038035527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=3MKL4Wwz89gcxpaQc2UyDgfAii2ZbqPqkKQTBIMkIx8%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]
[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://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2F&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038045483%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=RKm55dczsHpQHZgep%2Fed%2BWQ%2B6z8pWBr732mCg4UoF6o%3D&reserved=0>
Exhibitions<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fexhibitions&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038045483%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=MSrJOjZBShie%2FTQZpqITjeN8cUzy%2BKvk7XOD%2F%2F1JuiQ%3D&reserved=0> | Membership<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.brooklynmuseum.org%2Fsupport%2Fjoin%2Fmembership&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038055439%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=zHYRwTuJMQ0I%2BVXzhz5LXXcQ2W6U54Ga%2BA8mHmmyKMM%3D&reserved=0> | Shop<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fshop.brooklynmuseum.org%2F&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038065394%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nFz6BK5R4%2FQUEj7yNB8IpQJszM%2BsvMR9Hounako%2FWSE%3D&reserved=0> | 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<https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=04%7C01%7C%7C98948e56333e4c1b775108d957630306%7Ced5b36e701ee4ebc867ee03cfa0d4697%7C0%7C0%7C637636905038065394%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=%2FUZ3KchP3KYC%2B9z2UvfK5RTimZihxYbgeNNBF1mMmDg%3D&reserved=0>

--
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

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 3453 bytes
Desc: image004.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 43093 bytes
Desc: image005.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 39189 bytes
Desc: image006.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 48251 bytes
Desc: image007.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 85101 bytes
Desc: image002.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/d39f4581/attachment-0007.png>