Author Topic: Importing Contacts via CSV  (Read 9273 times)

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Importing Contacts via CSV
« on: March 19, 2015, 03:19:08 PM »
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.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Importing Contacts via CSV
« Reply #1 on: March 19, 2015, 03:24:35 PM »
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".

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Re: Importing Contacts via CSV
« Reply #2 on: March 23, 2015, 11:10:20 AM »
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.

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Re: Importing Contacts via CSV
« Reply #3 on: April 06, 2015, 04:25:20 PM »
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.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Importing Contacts via CSV
« Reply #4 on: April 07, 2015, 02:19:47 AM »
"Groups" should be fine. Remember there are group import options in import form. By default groups are not imported.

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Re: Importing Contacts via CSV
« Reply #5 on: April 07, 2015, 03:19:50 PM »
I tried a text CSV file with three lines:

     First Name,Last Name,Primary Email,Display Name,Job Title,Groups
     Test1FN,Test1LN,test1@example.com,Test1 DN,Test1 Title,PTG3 Publicity
     Test2FN,Test2LN,test2@example.com,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.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Importing Contacts via CSV
« Reply #6 on: April 08, 2015, 02:07:27 AM »
What Roundcube version are you using?

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Re: Importing Contacts via CSV
« Reply #7 on: April 09, 2015, 11:24:54 AM »
I have no idea.  Is there a way in the Roundcube mail page to determine?  I could not find one.  Thanks.

Offline bsfinkel

  • Newbie
  • *
  • Posts: 6
Re: Importing Contacts via CSV
« Reply #8 on: April 09, 2015, 05:53:29 PM »
I believe that it is  Roundcube Webmail 0.9.3  .

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Importing Contacts via CSV
« Reply #9 on: April 10, 2015, 02:18:42 AM »
I'm afraid you need at least 1.0.

Offline rajni123

  • Newbie
  • *
  • Posts: 1
Re: Importing Contacts via CSV
« Reply #10 on: April 17, 2015, 05:27:30 AM »
I have no idea all about this. :-\