[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Bulk import tool - account -parent account relationship mapping

Posted on 2007-11-22
1
Medium Priority
?
412 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 1500 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

590 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