<div dir="ltr">Well, we definitely have successfully used the EAD ID field value to link via column C in the spreadsheet importer for a long time. We have a specific use case where we want to add lines of inventory to a resource before we assign the EAD ID. Our EAD ID and the value of what is in Identifier are not the same. I'm having trouble figuring out in what form the plugin wants info in column B. :(</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 26, 2022 at 10:24 AM Lisa Calahan <<a href="mailto:lcalahan@umn.edu">lcalahan@umn.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I wonder if the identifier needs to match the data in the EAD ID field within the Finding Aid Data subrecord? I had an issue with that before and it solved my problem, but I'm not using the Harvard spreadsheet. <div><br></div><div>Might be worth a try, though?</div><div>Lisa </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 26, 2022 at 8:58 AM Olivia S Solis <<a href="mailto:livsolis@utexas.edu" target="_blank">livsolis@utexas.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Our identifier is all in the first box. We have an autoincrement system that works just there. Would the dashes cause problems?<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 26, 2022 at 8:54 AM Leah Tams <<a href="mailto:leah.tams@duke.edu" target="_blank">leah.tams@duke.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Hi Olivia,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif">I wonder if the identifier should actually appear with periods, rather than hyphens, between the elements? That is how we input them in our import spreadsheet at Duke. They
appear as RL-12345 in ASpace, but in the spreadsheet we have to put RL.12345. I don’t have access to our database, though, so I’m not sure what they look like on that end.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Leah<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><i><span style="font-size:10pt;font-family:Cambria,serif">she/her/hers</span></i><span style="font-size:10pt;font-family:Cambria,serif"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Cambria,serif">MSLS in Archives & Records Management<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Cambria,serif">Accessions Coordinator<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Cambria,serif">Rubenstein Rare Book & Manuscript Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Cambria,serif">Duke University<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Cambria,serif"><a href="mailto:leah.tams@duke.edu" target="_blank">leah.tams@duke.edu</a> |
<a href="http://www.leahtams.org/" target="_blank">leahtams.org</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Olivia S Solis<br>
<b>Sent:</b> Wednesday, October 26, 2022 9:43 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] collection_id/Resource Identifier in import spreadsheet<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hello all, <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">We have been using the spreadsheet importer for bulk adding archival objects for years, using the EAD ID column to link to the correct resource. We had a situation pop up where we may not have that number assigned yet, but we want to upload
part of the inventory. I tried using column B (collection_id/Resource identifier) to link to the right resource.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I don't know what I am doing wrong, but I can't get the AOs to get created with column B. The documentation in the original Harvard spreadsheet (which we still use a version of because of a lot of customization added) defined the field
like so: "The Resource "Identifier", aka collection-level unit_id, OR, could be internal resource record number from URL."<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I keep getting the following error: <span style="font-size:10pt;font-family:"Courier New";color:rgb(51,238,51);background:rgb(51,51,51)">Row 6: ERROR Row 6 will not be processed due to errors: This row is missing BOTH an EAD ID and URI</span><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">I tried the Identifier field:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><img border="0" width="227" height="34" style="width: 2.3645in; height: 0.3541in;" id="m_2370130412571869503m_2215480588421748975m_-1759492189301215628_x0000_i1025" src="cid:184149551444cff311" alt="Screen Shot 2022-10-26 at 8.34.36 AM.png"><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I tried it as it appears in the database: "camh-arc-004438", null,null,null<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I tried the path given in the URI:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><img border="0" width="247" height="49" style="width: 2.5729in; height: 0.5104in;" id="m_2370130412571869503m_2215480588421748975m_-1759492189301215628_x0000_i1026" src="cid:184149551445b16b22" alt="Screen Shot 2022-10-26 at 8.34.50 AM.png"><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">And I tried just the numeric ID, in the case above 4398.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">What am I doing wrong here? I can't think of many other identifiers that are unique to the record.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Olivia<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Olivia Solis, MSIS (she/her)</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Metadata Coordinator</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Dolph Briscoe Center for American History</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">The University of Texas at Austin</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">2300 Red River St. Stop D1100<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Austin TX, 78712-1426</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">(512) 232-8013</span><span style="font-size:9.5pt;color:rgb(136,136,136)"><u></u><u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
>> This message is from an external sender. Learn more about why this <<<br>
>> matters at <a href="https://links.utexas.edu/rtyclf" rel="noreferrer" target="_blank">https://links.utexas.edu/rtyclf</a>. <<<br>
</div></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.8px"><font color="#000000">Olivia Solis, MSIS (she/her)</font></div><div style="font-size:12.8px"><font color="#000000">Metadata Coordinator</font></div><div style="font-size:12.8px"><font color="#000000">Dolph Briscoe Center for American History</font></div><div style="font-size:12.8px"><font color="#000000">The University of Texas at Austin</font></div><div style="font-size:12.8px"><font color="#000000">2300 Red River St. Stop D1100</font></div><div style="font-size:12.8px"><font color="#000000">Austin TX, 78712-1426</font></div><div style="color:rgb(136,136,136);font-size:12.8px"><span style="color:rgb(0,0,0);font-size:12.8px">(512) 232-8013</span></div></div></div></div></div></div></div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Pronouns: she/they</div><div dir="ltr">Head of Archival Processing<br>University of Minnesota Libraries<br><a href="https://www.lib.umn.edu/special" target="_blank">Archives and Special Collections</a><br>Elmer L. Andersen Library<br></div><div dir="ltr"><br></div><div dir="ltr"><i style="background-color:rgb(255,255,255)"><font color="#000000">I <a href="https://editions.lib.umn.edu/openrivers/article/where-we-stand/" target="_blank">acknowledge that the University of Minnesota is located </a>on the traditional, ancestral and contemporary <a href="https://mcae.umn.edu/sites/mcae.dl.umn.edu/files/styles/panopoly_image_original/public/media/dakhota_thomakhoche.jpg?itok=SoL5V45r" target="_blank">lands of Indigenous people</a> and was built with <a href="https://www.jbhe.com/2019/11/the-university-of-minnesotas-historical-ties-to-slavery/" target="_blank">money from slaveholders</a>. </font></i><br></div></div></div></div></div></div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
>> This message is from an external sender. Learn more about why this <<<br>
>> matters at <a href="https://links.utexas.edu/rtyclf" rel="noreferrer" target="_blank">https://links.utexas.edu/rtyclf</a>. <<<br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.8px"><font color="#000000">Olivia Solis, MSIS (she/her)</font></div><div style="font-size:12.8px"><font color="#000000">Metadata Coordinator</font></div><div style="font-size:12.8px"><font color="#000000">Dolph Briscoe Center for American History</font></div><div style="font-size:12.8px"><font color="#000000">The University of Texas at Austin</font></div><div style="font-size:12.8px"><font color="#000000">2300 Red River St. Stop D1100</font></div><div style="font-size:12.8px"><font color="#000000">Austin TX, 78712-1426</font></div><div style="color:rgb(136,136,136);font-size:12.8px"><span style="color:rgb(0,0,0);font-size:12.8px">(512) 232-8013</span></div></div></div></div></div></div></div>