CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I'm about to do my first import of contacts into a pre-existing CiviCRM database on WordPress. Client sent over the CSV but there are columns like this:
Home Phone Home Fax Mobile Phone Work Phone Work Fax
That's fine, but in the DB, the Contact Details set has a Phone field and two dropdowns, one for Phone Location and one for Phone Type. And the ability to add more numbers. So what's the best way to take this CSV and properly do an import?
I'm assuming that home and work are location types in your Civi? If that is in fact the case, the one question I would ask from what you included is what location type to assign to the mobile phone. Home and work would be location types, and phone type would be phone, mobile, or fax. You would then set up your mapping in the contact import to assign the correct location and phone types to each column. Here is a sample of what I mean:
(I chose home as the location type for the mobile but that might not be correct in your situation.)
Hope this helps, Lesley
