/yamlloader

New python yaml loader, for the yamlised sde

Primary LanguagePythonMIT LicenseMIT

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.