[SOLVED]Import companies from CSV

keerik

Hi,
Im rather new on this....

I have an csv with companies I want to import into Epesi.

When I trie to import this data I get this:
Skipping - missing "Company Name" (Företag): Array ( [country] => SE [permission] => 0 )
Skipping - missing "Company Name" (Företag): Array ( [country] => SE [permission] => 0 )
Skipping - missing "Company Name" (Företag): Array ( [country] => SE [permission] => 0 )

My csv looks like this:

Företag;Telefon;Adress;Ort;Land;Postnummer
A Nordins Åkeri AB;706037180;Happstav. 48;SJÄLEVAD;SE;894 91
Kjell Abrahamssons Åkeri;703638156;Genesåsv. 77;DOMSJÖ;SE;892 43

And the mapping looks like this:

•Företag - Company Name (required)
•Telefon - Phone
•Adress - Address 1
•Ort - City
•Land - Country (required)
•Postnummer - Postal Code

So, Where is the problem????
Anyone who can help me?

/Kenneth

jasiek

Keerik,

You say:
[quote:ovoazgv5]My csv looks like this:
Företag;Telefon;Adress;Ort;Land;Postnummer
A Nordins Åkeri AB;706037180;Happstav. 48;SJÄLEVAD;SE;894 91
Kjell Abrahamssons Åkeri;703638156;Genesåsv. 77;DOMSJÖ;SE;892 43[/quote:ovoazgv5]

This is not a valid CSV. CSV stands for Comma Separated Values. You have no commas but semicolons.
Your file should looke like this:

"Företag","Telefon","Adress","Ort","Land","Postnummer"

"A Nordins Åkeri AB","706037180","Happstav. 48","SJÄLEVAD","SE","894 91"

"Kjell Abrahamssons Åkeri","703638156","Genesåsv. 77","DOMSJÖ","SE","892 43"

Please see this post for more info:
viewtopic.php?f=21&t=815

keerik

[quote="Jasiek":3uh1mhbl]Keerik,

You say:
[quote:3uh1mhbl]My csv looks like this:
Företag;Telefon;Adress;Ort;Land;Postnummer
A Nordins Åkeri AB;706037180;Happstav. 48;SJÄLEVAD;SE;894 91
Kjell Abrahamssons Åkeri;703638156;Genesåsv. 77;DOMSJÖ;SE;892 43[/quote:3uh1mhbl]

This is not a valid CSV. CSV stands for Comma Separated Values. You have no commas but semicolons.
Your file should looke like this:

"Företag","Telefon","Adress","Ort","Land","Postnummer"

"A Nordins Åkeri AB","706037180","Happstav. 48","SJÄLEVAD","SE","894 91"

"Kjell Abrahamssons Åkeri","703638156","Genesåsv. 77","DOMSJÖ","SE","892 43"

Please see this post for more info:
viewtopic.php?f=21&t=815[/quote:3uh1mhbl]

THANKS!!!! Jasiek,
I must have been very tired!! :mrgreen: :lol:

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge