<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Molly and Aida!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">URIs look like this:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">/repositories/3/resources/34<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="1209" height="89" style="width:12.5885in;height:.927in" id="Picture_x0020_4" src="cid:image003.png@01D789FA.28E69B70"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Molly Seegers<br>
<b>Sent:</b> Wednesday, August 4, 2021 10:38 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Cc:</b> Aida Garrido <Aida.Garrido@brooklynmuseum.org>; Aida Garrido <agarrkoch@gmail.com><br>
<b>Subject:</b> [Archivesspace_Users_Group] Archival object batch import, excel sheet, URI ID<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Posting this question on behalf of the Archives’ Summer Intern, Aida Garrido.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">I'm testing the following feature with one archival object:
<a href="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://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/1173913646/Import+Archival+Objects+from+Excel+or+CSV+File+from+v2.8.1?focusedCommentId=2870837249#comment-2870837249</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">I want to add an item to a series, i.e. an archival object child to another archival object. I get the following error:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Row 6: ERROR Row 6 will not be processed due to errors: Input resource's URI [] does not match row's URI [5244]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><img border="0" width="452" height="122" style="width:4.7083in;height:1.2708in" id="Picture_x0020_1" src="cid:image004.png@01D789FA.28E69B70"></span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">I am ingesting at the level of a series, whose internal resource record number from URL is 5244.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><img border="0" width="453" height="204" style="width:4.7187in;height:2.125in" id="Picture_x0020_2" src="cid:image005.png@01D789FA.28E69B70"></span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">What might I be doing wrong?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">I have also attached the excel sheet I'm importing.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Thank you. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-family:"Arial",sans-serif">Molly Seegers</span></b><span style="font-family:"Arial",sans-serif"><br>
Museum Archivist<br>
Brooklyn Museum<br>
200 Eastern Parkway, Brooklyn, NY 11238-6052<br>
P 718-501-6119<br>
Pronouns: she/her<br>
<br>
<a href="https://www.brooklynmuseum.org/"><span style="color:blue">brooklynmuseum.org</span></a><br>
<a href="https://www.brooklynmuseum.org/exhibitions"><span style="color:blue">Exhibitions</span></a> |
<a href="https://www.brooklynmuseum.org/support/join/membership"><span style="color:blue">Membership</span></a> |
<a href="https://shop.brooklynmuseum.org/"><span style="color:blue">Shop</span></a> | Follow @brooklynmuseum<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>