<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">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 class="msg-1759492189301215628">
<div lang="EN-US">
<div class="m_-1759492189301215628WordSection1">
<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_-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_-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" 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>