Automatically import styles from an Excel file. We (mostly Björn) receive the Excel file via E-Mail.
Gitlab: https://git.picalike.corpex-kunden.de/picalike/witt_style_import
====== Running ======
* convert Excel file to CSV
* save CSV file to a folder (e.g. /tmp)
* control if order of columns corresponds to named_tuple in script
* run style_importer
docker run -v /tmp:/var/local/style_import registry.picalike.corpex-kunden.de/witt/style_import
* note down any “unknown pids” and “problematic styles” that the program might report
* check results in mongo (mongodb01.live.picalike.corpex-kunden.de:27017, db: picalike3 collection: pci_styles)
====== Custom Import Filters ======
In case the customer requests to apply (default) filters while importing their feed, the process is different.
* convert Excel file to CSV
* save CSV file to a folder (e.g. /tmp)
* clone Gitlab repo witt_style_import
* control if order of columns corresponds to named_tuple in script
* pull base image
docker pull registry.picalike.corpex-kunden.de/witt/style_import
* add default values in import_styles.py:
* execute build.sh in
* run style_importer
docker run -v /tmp:/var/local/style_import style_import:latest