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.
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
.
sudo pacman -S python-pip
pip install --user pipenv
pipenv install
pipenv shell
python Load.py «database engine»
Alter the settings in config.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»
You must create the "evesde" schema before using the loader.