Convert PLEXOS files to SQLite databases
Functions to process PLEXOS solution and input files and dump them into SQLite databases that are easier to read.
1 2 3 4 5
Folder(s) to process (See details)
Should temporary databases be preserved?
Single PLEXOS solution or input file to process
process_solution converts a single zipped PLEXOS solution into a SQLite database.
The resulting database file has a simplified structure so data can be retrieved easily.
The temporary database contains the original data structure in the PLEXOS solution file.
process_input converts a single PLEXOS input file (in XML form) solution into a
SQLite database. The database includes the raw tables and a series of views that better
organize the data.
process_folders is used to process one or more folders. It searches each folder for
PLEXOS solution or input files and applies
process_input to each one of them.
The default folder is the working directory. If the wildcard
"*" is provided, all
the folders in the working directory will be processed (the list of folders if provided by
Do not rename the SQLite databases created with these functions. Other code expects those filenames to remain unchanged.
1 2 3 4 5 6 7 8 9 10 11 12
# Process the folder with the solution file provided by rplexos location_solution <- location_solution_rplexos() process_folder(location_solution) # Process the folder with the input file provided by rplexos # location_input <- location_input_rplexos() (for the moment, there is a bug in the soln file) # process_folder(location_input) # Other examples ## Not run: process_folder() ## Not run: process_solution("HiWind/Model WWSIS_c_RT_CoreB_M01_SC3 Solution.zip") ## Not run: process_input("WWSIS model.xml")