chill-import-from-canvas/third_party
nobohan 9c90e5ac07 Add single python script for translating third party information into SQL 2024-02-16 09:48:07 +01:00
..
README.md Add single python script for translating third party information into SQL 2024-02-16 09:48:07 +01:00
import_third_party_to_sql.py Add single python script for translating third party information into SQL 2024-02-16 09:48:07 +01:00

README.md

Import Third parties into Chill from the canvas

This folder contains a single Python script that reads a csv file with Third party and print to the console some SQL to execute on the database.

The csv file should be simply exported from the sheet "Tiers" from the xls canvas.

Then, you can run the python script with adapting the following:

  • name of the csv file to open
  • change the mapping of third party categories, civilities and third party kinds according to your Chill database

So far, the addresses are not treated.