All Projects → harvard-library → aspace-import-excel

harvard-library / aspace-import-excel

Licence: Apache-2.0 license
Import resources, archival objects, etc. into ArchivesSpace using Excel spreadsheet files

Programming Languages

javascript
184084 projects - #8 most used programming language
ruby
36898 projects - #4 most used programming language
HTML
75241 projects
Batchfile
5799 projects

Projects that are alternatives of or similar to aspace-import-excel

Airrecord
Ruby wrapper for Airtable, your personal database
Stars: ✭ 193 (+394.87%)
Mutual labels:  spreadsheet
Sc Im
sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
Stars: ✭ 3,081 (+7800%)
Mutual labels:  spreadsheet
react-datasheet-grid
An Airtable-like / Excel-like component to create beautiful spreadsheets.
Stars: ✭ 227 (+482.05%)
Mutual labels:  spreadsheet
Excel to code
Roughly translate some Excel spreadsheets to Ruby or C.
Stars: ✭ 214 (+448.72%)
Mutual labels:  spreadsheet
Googlesheets4
Google Spreadsheets R API (reboot of the googlesheets package)
Stars: ✭ 232 (+494.87%)
Mutual labels:  spreadsheet
Handsontable
JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡
Stars: ✭ 16,059 (+41076.92%)
Mutual labels:  spreadsheet
Volbx
Graphical tool for data manipulation written in C++/Qt
Stars: ✭ 187 (+379.49%)
Mutual labels:  spreadsheet
google-sheets-wrapper
Lightweight wrapper around the official Google Sheets API that makes it easy to read/write rows
Stars: ✭ 36 (-7.69%)
Mutual labels:  spreadsheet
Psexcel
A simple Excel PowerShell module
Stars: ✭ 234 (+500%)
Mutual labels:  spreadsheet
PivotHelper
PivotHelper is a utility web app that generates Pivot tables and charts from CSV files and Microsoft Excel spreadsheets.
Stars: ✭ 26 (-33.33%)
Mutual labels:  spreadsheet
Xlsxwriter
A Python module for creating Excel XLSX files.
Stars: ✭ 2,766 (+6992.31%)
Mutual labels:  spreadsheet
Seatable
SeaTable: easy like a spreadsheet, powerful like a database
Stars: ✭ 231 (+492.31%)
Mutual labels:  spreadsheet
medium-editor-handsontable
📊 Handsontable extension for MediumEditor
Stars: ✭ 50 (+28.21%)
Mutual labels:  spreadsheet
Hyperformula
A complete, open-source Excel-like calculation engine written in TypeScript. Includes 380+ built-in functions. Maintained by the Handsontable team⚡
Stars: ✭ 210 (+438.46%)
Mutual labels:  spreadsheet
rodf
ODF generation library for Ruby
Stars: ✭ 50 (+28.21%)
Mutual labels:  spreadsheet
Calx.js
jQuery Calx - a jQuery plugin for creating formula-based calculation form
Stars: ✭ 190 (+387.18%)
Mutual labels:  spreadsheet
Cookbook
Code snippets for various programming languages and libraries
Stars: ✭ 245 (+528.21%)
Mutual labels:  spreadsheet
xlsx-renderer
Render xlsx from template
Stars: ✭ 21 (-46.15%)
Mutual labels:  spreadsheet
spreadcheetah
SpreadCheetah is a high-performance .NET library for generating spreadsheet (Microsoft Excel XLSX) files.
Stars: ✭ 107 (+174.36%)
Mutual labels:  spreadsheet
react-bolivianite-grid
React grid component for virtualized rendering large tabular data.
Stars: ✭ 95 (+143.59%)
Mutual labels:  spreadsheet

aspace-import-excel

An ArchivesSpace plugin to support the bulk uploading via Excel SpreadSheet of Archival Objects and (optionally) their associated Creator Agents, Top Containers, Subjects, Digital Objects etc.

Also supports the import of spreadsheets that will allow for the creation of Digital Objects to be associated with already-created Archival Objects for Version 2.2.2 and higher of ArchiveSpace.

Current Version

For versions of ArchivesSpace before v2.2.2: v1.7.8

NOTE: v1.7.8 does not support the creation of Digital Objects to be associated with already-created Archival Objects.

For ArchivesSpace v2.2.2 and higher: v3.0.2

Development

This plugin supports interactive selection of an archival object (or resource) as the starting point of the bulk upload.

Version 3.0 incorporates new functionality for uploading archival objects (described in the user documentation), which supports the use of an expansion to the original Excel template. Version 3.0 is, however, backward compatible, so that users whose workflow is satisfied with the original template can continue to use it.

Bulk upload/creation of Archival Objects

The Excel templates will be found in the templates/ folder as

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 assignment of locations to top-level containers) would take place interactively.

See the user documentation for more information.

Bulk upload/creation of Digital Objects associated with already-created Archival Objects

This functionality is turned on by default See the Installation instructions for turning it off.

The Excel template will be found in the templates/ folder as aspace_import_excel_DO_template.xlsx.

As with the original development, we are not completely reproducing all the functionality of ArchivesSpace: only one Digital Object, which can have either or both of one:

  • File with an Xlink Actuate Attribute of onLoad and an Xlink Show Attribute of embed
  • File with an Xlink Actuate Attribute of onRequest and an Xlink Show Attribute of new

See the user documentation for more information.

Installation

This is a regular ArchivesSpace Plug-in.

To install this plug-in:

  1. Either clone this plugin, or download the latest version:

    • Clone the plug-in from this GitHub repository into the ArchivesSpace /plugins/ directory.
    • Download the zipfile of the appropriate version: see Current Versions for links to the appropriate release download. Unzip the download into the /plugins/ directory. You will probably need to rename the top folder/directory to aspace-import-excel.
  2. (Optional) To turn off the functionality for creating Digital Objects associated with already-created Archival objects, you must edit /plugin/aspace-import-excel/frontend/plugin_init.rb. Change the line

    AppConfig[:hide_do_load] = false

to

    AppConfig[:hide_do_load] = true
  1. IF you are running, on Windows, a version of ArchivesSpace that is lower than version 2.6.0:

    There was a problem with Bundler versioning.

Copy

archivesspace\aspace-import-excel\extras\modified_initialize-plugin.bat

to

archivesspace\scripts

UPDATE: You no longer need to use this modified .bat script if you are running ArchivesSpace 2.6.0 or higher.

  1. Run the initializer script:

    • for Linux, that's
    scripts/initialize-plugin.sh aspace-import-excel
    • for Windows, running an ArchivesSpace version lower than 2.6.0 ,that's
    scripts\modified_initialize-plugin.bat aspace-import-excel
    

    Otherwise, for Windows running ArchivesSpace version 2.6.0 and higher:

    scripts\initialize-plugin.bat aspace-import-excel
    
  2. In the common/config/config.rb file, add 'aspace-import-excel' to the AppConfig[:plugins] array.

  3. Stop and restart ArchivesSpace

Why we don't include a Gemfile.lock in this repository

We have found that when we include a Gemfile.lock file in our plugin, some sites have found that, after initializing the plugin and trying to restart ArchivesSpace, they get errors like this:

[!] There was an error parsing Gemfile: You cannot specify the same gem twice with different version requirements.
You specified: rubyzip (~> 1.2.2) and rubyzip (= 1.0.0). Bundler cannot continue.

This problem does not seem to occur when the Gemfile.lock is created through the initialization instead.

User Documentation

User documentation is available

Contributors

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].