CSV Date Italian Format

[luca.decarlo]

By importing a CSV file with date in Italian format (dd-mm-YY), set today's date in the jdate field in all records.

 

[troester]

You can use the listcsv plugin to format this data to SQL format.

 

[luca.decarlo]

I'm trying to import the csv file like you said:

1. create the db structure but the fields have complete filenames are different than those generated by the elements menu. (see attachment)

2. does not match a db table

3. on import it returns an error (attachment)

----- cassa.csv ----
"Data","Descrizione","Categoria_Incasso","entrate","uscite","idDocumento","idFornitore","idPagamento","idArticolo"
01/07/2023,"Olio 5W40 + Pasticca",6,24,0,0,,2,
01/07/2023,"Olio 5W40",6,30,0,0,,1,
03/07/2023,"Tagliando Dacia",7,0,32,0,4,1,
03/07/2023,"Cuffua freni e candele",7,320,0,108,,1,
03/07/2023,"Tagliando DACIA Logan",7,95,0,109,,1,
03/07/2023,"Lavaggio",5,20,0,0,,2,
03/07/2023,"Lucidatura fanali",9,50,0,0,,2,
04/07/2023,"Benny",11,0,25,0,,1,
05/07/2023,"Varie Peugeot 106",7,0,66,0,4,1,
05/07/2023,"Spazzole tergi",8,0,14,0,4,1,

 

[troester]

See https://fabrikar.com/forums/index.php?threads/importing-csv-file-fails.53923/ for a fix for creating lists via backend "Import" button.

But this is not the same as importing data via the list's "CSV/Import from CSV". Here you can manipulate the data by adding the listcsv plugin http://fabrikar.com/forums/index.php?wiki/list-csv-list-plugin/

 

[luca.decarlo]

Ok, done and the import works, even if the numeric fields created them varchar.
If I try to edit the field from the elements section, I always get the same error (see attachment)
If instead I create the element manually and try to change it from text to number and vice versa it works!