Hello the community,
I want to write a script which will read the data from a csv file which is in the attachment field "doc" in the table "fileImport"
The csv has 4 columns:
Nom,Ligne,Jour,Valeur
here is an example of the data:
Nom,Ligne,Jour,Valeur
Bornet Marc,AL / ASD,2024-04-01,2
Doe John 85%,AL / ASD,2024-04-01,17
I want to parse all data and to create/update/delete records in the table "Planning" and writing the data in the appropriate field:
Nom,Ligne,Jour,SV
how can I do such a script