Project ID: 5717 | Branch group: Retail & Logistik | Branch: trade
Automated System Testing for Report Comparison
Project start/end: 01.01.2021 - 31.03.2022
The main goal of this project is to reduce the test effort significantly while increasing the test quality. At the same time, the entry barrier for new employees is to be lowered in order to keep the test automation solution maintainable and productive in the future. PTA is responsible for the project conception and implementation.
A fully integrated solution is created that is controlled via test series in SpiraTeam. An RPA tool is started for this purpose during the scheduled execution, which both starts and operates the export-generating application and extracts the data records from the application and compares values in the report and in the application. The corresponding test result is not only transmitted back to the ALM tool as 'Passed/Failed', the corresponding error report is also transferred. This means that in the event of an error, the cause of the error can be determined very quickly.
The formal and content examination of reports and exports (*.csv or *.xlsx) is a very time-consuming repetitive activity. At increasing report size, neither efficient nor error-free work can be ensured by humans. However, by simulating the human tester and the possibility to transfer 'variables' from one application to another, it is possible to keep the expected values of the reports in a machine-readable form. Not only the execution time of the test cases could be reduced by 90 %, but also the effort of creation and maintenance is comparable to the creation of manual test cases due to the easy handling.