Importing Contacts via CSV

[bsfinkel]

I need to import a large contact file.  I created a test CSV file with these fields:

     First Name,Last Name,Primary Email,Display Name.Job Title,contactgroup_id

and two contact lines after this header line.  The first three fields were imported; the last three were not.
I then created another test CSV file with these fields:

    Display Name.Job Title,contactgroup_id,First Name,Last Name,Primary Email

and two more contact lines.  Importing this input file resulted in NO contacts being imported.
Is there something in the import process that I am missing?  Thanks.

[alec]

First of all, you have a dot after "Display Name" which is wrong. Second, you can't import groups by ID, you need to use group name and the field name will be "Groups".

[bsfinkel]

Thanks for spotting the period typo.  I changed it to a comma, and the two test contacts files loaded.

I still do not know how to import the contacts into a specific group.  I changed the first line of my two test CSV files so that the column heading was "Groups", and the four test contacts were not placed in any group.   Can I assign a group via the CSV import file?  Thanks.

[bsfinkel]

I have not received a reply to my last posting.  Can I include a group in each entry in the CSV file to assign that new contact to a specific group?  I could not find anything definitive in the online archives.  If so, what column header do I use?  I have tried "Group", "Groups" and "contactgroup_id", all without success.  I need to import a large number of contacts, and I would prefer not having to find each one and assign a group after the import.  Thanks.

[alec]

"Groups" should be fine. Remember there are group import options in import form. By default groups are not imported.

[bsfinkel]

I tried a text CSV file with three lines:

     First Name,Last Name,Primary Email,Display Name,Job Title,Groups
     Test1FN,Test1LN,[email protected],Test1 DN,Test1 Title,PTG3 Publicity
     Test2FN,Test2LN,[email protected],Test2 DN,Test2 Title,PTG3 Publicity

and the two contacts were imported. The first five fields were imported properly, but the two contacts were not added to the desired group (nor to any group).  What am I doing incorrectly?  Thanks.

[alec]

What Roundcube version are you using?

[bsfinkel]

I have no idea.  Is there a way in the Roundcube mail page to determine?  I could not find one.  Thanks.

[bsfinkel]

I believe that it is  Roundcube Webmail 0.9.3  .

[alec]

I'm afraid you need at least 1.0.

[rajni123]

I have no idea all about this.