This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4902 IT projects that we have successfully completed with our customers.How can we support you?
Excel macro for transforming test cases
Project duration: 7 days
Brief description
In order to minimize the time required for the manual transfer of test case descriptions to the test management tool SpiraTest, an Excel macro is created which transforms test cases that are in Jira exported to Excel into the Excel format required for importing them to SpiraTest.
Supplement
The macro is programmed with Excel 2013 and delivered as a separate Excel file including user documentation. The program contains a user dialog and simple error handling for easier handling.
Subject description
The target format for the test case descriptions is the Excel template provided by Inflectra, which enables an automated import or export of test cases to and from SpiraTest by means of a plug-in to be installed. In an analysis phase, the mapping of the cell contents between source file and target file format as well as the detailed requirements regarding the formal representation of the test case information in SpiraTest (version 5.2.01) are first discussed with the customer.
IT project data
- Industries energy
- Specialist tasks interfaces, software development, test management
- DP tasks customised software new development
- System environments Client/Server
- Procedure model customer standard
- Programming languages VBA
- Development and test tool SpiraTest
Project period07.11.2017 - 14.11.2017
Customers who trust us
Have we sparked your interest ?
