CiviCRM Community Forums (archive)

There doesn't appear to be a way to CSV import an Organization address through the CiviCRM Import feature and make the imported address "is_primary" or "is_billing"....please correct me am I wrong?

I wish to import a few hundred Orgizations, and about 20% of them have a separate address for Billing.

I'm thinking that I will import, then run some MySQL queries on the back end so that the primary addresses are "is_primary" and the billing addresses are "is_billing".

Is this manual MySQL option my only choice or am I missing something?  Just wanted to check before I start to do this the manual way.  Thanks!

I think you can handle this in the following manner:

I assume you have a unique ID on each of the contact you are importing.  If not create one. 
Create a batch ID which is the same for all contacts you will import
During the first round of import bring in the contacts and the primary address.
Put the unique ID in the "External ID" field within Civi
Put the batch ID within the "Source" field in Civi
Go through MySQL and get all the contacts with the batch ID, join to the address table and set all addresses to Primary
Then go back and using your unique IDs import the billing addresses
Go through mySQL again and get all contacts with the batch ID, join to the addresses table and mark all addresses as Billing that are not already marked as Primary

Hope that helps...

Roberto