[Archivesspace_Users_Group] bulk uploading of Archival Objects via Excel Spreadsheet- how large is too large?

Thu Sep 28 15:37:15 EDT 2017

I have had success uploading this template in 2.1.2 while testing with just a few rows of data.  I now need to upload *for real* a spreadsheet that contains 11,000 rows of data.  I tried to load it and got an error message that says "Processing Stopped at Row 0".  That seems like a pretty weird error given that Row 0 doesn't exist and that I am able to successfully load a test of several lines of this data, so I'm guessing it is trying to tell me the file is too large.  I have now put series 1, which is about 500 rows of data, in its own spreadsheet and am going to try to upload just that.
Does anyone have an idea from their own testing how many rows the system can handle processing in one spreadsheet?

[Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet
Fox, Bobbi bobbi_fox at harvard.edu <mailto:archivesspace_users_group%40lyralists.lyrasis.org?Subject=Re%3A%20%5BArchivesspace_Users_Group%5D%20A%20plugin%20to%20support%20bulk%20uploading%0A%20of%20Archival%20Objects%20via%20Excel%20Spreadsheet&In-Reply-To=%3CBN6PR07MB3492FE9C6EC8A4FDA3352D7490AD0%40BN6PR07MB3492.namprd07.prod.outlook.com%3E>
Fri Jul 14 16:00:16 EDT 2017

  *   Previous message: [Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/004925.html>
  *   Next message: [Archivesspace_Users_Group] Barcodes Disappearing from Database<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/004927.html>
  *   Messages sorted by: [ date ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/date.html#4926> [ thread ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/thread.html#4926> [ subject ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/subject.html#4926> [ author ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/author.html#4926>

________________________________

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

Cheers,

Bobbi

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group> [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>] On Behalf Of VivianLea.Solek at Kofc.Org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>

Sent: Friday, July 14, 2017 3:57 PM

To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>

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

VivianLea Solek

Archivist

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<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group><mailto:bobbi_fox at harvard.edu<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>>

To: "archivesspace_users_group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group><mailto:archivesspace_users_group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>" <archivesspace_users_group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group><mailto:archivesspace_users_group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>>,

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<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group><mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>

________________________________

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=<https://github.com/harvard-library/aspace-import-excel%3Chttps:/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=<https://github.com/harvard-library/aspace-import-excel/blob/master/user_documentation/USER_DOCUMENTATION.md%3Chttps:/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.

Cheers,

Bobbi Fox, Maintainer

 _______________________________________________

Archivesspace_Users_Group mailing list

Archivesspace_Users_Group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group><mailto:Archivesspace_Users_Group at lyralists.lyrasis.org<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>>

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=

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>

________________________________

  *   Previous message: [Archivesspace_Users_Group] A plugin to support bulk uploading of Archival Objects via Excel Spreadsheet<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/004925.html>
  *   Next message: [Archivesspace_Users_Group] Barcodes Disappearing from Database<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/004927.html>
  *   Messages sorted by: [ date ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/date.html#4926> [ thread ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/thread.html#4926> [ subject ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/subject.html#4926> [ author ]<http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2017-July/author.html#4926>

________________________________
More information about the Archivesspace_Users_Group mailing list<http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group>

Alston Cobourn
Processing and Digital Assets Archivist
Texas A&M-Corpus Christi
Alston.cobourn at tamucc.edu<mailto:Alston.cobourn at tamucc.edu>
361-825-2300

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20170928/9fd075c4/attachment.html>