This script is currently in early stages and was initially designed to simplify uploading the assets until a more permanent web UI could be built for the task. Therefore this utility is very low-level and likely requires some tinkering outside its intended use case.

Setup

Open import/main.py
Configure the two globals:

MONGO_URL = "enter mongo DB URL"
MONGO_DB = "name of DB"

Make sure dependencies are intalled with poetry install

Run

The script takes one parameter which is simply the path of your excel sheet.

poetry run python import/main.py $PATH

For example; if uploading the data provided in this repository you can run the following:

poetry run python import/main.py ../data/atr_data.xlsx

You should see output showing the individual objects it extracted from your excel sheet along with a success message at the end.

Expected Data Format

See {project_root}/data/atr_data.xlsx