Migate frm Public contact folder to BCM supported by SQL


Patrick Pohlmann


I have the following task to to:

All our Contacts are in a public Contact Folder on Exchange 2003. These
Contacts are as well in a Table on a SQL 2005 Database (tbl_Contacts),
including entryID and a connection between Companies and the contacts
working for this companies (tbl_ContactLinks).

I now want to assign the data to BCM. There is now problem to sort the
public contact folder items in persons and companies and to copy them
afterwords to the approriate BCM Folders. But how can I make the connection
beetween them. Since the BCM Database is on my SQL 2005 as well, this should
be possible by SQL. But wich tables and fileds on BCM have to be modified?

Is there any documentation of the BCM database structure?

Thank you for your help.

Best regards

Viele Grüße








Check out the BCM SDK at MSDN (with your M-O-U-S-E...)http://msdn2.microsoft.com/en-us/library/aa431857.aspx


Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Managerwww.pinpointtools.com

- Show quoted text -

I would start with the BCM database's PublicAccountView and
PublicContactView, which were added in v3 for this purpose. Add the
companies to the PublicAccountView. The next time BCM runs it will
process the new entries in that view, turning them into BCM Accounts
and assigning them BCM IDs. You can then add the Contacts to
PublicContactView, using the IDs from PublicAccountView to maintain
the links.

You may be able to write a SQL script that adds a Company, gets the
Account number, and then adds that Company's contacts.

I'm not certain is Outlook needs to be running to generate the Account
IDs, but I would have it running. You can monitor progress by watching
the Accounts appear in the Outlook as they get added to the view and
processed by BCM.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question