[solved]Gestire file CVS

[genovince]

Hi, I have an excel file with 5 columns and 1,700 rows. This is the management of a warehouse. My idea is to create a database with fabrik and then to load the CSV file is a thing possible?

 

[troester]

Yes, you can create a Fabrik list and then do a CSV import.
Or you can create the Fabrik list directly from a CSV-file via the "Import" button.

In any case you must adapt your excel:
- the first row must contain element names
- it must be a CSV-file, so at least you must do a "Save as"...csv; which may still have issues with character encoding; better is to open the Excel with e.g. OpenOffice and create a correct, UTF8-encodes CSV file (you can't convert to UTF8 via Excel)

 

[genovince]

Thank you very much, I try

 

[genovince]

I was able to load the CSV file by saving with Open Office, Thanks.
But I have two problems: 1) I can not load the file if there is a field DATA and the error message is "DateTime :: __ construct (): Failed to parse string time (16.12.2014 00:00) at position 0 (1): Unexpected character "
2) I have a "Phone" field with some formats numbers from 11 to 10 and other characters. Those with 11 characters after loading all have the same number: 2147483647.

 

[troester]

Did you use the "Import" button (i.e. creating a new Fabrik list)?
Or did you "CSV import" to an existing list?
What are your element types and settings?

I think in case 1 your date in the CSV must have SQL format (YYYY-MM-DD HH:ii)
in case 2 it must match your date element format settings

 

[genovince]

I solved using the button "import" list
Thank you