Program suite to read Google Sheets file over landowners, process this to a payment XML file according to the SEPA Payment Initiation Format.
Uses an API made by feeding generateDS the xml schema for pain.001.001.03.
Requires a handful of different modules, including reportlab for PDF generation.
Step 1: Read over Google Sheet document online, fix any errors
Step 2: Run Google Sheet as CSV through readsheet.py program
Step 3: Run make_xml.py on output.csv to build payment file, output is output.xml
Step 3.5: Add valid header to file according to pain.001.001.03 to output.xml
Step 4: Upload payment file to bank
Step 5: Verify and authorize payment
Step 6: Generate PDF for payments using makeallbilag.py with input output.csv
Step 7: Send all marked "letter" as physical letter, send all marked "email" as email, using another program maybe
TL;DR:
python3 readsheet.py python3 make_xml.py python3 makeallbilag.py