This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

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


Situation

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

Solution

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:

 

 

Attachments
IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial