rialto-etl

Rialto::Etl

Rialto::Etl is a set of ETL tools for RIALTO, Stanford University Libraries' research intelligence project

Installation

Add this line to your application's Gemfile:

gem 'rialto-etl'

And then execute:

$ bundle

Or install it yourself as:

$ gem install rialto-etl

Usage

Extract

Run bin/extract to run a named extractor and print output to STDOUT:

$ bin/extract -s StanfordResearchers
{"count":10,"firstPage":true,"lastPage":false,"page":1,"totalCount":29089,"totalPages":2909,"values":[{"administrativeAppointments":[...

Note: if you need to run any of the extractors that inherit from AbstractStanfordExtractor, you will first need to obtain a token for the CAP API and set the CAP_TOKEN environment variable in your session.

Transform

Run bin/transform to run a named transformer, based on Traject, on a named input file and print output to STDOUT:

$ bin/transform -s StanfordOrganizationsToVivo -i stanford_organizations.json
{"@id":"http://authorities.stanford.edu/orgs#vice-provost-for-undergraduate-education/stanford-introductory-studies/freshman-and-sophomore-programs","@type":"http://vivoweb.org/ontology/core#Division","rdfs:label":"Freshman and Sophomore Programs","vivo:abbreviation":["FFQH"]}

Load

TBD

Help

$ bin/extract -h
Usage: bin/extract [options]
    -n, --name NAME                Name of the extractor to run (REQUIRED)

$ bin/transform -h
Usage: bin/transform [options]
    -n, --name NAME                Name of the transformer to run (REQUIRED)
    -i, --input-file FILENAME      Name of file holding data to be transformed (REQUIRED)

Documentation

• Mapping / Mapping Target
• CAP Organizations to VIVO Mapping

Development

After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/sul-dlss-labs/rialto-etl.