Prepare a CSV to load via Islandora Workbench
This is a convenience utility to allow a more user friendly spreadsheet to then be converted to the format Workbench expects. Can be thought of as middleware between normal spreadsheet curation and the format workbench expects.
sequenceDiagram
actor Alice
Alice->>Google Sheets: Edit 1
Alice->>Google Sheets: Edit 2
Alice->>Google Sheets: Edit ...
Alice->>Google Sheets: Edit N
Google Sheets->>Alice: <br>Download CSV
Alice->>Fabricator: template.csv
Fabricator->>Fabricator: processing/validating
Fabricator->>Alice: workbench.csv
Alice->>Islandora Workbench: workbench.csv
Islandora Workbench->>Drupal: entity CUD
go run main.go \
--source /path/to/google/sheet.csv \
--target workbench.csv
- HTTP service to allow a Google Sheets Apps script to validate a spreadsheet
- Validator service
- CSV transform service