Hi! I want to learn how to import contacts with a csv file. I installed the import module under the Administrator -> Modules Administration -> Import tool.
When I go to IMenu -> Import -> Contacts
It wants me to do Column Mapping for Last Name and First Name. I tried putting in a few things, but I can't seem to figure it out.
It's an excel document with Primary Contact Information First Name in cel I1, and Primary Contact Information Last Name in cel J1. With the names in cels I2 onward, and in cels J2 and onward. If that makes sense.
So I tried putting in fields like J in Last Name and I in First Name. I tried putting Primary Contact Information Last Name in Last Name. But nothing seems to work.
When I tried to Upload the CSV File it will say
[quote:1kzbptba]Import contacts
You can import Excel or csv (comma-separated values) file. Data should be exported as table with columns named. If using a csv file the field delimeter is "," and the text delimeter is ".
Current column mappings
* Primary Contact Information Last Name - Last Name (required)
* Primary Contact Information First Name - First Name (required)
You can change column mapping here
You can tweak import with form below
Select groups that will be assigned to all imported contacts (in addition to groups defined in your import file). All contacts must be assigned a country, choose a default that will be used if your import file is missing this field. Countries in import files should be written as 2 character code (ISO 3166-1 alpha-2) i.e. DE for Germany.
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Skipping - missing "Last Name" (Primary Contact Information Last Name): Array ( [country] => US [permission] => 0 )
Data imported[/quote:1kzbptba]
But nothing is uploading to the Contact List. Thank you so much for the help! 🙂
