[Archivesspace_Users_Group] Export of archival objects / contents lists?

[McPhee, Laurel]

Hi Jane,

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:

Attached is a simple xls stylesheet that can be used in conjunction with a xml parser (I use the Saxon parser http://saxon.sourceforge.net/) 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).

Hope this helps and also might be of interest to others,
Laurel

Laurel McPhee
Supervisory Archivist, Special Collections & Archives Program
UC San Diego Library | * 858-534-5619 | * lmcphee at ucsd.edu<mailto:lmcphee at ucsd.edu>



From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Jane LaBarbara
Sent: Wednesday, March 28, 2018 11:59 AM
To: 'archivesspace_users_group at lyralists.lyrasis.org' <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Export of archival objects / contents lists?

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?

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.

Thanks for your advice,
Jane

/ Jane Metters LaBarbara
Assistant Curator, West Virginia & Regional History Center<https://wvrhc.lib.wvu.edu/>
West Virginia University Libraries
(304) 293-0352 office
jane.labarbara at mail.wvu.edu<mailto:jane.labarbara at mail.wvu.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180328/51f0027c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ead_to_csv.xsl
Type: text/xml
Size: 8251 bytes
Desc: ead_to_csv.xsl
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20180328/51f0027c/attachment.xml>