Pipeline status:

CYME Model Data Extractor

Extract a CYME MDB file to its constituent tables in CSV format.

Input

The input folder must contain one or more MDB files, with the extension .mdb.

File config.csv:

Parameter name	Default value	Remarks
FILES	*.mdb	Supports patterns. Single filename example: my-network.mdb
TABLES	*	Supports patterns. Most CYME tables match CYM*
EXTRACT	non-empty	Allowed values are all or non-empty
TIMEZONE	US/CA	General format is <country>/city
POSTPROC	network_graph	Allowed post-processors are list in postproc folder. Current valid values are network_graph, voltage_profile, and write_glm
OUTPUT	zip csv json	File extensions to copy to the output folder.

Examples

Example 1 is based on the autotest/input_1.

config.csv

config.glm

modify.csv

settings.csv

Output

The output folder will contain a folder for each input MDB file, with CSV files corresponding to each of the tables in the input MDB file. CSV file names correspond to the MDB table name, with the CYM prefix removed and using lowercase letters.

An index file named index.csv is output containing information about each CSV file created, with the following structure

database	table	csvname	size	rows
mdbname	CYMTABLENAME	tablename	n-chars	n-rows

Docker Usage

You can run this pipeline on a supported docker container (e.g., ubuntu:20.04) using the following command:

host% mkdir input
host% cp my-database.mdb input
host% git clone https://github.com/openfido/cyme-extract --depth 1
host% mkdir output
host% docker run -it -v $PWD:$PWD -e OPENFIDO_INPUT=$PWD/input -e OPENFIDO_OUTPUT=$PWD/output ubuntu:20.04 $PWD/cyme-extract/openfido.sh