New python yaml loader, for the yamlised sde
Branch: master
Clone or download
Steve Anderson
Latest commit b9a38b7 Dec 18, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
tableloader added for language selection during load Dec 18, 2018
.gitattributes
.gitignore
LICENSE
Load.py added for language selection during load Dec 18, 2018
README.md
TypesToJson.py
exportTypesxlsx.py
invVolumes1.csv
invVolumes2.csv
requirements.txt
sdeloader.cfg fix for station names May 12, 2017

README.md

A data loader, to bring in the YAML version of the SDE

Loads data back into approximately the same structure.

Fetch the YAML SDE from CCP's Developer site.

Installation

macOS

Remember to install libyaml first, and adjust the include path for clang:

sudo port install libyaml
export C_INCLUDE_PATH=/opt/local/include

or brew install libyaml export C_INCLUDE_PATH=/opt/local/include (not sure what Homebrew path would be)

For PostgreSQL, you will also need to install psycopg2.

Operation

Alter the settings in sdeloader.cfg, specifically the DSN/URI for the database you'll be using, and the source path for the SDE files.

Make sure to copy the two csv files to the place you've stuck the SDE.

Then run the loader:

python Load.py «database engine»

Database Engines

PostgresSQL with Schema

You must create the "evesde" schema before using the loader.