Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SWIFT (Semantic Web Ingest from Tables) is a toolkit that allows experienced users to bulk-upload data into an eagle-i repository, via ETL (Extract, Transform and Load). The figure below is a high level depiction of the ETL process. Currently the  The toolkit supports only Excel spreadsheets and csv files as input files(though both need to conform to a SWIFT template, see below).

Gliffy Diagram
nameetl-high-level

...

  • an ETL Input Generator - command line program that generates Excel spreadsheet templates and mapping files for the various resource types of the eagle-i resource ontology (e.g. a template/map for antibodies, for instruments, etc.)
  • an ETLer -  command line program that executes a bulk upload
  • a deETLer - command line program that deletes a previous ETL upload
  • Bulk workflow - command line program that executes workflow transitions on groups of resources, e.g. Publish, Return to curation, Withdraw

...