locked
Bulk Import RRS feed

  • Question

  •  

    Hi

       I want to import Accounts Data available in csv file into Accounts Entity. I tried to import the data from csv file to Accounts form. It is imported successfully.  I have two lookup fields in accounts form. When i opened  the imported account records in lookup field it is showing empty.  how to  solve this one. I am using Bulk Import tool which i downloaded from the net.

     

    Thanks

    Shaik

    Wednesday, November 7, 2007 7:17 AM

Answers

All replies

  • Lookup fields will not imported, you have to modify the code yourself. or use scribe.

     

    REgards,

    Imran

     

     

     

    Friday, January 11, 2008 7:03 AM
    Moderator
  • Lookup fields can be imported, however you to pass the entity's primary key (Guid) value, not the name. The most effective way to get the primary key values is via SQL queries. If you use Excel as the original source of data you can use the Excel VLOOKUP function in conjunction with a query to the CRM database to map the Guid values

    Friday, January 11, 2008 11:54 AM
    Moderator
  • Hi all.

     

    Posted the answer on another thread.

    http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2966322&SiteID=27

     

    Cheers,

    Adi

     

     

    Friday, March 7, 2008 4:41 PM
  • hi nazeer31

     

    can u send me the link where you downloaded the bulk import tool and a sample csv file format of your accounts data

     

    thanks

    lokesh

     

     

    Thursday, July 24, 2008 11:34 AM