locked
Problem with BulkImport RRS feed

  • Question

  •  

    Hi

      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

     

    thanks

    shaik

    Wednesday, November 14, 2007 11:15 AM

Answers

  • 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