Currently we import new stores for sozialpass manually from csv every quarter. The source file will be provided in nextcloud by the city of nuernberg. This source file contains addresses which have to be converted to coordinates before they can be used for store import. The output file will be uploaded to the entitlement server.
- Enable
geocodingandcsvWriterin/backend/src/resources/config.local.yml - Save the CSV file from Nextcloud to
/backend/src/resources/import/Akzeptanzpartner-daten.csv - Start
import datajob. This may take a while. - Check the log if entries were filtered out and try to fix them. Check if
acceptingstoreswere updated in the database - Update repo sozialpass-nuernberg-data with content of csv file of
src/main/resources/import/nuernberg-akzeptanzstellen_geoinfo.csv - Update the csv file on nextcloud with current geoinfos from the output file.
- Connect to
ssh <username>@entitlementcard.app - Go to data directory
cd /var/www/data - Pull recent main
sudo git pull - You can wait until the next scheduled import will take place or run this command to trigger the import:
sudo -u backend /opt/ehrenamtskarte/backend/bin/backend import