Problem with BulkImport RRS feed

  • Question



      I am importing data into accounts form using Bulk Import. In Bulk Import there no code for LookUp fileds. In my accounts form I have two lookup fields for contacts and ownerid. I want to get the entity name for these lookup filelds dynamically using .net code. How do i get the entity names for these lookup fields




    Wednesday, November 14, 2007 11:15 AM


  • This one's tricky. You'll need to go into the database, get the GUIDs and entity names from there and then do a search and replace in your import file.

    How I did it was this...
    1. Export a list of GUIDs and entity names into a text file
    2. Read the import file into memory
    3. Read through the list file line by line and do a search and replace with the import data
    3.1 Just replace all the entity names with the GUIDs
    4. Write the import data in memory to a text file. But just remember to look through the list again before doing an import. There are bound to be errors.

    Tuesday, November 20, 2007 11:46 PM