This site requires JavaScript to be enabled


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
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
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).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
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

Reinstantiate all Template Instances through automation/TCShell with referenced external excel file

Users can create Template instances or Reinstantiate multiple template instances folder through automation without manual intervention using TCshell.


The user has multiple templates with each of the template referring to each individual sheet in an external excel workbook/file.If and when the test/data sheets are modified, the user wants to create Template Instances/ Reinstantiate the already created template instances folders all at one go with manual intervention.


We can acheive the above mentioned scenario through the use of TCshell commands. 

1.If all the template instance folders are placed inside a common folder, then we can iterate through all the folders using the For syntax and perform a task operation on them.

The syntax:  For "=>SUBPARTS:TestCaseTemplateInstance" TaskOnAll "Reinstantiate Instance" runs a tql query on the particular folder containing the  template instance folders and the resinstantiates each folder.

2.If the tenplate instance folders are located in different locations/folders, then we can individually jump to that node and then perform a task on them.

In that case multiple jumpToNode statements must be used followed by the syntax:  task 1 or  task "Reinstantiate Instance".

The sample tcs and batch files are attached.You can run the tcs file from the cmd prompt or from a batch file.

The sample subset is attached which contains two test case templates referring to different sheets in an excel file.

Note: running a "task" command on a node lists out all different tasks that can be performed on them.Also refer the below links for more details.

[opt.] Reference


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial