Importing Contacts with a CSV file

[Jozef]

Importing Contacts with a CSV file
I had some trouble figering out, how to import an Contacts CSV file.

The format below did the trick:

First Name,Last Name,E-mail Address,
Jozef,Broeckx,NiceGuy@Casema.nl,

Make sure to put a comma at the end of each line.
Double quotes around each field also works. It's the comma at the end that's mandatory.

Any other tips are welcome....http://www.roundcubeforum.net/Smileys/default/grin.gif

[tester444]

Greetings
I appreciate your help. I didn't find that solution anywhere on the internet.
I have been inserting the emails manually for over two years.
None of the specialists nor the tool owners themselves bothered to alert on this.
I want to add another thing that the order is also essential: first name, last name, then email. Import is not accepted if the email is at the beginning.
Jozef, thank you again, have a nice day.

[iamauser]

Over 7 years later and this thread is invaluable. I'd also like to add this, if you want to import with groups the below seems to work for me:

First Name,Last Name,E-mail Address,Categories,

[DonU]

I am trying to import contacts that have multiple Groups assigned but I cannot successfully get all the groups in. Sometimes some work properly but when I rerun same file I get different results. A sample file is below.

First Name,Last Name,E-mail Address,Categories,
Christine,Adams,crisad@nomail.ca,MMM-1,
Andrew,Adamson,andamson8@nomail.com,Members;MMM-1,
Avril,Adamson,aprilshowers.adamson@nomail.com,Members;MMM-1,
Di,Agar,diana.agar@nomail.ca,,
David,Agar,david.agar@nomail.ca,Members,


Is there a trick to this?

[JohnDoh]

The short answer is probably yes but can you tell me what settings you are using for "Import group assignments" and "Replace the entire address book"?

Semicolon should be good as a group list delimiter so I'm wondering if something else about how existing contacts are detected/ignored could be the issue.

Also what version of Roundcube?