Solved

Bulk import tool - account -parent account relationship mapping

Posted on 2007-11-22
1
399 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Dynamic CRM online Queries 1 105
Dependent Pick List - Dynamics CRM 2011 3 118
Microsoft Dynamics 365 2 312
crm development 2 98
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

726 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