Importing data to MariaDB with AWIM

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
perherman
Posts: 20
Joined: Thu Nov 23, 2017 10:41 am
Contact:

Importing data to MariaDB with AWIM

Post by 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
Posts: 20
Joined: Thu Nov 23, 2017 10:41 am
Contact:

Re: Importing data to MariaDB with AWIM

Post by 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
Posts: 20
Joined: Thu Nov 23, 2017 10:41 am
Contact:

Re: Importing data to MariaDB with AWIM

Post by 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
Post Reply