Skip to main content

Update Database

Overview​

The Update Database feature lets you bulk-import plant records (Sites, Units, and Storage) into an open iPool system database from CSV or XLSX template files. For the full procedure, see Update Database.

What It Is​

The Update Database dialog has four modes:

  • Manual — imports Sites, Units, and Storages from CSV or XLSX template files (Sites.csv, Units.csv, Storages.csv). Entries are added or updated in the system database without requiring manual row-by-row editing.
  • Capacity Upgrade — reads a Historical Database Error Report and updates Units.MwMax for capacity-upgrade entries. Only one column in one table is changed.
  • Generation Files — reconciles a regional database against an MNM GenList and CAPEG files, performing structural updates in one pass.
  • RTD Files — updates Units.MLF (Marginal Loss Factor) and recomputes Sites.MLF from hourly RTD files. Available on Desktop and Web.

For full details on each mode, see Update Database.

When to Use It​

  • Use Manual mode when Historical Load Step 6 produces a Historical Database Error Report (HistDBErr.csv) showing missing-in-db errors — units, sites, or storage entries that exist in IEMOP data but are not yet in the SysWESM database. Resolve these by importing the relevant template files before re-running the Historical Load.
  • Use Capacity Upgrade mode when the Historical Database Error Report shows capacity upgrade entries that need to update Units.MwMax.
  • Use Generation Files mode when you need to reconcile a regional database against current MNM GenList and CAPEG data.
  • Use RTD Files mode to update Units.MLF (Marginal Loss Factors) when you receive new hourly RTD files and need to refresh MLF values in the database.

Command-Line Interface (CLI)​

The iPoolSuite.exe CLI supports all three update-file modes via the -updatedb flag. A log file is written beside the database as <name>.cli.log. Use -s to commit changes; without -s, the operation is a dry run.

Mode 1 — Manual (Sites/Units/Storages):

iPoolSuite.exe -updatedb \
  [-SitesFile <sites.csv>] \
  [-UnitsFile <units.csv>] \
  [-StorsFile <stors.csv>] \
  -o <database.db> \
  -s

Mode 2 — Capacity Upgrade:

iPoolSuite.exe -updatedb \
  -histDBErr <histdberr.csv> \
  -o <database.db> \
  -s

Mode 3 — Generation Files:

iPoolSuite.exe -updatedb \
  -genlist <genlist.csv> \
  -capeg <capeg.csv> \
  [-capeg <capeg2.csv> ...] \
  -o <database.db> \
  -s \
  [--no-auto-rename-siteid] \
  [--no-create-twin-battery]

For full flag descriptions, see Update Database.