RPA: Using TDS to process mass data proviced in Excel
A lot of RPA use cases start with data stored in excel. TDS can be used to provide a scalable way to process excel data.
Note: This is a variant of https://support.tricentis.com/community/article.do?number=KB0013515 - the code is extended to support unattended use
RPA (Robotic Process Automation) is very useful to replace repetitive and tedious manual tasks like processing data provided in an excel sheet. A lot of times users are asked to run through hundreds of rows to enter e.g. data in an internal system.
Of course it can be done using the excel automation capabilities - however using TDS allows for more scalable and robust implementation of bots.
Note: The proposed solution can of course also be used to upload test data as part of the test execution
The attached Excel WorkBook "BulkExcel" contains a parameter worksheet which is used to parameterize the actual upload macro. This macro is an improved version of the original macro provided in https://support.tricentis.com/community/article.do?number=KB0013515
Note: The order of the parameter matters – there is no "intelligence" retrieval implemented yet.
You can still run the upload by clicking the button "Load Excel to TDS" but it also possible to use the SET "Run Excel Macro" to upload any excel sheet to TDS.
First of course you need open the Bulk Upload file and define the parameter range:
In the next step we will set the parameters:
For the sample I will always clean up the data category – in a real live scenario you would normally add data.
The parameter "Add Status Field" will automatically add a TDS attribute data_state to each record. This can be later used for processing purpose.
Finnally I am using "Run Excel Macro" to trigger the actual upload – the macro is called "Upload". At the end of course, I close the workbook.
Running this macro with an excel sheet containing 100 records results in a prepared TDS: