This site requires JavaScript to be enabled
IE BUMPER

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
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
583 results in 11 categories found for excel
(ca. Seconds)
Results per page

How to delete values in Excel except Header row (Using Excel 3.0)

This article demonstrates how to delete values present in Excel file except Header Row using Excel 3.0 engine. (Tosca 12.1 and above) Situation User wants to delete all values present in an Excel file except Header row. Example: An Excel sheet contains total 51 Rows (includin [...]
Number KB0014894
Topic Knowledge Base
Category Guide
State Approval
Published

Store Excel worksheet/tab names in different buffers

This article shows how to store Excel worksheet or tab names in different buffers. Situation User wants to store Excel worksheet names in different buffers. Solution This can be achieved by scanning one of the Excel tab by using UIA engine.  1. Scan Excel tab [...]
Number KB0014656
Topic Knowledge Base
Category Guide
State Approval
Published

Using Tbox Excel Modules to read in and manipulate data

We will create a brief example test case to show how to use the new Tbox Excel Modules. Situation Being able to bring in excel contents to Tosca, and manupulate them like a table while using constraints, a new feature for Tosca 12.1! Solution We can buffer and use constra [...]
Number KB0014621
Topic Knowledge Base
Category Academy
State Approval
Published

How to verify or edit content in Excel sheets

This article contains a basic example of how data in Excel sheets can be verified or edited. Situation You would like to verify some data in your Excel sheet or modify the Excel sheet. This article will walk you through all the steps necessary to create an Excel file in a [...]
Number KB0012732
Topic Knowledge Base
Category Guide
State Draft
Published 2017-01-22

How to find the number of rows and columns for the Excel Table

This article describes how to find the number of rows and columns for the Excel Table. Situation I want to find the number of rows and columns for the Excel Table. Solution Please refer the below screenshot to find the number of rows and columns for Excel Table. Tosca 12. [...]
Number KB0014554
Topic Knowledge Base
Category Guide
State Approval
Published

How to get the No of Rows in which data is present in excel using Tbox excel Modules.

HOW TO GET THE NUMBER OF ROWS IN EXCEL AGAINST ANY COLUMN WITH TBOX EXCEL MODULES Situation Use case is that we need to get the Number of rows of the first name as shown in below screenshot: SOLUTION You can do the same as can be seen in the below screenshot. We can use n [...]
Number KB0014658
Topic Knowledge Base
Category Academy
State Approval
Published

How to get the No of Rows in which data is present in excel using Tbox excel Modules.

HOW TO GET THE NUMBER OF ROWS IN EXCEL AGAINST ANY COLUMN WITH TBOX EXCEL MODULES Situation Use case is that we need to get the Number of rows of the first name as shown in below screenshot: SOLUTION You can do the same as can be seen in the below screenshot. We can use n [...]
Number KB0014659
Topic Knowledge Base
Category Academy
State Approval
Published

How to buffer the RowCount and ColumnCount of an Excel file using TBox Excel modules?

This article will help you in getting the row count and column count of an excel file using TBox Excel modules. Situation You want to buffer the Row Count and Column Count of an excel file using TBox Excel modules. Solution In the case of TBox modules, we can [...]
Number KB0014963
Topic Knowledge Base
Category Guide
State Approval
Published

How to read all table data from MSSQL database and Insert in excel

This article describes how to read all table data from the MSSQL database and Insert in excel. Situation You want to read all table data from the MSSQL database and Insert in excel. Example: Solution Please refer to the steps to store data in excel from the database. S [...]
Number KB0015075
Topic Knowledge Base
Category Guide
State Approval
Published

Guide on how to generate custom excel based reporting out of Tosca

Tosca is a great tool with so many different features that it amazes on what it can achieve. This KB article can be a guide on how to create a Daily Status Report for various projects executed from Tosca (both manual and automation). We have Tosca Analytics which is web-based ava [...]
Number KB0012689
Topic Knowledge Base
Category Guide
State Approval
Published 2016-12-12

How to sort data of a column in an excel file

This article will help you in sorting the data of a column in an excel file. Situation You want to sort the data of a column in an excel file. Solution In order to sort the data of a column in an excel file Windows PowerShell has been used. Please find the below screenshot [...]
Number KB0015185
Topic Knowledge Base
Category Guide
State Approval
Published

Error : Unable to open registry key while doing row by row comparison in Tosca BI

Situation You are using Row by Row comparison module for comparing Excel files using ODBC driver as mentioned in this article  Your testcases were working earlier but suddenly you get below error message. There are two cases and you will get different errors based on what [...]
Number KB0014741
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

How to get row data and the row number for any column value in excel table

This article explains how to get row data and the row number for any column value in the excel table. Situation I want to get row data(FirstName, LastName) for a particular ID. I want to get the row number for a particular column value in the table. The table looks like [...]
Number KB0014443
Topic Knowledge Base
Category Guide
State Approval
Published

Copy Excel data from one worksheet/workbook to another worksheet/workbook

Copy Excel data This article contains key examples when user wants to buffer excel data in multiple different buffers for further evaluation on the values. Also, this article would help user when trying to copy data from one worksheet/workbook to another worksheet [...]
Number KB0014190
Topic Knowledge Base
Category Guide
State Approval
Published

Getting error : Table has no default property for input, when you try to input value into excel file

This KB helps you how to resolve "Table has no default property for input" error when you try to input value into an excel file using Excel 3.0 Engine. Situation When you try to input values into Excel using Excel engine 3.0, Tbox excel range manipulation module, you get [...]
Number KB0015139
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

How to copy data from a website and save it as an Excel file

This article contains key examples needed to copy information from a website with Tosca Commander. Then we can use that information in a buffer to save it to an excel document. Situation You would like to copy and save some data from a website into an Excel file. PREREQUISIT [...]
Number KB0013074
Topic Knowledge Base
Category Academy
State Approval
Published

Using TextStream to generate a text file from Excel Spreadsheet

This article is designed to show you how to write to a file using a Text Stream by pulling the data from an Excel Spreadsheet. Situation Your project may require you to write to a file using the Text Stream Module. You may need to loop through an Excel Spreadsheet to [...]
Number KB0012691
Topic Knowledge Base
Category Best Practice
State Technical Review
Published 2016-12-13

Copying Excel Data to TDM

User wants to copy data from Excel and paste it into the TDM Object Editor Solution : 1. Firstly, you need to download Aid Pack from supprot portal (Version Specific). 2. Within Aid Pack, with help of Excel Engine 3.0 module (Excel Open Workbook, Excel set header etc.) user f [...]
Number KB0013391
Topic Knowledge Base
Category Academy
State Approval
Published

Macro for TestCase Design (TCD) Export to Excel

This article is about an Excel Macro which is used to let your TCD Export look fancy. Situation Business users want to know which business data they actually use within their test cases. Since business users probably do not have access to Tosca, you need to export the TestShee [...]
Number KB0012368
Topic Knowledge Base
Category Best Practice
State Approval
Published 2016-04-06

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 unatte [...]
Number KB0014773
Topic Knowledge Base
Category Guide
State Published
Published 2019-10-23

Query an Excel File with Database Engine

This article explains how to connect to an Excel file using the Database Engine to perform SQL queries using the standard modules. Situation If you need to generate a baseline file, filter tables based on conditions, or generally run SQL queries against an Excel file. This wil [...]
Number KB0013106
Topic Knowledge Base
Category Academy
State Approval
Published

How to fix "Exception has been thrown by the target of an invocation" error in Excel .

Situation: A general error with the messege “Exception has been thrown by the target of an invocation” is observed while creating  template instances using excel sheet or using the Tbox excel Excel Modules .       Solution: This issue [...]
Number KB0015059
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

System.OutOfMemory Exceptions while testing databases and excel sheets.

Users may come accross this exception when running tests that need to process data from a database query or excel sheet. While Tosca Commander is capable of testing many things, the executing engine's overall performance is still limited by the machine's hardware. This ar [...]
Number KB0015089
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

How to get total number of sheets present in an Excel workbook

This article guide us on how to get total number of sheets available in an Excel workbook Situation User wants to store the count of total number of sheets/tabs present in an Excel workbook. In this case, output buffer should show value as 6 as total 6 sheets/tabs are avail [...]
Number KB0014644
Topic Knowledge Base
Category Guide
State Approval
Published

Bulk Upload and Download to the new Test Data Service via Excel

The new test data service doesn't provide bulk operations at the moment. A lot of our customers are still using excel as a data source. Attached excel sheet contains a macro to upload the content a work sheet to a test data repository and also to download the content of a t [...]
Number KB0013515
Topic Knowledge Base
Category Guide
State Approval
Published

UseCellTextAsValue Setting - Fetching data from excel template as it appears in the cell

Fetching the data from an excel file (XL references) as it appears in the cell by using the setting UseCellTextAsValue in the ToscaCommander.exe.config. Situation The user has designed the test case instances in an external excel file.It is then treated as a data source f [...]
Number KB0013681
Topic Knowledge Base
Category Academy
State Approval
Published

How to convert scientific format (e.g. e+) to original format in Tosca

This article explains how to convert scientific format (e.g. e+) to original format. Situation Read data from the excel Template: Whenever I read long digits value from excel, it reads the value in the scientific format (e.g. 4.5698752684E+15). Solution We can convert [...]
Number KB0014949
Topic Knowledge Base
Category Guide
State Approval
Published

How to reset an Excel worksheet to its default formatting

How to reset all the cells in an open Excel Worksheet to its default formatting Situation In case you want to reset all the cells in an open worksheet in Microsoft Excel (2013+) to it's default format settings, there is a simple workaround using Tosca Testsuite Solution [...]
Number KB0013464
Topic Knowledge Base
Category Guide
State Approval
Published

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. Situation The user has multiple templates with each of the template referring to each individual sheet in an external excel wor [...]
Number KB0013306
Topic Knowledge Base
Category Guide
State Approval
Published

Get Difference between two date time in Hours:Minutes:Second with or without excel installed

This article describes how to get the difference between two Date time (dd MM yy Hours:Minutes:Second) in format "Hours:Minutes:Second" with CALC function and without using CALC. Situation There can be a scenario where you want to find out the difference between DATE [...]
Number KB0014507
Topic Knowledge Base
Category Guide
State Approval
Published

Using values from an excel sheet to calculate different values for further use

This article describes how to get values from an excel sheet (which is not used as a data source for templates) do calculations on those values (specifically ranges) and save them to a buffer for further use. Situation Sometimes, it is not possible to use an excel sheet a [...]
Number KB0012430
Topic Knowledge Base
Category Guide
State Technical Review
Published 2016-05-11

Example: Comparing 2 Excel files

  This article shows how to use the Excel engine to compare 2 different Excel files and have the differences shown in the Execution result   Situation You want to compare 2 Excel files and log the differences into the result   Solution This c [...]
Number KB0011865
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-12-10

Reading strings from Excel and testing for equality in TDM Studio

Short summary what this article is about Situation Working with Excel always requires the utmost vigilance, as this experience report once again makes clear. Abandonment of an existing Q-upProject was to read test data from an Excel file. In order to further process these test [...]
Number KB0014289
Topic Knowledge Base
Category FAQ
State Approval
Published

Error when referencing Excel file

This article describes a possible solution for the error "Exception has been thrown by the target of an invocation". Another possible cause/solution to this error can also be found in the Knowledgebase article: TC Reinstantiation Error MS Excel 2010 Situation When assigning [...]
Number KB0012150
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2015-11-11

How to compare xlsx or xls files using Row by row comparison Module in BI

How to compare xlsx or xls files using Row by Row comparison Module in BI Situation Xlsx or xls files are not supported in row by row comparison module directly, you can either convert them to CSV files and then use them. Another method is to install an ODBC driver for e [...]
Number KB0014219
Topic Knowledge Base
Category Guide
State Approval
Published

Create a report in Microsoft Excel out of the raw license usage data

If you have Tricentis License Server version 1.2.0 installed, you have access to Tricentis License Usage Tracking. The license usage database collects your licensing data and updates the information every minute. You can query this data and create reports, for example in Microsof [...]
Number KB0014344
Topic Knowledge Base
Category Guide
State Approval
Published

How to handle Error :  VB Script file or VB6 keyboard>XL Open Workbook< does not exist

Situation Following error occurs during execution of Excel Open Workbook module from Aidpack. This error is occurring for all Aidpack Excel modules.   VB Script File or VB6 Keyword >XLOpenWorkbook< does not exist. Error executing teststep >Excel Open Workbook (M [...]
Number KB0014316
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

TC Reinstantiation Error MS Excel 2010

This articles describes the procedure for solving error messages, occurring after installing of MS Excel 2003 or 2010. Note that another possible cause for this error message is described in the article: Error when referencing Excel file Situation  The Re-Instantiat [...]
Number KB0011276
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2015-03-26

Reinstantation-Failure by using an Excel Schema

This article describes an error, occuring when instantiating a testcase Situation   If the error message "Reinstantiate failed!" appears during the instantiation of a testcase template with an Excel schema...     Solution  ...th [...]
Number KB0010766
Topic Knowledge Base
Category Troubleshooting
State Draft
Published 2014-05-14

How to use different date functions

Using different excel date functions in Tosca Situation How to use Different date functions Functions Weekday: To know if a date is which day of the week. Datedif: To know the difference between two dates (Number of days) If: To know if a date is greater than other [...]
Number KB0013636
Topic Knowledge Base
Category Guide
State Approval
Published

Steer CSV files with TBox DB Expert Module

Steering a CSV file in TBox without any classic modules like “Excel Engine” or “TextStream Engine”. Situation You must steer a CSV file named “test.csv” but can not use any classic engines. Solution ! This will only work with Tosca v11.3+ [...]
Number KB0014004
Topic Knowledge Base
Category Guide
State Approval
Published

Enter today's date in ordinal notation

This guide will show you how to be able to get today's date with ordinal notation (e.g. 3rd Dec 2018) Situation The requirement is to fetch and convert a date which usually comes in the system format like 12/3/2018 or 2018-12-03 into 3rd Dec 2018. Solution In order for t [...]
Number KB0014185
Topic Knowledge Base
Category Guide
State Approval
Published

How to view the differences between 2 PDF files

Link German version  Situation You have setup a ExecutionList with "TC PDF Compare" and want to view the differences between 2 PDF files after the execution Solution  Read the Manual for Tosca Viewer AND Details Viewer    Go in Tosca Com [...]
Number KB0013491
Topic Knowledge Base
Category Guide
State Approval
Published

Performance improvement during template instantiation with XL data source

This article describes how to use an alternative Excel interface to improve the performance of template instantiation. Situation When you use template instantiation you can use either a TestSheet or an ExcelSheet as your data source. If an ExcelSheet is used, Tosca will [...]
Number KB0012344
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2016-03-29

[CALC] Execution depends on MS Office installation extend

This article describes an error when using EXCEL 2010 incl. MUI-Pack without SP1 and Tosca 7.6.0 Situation An error message gets thrown when executing a CALC function:   "Error 1004 - Open method of the Workbooks could not be executed." TS:TC:->KFZ-Versicher [...]
Number KB0010985
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-07-28

XL-Connector: Warning in case of too many characters

This article describes an error that occurs when an XL-Cell contains more than 1024 characters. Situation An XL-Cell contains more than 1024 characters. If a template connects to an XL-Cell, that contains more than 1024 characters, the following behaviour occurs when (re) [...]
Number KB0010940
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-07-25

Implement a logical time axis (logical business days)

Setting-up a powerful test data management requires to implement a logical time axis, holding the required business days. The days need to be dynamic as well: as time goes by, the 15th of a month will be the 15th of May, the 15th of June, etc.. Your automated test data generator [...]
Number KB0012421
Topic Knowledge Base
Category Best Practice
State Technical Review
Published 2016-05-02

How to calculate the length of a string when Calc function fails

Situation Suppose we have a string stored in a buffer and we want to get the total number of characters of that particular string. We have a standard CALC LEN function provided by excel which can be used in Tosca to get the length of the string as below : {CALC[LEN("" [...]
Number KB0015200
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

CALC compendium

This article shows various examples on how to use Excel formulas in Tosca by using CALC Situation Important! If your Calc expression doesn´t work in Excel it won´t either do in Tosca.  Please note that depending on your localization settings chara [...]
Number KB0011963
Topic Knowledge Base
Category Troubleshooting
State Draft
Published 2015-04-12

Adding the Setting "UseCellTextAsValue"

This article shows how to create the setting "UseCellTextAsValue" This setting is available for the Tosca Versions 7.3.2 P1, 7.4.0 P1+2, all Versions > 7.4.1. Situation With this setting, it is possible to define how the Values from Excel are transferred to Tosca.Eith [...]
Number KB0011272
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-06-17

Best Practice: Upgrade Tosca or Tosca Server Version

This article describes where to find information when upgrading to a new version of Tosca or Tricentis Tosca Server. Before you start with the upgrade process to a new version of Tricentis Tosca or the Tricentis Tosca Server, please consult the Tosca Upgrade Manuals. The [...]
Number KB0010926
Topic Knowledge Base
Category Best Practice
State Published
Published 2015-11-02

Error Ambiguous Names for XL Paths found while linking the test sheet to the Template.

Short summary what this article is about Situation You are getting the error message “Ambiguous Names for XL Paths found” for some specific attributes while linking the test sheet to the Template. Solution When the module attribute names match with the structure [...]
Number KB0014782
Topic Knowledge Base
Category Guide
State Approval
Published

How to convert CSV to XLSX

Situation You want to Convert an .CSV file into .XLSX file    Solution The Use case can be achieved with the help of Powershell. Please find the below step   Explaination: * The above Test Step opens Powershell.exe * Runs the below argument to conver [...]
Number KB0015144
Topic Knowledge Base
Category Academy
State Approval
Published

Language Translation Using Tosca

Language Translation during run time execution and this will support only for classic engine Situation There might be situation where user trying to translate the languages.So in order to achieve translation through Tosca please do the prequiste settings by following the below [...]
Number KB0014274
Topic Knowledge Base
Category Guide
State Approval
Published

How to use Academy Training Dashboard

Designated user or user in position of authority requests access to Report/Dashboard to see training progress of users in company. Situation Designated user or user in position of authority requests access to Report/Dashboard to see training progress of users in company. Solu [...]
Number KB0014903
Topic Knowledge Base
Category Academy
State Approval
Published

Optimizing User management - NEW Feature for user registration

This article will help you to understand the idea behind using the 'User management feature' developed by Tricentis Operations and how it works from administrative and user perspective. Situation Prior to receiving access to our company website or the Learning Manageme [...]
Number KB0012802
Topic Knowledge Base
Category Guide
State Approval
Published 2017-03-21

CONVERT MONTH IN DATE EXPRESSION FROM ONE LANGUAGE TO OTHER

CONVERT MONTH IN DATE EXPRESSION FROM ONE LANGUAGE TO ANOTHER Situation You want to convert month in your Date from one language to another. For example: Actual Date[Swedish]: 14-Mai-19 Expected Date[English]: 14-May-19 Solution You want to convert date fetched from your [...]
Number KB0014700
Topic Knowledge Base
Category Best Practice
State Approval
Published

How to add leading zero(es) to numbers

You have a number and want to add leading zeroes. Situation This article explains how to add leading zeroes to numbers. For example, sometimes you might deal with numbers that do not have the same number of digits, however the system requires a fixed length for all num [...]
Number KB0014018
Topic Knowledge Base
Category Guide
State Draft
Published

How to create Custom Report

Report Customization Situation How to start Report Customization   Solution # Go to the reporting section of Tosca. # Right click on parent folder "Reporting" and click on "Create Report Definition"   # Drag an object of the desired " [...]
Number KB0013671
Topic Knowledge Base
Category Guide
State Approval
Published

How to get the date of the first Monday of the current week

How to get the date of the first Monday of the current week Situation : Suppose there  is a use case where the user wants to generate the first date of that week (say today is wednesday but the user wants to generate the date correspoinding to Monday i:e, the first day o [...]
Number KB0014696
Topic Knowledge Base
Category Guide
State Approval
Published

Get the current time in Epoch TIme Format

Current Time in Epoch TIme Format. Situation How to get the current time in Epoch Time format? Solution >  Epoch Time is the count of number of seconds that are being counted from 01-01-1970 00hours:00min:00sec to now. > So in order to get the Epoch Time, [...]
Number KB0014742
Topic Knowledge Base
Category Guide
State Approval
Published

How to do Camel Case styling using Tosca

Situation   What to do to convert "TRICENTIS" or "tricentis" to "Tricentis" using Tosca.   Solution   Use Tbox set buffer module, buffer the value "TRICENTIS" to Title. Then with another buffer you can camel case the s [...]
Number KB0014179
Topic Knowledge Base
Category Best Practice
State Approval
Published

OSV error "Found multiple matches with the same weight, aborting this match completely"

How to resolve the OSV error "Found multiple matches with the same weight, aborting this match completely" Situation You are sending a request to OSV, but no response is triggered. In the Environment Log you see the following error: Found multiple matches with the same [...]
Number KB0013721
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

Buffer - Convert date

This article shows how to convert a date format, which is stored in a buffer You can convert a date format, which is stored in a buffer, with the help of CALC and TC Set Buffer. For example: {CALC[    TEXT(    "{B[BVVonDate]}"    [...]
Number KB0010879
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-07-25

Change the database storage location of the License Usage Tracking

If you don't want to store the license usage statistics into a database on the system drive the following instructions will help Situation Your system drive (usually C:) storage is limited and it might not hold the accumulating data for long before you will get a warning t [...]
Number KB0014413
Topic Knowledge Base
Category Guide
State Approval
Published

Steering HTML Date Pickers / Calendars without customization

This article explains how to dynamically steer custom HTML Date Pickers (Calendars) using standard Tosca functionalities. We will be using the YUI Simple Calendar for our example but the same concepts can be applied to any HTML Date Picker control. Situation HTML Date Pickers [...]
Number KB0012504
Topic Knowledge Base
Category Guide
State Published
Published 2019-06-13

How to read, verify and modify CSV files with an SET

Note:   This example code is intended to demonstrate customization capabilities of the TOSCA Testsuite. It  '             is not part of the TOSCA Testsuite scope of delivery and TRICENTIS will not offer any support.  &# [...]
Number KB0015110
Topic Knowledge Base
Category Guide
State Approval
Published

How to convert a HTML Table to CSV

a short guide how to convert html tables into csv Disclaimer Please keep in mind when using external Frameworks, this method may render invalid. Situation You have a HTML page which includes a table, but you would need the data of the table in a .csv format. Solution Open [...]
Number KB0014897
Topic Knowledge Base
Category Guide
State Approval
Published

Change US/EU number formats with CALC

How to change US number format to EU and vice versa from a string. Situation You need to change the number format of a string. e.g.: 1.234.567,89 ⇄ 1,234,567.89 or 1.234.567,89 € ⇄ 1,234,567.89 $   Solution One way to achieve this would be over CALC with SUBSTITU [...]
Number KB0014846
Topic Knowledge Base
Category Guide
State Approval
Published

How is the Microsoft Office Open XML formats * .xlsx and * .accdb accessed via ODBC?

Short summary what this article is about Situation To access the Excel and Access format * .xlsx and * .accdb via ODBC connection, ODBC drivers must be installed. These are included in the Microsoft Office installation by default, but can also be installed separately without [...]
Number KB0014312
Topic Knowledge Base
Category FAQ
State Approval
Published
Results per page

Release Notes 8.1.0

Release Notes 8.1.0Webservice Engine 3.0The new Webservice Engine 3.0 uses cutting-edge features of Tosca TBox and allows web services to be tested automated with SOAP.The engine supports synchronous and asynchronous calls, SSL, authentication, proxies, session cookies, MTOM and [...]
Author Herbert Linhard
Published 2014-06-06 09:21:13
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 384
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:12:02

Release Notes 8.1.0

Release Notes 8.1.0Webservice Engine 3.0Die neue Webservice Engine 3.0 nutzt die innovativen Features der Tosca TBox und erlaubt Ihnen das automatisierte Testen von Webservices mit SOAP.Unterstützt werden unter anderem synchrone und asynchrone Aufrufe, SSL, Authentifizierung, Pro [...]
Author Herbert Linhard
Published 2014-06-06 09:21:13
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 13
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:11:53

Software Testers: Get Started with ETL, Data Warehouse, and BI Testing

Editor’s note: Wayne Yaddow is an independent consultant with over 20 years’ experience leading data migration/integration/ETL testing projects at organizations including J.P. Morgan Chase, Credit Suisse, Standard and Poor’s, AIG, Oppenheimer Funds, IBM, and Achieve3000.  Additio [...]
Author Sanal Nair
Published 2018-10-03 18:11:36
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 54
Upvotes
Comments 0
Helpful 1
Last Updated on 2018-10-09 10:11:15

Change log 8.1.0

Basic Window Operations* The Module TC Save as has been entirely reworked and is now language-independent.Buffer Operations* The description of the Module TC Partial Buffer has been revised.Excel Engine* The ModuleAttribute names of the Module Excel Range Manipulation have been t [...]
Author Alexander Kleemann
Published 2014-06-06 09:21:12
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 254
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:12:09

Change log 8.1.0

Basic Window Operations* Das Modul TC Save as wurde komplett überarbeitet und kann jetzt sprachunabhängig verwendet werden.Buffer Operations* Die Beschreibung des Moduls TC Partial Buffer wurde korrigiert.Excel Engine* Die Bezeichnungen der Modulattribute des Moduls Excel Range M [...]
Author Alexander Kleemann
Published 2014-06-06 09:21:12
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 16
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:11:44

Release Notes 8.0.1

TBoxXScanMit der Version 8.0.1 wurde der Xscan-Dialog überarbeitet um noch besser und schneller zu Ergebnissen zu führen. Dank Ihres Feedbacks konnten wir einige kleine, aber sehr nützliche Verbesserungen der Usability realisieren.ScratchbookBei der Erstellung von Testfällen werd [...]
Author Robin Taylor
Published 2014-06-06 09:21:11
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 16
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:11:57

Release Notes 8.0.1

TBoxXScanThe XScan dialog has been reworked with version 8.0.1. As a result, users are now able to obtain results faster and more easily than before. Thanks to your feedback we were able to enhance the usability.ScratchBookFrom now on, you will benefit from the help of the Scratc [...]
Author Robin Taylor
Published 2014-06-06 09:21:11
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 275
Upvotes
Comments 0
Helpful
Last Updated on 2016-07-14 07:11:52

Getting Started with Test Automation: How to Structure Your Team

Editor’s note: Test automation has always been important for increasing the speed, accuracy, and repeatability of testing—but Agile and DevOps had made automation an imperative. Nevertheless, test automation rates remain dismally low: well under 20%. One way to boost your likelih [...]
Author Sanal Nair
Published 2018-10-03 18:13:10
Forum Tricentis Tosca
Posted in Tricentis Tosca
Views 45
Upvotes
Comments 0
Helpful 1
Last Updated on 2018-10-09 10:10:49

Accelerate 2018 Highlights: Digital Transformation Requires Continuous Testing

Continuous Testing [boom boom boomp] Continuous Testing [boom boom boomp] Continuous Testing [boom boom boomp]  If you were among the 2000&amp;#43; attendees at Tricentis Accelerate—now Europe’s largest software testing conference—you probably can’t get that loop out of your head (th [...]
Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Tricentis Tosca: Excel Operation Write to a Cell

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to Enter Data into an Excel File

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Tricentis Tosca: Excel Operation Fetch Value

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Tricentis Tosca: Excel Operation Write to a Cell

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How To: Fetch Row Count and Column Count from an Excel Table

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How To: Create New WorkBook and Worksheet in Workbook (Excel)

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Excel validations in excel 2016

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How can you load an Excel File into Tosca BI?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

All the columns and rows present in the table are copied in the same cell in Excel while using Buffe

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Iterating an Excel file

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Question how to: using an array to loop through an excel spreadsheet

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Dealing with Dates using Excel XDS

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Welche Version von Microsoft Excel wird untersützt?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Excel versus Testcase Design add-in (Comparative study)

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Issue with fetching Test data from Excel

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to Buffer value from excel sheet?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to get the row number of a cell from excel sheet

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to Adjust Column width and color the cell in Excel using TOSCA

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Comparing 2 excel or 2 word files using Tosca

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Reading Excel file in Standard Module(Row by Row comparison) Exception: DB to File comparison

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Import Test Sheet and Output Results in Excel

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to login multiple user from excel for Tosca Trail version

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to execute testcases dynamically from excel sheet in Tosca?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Not able to open excel workbook

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

data in excel as input of DB2 query and output of DB2 will be input in SQL.

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Is it possible to use condition on the teststep/testcase when we are using an excel template?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Working with data from excel sheets

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Comparing two Excel xlsx files with Tosca

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Solution required-script has to iterate through the excel sheet rows and fetch the data from a row t

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to buffer the result table to excel after executing query in DB via Tosca?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Excel sheet download problem from ALV

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Export Test Cases from Tosca to MS EXCEL

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Excel Automation

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Exporting table/sql result to an Excel/csv

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Upload Manual Test Cases from MS EXCEL to TOSCA

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

There are No Excel Engine and Patch03 in Exchange Portal

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Excel Engine - Neue Zeile oder Rowcount

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

TOSCA - How to extract data from webpage to excel/XML using tosca

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to get row count and column Count and how to store entire results in Excel File

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Copy specific columns from one excel to another

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Providing the TOSCA template condition using excel

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Extract 'Execution time/duration' of an execution into a custom Report or Excel.

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to remove entire row in an excel sheet?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

SAP table to excel or xml

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to validate whether excel file has downloaded or not.

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Is there any option to upload the attributes and the corresponding data from an excel into Test Case

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to save an excel file to a location in my machine?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

I am not able to retrieve the downloaded Excel file name

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to buffer all the rows and columns from SQL query result and paste it in excel?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Could you please help me &quot; Passing Test Data From Excel to Test Steps&quot;

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Question: Instantiation Error! Data not passing from Excel spreadsheet.. Why not &amp; How?!

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Why does Tosca force me to use Excel when trying to connect to an sql db?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Bring Test information from Excel utilizing TOSCA?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Questions on 12.1 Compare functionality

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Need to verify the text value from DB result set against standard template

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Is it possible to search the content of embedded documents

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Improvements To TOSCA which I feel great to have

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Buffering Filename from Local Harddrive

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to overcome the non availability of Exit OR Break function in Tosca

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to verify a partial file name that has been downloaded

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Issue with datasource on templates

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

HOW TO TRIM OUTPUT/BUFFER VALUE

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Notes Function for Test Steps or Test Cases?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to make tosca return the result of a calculation in standard notation instead of scientific nota

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Error Exception from HRESULT: 0x800A03EC

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Test Automation

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Sharing Reporting Templates

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Supporting different risk weight calculations in requirement sections

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

CALC function.

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

How to take Result extract from Table (Buffer) after executing SQL Query through Tosca BI

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Adding a new &quot;Status&quot; beside Pass, Fail, Blocked

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

TDM implementation

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

TOSCA Reporting - Creating custom reports

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Where can I find the answers for the below listed questions?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

PATGuard 2 Elite License Issues

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

General clarifications on TOSCA

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

TBOX Sendkeys

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Can we delete complete column and column values in TDS table?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Need inputs on Validations - SAP automation

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

if screen resolution changes does tosca scripts will work? Tosca ll be able to find the object?

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Template Instanzen mit Testfällen verlinken

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

how to calc function with if condition

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Control Properties

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44

Pasting data to a newly created file

Author Sanal Nair
Published 2018-10-16 12:16:43
Forum Accelerate
Posted in Accelerate
Views 12
Upvotes
Comments 0
Helpful 0
Last Updated on 2018-10-16 10:16:44
Results per page

Tricentis Academy: New Course – RPA Specialist

Tricentis Academy is delighted to announce the launch of a new course: RPA Specialist The RPA Specialist course is your first step to becoming specialized in Robotic Process Automation with Tricentis. The course will take you through foundational knowledge of RPA, RPA Studio an [...]
Number NEW0000308
Category News
Created 2019-07-25 17:09:01
Tosca Version
Results per page

EXCEL I Migration of the Module TC EXCEL Module

EXCEL I Migration of the Module TC EXCEL Module The module TC EXCEL Module is used exclusively to steer existing TestCases from older Tosca Commander™ versions. The following preparatory steps are necessary to use the Module from version 6.6.0: Adjusting TestCases that use a buf [...]
Version 13.1

EXCEL I Create Range

EXCEL I Create Range Allows a range to be specified for the active worksheet. When you specify a new range, the new range is automatically set as the active range. Properties Properties - Create range Attribute Description Range ID The range ID by which this range can be reused. [...]
Version 13.1

Transfer execution results to Excel

Transfer execution results to Excel The Detail column in Tosca Commander contains the results of your ExecutionList as numerical values. You can transfer these values to Microsoft® Excel, which allows you to further process and analyze this data with third-party software. To tra [...]
Version 13.1

EXCEL I Set Header

EXCEL I Set Header The module Set Header serves to determine the header in the currently active range. Properties Properties - Set Header Attribute Description Startcell.Row Defines the starting row of the header within the active range. Syntax: # In this example, row [...]
Version 13.1

EXCEL I Set Active Workbook

EXCEL I Set Active Workbook The Module Set Active Workbook sets the desired Microsoft® Excel file as the active workbook. Properties Properties - Set Active Worksheet Attribute Description Workbook ID ID of the Microsoft® Excel file that has been set as the active workbook. In t [...]
Version 13.1

Settings - Excel

Settings - Excel The following setting is located at Settings->Wizard->Excel: NameOfTheTableModule This is the name of the table steering module. The name must be XLTABSTR. -- Was this information helpful? Tricentis Tosca Manual 13.1 © Tricentis GmbH /* */ -- /* */
Version 13.1

EXCEL I Open Workbook

EXCEL I Open Workbook Properties Properties - Open workbook Attribute Description Workbook Path of the Microsoft® Excel file to be opened Workbook ID ID of the Microsoft® Excel file to be opened (optional) Each workbook needs a unique ID. If the user does not assign an ID to a wo [...]
Version 13.1

EXCEL IGet Active Excel Application

EXCEL IGet Active Excel Application The Module Get Active Excel Application allows an already open Excel instance to be identified and used. The Excel instance does not have to be opened ahead of time with the Tosca Excel Engine. Properties Properties for Set Active Worksheet Att [...]
Version 13.1

EXCEL I Close Workbook

EXCEL I Close Workbook The module Close Workbook closes the Microsoft® Excel file. Properties Properties - Close Workbook Attribute Description Workbook ID ID of the Microsoft® Excel file to be closed. Save Workbook Defines whether the Microsoft® Excel file is to be saved. The de [...]
Version 13.1

Excel Modules

Excel Modules The folder TBox XEngines->Excel in the Standard subset contains Modules that perform specific tasks for the Excel Engine 3.0. TBox Open Excel Workbook TBox Define Excel Range TBox Create Excel Worksheet TBox Excel Range Manipulation TBox Run Excel Macro TBox Close [...]
Version 13.1

EXCEL I Object model

EXCEL I Object model To use the following commands both effectively and efficiently, you should understand the object model of Microsoft® Excel: Some of the commands are context-sensitive. In connection with the command Set Active Worksheet, for example, you can only select one w [...]
Version 13.1

EXCEL I Installing the Engine

EXCEL I Installing the Engine The Tosca Excel Engine is installed by default as part of a complete Tricentis Tosca installation. All information regarding software versions and hardware requirements for the Engine can be found in the "System Requirements for Tricentis Tosca 13.1" [...]
Version 13.1

Excel Engine 3.0

Excel Engine 3.0 Use the Excel Engine 3.0 to test Microsoft Excel files 2007 and higher. It supports the following file extensions: .xls,.xlsb,.xlsx,.xlm,.xlsm,.xlt,.xltx,.xltm. Installation The Excel Engine 3.0 is part of the Tricentis Tosca standard installation. For detailed [...]
Version 13.1

Using test data from Excel

Using test data from Excel Test case data can be managed in Excel. This requires an Excel spreadsheet which arranges the test data in rows and columns. For further information on supported Excel versions, please refer to the System requirements. The TestCases are represented by c [...]
Version 13.1

EXCEL I Set Active Worksheet

EXCEL I Set Active Worksheet The module Set Active Worksheet sets the desired worksheet as the active worksheet via its ID. Properties Properties - Set Active Worksheet Attribute Description Worksheet ID ID of the Worksheet that is to become the active worksheet for the active wo [...]
Version 13.1

EXCEL I Set Active Range

EXCEL I Set Active Range The module Set Active Range sets the desired range as the active range via its ID. Properties Properties - Set Active Range Attribute Description Range ID Defines the ID of the range, which should be the active range for the current worksheet. In this exa [...]
Version 13.1

EXCEL IRange Manipulation

EXCEL IRange Manipulation The module Range Manipulation serves to steer ranges and to perform actions. Properties Properties - Range Manipulation Attribute Description Range Table steering for the currently active range. All functions of the general table steering are available ( [...]
Version 13.1

Excel Engine

Excel Engine This package contains the Modules of Tosca Excel Engine. A detailed description of the functions of Tosca Excel Engine can be found in chapter "EXCEL IModules". -- Was this information helpful? Tricentis Tosca Manual 13.1 © Tricentis GmbH /* */ -- /* */
Version 13.1

EXCEL IFiles and directories

EXCEL IFiles and directories The Tosca Excel Engine consists of the following files. The directory %TRICENTIS_HOME% must contain the following subdirectories and files: %TRICENTIS_HOME%\dll \XLEngine.dll\XLTosca.dll ObjectMappings.dat The file ObjectMappings.dat is stored by def [...]
Version 13.1

Steer Excel files

Steer Excel files To steer Microsoft® Excel files, you have to create Excel Engine 3.0 TestCases. The Standard subset contains all Modules that you need to create an Excel TestCase. You can find these Modules under Standard modules->TBox XEngines->Excel. TBox Open Excel Workbook [...]
Version 13.1

EXCEL IModules

EXCEL IModules Tricentis provides the Tosca Excel Modules, which can be imported as a subset to Tosca Commander™, via the Tosca Exchange Portal. -- Was this information helpful? Tricentis Tosca Manual 13.1 © Tricentis GmbH /* */ -- /* */
Version 13.1

Dynamic expressions

Dynamic expressions Dynamic expressions are used if values are needed for test specification that are not generated until the TestCases have been executed. Dynamic expressions can be used on both the Module and the TestCase level. Examples: the current date the current first of [...]
Version 13.1

CALC - More than a little Helper

CALC - More than a little Helper The CALC function is a powerful tool made available to you in Tricentis Tosca. But how can you use it practically? In this article you will learn how to use CALC (even with buffers) for executing both elementary and a many other additional functio [...]
Version 13.1

Assigning test data to templates

Assigning test data to templates If a TestCase is marked as a TestCase Template, it must refer to a template, which is provided as the data source, so that TestSteps can be associated with test data. TestCase-Design Sheet or Class For further information on combining TestCase-Des [...]
Version 13.1

Perform calculations

Perform calculations To perform calculations in your tests, use the expressions CALC or MATH. Use CALC if you have Microsoft® Excel installed. Use MATH if you do not have Microsoft® Excel installed. Use CALC Use the following syntax for CALC: Syntax: {CALC[
Version 13.1

Edit values

Edit values In an OSV Scenario, Module Attributes represent relevant message elements that you use for testing, such as a date or customer ID. To steer these Module Attributes during your test activities, you use values and ActionModes. Tricentis Tosca helps you add default valu [...]
Version 13.1

Use the context menu and mini toolbar

Use the context menu and mini toolbar Options in Tosca Commander are provided via the context menu: simply right-click onto an object to access these options. Many context menu options are also provided via the dynamic menu. The upper part of the context menu includes a mini too [...]
Version 13.1

Settings - Translation

Settings - Translation The following settings can be found under Settings->Engine->Translation. These settings are used for translating values (see chapter "Translating values"). Enable Translation Mode Description This setting must be activated for the translation to take place. [...]
Version 13.1

SAP I TableTree

SAP I TableTree The Module SAP TableTree is used for steering table trees. You can steer SAP TableTrees with SAP Engine 3.0. For detailed information, see chapter "SAP TableTree". Unlike TreeViews, TableTrees contain a tree in the first column and tables in the second column. Th [...]
Version 13.1

Example TQL solutions

Example TQL solutions The examples in this chapter illustrate how typical problems are solved using TQL and the sample application Vehicle insurance calculator. TestCase and Module have been selected in the examples below in order to search for their properties. The illustration [...]
Version 13.1

Comparing tables - Baseline

Comparing tables - Baseline Tosca allows the current content of a table to be compared with the previously saved content of the same table. This generates a base file in xml format (BaseLine). In all future executions, a new file (Dump) is generated which is compared with the b [...]
Version 13.1

System requirements for Tricentis Tosca

System Requirements for Tricentis Tosca 13.1 To use all Tosca features and functions, local administrator rights are required for the installation. Write permission for the directory %TRICENTIS_PROJECTS% is required to operate Tricentis Tosca. Hardware requirements for Tosca Com [...]
Version 13.1

Creating TemplateInstances

Creating TemplateInstances TestCase TemplateInstances serve as containers for TestCases that are dynamically generated from a TestCase Template. TestCase TemplateInstances have to be linked to a data source, from which the data for generating the TestCases is read. Each template [...]
Version 13.1

SAP I Steering tables

SAP I Steering tables The control type SAPTable is used for steering SAP tables in Tosca Commander™. Unlike simple controls, tables provide additional attributes that are required to steer tables, e.g. Row and Column. You can steer SAP tables with SAP Engine 3.0. For detailed in [...]
Version 13.1

Test Data Management: an Example

Test Data Management: an Example Test data management serves to manage, use and reuse test data. In addition, a TQL syntax can be used to search for appropriate objects in the test data repository. The example below describes the basic procedures of test data management. For a mo [...]
Version 13.1

Settings - TestCase from XL

Settings - TestCase from XL The following settings can be found under Settings->TestCase from XL. BusinessObjects’ Workbook Description List of paths and file names of the worksheets with business objects, separated by semicolons ; Example   Domains’ Workbook Description List of [...]
Version 13.1

Create ExportFormat-Parameters

Create ExportFormat-Parameters When you print a report, you can specify the output settings in the Print Options dialog. Alternatively, you can create ExportFormat parameters directly in Tosca Commander. The system automatically transfers them to your report. To create an Expor [...]
Version 13.1

Settings - TestSet

Settings - TestSet The following settings can be found under Settings->TestCase from XL->TestSet. If required, standard values can be defined for settings (Excel template). Domain column Description Specifies the column, which is defined as domain. The column must always be posi [...]
Version 13.1

Transfer used values

Transfer used values The Used value column of an ExecutionList shows the values you used in your TestStep. If you, for instance, used dynamic values in your tests, the column displays the actual, used value once execution has finished. If you want to re-test your TestCases with [...]
Version 13.1

Options - ReportingAddIn

Options - ReportingAddIn You can specify various settings in the Reporting section of the Options dialog. You can find the settings described below under Project -> Options -> Reporting. DefaultPrintOutputFormat Allows you to define the output format for reports. Value Descripti [...]
Version 13.1

Dynamic menu - Reporting

Dynamic menu - Reporting This dynamic menu includes options that can be selected within the Reporting section in Tosca Commander. The Create Folder option in the dynamic menu Reporting provides the following options: Menu options for Create Folder in the dynamic menu Reporting O [...]
Version 13.1

Edit objects

Edit objects Tosca TDM ObjectEditor is a program integrated into Tosca which serves to display and edit TDM objects in a TDM repository. The Tosca TDM ObjectEditor is located in the directory %COMMANDER_HOME% and can be opened directly via the TDMObjectEditor.exe file. The Tosc [...]
Version 13.1

Settings - Engine Calculator

Settings - Engine Calculator The following setting can be found at Settings->Engine->Engine Calculator: Use Excel localization Description This setting is relevant to users of the CALC function (see chapter "Calculations"). Please note that this setting applies only to classic e [...]
Version 13.1

Export and import specified records

Export and import specified records In case security is enabled and the selected repository is authorized, the functionality described on this page may be restricted depending on the user groups you belong to. Contact your Administrator for access rights (read/write content and c [...]
Version 13.1

Create a report definition

Create a report definition In order to create a report, you first need to create a report definition. This is the basic framework of the report within which you can define your datasets and design your report. To create a report definition, follow the steps below: Navigate to th [...]
Version 13.1

Working with TestCase templates

Working with TestCase templates Templates are models for concrete TestCases. TestCases with a similar sequence can be generalized with a template and be dynamically created using an external DataSource. This process is called dynamic TestCase generation. Select the option Conver [...]
Version 13.1

List of object icons

List of object icons Use the chart below as a quick reference for icons used in Tosca Commander. Icons in Tosca Commander TestCases TestCase folder TestCase Business TestCase TestStep folder TestStep, XTestStep Manual TestStep TestCase Templates, Business TestCase Templates Temp [...]
Version 13.1

TOSCACommander.exe.config

TOSCACommander.exe.config The TOSCACommander.exe.config file contains application settings for Tosca Commander, and default values for user-specific settings. The TOSCACommander.exe.config file is located in the following directory: %COMMANDER_HOME%. Only administrators can make [...]
Version 13.1

Steer with Classic Engines

Steer with Classic Engines You plan, create, and prompt the execution of your tests in Tosca Commander. Tosca Commander forwards the information to the respective Classic Engine (see list below), which performs the actual steering. After the execution has finished, the Classic E [...]
Version 13.1

Options - General

Options - General You can specify various settings in the General section of the Options dialog. You can find the settings described below under Project -> Options -> General. Options - General Minimize on Execution/Scan Minimizes Tosca Commander™ while TestCases are executed or [...]
Version 13.1

Creating TestCases dynamically

Creating TestCases dynamically In Tosca Commander™, all required input and verification parameters are specified in the TestCases. The concept of dynamic TestCase creation enables separating the TestCases from the test data in the template (Microsoft® Excel or TestCase-Design). B [...]
Version 13.1

Specify values

Specify values In addition to simple character strings and numerical data, you can specify the following values in the Value column: "Keyboard commands": simulate keyboard commands "Click operations": perform mouse-clicks "Text expressions": use values you have previously saved, [...]
Version 13.1

Ways to design your Scenario

Ways to design your Scenario Business Scenarios consist of one or more inbound and outbound messages. The OSV Host uses the values of specific message elements as identifiers to start or resume business Scenarios. With the help of these identifiers, the system assigns inbound me [...]
Version 13.1

Work with execution results

Work with execution results Once you have run your ExecutionLists, you can analyze and process the results of your tests. ExecutionList Insurance app tests after execution In addition to your folder structure, ExecutionLists typically contain the following objects: Object Descrip [...]
Version 13.1

Modify objects via the context menu

Modify objects via the context menu In Tosca Commander you can easily modify objects and their properties via the context menu. Whether specific parameters are available for selection or not depends mainly on the selected object. You can call up this function by right-clicking on [...]
Version 13.1

Steering tables

Steering tables The following chapters contain a detailed description of general table steering. General table steering is supported by the following Tosca Engines: Database Engine Delphi Engine DotNet Engine Excel Engine Flash Engine Firefox Engine Gupta Engine Host Engine HTML [...]
Version 13.1

TBox XEngines Modules in the Standard subset

TBox XEngines Modules in the Standard subset The folder Standard modules->TBox XEngines in the Tricentis Tosca Standard subset contains XModules that perform specific tasks for 3.0 Engines. The folder has the following sub-folders: Examples Parameter Data Database HTML File XML J [...]
Version 13.1

Check the Environment Log

Check the Environment Log The Environment Log provides you with information on the OSV Environment to which you are connected. The log entries show which activities you have performed in this environment. To open the Environment Log, click on Environment in the Home menu. The l [...]
Version 13.1

Tosca BI Reconciliation testing

Tosca BI Reconciliation testing You can use Reconciliation tests if you want to perform an in-depth comparison of each individual source row with each target row. While aggregated tests are much faster, Reconciliation tests are more precise. They provide you with a detailed repor [...]
Version 13.1

Use TestSheets

Use TestSheets TestSheets are the basic framework in TestCase-Design. You use them to organize your test data in order to have a logical testing structure. Each requirement of your application should be covered by a TestSheet. In your TestSheet, you can either use TestCase-Desig [...]
Version 13.1

Used Values and ActionModes

Used Values and ActionModes During test execution, Tosca Commander™ can transfer values to the test object to be verified or read out. This can be carried out with the aid of the ActionModes Input, Verify, Buffer and Output . The values that have been entered into the TestStep ar [...]
Version 13.1

Tosca BI Report testing

Tosca BI Report testing Report testing includes tests related to the presentation and content of reports. Typically, these are HTML reports which can be tested with the XBrowser Engine 3.0. Tosca also offers support for other technologies via the API Engine 3.0 for webservices, t [...]
Version 13.1

Dynamic menu - TestCaseDesign

Dynamic menu - TestCaseDesign This dynamic menu includes options that can be selected within the TestCaseDesign section in Tosca Commander. The Create Folder option in the dynamic menu TestCaseDesign provides the following options: Menu options for Create Folder in the dynamic me [...]
Version 13.1
Results per page

Example | Table steering

Example | Table steering This example shows how to work with tables in RPA Studio. Goal You want to automate the following process: Take user data from a table. Insert the data into a form in your application as part of a particular transaction. Update the table with the transact [...]
Version latest

Modules in the RPA subset

Modules in the RPA subset The RPA subset contains three main folders: Automation Tools: Modules to perform automation operations Automation Engines: Modules based on specific automation engines Data Management: Modules to manipulate Test Data Service database records For a detai [...]
Version latest

Specify table headers

Specify table headers Every table has headers: header rows and/or header columns. RPA Studio automatically assigns header rows: During the scan if you scan a table in your application In the Excel Modules of the RPA subset If you want to add header columns, or if you want to spec [...]
Version latest

Write data into a table

Write data into a table When you work with tables, you might want to enter data. Let's say you have gone through a process in your application that results in an ID number. Now you want to write this ID number into a specific cell in your table. To write data into a table, you [...]
Version latest

Work with tables

Work with tables RPA Studio supports the following table types: tables in your application that you have scanned Microsoft Excel tables that you steer with the Excel Modules of the RPA subset Within these tables, you steer individual cells. For instance, a Bot can insert a given [...]
Version latest
Results per page

Create Excel Report Actions

Create Excel Report Actions Create Excel Report actions write the contents of one or more Table datasets or parameters to a Microsoft Excel worksheet. The worksheet is created from a template that may be uploaded by selecting the Data/Report Templates/Excel Templates folder i [...]
Version 3.9.4

Uploading App Parameter Values from Excel

Uploading App Parameter Values from Excel The Consumer interface for Apps allows values for Pair List, Select List, String List and Table parameters to be uploaded from an Excel spreadsheet. This may be done from the editor screens for each of the parameter types. To upload [...]
Version 3.9.4

View Excel Templates

View Excel Templates Select the Data/Report Templates/Excel Templates folder in the LiveCompare hierarchy to display the Excel Templates (Report Templates Folder) screen. This screen shows the Microsoft Excel template worksheets that have been uploaded to the LiveCompare serve [...]
Version 3.9.4

View Datasets - Comparison Results

View Datasets - Comparison Results When a Compare View action is run, the associated View dataset is populated with comparison results for each of the table views compared. View datasets have the following structure: &lt;Dataset Name&gt; (View Dataset) &lt;Table 1&gt; &lt;Table N&gt; Entities [...]
Version 3.9.4

SAP HANA Migration Assessment Summary Excel Report

SAP HANA Migration Assessment Summary Excel Report The SAP HANA Migration Assessment Summary Excel report provides a summary of the upgrade tasks in each of the Development, Testing, Integration, Security and Training areas. It also provides an estimate of the time required to pe [...]
Version 3.9.4

Creating External Data Sources

Creating External Data Sources External Data Sources allow workflow data to be read from or written to an external source, for example: An existing SQLite, SQL Server, DB2 or Access database table. An Excel spreadsheet. A CSV file. A custom data source defined by specifying a [...]
Version 3.9.4

View Datasets - Retrieval Results

View Datasets - Retrieval Results When a Retrieve View action is run, the associated View dataset is populated with objects representing the table data retrieved. View datasets have the following structure: &lt;Dataset Name&gt; (View Dataset) &lt;Table 1&gt; &lt;Table N&gt; Entities &lt;Dataset [...]
Version 3.9.4

Folder Objects

Folder Objects When a folder object is selected in a Hierarchy dataset, the Details pane displays a table listing all the objects retrieved into the folder. The table has the following columns: Column Description Status If the Hierarchy dataset contains comparison results, th [...]
Version 3.9.4

Table Set Datasets

Table Set Datasets Table Set datasets are populated by LiveCompare actions where the results are stored in several tables. For example, the Retrieve Table Set action retrieves the contents of a list of tables from a specified RFC Destination. When a Table Set dataset is popula [...]
Version 3.9.4

Editing Table Parameters

Editing Table Parameters An App variant’s Table parameters may be edited by clicking their ‘Edit…’ buttons in the Consumer interface’s Variant screen. A Table parameter may be modified as follows: To add a new row, click ‘Add Row’ and complete the field values. To modify an e [...]
Version 3.9.4

Editing String List Parameters

Editing String List Parameters An App variant’s String List parameters may be edited by clicking their ‘Edit…’ buttons in the Consumer interface’s Variant screen. A String List parameter may be modified as follows: To add a new string element, click ‘Add Row’ and complete the [...]
Version 3.9.4

Table Datasets

Table Datasets Table datasets are populated by LiveCompare actions where the results are stored in a table structure. For example, the Read SAP Table action populates a Table dataset with values read from an SAP table. When a Table dataset is populated, the dataset node in t [...]
Version 3.9.4

Contents Display

Contents Display The Contents tab is available for table contents results accessed from a Hierarchy dataset or report, or compared by the Quick Compare Wizard. It displays a grid control with columns showing the fields from the compared table, and rows showing the table values. [...]
Version 3.9.4

Data Store Details

Data Store Details If a Data Store is selected in the LiveCompare hierarchy or Data Stores screen, the Details pane displays the name of the Data Store, and a ‘Contents’ section which lists the tables that the Data Store contains. Select a link in the NAME column to display th [...]
Version 3.9.4

Editing Pair List Parameters

Editing Pair List Parameters An App variant’s Pair List parameters may be edited by clicking their ‘Edit…’ buttons in the Consumer interface’s Variant screen. A Pair List parameter may be modified as follows: To add a new pair, click ‘Add Row’ and complete the field values. T [...]
Version 3.9.4

Revisions Details

Revisions Details When an SAP object is selected from a Vault hierarchy, the Details pane lists the revisions that have been created for the object by the Record Snapshot action: The Revisions table has the following columns: Column Description Rev The revision number for the [...]
Version 3.9.4

Editing Select List Parameters

Editing Select List Parameters An App variant’s Select List parameters may be edited by clicking their ‘Edit…’ buttons in the Consumer interface’s Variant screen. A Select List parameter may be modified as follows: To add a new row, click ‘Add Row’ and complete the field valu [...]
Version 3.9.4

Smart Impact App

Smart Impact App The Smart Impact App is provided with one or more of the following on the SAP system to be analyzed. A set of transports A set of objects A set of ChaRM change requests These provide the Smart Impact App with a set of changing objects. The Smart Impact App identi [...]
Version 3.9.4

Upload Blacklist

Upload Blacklist This screen is accessed via the ‘Upload’ button on an RFC Destination’s General tab, and allows a table blacklist to be uploaded to the RFC Destination from an Excel spreadsheet. The Excel spreadsheet should include a worksheet named Sheet1, with the tables to be [...]
Version 3.9.4

Step 2 (As-Is) - Downloading Performance History Data

Step 2 (As-Is) - Downloading Performance History Data An SAP HANA migration assessment requires performance history data from your production system. Performance history data may be obtained in any of the following ways. Using the ST03N transaction. Using an RFC Destination on yo [...]
Version 3.9.4

Compare Objects App

Compare Objects App The Compare Objects App compares a set of objects on two SAP systems. The objects may be specified by name or by using specifications defined in a Select List. DevOps Categories Development, Operations. Prerequisites None. Running the App To run the Compare Ob [...]
Version 3.9.4

Integration Excel Report

Integration Excel Report The Integration Excel Report includes the following spreadsheets. Standard IDOCs This spreadsheet helps to identify where customizations made to standard IDOCs on the As-Is system may need to be applied to the To-Be system. This may be the case if SAP has [...]
Version 3.9.4

Testing Excel Report

Testing Excel Report The Testing Excel Report includes the following spreadsheets. Standard This spreadsheet lists used standard programs and transactions on the As-Is system that will impacted by screen changes on the To-Be system following an upgrade. The report list each used [...]
Version 3.9.4

Development Excel Report

Development Excel Report The Development Excel Report includes the following spreadsheets. Used This spreadsheet lists the objects that are used on the As-Is system according to the available performance history data. Each used program and transaction is listed, along with its ap [...]
Version 3.9.4

External Data Source Details

External Data Source Details If an External Data Source is selected in the LiveCompare hierarchy or External Data Sources screen, the following details are shown. Note that if a workflow or user interface action is currently accessing an External Data Source, it may not be abl [...]
Version 3.9.4

Security Excel Report

Security Excel Report The Security Excel Report includes the following spreadsheets. Impacted Roles This spreadsheet lists the roles impacted by the migration. These roles have authorization objects that have been either added or removed on the To-Be system. Details During an SAP [...]
Version 3.9.4

Training Excel Report

Training Excel Report The Training Excel Report includes the following spreadsheets. Standard This spreadsheet lists used standard programs and transactions on the As-Is system that will impacted by screen changes on the To-Be system following an upgrade. The report list each use [...]
Version 3.9.4

Editing External Data Sources

Editing External Data Sources If you have LiveCompare Editor or Administrator privileges, you can edit the details for an External Data Source by carrying out the following steps: Select an External Data Source from the Data/External Data Sources folder in the LiveCompare hier [...]
Version 3.9.4

Apps Usage App

Apps Usage App The Apps Usage App audits the run log information on the LiveCompare server to summarize how Apps and workflows are used at your site. A Dashboard report shows the status, top users, top Apps, top workflows and usage distribution over various time periods. Further [...]
Version 3.9.4

Test Audit App

Test Audit App The Test Audit App is provided with a set of Most-at-risk objects obtained from the Smart Impact App, and performs an audit of the objects, retrieving usage data for them from the QA and Production systems. Optionally, the Most-at-risk tokens are used to retrieve m [...]
Version 3.9.4

Used Objects App

Used Objects App The Used Objects App identifies objects that have been used according to the available performance history data. The App reports on standard and custom objects, users, application areas and SAP license type assignments. The results are presented in a Dashboard re [...]
Version 3.9.4

Write External Data Source Actions

Write External Data Source Actions Write External Data Source actions read data from a Table dataset, and write it to an External Data Source defined in the LiveCompare hierarchy. Action Property Description External Data Source An External Data Source parameter referring to [...]
Version 3.9.4

Replacing External Data Files

Replacing External Data Files If you have LiveCompare Editor or Administrator privileges, you can replace the data file associated with an Excel, Access or CSV External Data Source by carrying out the following steps: Select an Excel, Access or CSV External Data Source from th [...]
Version 3.9.4
Results per page

Importing Test Cases Using Excel Import

Importing Test Cases Using Excel Import In qTest Manager, you can import Test Cases from an Excel spreadsheet to create new Test Cases as well as to make changes to existing Test Cases. While there is an Example Sample Template, any column value can be mapped to a custom field w [...]
Version On-Demand

Importing Requirements Using Excel Import

Importing Requirements Using Excel Import qTest Manager allows you to store Requirements so that testers can easily access information for test coverage. You can create Requirementsor Import Requirements. Note: Many users will have already created Requirements in another tool, s [...]
Version On-Demand

Using the Defects Module

Using the Defects Module The Defects module is where users can create, view, and edit Defects that have been created within the internal defect tracker. qTest Manager's internal Defect tracker is simple, yet powerful, allowing you to manage Defects in real-time as they are raise [...]
Version On-Demand

Using the Defects Module

Using the Defects Module The Defects module is where users can create, view, and edit defects that have been created within the internal defect tracker. qTest Manager's internal defect tracker is simple, yet powerful, allowing you to manage defects in real-time as they are raise [...]
Version On-Demand

Manager 9.6.1-1+ Release Notes

Manager 9.6.1-1+ Release Notes Manager 9.6.12 June 14, 2019  Bug Fixes and Improvements Ticket # Component Description 28688 28869 Login Multiple clicks on the login page would previously result in a 500 error when using either IE11 or Chrome. This is now resolved. Manager 9.6.1 [...]
Version On-Demand

Manager 9.6.1-1+ Release Notes

Manager 9.6.1-1+ Release Notes Manager 9.6.12 Release Notes  Bug Fixes and Improvements Ticket # Component Description 28688 28869 Login Multiple clicks on the login page would previously result in a 500 error when using either IE11 or Chrome. This is now resolved. Manager 9.6.1 [...]
Version On-Demand

Export Requirements and Test Design Reports

Export Requirements and Test Design Reports In addition to the out-of-the-box reports in the Reports tab and custom dashboards and analytics through Insights, qTest Manager allows users to export reports from Requirements and Test Design. Requirement Details Export Requirements Y [...]
Version On-Demand

Legacy Cross Project Reporting

Legacy Cross Project Reporting All qTest cross-project reporting should be done through qTest Insights or Tricentis Analytics,our self-service business intelligence tools for test analytics. This article refers to our legacy reporting. Accessing Legacy Cross-Project Reporting To [...]
Version On-Demand

Manager 9.3 Release Notes

Manager 9.3 Release Notes Enhancements JIRA Integration Send Test Log Attachments to Linked JIRA Defects Attachments for Test Logs and Test Step Logs can now be automatically uploaded to linked Defects in Jira. This feature is enabled by default, but you can disable it by selecti [...]
Version On-Demand

Import Test Cases from TestLink

Import Test Cases from TestLink These instructions give step by step instructions to convert XML files exported from TestLink to qTest Manager. Prerequisites Windows 32 or 64bit is required. Currently, we only support converting and importing Test Cases from TestLink to qTest. Th [...]
Version On-Demand

Manager 9.3 OnPremise Release Notes-November 2018

Manager 9.3 OnPremise Release Notes-November 2018 Enhancements JIRA Integration Send Test Log Attachments to Linked JIRA Defects Attachments for Test Logs and Test Step Logs can now be automatically uploaded to linked Defects in Jira. This feature is enabled by default, but you c [...]
Version On-Demand

Manager 9.1.5 OnPremise Release Notes-June 2018

Manager 9.1.5 OnPremise Release Notes-June 2018 TestPad Enhancements Below are highlights for each of the TestPad enhancements. For more info on using the TestPad, check out these articles: Executing Test Runs and Submit Defects in Test Execution Rich-Text Editor A rich-text edit [...]
Version On-Demand

Manager 9.1.5 Release Notes

Manager 9.1.5 Release Notes TestPad Enhancements Below are highlights for each of the TestPad enhancements. For more info on using the TestPad, check out these articles: Executing Test Runs and Submit Defects in Test Execution. Rich-Text Editor A rich-text editor has been added t [...]
Version On-Demand

qTest Manager 9.7.1 OnPremise Release Notes July 2019

qTest Manager 9.7.1 OnPremise Release Notes July 2019 We are happy to announce the July 2019 release of qTest Manager 9.7.1 OnPremise! Here are a few release highlights: API's for Jira integration and configuration New Site Templates API's New Project API's and additional inputs [...]
Version On-Demand

qTest Manager Quick Start Guides

qTest Manager Quick Start Guides qTest Manager is highly configurable, whether you plan to use qTest on its own, or with Jira, Rally, or VersionOne. Follow the steps within the appropriate Quick Start Guides below to quickly set up and use qTest Manager. qTest Manager Core Quick [...]
Version On-Demand

Licenses and Users

Licenses and Users To add a new user to qTest Manager, you will need to invite them to the site via an activation link. The activation link is sent in an email generated from within qTest Manager. You must be a Site Administrator to use this functionality. If you are using a free [...]
Version On-Demand

Manager 9.1.1+ Release Notes

Manager 9.1.1+ Release Notes 9.1.9 Release Improvements and Bug Fixes Ticket 12289: Rally Defect Status is now displaying correctly in the Defect Summary page as well as Insights. Ticket 17804: Test Step formatting will now export as expected. Ticket 18217: The History for a Requ [...]
Version On-Demand

Batch Actions

Batch Actions Batch Actions allow Administrators to manage and modify potentially large groups of users simultaneously. You will find the Batch Action icon on the License Information page. Batch Actions include: Assign projects Reset Passwords Resetting a user's password will res [...]
Version On-Demand

Manager 9.1.1+ Release Notes

Manager 9.1.1+ Release Notes 9.1.9 Release Notes-July 25, 2018 Improvements and Bug Fixes Ticket 12289: Rally Defect Status is now displaying correctly in the Defect Summary page as well as Insights. Ticket 17804: Test Step formatting will now export as expected. Ticket 18217: Th [...]
Version On-Demand

Legacy Reports

Legacy Reports Legacy reporting is available in the Reports module. Customers who are on the Elite plan should use qTest Insights for more reporting functionality. In addition to Insights and the legacy Reports module, you can also find export reports within other modules. For [...]
Version On-Demand

Manager 9.6.1 Release Notes

Manager 9.6.1 Release Notes We are happy to announce the Release of qTest Manager 9.6.1 for our OnPremise customers! Here are a few Release highlights: enhanced Audit Logging  VersionOne Requirement folder structure capability Tosca Integration enhancements qTest integration with [...]
Version On-Demand

Manager 8.5 Release Notes

Manager 8.5 Release Notes 8.5 OnDemand Release Notes - June 2017 Enhancements Unlimited custom fields (previously limited to 20 custom fields maximum per object) API Update: Added ability to paginate results from Get Test Runs API Default landing page jumps to most recently vis [...]
Version On-Demand

qTest Manager 8.7.3 OnPremise Release Notes - Oct 23, 2017

qTest Manager 8.7.3 OnPremise Release Notes - Oct 23, 2017 Installation/Deployment Packages Linux Docker deployment packages One Docker deployment package to deploy qTest Manager, qTest Sessions. qTest Insights (no new update to Parameters) Linux non-Docker installation/upgrade p [...]
Version On-Demand
Results per page

Importing Test Cases Using Excel Import

Importing Test Cases Using Excel Import In qTest Manager, you can import Test Cases from an Excel spreadsheet to create new Test Cases as well as to make changes to existing Test Cases. While there is an Example Sample Template, any column value can be mapped to a custom field w [...]
Version 9.9.1

Importing Requirements Using Excel Import

Importing Requirements Using Excel Import qTest Manager allows you to store Requirements so that testers can easily access information for test coverage. You can create Requirementsor Import Requirements. Note: Many users will have already created Requirements in another tool, s [...]
Version 9.9.1

Using the Defects Module

Using the Defects Module The Defects module is where users can create, view, and edit Defects that have been created within the internal defect tracker. qTest Manager's internal Defect tracker is simple, yet powerful, allowing you to manage Defects in real-time as they are raise [...]
Version 9.9.1

Using the Defects Module

Using the Defects Module The Defects module is where users can create, view, and edit defects that have been created within the internal defect tracker. qTest Manager's internal defect tracker is simple, yet powerful, allowing you to manage defects in real-time as they are raise [...]
Version 9.9.1

Export Requirements and Test Design Reports

Export Requirements and Test Design Reports In addition to the out-of-the-box reports in the Reports tab and custom dashboards and analytics through Insights, qTest Manager allows users to export reports from Requirements and Test Design. Requirement Details Export Requirements Y [...]
Version 9.9.1

qTest Manager Quick Start Guides

qTest Manager Quick Start Guides qTest Manager is highly configurable, whether you plan to use qTest on its own, or with Jira, Rally, or VersionOne. Follow the steps within the appropriate Quick Start Guides below to quickly set up and use qTest Manager. qTest Manager Core Quick [...]
Version 9.9.1

Import Test Cases from TestLink

Import Test Cases from TestLink These instructions give step by step instructions to convert XML files exported from TestLink to qTest Manager. Prerequisites Windows 32 or 64bit is required. Currently, we only support converting and importing Test Cases from TestLink to qTest. Th [...]
Version 9.9.1

Legacy Cross Project Reporting

Legacy Cross Project Reporting All qTest cross-project reporting should be done through qTest Insights or Tricentis Analytics,our self-service business intelligence tools for test analytics. This article refers to our legacy reporting. Accessing Legacy Cross-Project Reporting To [...]
Version 9.9.1

qTest Manager 9.7.1 OnPremise Release Notes July 2019

qTest Manager 9.7.1 OnPremise Release Notes July 2019 We are happy to announce the July 2019 release of qTest Manager 9.7.1 OnPremise! Here are a few release highlights: API's for Jira integration and configuration New Site Templates API's New Project API's and additional inputs [...]
Version 9.9.1

Manager 9.3 Release Notes

Manager 9.3 Release Notes Enhancements JIRA Integration Send Test Log Attachments to Linked JIRA Defects Attachments for Test Logs and Test Step Logs can now be automatically uploaded to linked Defects in Jira. This feature is enabled by default, but you can disable it by selecti [...]
Version 9.9.1

Manager 9.1.5 Release Notes

Manager 9.1.5 Release Notes TestPad Enhancements Below are highlights for each of the TestPad enhancements. For more info on using the TestPad, check out these articles: Executing Test Runs and Submit Defects in Test Execution. Rich-Text Editor A rich-text editor has been added t [...]
Version 9.9.1

Batch Actions

Batch Actions Batch Actions allow Administrators to manage and modify potentially large groups of users simultaneously. You will find the Batch Action icon on the License Information page. Batch Actions include: Assign projects Reset Passwords Resetting a user's password will res [...]
Version 9.9.1

Licenses and Users

Licenses and Users To add a new user to qTest Manager, you will need to invite them to the site via an activation link. The activation link is sent in an email generated from within qTest Manager. You must be a Site Administrator to use this functionality. If you are using a free [...]
Version 9.9.1

Manager 8.7.3 Release Notes

Manager 8.7.3 Release Notes Installation/Deployment Packages Linux Docker deployment packages One Docker deployment package to deploy qTest Manager, qTest Sessions. qTest Insights (no new update to Parameters) Linux non-Docker installation/upgrade package One package for installi [...]
Version 9.9.1

Legacy Reports

Legacy Reports Legacy reporting is available in the Reports module. Customers who are on the Elite plan should use qTest Insights for more reporting functionality. In addition to Insights and the legacy Reports module, you can also find export reports within other modules. For [...]
Version 9.9.1
Results per page

RPA Specialist - Self-Paced Track Standard

What is RPA Specialist? In this half-day course, we will look at what RPA is and why it is important, as well as comparing and contrasting the differences between test automation and robotic process automation. Following this, we will move on to cover RPA Studio and RPA Orche [...]
  Help
IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial