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
Solved

Bulk import tool - account -parent account relationship mapping

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 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