Author Topic: Import multiple addresses (Read 1543 times)

Conte01 · December 29, 2010, 01:21:30 am

Hello,

We are about to import our company contacts into civicrm and came upon a problem

When entering a new organization you can add another adress and therefore and other street and so on, but we cant figure out how to do this during an import

Is there a way to import several adresses (like streets, postal codes) for one organization?

Thanks
conte

Kiran Jagtap · December 29, 2010, 04:02:55 am

yep, we have the facility to import multiple addresses at a time,
just make sure to select different location type from mapper field ( Home, Work, billing ... )

For Example : Consider import of 2 street addresses at a time.

street address 1 => for location 'Home';
street address 2 => for location 'Work'

my sample .csv data file would looks like :

"First Name", "Last Name", "Street Address", "Street Address"
"abc1", "xyz1", "street address 1", "street address 2"

Now on 'Match Fields' ( second step of import ), my mapping would be

"abc1" => 'First Name'
"xyz1" => 'Last Name'
"street address 1" => "Street Address" => "Home"
"street address 2" => "Street Address" => "Work"

here when u select "Street Address" from drop down .. second drop down is get build dynamically and from there u could pickup location ( Home, Work )

and remaining process is same as normal import.

Hope this help

Kiran

Conte01 · December 29, 2010, 04:15:51 am

hi

thanks for the answer

I figured out this one, but dont consider it a clean solution.

When creating a new organization you are able to click on add another adress and get a new field for all data like street, postal code and so on. that is not possible during an import, isnt it?

thanks
conte

Hershel · December 29, 2010, 06:54:57 am

> that is not possible during an import, isnt it?

I don't follow your question exactly. Not it's not possible nor is it desirable. "Import" means you are importing all your data automatically from a CSV file--everything is processed automatically. So if you can put two addresses on one line of the CSV then both can be imported for that one contact, i.e. the contact of that line of the CSV.

Clicking on a button to manually add an address is an inherently manual process--this you can always do afterward manually using the web interface.

Can you explain what precisely you want to import?

ctarascio · December 29, 2010, 07:45:47 am

hi,
i think i understand what conte wants to do.

conte: in order to import multiple addresses for an organization, you must specify a different location type for each address. the location type can be "hard coded" in your import file (see attached) or, you can assign a location type when you map the fields in your import file to the fields in civicrm during the import process.

the attached file contains one organization that has 2 addresses: one has a location type of "main" and the other has a location type of "work". if the default location types don't meet your needs, you can create additions ones by going to administer civicrm/option lists/location types.

you cannot, however, use the same location type for more than one address as this will result in the last address "overwriting" the first one in the record.

hope this helps. if not please provide more detail about what you are trying to do.

cynthia

Conte01 · December 29, 2010, 11:41:36 pm

Hello,

Thank you guys for the replys. It seems that it was just a stupid error in reasonsing by myself. Importing multiple adresses works of course perfectly

I got another question: In the attached test file the street name begins with an Ö but when importing the Ö is gone. This is some UTF thing isnt it?
We exported our data from access into an excel file from which i create the csv file. How do i get the Ös, Üs and Äs into civicrm?

thanks
conte

Hershel · December 30, 2010, 03:02:38 am

Yes, this is an encoding issue. You may have to just play with it a bit to find the right one.

Conte01 · December 30, 2010, 05:42:09 am

hi,

not sure what i am should "play" here?

conte

Hershel · December 30, 2010, 05:43:34 am

With the file encoding: http://en.wikipedia.org/wiki/Character_encoding

ctarascio · December 30, 2010, 05:49:26 am

hi conte,
if you enclose your fields in quotes i think it will work. i tried with the attached file and the name imported just fine.

hope this helps,
cynthia

CiviCRM Community Forums (archive)

News:

Author Topic: Import multiple addresses (Read 1543 times)

Conte01

Import multiple addresses

Kiran Jagtap

Re: Import multiple addresses

Conte01

Re: Import multiple addresses

Hershel

Re: Import multiple addresses

ctarascio

Re: Import multiple addresses

Conte01

Re: Import multiple addresses

Hershel

Re: Import multiple addresses

Conte01

Re: Import multiple addresses

Hershel

Re: Import multiple addresses

ctarascio

Re: Import multiple addresses