1 Reply Latest reply on May 15, 2017 11:22 PM by Ankit Gupta RSS
    hrastogi Explorer

    Is there a quick way to upload around 3000 records in a data table

    Please let me know if anyone of you is aware of a quick way to upload around 3000 records in a data table.

     

    Regards,

     

    Hemant

      • Re: Is there a quick way to upload around 3000 records in a data table
        Ankit Gupta Ninja

        Hi Hemant Rastogi,

         

        Per my understanding; following steps can be used:

        1. Import the csv file to the file repository.

        2. The path of the csv file can be taken using GetFileInfo service.

        3. Then, map the path from GetFileInfo service to LoadText service which will provide the csv content.

        4. Identify the Primary key in your Data; if there is none add a Id field which will primary the Primary key. (In this case we will have to iterate through the table to add distinct value to the primary key field)

        4. Create the DataShape which defines the structure of the data.

        5. Use AddDataTableEntries service of the DataTable to add the records to the DataTable.

         

        I hope it helps.