<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:382145066;
mso-list-template-ids:369896976;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi, VivianLea,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Take a look at the template, and see if it meets your needs; you do, however, have to create the Resource, however minimally, in ArchivesSpace somehow (could
be interactively, of course!)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Bobbi<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>VivianLea.Solek@Kofc.Org<br>
<b>Sent:</b> Friday, July 14, 2017 3:57 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="font-size:10.0pt;font-family:"Arial",sans-serif">Hi Bobbi,</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">...so this would get our raw data from Excel into ASpace without going through an EAD transformation? I'm migrating from an ANCIENT DOS system which I've been able to get out to excel. Once I have
that cleaned up, if I and my IT partner can skip the transformation step, that would be beyond fabulous! There are only 15 fields to come over, so it would be very easy to map them to your template.</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">Looking forward to your response, which might make my whole month!</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">All the best,</span><br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">VivianLea</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">VivianLea Solek</span><br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">Archivist</span><br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">Knights of Columbus Supreme Council Archives</span><br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
Knights of Columbus Museum<br>
1 State Street<br>
New Haven, CT 06511-6702</span><br>
<span style="font-size:10.0pt;font-family:"Arial",sans-serif">Phone 203 752-4578<br>
Fax 203 865-0351</span><br>
<br>
<img width="16" height="16" id="_x0000_i1025" src="cid:image001.gif@01D2FCBA.47A3F610" alt="Inactive hide details for "Fox, Bobbi" ---07/14/2017 03:44:00 PM---Library Technology Services, which supports the Harvard Libr"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#424282">"Fox,
Bobbi" ---07/14/2017 03:44:00 PM---Library Technology Services, which supports the Harvard Library, is pleased to announce the availabi</span><br>
<br>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">From: </span>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif">"Fox, Bobbi" <<a href="mailto:bobbi_fox@harvard.edu">bobbi_fox@harvard.edu</a>></span><br>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">To: </span>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif">"<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>" <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>>,
</span><br>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">Date: </span>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif">07/14/2017 03:44 PM</span><br>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">Subject:
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif">[Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet</span><br>
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5F5F5F">Sent by:
</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif"><a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a></span><o:p></o:p></p>
<div class="MsoNormal">
<hr size="2" width="100%" noshade="" style="color:#8091A5" align="left">
</div>
<p class="MsoNormal"><br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Library Technology Services, which supports the Harvard Library, is pleased to announce the availability of a new plugin,
<b>aspace-import-excel</b>, available on GitHub at </span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_harvard-2Dlibrary_aspace-2Dimport-2Dexcel&d=CwMFAg&c=C90XguLnqhMT2ADRaOs3gQ&r=balEICFvGrVJ8Sr6vcdFtVtZaJWT42A5myJ4zXSQILc&m=GXMnvtV2cyS8rDYQOUdBae-J3_5pKCeySUAi9E3PwPI&s=fCSeo6kcKxmI1Bf3tiPlXtQOAYoXx6EI3FqCbRRJ7zA&e="><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#0563C1">https://github.com/harvard-library/aspace-import-excel</span></a><span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> .</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Using the provided spreadsheet template, users can go to a Resource, and either add or insert the set of Archival Objects that have been defined in the spreadsheet.</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Please note carefully the following paragraph in the README:</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> The intention is not to completely reproduce a Finding Aid as presented in an EAD XML, or to allow for every permutation of Archival
Object creation within ArchivesSpace. We are aiming for the "80% rule"; that is, at least 80% of the work that would be done interactively can be replaced by an excel spreadsheet; additional refinements to individual archival objects (such as addition of agents-as-subjects,
assignment of locations to top-level containers, etc.) would take place interactively.</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Installation information is on the main README file, with User Documentation at
</span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_harvard-2Dlibrary_aspace-2Dimport-2Dexcel_blob_master_user-5Fdocumentation_USER-5FDOCUMENTATION.md&d=CwMFAg&c=C90XguLnqhMT2ADRaOs3gQ&r=balEICFvGrVJ8Sr6vcdFtVtZaJWT42A5myJ4zXSQILc&m=GXMnvtV2cyS8rDYQOUdBae-J3_5pKCeySUAi9E3PwPI&s=J4VWVV6rAX9keFG8WHk40diJhihn7Csss69FNUy-cho&e="><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#0563C1">https://github.com/harvard-library/aspace-import-excel/blob/master/user_documentation/USER_DOCUMENTATION.md</span></a><span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> ,
including workflow, step by step usage, and extensive (exhaustive? :-) explanation of the Spreadsheet Template.</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">This plugin was designed to aid the Harvard Library archival community, but we hope that it may be useful to other archivists in the ArchivesSpace community.</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Pull requests welcome. If you encounter problems, please create an issue on the GitHub repository.</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Cheers,</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Bobbi Fox, Maintainer</span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><br>
<span style="font-size:10.0pt;font-family:"Calibri",sans-serif"> </span><tt><span style="font-size:10.0pt">_______________________________________________</span></tt><span style="font-size:10.0pt;font-family:"Courier New""><br>
<tt>Archivesspace_Users_Group mailing list</tt><br>
<tt><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a></tt><br>
<tt><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=CwICAg&c=C90XguLnqhMT2ADRaOs3gQ&r=balEICFvGrVJ8Sr6vcdFtVtZaJWT42A5myJ4zXSQILc&m=GXMnvtV2cyS8rDYQOUdBae-J3_5pKCeySUAi9E3PwPI&s=x7wbsF-0e7H4tdAqlZfuP-j27pCXO_i_JOAwg51LQMs&e=">https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=CwICAg&c=C90XguLnqhMT2ADRaOs3gQ&r=balEICFvGrVJ8Sr6vcdFtVtZaJWT42A5myJ4zXSQILc&m=GXMnvtV2cyS8rDYQOUdBae-J3_5pKCeySUAi9E3PwPI&s=x7wbsF-0e7H4tdAqlZfuP-j27pCXO_i_JOAwg51LQMs&e=</a> </tt></span><o:p></o:p></p>
<div>
<p class="MsoNormal">CONFIDENTIALITY NOTICE: This message and any attachments may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee or addressees named above for its intended purpose. If you
are not the intended recipient of this message, this message constitutes notice that any review, retransmission, distribution, copying or other use or taking any action in reliance on the information in this message and its attachments, is prohibited. If you
receive this communication in error, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Unless expressly stated in this e-mail, nothing in this message may be construed
as a digital or electronic signature. Thank you.<o:p></o:p></p>
</div>
</div>
</body>
</html>