<div dir="ltr"><div><div><div>Dear Noah,<br><br></div>Thank you so much for this! What I'm wondering, do you need to keep the rows 1-3 and 5 for AS to recognize the metadata or is it only row 4 that is being recognized? does it matter if you do or don't keep those rows in? <br><br></div>Also if you're trying to connect digital objects from a server or a DAMS to this metadata, is there a separate workflow that you use to connect them? I saw a different DO archivesspace template and do you need to do that separately or can you add it to this csv file? <br><br>My institution uses Omeka and typically I have to upload the digital files to the Omeka server and then upload the CSV file to have it recognize and connect the digital file pathways to the DO. Since we're hosting AS on our own servers I was wondering if there's something I should be doing with AS to connect them with the files in Omeka or if I wanted to upload them directly from our server?<br><br></div><div>Just curious if that's something you've done.</div><div><br></div><div>Thank you so much for your help,<br></div><div>Suzanna <br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 29, 2021 at 5:00 PM Noah Huffman <<a href="mailto:noah.huffman@duke.edu" target="_blank">noah.huffman@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 lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Hi Suzanna,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">I’ve attached a sample import spreadsheet. This sheet may not use the most up-to-date template, but it should give you an idea of how the data should be formatted
and it should still import successfully. Obviously, you’ll note that this is fake data, but hopefully illustrative.</span><span style="font-size:11pt;font-family:Wingdings;color:rgb(31,73,125)">J</span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">For the publish column, use TRUE if you want to the imported record to be visible in the ArchivesSpace public interface, FALSE if not. I think if you leave that
column blank it will default to TRUE, which will effectively check all the “publish” checkboxes for the imported archival objects.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">For the EADID column, the value in your spreadsheet must match the value in the EAD ID field of your resource record in ArchivesSpace.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Here’s a link to video tutorial on using the Spreadsheet importer (formerly known as the Harvard Import Tool):
<a href="https://youtu.be/xl-KjVCmm9g" target="_blank">https://youtu.be/xl-KjVCmm9g</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Hope this helps,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">-Noah<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(64,64,64)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">================<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">Noah Huffman<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">Archivist for Metadata, Systems, and Digital Records<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">David M. Rubenstein Rare Book & Manuscript Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">Duke University | 919-660-5982<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)"><a href="http://library.duke.edu/rubenstein/" target="_blank"><span style="color:rgb(31,73,125)">http://library.duke.edu/rubenstein/</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">Pronouns:</span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">
</span><span style="font-size:10pt;font-family:"Georgia",serif;color:rgb(31,73,125)">he / him / his<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif"> <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>Calev, Suzanna<br>
<b>Sent:</b> Friday, January 29, 2021 4:41 PM<br>
<b>To:</b> <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] Example of a CSV excel spreadsheet?<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt">Hi everyone, <u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12pt">I apologize if this is extremely obvious, but I'm still trying to figure out how to do things in AS. I'm trying to create a csv file from the templates provided in the AS documentation and I'm confused as to
what to put in certain sections. For example, the publish column, do we say yes or no? or put something else to indicate whether we want it to be published? For the hierarchy one, we are just putting numbers 1, 2, or 3 to indicate if the item is a resource,
child, or grandchild of the parent item? <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">For the EAD ID, should you be entering a unique number into the resource so that it identifies what resource you're using? or is that for the component unique identifier column?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt">I think what would really help me is to see an example of what other people have done for a particular collection, even if it's just a few rows, if anyone is willing to share with me what they've entered into
the different columns for your csv files, I think it would help me figure out how to configure my own for the photo collection metadata I'm trying to upload.
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thank you,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Suzanna <u></u><u></u></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Suzanna Calev, MLIS & MA<u></u><u></u></p>
<div>
<p class="MsoNormal">Archivist/Public Services Librarian<br>
Farley Library<br>
187 South Franklin Street<br>
Wilkes-Barre, PA 18766<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Office: 570-408-2012<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Archives: 570-408-4264<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Cell: 917-656-3515 <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:suzanna.calev@wilkes.edu" target="_blank">suzanna.calev@wilkes.edu</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><br>
<br>
<u></u><u></u></p>
</div>
</div>
</div>
</div>
</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>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Suzanna Calev, MLIS & MA<div>Archivist/Public Services Librarian<br>Farley Library<br>187 South Franklin Street<br>Wilkes-Barre, PA 18766</div><div>Office: 570-408-2012<br></div><div>Archives: 570-408-4264</div><div>Cell: 917-656-3515 <br></div><div><a href="mailto:suzanna.calev@wilkes.edu" target="_blank">suzanna.calev@wilkes.edu</a></div><div><br></div><div><b><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(0,32,96)"></span></b><br><br><br></div></div></div></div></div></div></div></div></div>