Import from CSV not working

[frankfokke]

Dadabik 11 Elba
PHP Version: 7.2.34 (Zend: 3.2.0)
HTTP Server: Apache 2.0 Handler
Database Engine: MySQL 5.5.5-10.5.10-MariaDB
Browser: Firefox 89.0.1

Hi,
I am trying to import from a CSV-file. No matter what I do, I only get errors. So I tried the following:
I create a table with only one record. I export the table to CSV. The file looks like this:

"Id","Factuurnummer","Aantal","Productnaam","Model","BTW","Prijsstex","Prijsstin","Totex","Totincl"
"1085","0448467","10","Flesjes 10ml bruin","fl0010gl18br61","21.00","0.120000","0.145200","1.200000","1.452000"

I delete the record in dadabik. Now it has no records.

I import from CSV. This is what it shows:

1 new elements will be added. To proceed, click "Continue" at the end of the page
Id Factuurnummer Aantal Productnaam Model BTW Prijsstex Prijsstin Totex Totincl
1086 0448467 10 Flesjes 10ml bruin fl0010gl18br61 21.00 0.120000 0.145200 1.200000 1.452000


I click on continue and get:

You haven't filled out some required fields.

I just don't get it.....whatever table I try to import, always this error.

So I go to phpmyadmin, import from CSV to the table and that works fine.

What am I doing wrong in dadabik?

Cheers, Frank.

 

[eugenio]

Hello,
do you have required fields in your table? If yes, for all those fields, are you providing values in the CSV?

Best,

 

[frankfokke]

There are no required fields and all fields have the correct value, since I just exported the table to CSV, emptied the table and try to import that one record CSV again:

I get:

Cheers, Frank.

 

[eugenio]

I guess the standard input form is working, right?
Can you post a screenshot of the whole insert form?

Best,

 

[frankfokke]

So, what do I do to correct this?

 

[eugenio]

I don't see the screenshot of the insert form, did you post it?

 

[mladen]

11.0-Elba enterprise
PHP Version: 7.3.12
mysql version: 8.0.18
Web server: Apache/2.4.41 (Win64) PHP/7.3.12
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0


to me it is also not working, neither XLSX nor CSV

[pre]
You have inserted a/some non-numeric characters into a numeric field.
[/pre]

i tried in firefox and chrome.

 

[eugenio]

mladen Wrote:
>
> [pre]
> You have inserted a/some non-numeric characters in
> to a numeric field.
> [/pre]
>
> i tried in firefox and chrome.

Here the message is pretty clear, are you importing non-numeric characters for fields you set as numeric?

Best,

 

[mladen]

Hi Eugenio,

that is what is unclear to me. my last two fields are decimal. So first i tried importing decimal number with ",", after that i tried with "."
After that i tried both in CSV format

 

[eugenio]

Hello,
the decimal separator is the same you use in the forms, dot (.).