Import contacts from parent company

Highlighted
Contributor

We have a parent company with a separate Office 365 and Exchange Online. I have to import there contacts into our system. I see an option to export, but not to import.

 

The systems are not connected, two separate systems. So we are looking to import their contacts and I do an export of my contacts. We most likely want to do this every quarter.

 

 

 

 

5 Replies
Highlighted

Just to clarify, by "contacts" do you mean contact entries stored in the GAL, or stored in a specific mailbox? For the first scenario, you can use PowerShell to export/import them as needed, or use a specialized 3rd party tool (GalSync). For the second scenario, you will either have to export/import via Outlook, or by using EWS-based code.

Highlighted

Contacts for the GAL, so PowerShell then.

Highlighted

Yup, Get-MailContact should do the trick. It's relatively easy to automate this export via PowerShell, but as I mentioned above there are also specialized 3rd party tools for such scenarios, if you are willing to spend some $$.

Highlighted

@Jerry Gonzalez

 

I recently ran into the similar scenario with a client.  If you have the export in a CSV file you can use PowerShell to create the mail objects, using the New-MailContact cmdlet.

 

This is assuming you have column headers "DisplayName, PrimarySMTPAddress"

 

You could use something like this:

 

$csv = <Path to CSV>

$import = Import-Csv $csv

$import | Foreach {

New-MailContact -Name $_.DisplayName -ExternalEmailAddress $_.PrimarySMTPAddress

}

 

 

Highlighted
And for contact sync, include an export of the legacyExchangeDN value at source and import it as an additional proxyAddresses attribute starting "X500:" (that is, add X500: to the legDN value when importing it)