Solved

Bulk import tool - account -parent account relationship mapping

Posted on 2007-11-22
1
409 Views
Last Modified: 2008-10-08
Hi
I have tow csvs parent and account. Both the csvs contains list of Accounts. The difference is that the parent.csv contains the list of all Accounts which will act as a parent account to others. Now for the question

The account.csv file contains two fields account name and parent name. THe parent name filed will be containing the values that are present in parent.csv.
How can I make sure that the tool will look up the GUID of the parent and insert it into the parent account field
0
Comment
Question by:sujithcnair
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
preitmeyer earned 500 total points
ID: 20396182
There is a great answer for this question, the answer is, it wont :-)
The ONLY way to use the built-in tool to map parent and child relationships is as follows:
1. Import all of your accounts marked as parent accounts
2. Go into SQL on the backend of the MSCRM database, into the AccountBase table and get all the GUID's for the accounts you just imported.
3. Map all of  your child accounts in the csv file to contain the guid where the old account-id used to be (I use vlookup for this in excel to map them accordingly)
4. Once you have a csv file with the proper parent account guid for each child, import the children with the "parent account" field set as the guid.

That's it.
For a good best practice here, when importing your original accounts, import the old AccountNumber (whatever it was before, not a guid) into a hidden field on the account entity so you can go back and check your work. This also makes things a LOT easier when creating the GUID mappings in Excel.
Good luck!
-Paul
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question