witt_style_import
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
<HTML><ol></HTML>
- 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 <apikey> <name of csv file>
- 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)<HTML></ol></HTML>
Custom Import Filters
In case the customer requests to apply (default) filters while importing their feed, the process is different.
<HTML><ol></HTML>
- 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 <apikey> <name of csv file>
<HTML></ol></HTML>
witt_style_import.txt · Last modified: 2024/04/11 14:23 by 127.0.0.1