[Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet

Fox, Bobbi bobbi_fox at harvard.edu
Fri Jul 14 16:00:16 EDT 2017

Hi, VivianLea,

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!)


From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of VivianLea.Solek at Kofc.Org
Sent: Friday, July 14, 2017 3:57 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet

Hi Bobbi,

...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.

Looking forward to your response, which might make my whole month!

All the best,

VivianLea Solek
Knights of Columbus Supreme Council Archives

Knights of Columbus Museum
1 State Street
New Haven, CT 06511-6702
Phone 203 752-4578
Fax 203 865-0351

[Inactive hide details for "Fox, Bobbi" ---07/14/2017 03:44:00 PM---Library Technology Services, which supports the Harvard Libr]"Fox, Bobbi" ---07/14/2017 03:44:00 PM---Library Technology Services, which supports the Harvard Library, is pleased to announce the availabi

From: "Fox, Bobbi" <bobbi_fox at harvard.edu<mailto:bobbi_fox at harvard.edu>>
To: "archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>" <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>,
Date: 07/14/2017 03:44 PM
Subject: [Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet
Sent by: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>


Library Technology Services, which supports the Harvard Library, is pleased to announce the availability of a new plugin, aspace-import-excel, available on GitHub at https://github.com/harvard-library/aspace-import-excel<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=> .

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.

Please note carefully the following paragraph in the README:

                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.

Installation information is on the main README file, with User Documentation at https://github.com/harvard-library/aspace-import-excel/blob/master/user_documentation/USER_DOCUMENTATION.md<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=> , including workflow, step by step usage, and extensive (exhaustive? :-) explanation of the Spreadsheet Template.

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.

Pull requests welcome.  If you encounter problems, please create an issue on the GitHub repository.

Bobbi Fox, Maintainer

Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170714/bfcef26e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 105 bytes
Desc: image001.gif
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170714/bfcef26e/attachment.gif>

More information about the Archivesspace_Users_Group mailing list