Importing data to MariaDB with AWIM

perherman

Hi
I am trying to import data from a CSV file via the import function,
I get the following error:
Invalid description of data column PostalCode.Code. It must start with PostalCode.

My file looks like this:
PostalCode.Code,PostalCode.City,PostalCode.Region
"27456";"ABBEKÅS";"29"
"27404";"ABBEKÅS";"29"
"27456";"ABBEKÅS";"29"
"93082";"ABBORRTRÄSK";"67"
"93082";"ABBORRTRÄSK";"67"
"98107";"ABISKO";"70"
"98107";"ABISKO";"70"
"61690";"ÅBY";"10"
"61630";"ÅBY";"10"
"61621";"ÅBY";"10"

I have successfully export a few lines from AWIM with some testdata entered in AWIM, and then re-imported that data, with the headings above. So the headings should be Ok,

Any suggestions?

Per-Olof

perherman

Changed the delimitation to match the export of data from AWIM:

PostalCode.Code,PostalCode.City,PostalCode.Region
27456,ABBEKÅS,29
27404,ABBEKÅS,29
27456,ABBEKÅS,29
93082,ABBORRTRÄSK,67
93082,ABBORRTRÄSK,67
98107,ABISKO,70
98107,ABISKO,70
61690,ÅBY,10
61630,ÅBY,10
61621,ÅBY,10
61690,ÅBY,10
61622,ÅBY,10

Still the same error,

Per-Olof

perherman

The file I tried to import was exported from HeidSQL. So I suspected something with the file itself, and copied to content to the file exported from AWIM, and imported. Now it worked!!

Very strange!

Any idea what this is?

best

Per-Olof