<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: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;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Garamond;
        panose-1:2 2 4 4 3 3 1 1 8 3;}
/* 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.EmailStyle22
        {mso-style-type:personal-compose;
        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">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Did you resolve this issue? I am having the same issue.<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><img width="829" height="73" style="width:8.6354in;height:.7604in" id="Picture_x0020_8" src="cid:image007.png@01D931AE.24BF07F0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="1064" height="63" style="width:11.0833in;height:.6562in" id="Picture_x0020_6" src="cid:image001.png@01D931AD.BDF3E040"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I tried putting the AO URI in the ref-id column, nothing in the Ref ID column. It throws an error.<o:p></o:p></p>
<p class="MsoNormal"><img width="834" height="76" style="width:8.6875in;height:.7916in" id="Picture_x0020_7" src="cid:image008.png@01D931AE.24BF07F0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img width="750" height="62" style="width:7.8125in;height:.6458in" id="Picture_x0020_5" src="cid:image002.png@01D931AD.BDF3E040"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I visited the same page in the Help manual and added a comment requesting clarification (see highlighted text).<o:p></o:p></p>
<p class="MsoNormal"><img width="792" height="73" style="width:8.25in;height:.7604in" id="Picture_x0020_9" src="cid:image009.png@01D931AE.A9E57CC0"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal">Cheers<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><img width="49" height="61" style="width:.5104in;height:.6354in" id="Graphic_x0020_3" src="cid:image003.png@01D931AD.476D29E0"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></b></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">Sarit Hand</span></b><b><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">Digital Archivist</span><span style="font-size:10.0pt;font-family:"Garamond",serif"><br>
</span><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">AP Corporate Archives</span><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">200 Liberty Street<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">New York, NY 10281<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif">T
</span><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">212.621.7035<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="mailto:shand@ap.org"><span style="color:blue">shand@ap.org</span></a><br>
</span><span style="font-size:12.0pt"><a href="http://www.ap.org"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">ap.org</span></a></span><span lang="FR" style="font-family:"Verdana",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif"><img border="0" width="266" height="69" style="width:2.7708in;height:.7187in" id="Graphic_x0020_4" src="cid:image004.png@01D931AD.476D29E0"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<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><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:red">[EXTERNAL]<o:p></o:p></span></p>
<div>
<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://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">
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:image005.png@01D931AD.476D29E0"></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:image006.png@01D931AD.476D29E0"></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://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"><span style="color:blue">brooklynmuseum.org</span></a><br>
<a href="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"><span style="color:blue">Exhibitions</span></a>
 | <a href="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">
<span style="color:blue">Membership</span></a> | <a href="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">
<span style="color:blue">Shop</span></a> | Follow @brooklynmuseum<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
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.
</body>
</html>