Import CONTACTS from another system into CRM 4.0

(0) Share

Report

Posted on by RobertMTN

200

Please need to import CONTACTS from another system into CRM 4.0, however I need to keep the Contact ID (GuidID) from the original source... Cannot generate a new one.

Please how would I do that? Need to "insert" ContactBase and ContactExtensionBase (new) records...

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

RE: Import CONTACTS from another system into CRM 4.0

Hi Allaaqui,

Directly accessing the SQL Database and performing any sort of CRUD Operation is an unsupported customizations.

You need not insert any data to SQL rather use Import Data Wizard to map your existing GUID to the ContactId field, which stores the GUID of Contact Records.

Hope that helps

Thanks

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

RE: Import CONTACTS from another system into CRM 4.0

Hi Allaaqui,

you don't need to insert into Contactbase and ContactExtensionBase tables.. this not supported way by microsoft.

you can use CRM 4.0 web services to import contact data into CRM 4.0, and when importing in your program you need to set contact.contactid [CRM] value with existing GUID.. then CRM will not create new GUID for that record.. it will use assigned GUID.

Or if you are using CRM data import feature, then map contact ID from your existing system with ContactID primary key.

Here are some resources which might help you

blogs.msdn.com/.../understanding-crm-metadata-primarykey-and-primaryfield.aspx

www.powerobjects.com/.../dynamics-crm-using-scribe-insight-and-an-easy-way-to-link-accounts-and-contacts-when-migrating-data

www.powerobjects.com/.../utilizing-guids-for-importing-data-to-multiple-orgs-dynamics-crm

Hope this will help to solve you issue.

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

RE: Import CONTACTS from another system into CRM 4.0

Check the below post that provides all the steps required to import conatct into the crm

blogs.msdn.com/.../importing-data-in-crm-4-0-made-easier.aspx

Was this reply helpful? Yes No
RobertMTN 200 on at

Like (0)

Report

RE: Import CONTACTS from another system into CRM 4.0

Thank you... How and what do I use to import the Contact data?

Was this reply helpful? Yes No
Suggested answer

Royal King 27,686 on at

Like (0)

Report

RE: Import CONTACTS from another system into CRM 4.0

Mappping contact guid column to contact (primary key) field in CRM import process will add guid as primary key in CRM as well. You dont have to insert data into to 2 table CRM will take care of mapping values to the right table internally . All you have to do is mapping fields to right fields in contact entity.

Was this reply helpful? Yes No