Test Data Manager

Expand all | Collapse all

Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

  • 1.  Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

    Posted 09-29-2015 07:42 PM

    Suppose you have a use case where you imported data from an Excel file to a data pool and later you have additional data in another Excel file (with the same format) that you would like to append to the same data pool. The steps you would follow are:

     

    1. Rename the second Excel file (with additional data) so that the file name matches the first Excel file that you had successfully registered and imported.

    2. Register the second Excel file with the same project. This time on the registration screen, the workbook name should match the first Excel sheet that you had registered and imported from previously.

    3. Also, on the registration screen, make sure “Import Any Data” is checked and “Register” is unchecked. Then click the “Register/Import” button.


    DM_Register_second_Excel.jpg

    4. This will append the additional records to the same data pool.

     

    Note that if your data exists in a CSV file, you should be able to right-click on the data pool that has the initial data imported, and then click ‘Import External File Data’ and point to the CSV file.

    In this case, however, it is important that your CSV file does not contain the “Header” row with column names. Else, that will also get imported as a record in your Data pool.



  • 2.  Re: Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

    Posted 02-16-2017 04:55 PM

    Hi Sameer,

    When we are registering the CSV from TDod portal, do we have any option to import data on same DP.



  • 3.  Re: Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

    Posted 02-17-2017 11:15 AM

    Hi Anita,

    I do not know if there is a way to do this through the TDM portal.

     

    What I would suggest to do is to follow the above procedure through Datamaker, and then continue using the project/generator from the portal.

     

    Does that help?

     

    Cheers,

    Sameer



  • 4.  Re: Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

    Posted 02-28-2017 12:06 PM

    Hi Sameer,

     

    We have activity to load a csv  to be loaded in same table ( only diffential information should be loaded).

    Does TDM support automating this activity as weekly job instead of manually uploading csv every week.

     

    Regards,

    Anita