Follow these eight steps in order to install WaMDaM Wizard, populate your data into WaMDaM SQLite database, and implement use cases.
1. Download and Install the WaMDaM Wizard V 1.02¶
WaMDaM Wizard is a desktop data loader from a spreadsheet template to a SQLite database. The SQLite database is created based on the WaMDaM data model. Download the software for Windows 7 or 10 64 bit from the table below. You also can find out all the WaMDaM_Wizard releases on GitHub.
|Executable (.exe) [230 MB]||Download||Good option if you don't have Admin access to install it|
|Installer (msi) [160 MB]||Download||Lighter to donwload and probably faster to run|
|Run from source code||Good option to debug potential issues and improve it|
2. Launch WaMDaM Wizard¶
Once you installed the Wizard, double click at the Wizard's shortcut and this main window should appear.
Navigate the top tabs and see the Wizard's capabilites to prepare data for and import it into WaMDaM, and to export data to models.
3. Connect to SQLite¶
In WaMDaM Wizard you can either create and connect to a new or existing SQLite database instance on your machine. The Wizard automatically creats a blank WaMDaM SQLite file for you based on WaMDaM data model schema. Connecting to MySQL although it should work fine, it is not supported in this version.
4. Prepare your data into Excel¶
Follow the instructions here on how to prepare your data into WaMDaM Excel Workbook and register terms with controlled vocabulary.
5. Use the Wizard importers¶
- Import from Excel workbooks your prepared in Step 4
- Importers time series data from CUAHSI
- Import reservoir related data from the US Reclamation Water Information System. *
6. Open the SQLite database¶
Download and install the DB Browser For SQLite to query the database and view its tables.
Use the DB Browser For SQLite to inspect the loaded data into WaMDaM.
7. Execute use case queries¶
Use and adapt queries from WaMDaM use cases and execute them in the SQLite Manager.
8. Compare scenarios¶
9. Query WaMDaM¶
Use and adapt Python scripts to v