CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • How to import contacts with multiple emails/phone numbers?
Pages: [1]

Author Topic: How to import contacts with multiple emails/phone numbers?  (Read 2389 times)

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
How to import contacts with multiple emails/phone numbers?
March 30, 2008, 07:35:06 pm
Dear Friends,

Am doing an initial population - via import - of contact data into a CiviCRM installation (on Drupal, if it matters).

For many of our contacts, I have several email addresses and phone numbers.  However, I cannot find any way to 'map' these additional fields to contact data.  How to do this?

Many thanks in advance.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to import contacts with multiple emails/phone numbers?
March 30, 2008, 11:21:14 pm
Currently i think you can import only one email per location type.

Quote
However, I cannot find any way to 'map' these additional fields to contact data.
You mean you have lots of email for a particular contact? or some other information that cannot be entered CiviCRM ?

kurund
Found this reply helpful? Support CiviCRM

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 08:32:27 am
Yes, Kurund - I have several email addresses per contact, and - of course - 3 or 4 phone numbers per contact.

I can see that, in the contact data entry form, there are fields already there for 5 emails and 5 phone numbers.  But, when I try to import using a csv file, I cannot map to email2, email3, etc.  I.E., I cannot see any of those field names...  I do see the custom fields we've created no problem!  Weird!  Is there some option or function to activate to turn on 'supplemental' fields or similar?

Many thanks for any help.
« Last Edit: March 31, 2008, 09:30:23 am by CiviGuy »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 11:14:08 am

Importing multiple email/phone for the same location is currently not supported by import. There is no option or function to turn this on.

If super important to you, please consider checking the code and submitting a patch. Note however that the import code is quite formidable (IMO)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 11:38:34 am
Lobo -

Many thanks for your response on this - and your help in the past on other matters...

No, this is not super important for this particular body of data - I was just surprised that the 'native' data schema has these fields, but that I cannot import them.  This is for a contact, not for a location, if this matters.

OK, will approach another way...

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 12:08:59 pm
Hi,

What you could possibly do is to import several time the file, with a different field mapping (ie first time you import the main phone, second time the second phone...)

Tedious (but import is unfortunately quite often) but should work (I haven't tried for that case, but we do several pass import quite often to go around import limitations).

Good luck !

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 12:34:56 pm
Thanks, Xavier, I will look into this...

I don't unserstand quite how this would work; do you mean that the email2 or email3 field maps will suddenly appear if there is an email field already there?

I'll try this in a few hours to understand what you've suggested.  Thanks for the idea.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 12:54:48 pm

The native data schema is relational, import is flat. Mapping a flat model to a relational model can get complicated depending on how complex the relational model is. Import does not support quite a few of the objects in the schema. I dont think our goal is to have one mega import that can do everything

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: How to import contacts with multiple emails/phone numbers?
March 31, 2008, 03:56:56 pm
You may already have seen this, but I'm pretty sure you can import multiple emails from each row in your import file (i.e. each contact to be imported) by mapping them to different location "types". (When you select "Email" from the drop-down, you get to pick from your available Location Types.)

EXAMPLE:

Email - Home, Email - Work, Email - Other
===========================
dave@home.org, dave@work.com, dave@other.net

Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • How to import contacts with multiple emails/phone numbers?

This forum was archived on 2017-11-26.