plexos2duckdb

This is a command line tool to convert PLEXOS solution files to a DuckDB database.

Installation

Option 1: Download prebuilt binary

Prebuilt binaries are available from the GitHub Releases page.

1. Go to the latest release page on GitHub.

2. Download the appropriate binary for your operating system.

3. Extract the archive:

   tar -xzf plexos2duckdb-<platform>.tar.gz
   

   or on Windows:

   Expand-Archive plexos2duckdb-<platform>.zip -DestinationPath .
   

4. Copy the binary to a directory in your PATH, e.g.:

   # MacOS/Linux
   cp plexos2duckdb ~/local/bin/
   # Windows
   copy plexos2duckdb.exe %USERPROFILE%\local\bin\
   

   You will have to make sure ~/local/bin/ is in your PATH.

Option 2: Build from Source

If you prefer to build from source, ensure you have Rust and Cargo installed.

1. Clone the repository:

   git clone https://github.com/epri-dev/plexos2duckdb.git
   cd plexos2duckdb
   

2. Build the binary:

   cargo build --release
   

   The compiled binary will be located at:

   target/release/plexos2duckdb
   

3. Copy the binary to a directory in your PATH:

   # MacOS/Linux
   cp target/release/plexos2duckdb ~/local/bin/
   # Windows
   copy target\release\plexos2duckdb.exe %USERPROFILE%\local\bin\
   

   You will have to make sure ~/local/bin/ is in your PATH.

Quickstart

Verify installation is successful by checking the version:

plexos2duckdb --version

Run the help command to see available options:

plexos2duckdb --help

Convert a solution zip file to a duckdb database:

plexos2duckdb --input "Model-DayAhead-Solution.zip" --output "Model-DayAhead-Solution.duckdb"

Use any duckdb compatible database viewer to interactively explore the data with SQL: