<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)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{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;}
--></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">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Jane,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Yes, we do that all the time (we call it a “harvesting the EAD”), especially when a collection’s container list is getting a major do-over or addition. With a bit of tech know-how, you can apply these instructions
below from our tech specialist and the attached stylesheet. First, you export the EAD, but we do this all in one command line through the API:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal">Attached is a simple xls stylesheet that can be used in conjunction with a xml parser (I use the Saxon parser
<a href="http://saxon.sourceforge.net/">http://saxon.sourceforge.net/</a>) to transform the container list of an EAD file to CSV. It crawls through the container list and creates a row entry for each <c> tag. It tracks the level and hierarchy via the LEVEL
(the depth the c is nested) and just the position beneath other containers. It should be generic enough to work on any EAD (I think, it does use some specific checks like our Digital_File designator). You do need Java to run the XML parser and I do it from
the command line but things like oXygen will let you run it from inside it (at least you used to be able to).<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Hope this helps and also might be of interest to others,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Laurel<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#1F497D">Laurel McPhee<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F497D">Supervisory Archivist, Special Collections & Archives Program<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">UC San Diego Library | </span><span style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">(</span><span style="font-size:10.0pt;color:#1F497D">
</span><span style="color:#1F497D">858-534-5619 |</span><span style="font-size:10.0pt;color:#1F497D">
</span><span style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">*</span><span style="font-size:10.0pt;color:#1F497D">
</span><span style="color:#2E74B5"><a href="mailto:lmcphee@ucsd.edu">lmcphee@ucsd.edu</a></span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="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>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Jane LaBarbara<br>
<b>Sent:</b> Wednesday, March 28, 2018 11:59 AM<br>
<b>To:</b> 'archivesspace_users_group@lyralists.lyrasis.org' <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Export of archival objects / contents lists?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anyone have a recommended way of exporting archival object information from a specific resource record in a way that results in a contents list spreadsheet?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We have a lot of legacy contents list spreadsheets here, and we’re working on converting and uploading them into ASpace. We don’t want to have to enter data into both the spreadsheet and the ASpace record for every addendum, but we’re
reluctant to get rid of the spreadsheets if we can’t get that information back out again in spreadsheet form should we ever need it for a future project.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for your advice,<o:p></o:p></p>
<p class="MsoNormal">Jane<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#EAAA00;border:none windowtext 1.0pt;padding:0in;background:white">/</span></b><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#002855;background:white"> Jane
Metters LaBarbara <br>
</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#002855;background:white">Assistant Curator,
<a href="https://wvrhc.lib.wvu.edu/">West Virginia & Regional History Center</a><br>
West Virginia University Libraries<br>
(304) 293-0352 office<br>
<a href="mailto:jane.labarbara@mail.wvu.edu">jane.labarbara@mail.wvu.edu</a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>