Installation: Install: make install WARNING: This will delete any existing VegBIEN DB! Uninstall: make uninstall WARNING: This will delete your VegBIEN DB! Reinstall all datasources at once: . bin/reinstall_all Data import: Import data into VegBIEN: . bin/import_all Using column-based import: . bin/with_all 'import by_col=1' Stop all running imports: . bin/stop_imports Archive the last import: make schemas/rotate Re-import data: make schemas/rotate; . bin/import_all Note: This will archive the last import. Empty the DB: make schemas/reinstall WARNING: This will delete your VegBIEN DB! Datasource setup: Add a new datasource: make inputs//add If the datasource is a herbarium, should be the herbarium code as defined by the Index Herbariorum Schema changes: Regenerate schema from installed DB: make schemas/remake Reinstall DB from schema: make schemas/reinstall WARNING: This will delete your VegBIEN DB! Sync ERD with vegbien.sql schema: Run make schemas/vegbien.my.sql Open schemas/vegbien.ERD.mwb in MySQLWorkbench Go to File > Export > Synchronize With SQL CREATE Script... For Input File, select schemas/vegbien.my.sql Click Continue Click in the changes list and press Ctrl+A or Apple+A to select all Click Update Model Click Continue Note: The generated SQL script will be empty because we are syncing in the opposite direction Click Execute Reposition any lines that have been reset Add any new tables by dragging them from the Catalog in the left sidebar to the diagram Remove any deleted tables by right-clicking the table's diagram element, selecting Delete '', and clicking Delete Save If desired, update the graphical ERD exports (see below) Update graphical ERD exports: Go to File > Export > Export as PNG... Select schemas/vegbien.ERD.png and click Save Go to File > Export > Export as SVG... Select schemas/vegbien.ERD.svg and click Save Go to File > Export > Export as Single Page PDF... Select schemas/vegbien.ERD.pdf and click Save Go to File > Print... For Pages, choose From 1 To 1 In the lower left corner, click PDF > Save as PDF... Set the Title and Author to "" Select schemas/vegbien.ERD.core.pdf and click Save Testing: Mapping process: make test Map spreadsheet generation: make remake Missing mappings: make missing_mappings Everything (for most complete coverage): make test-all Documentation: To generate a Redmine-formatted list of steps for column-based import: make inputs/QMOR/import/steps.by_col.sql General: To see a program's description, read its top-of-file comment To see a program's usage, run it without arguments