Skip to content

Generates a QR from excel tables, one with attendance data and one with wages and IBANS

License

Notifications You must be signed in to change notification settings

VitBojanovsky/Wage-QR-generator-from-CrossChex

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

QR Code Generator Script

License: The license is in LICENSE.md. I strongly recommend reading it.

Description

This script generates QR codes from two input files: brigadnici.xls and config.xlsx.

  • brigadnici.xls: Exported from the program CrossChex; contains IDs and time spent at work.
  • config.xlsx: Contains IDs, names, and, most importantly, IBANs (international bank account numbers). These are required to create QR payments. There is currently no way to calculate IBANs from local account numbers automatically.

The script produces QR codes suitable for payments in the Czech Republic.

Disclaimer

  • This script generates QR payments in Czech format. Modifications may be required to deploy it in other countries.
  • The script does not calculate taxes and does not generate invoices. Please consult your local laws before using it.
  • For licensing inquiries, contact me at bojanovsky.vit@protonmail.com.

Useage

  • install Python and then install libs with the install.sh
  • From CrossChex export the attendance table and save it in the same folder as the script with the name brigadnici.xls
  • Add a config.xlsx that will look like this image
  • launch the script with Python
  • View the QRCodes in /QR_Codes

About

Generates a QR from excel tables, one with attendance data and one with wages and IBANS

Topics

Resources

License

Stars

Watchers

Forks