On the Itedama application, I develop a new module related to Quick Test Prop and Quality center. As improvement of automation testing, I needed to generate data sheets to be used with automated scripts. As I had a very large amount of test cases that could be automated, I decided to implement a structured way of working for QTP Data Sheets management.
There are three screens available for managing data sheet. All test data can be retrieved either from the module of decision management either from the Test data management (provisioning files).
This allows structure test data management. One test data will be available on all different modules with the same properties.
User is able to create a certain number of data sheet structure. The structure must be aligned with the specifications of the automated script in use.
User will be able either to add a list of values that will be available while encoding data on the data sheet either to encode a field name of the provisioning files meaning that all value of the provisioning field
will be retrieved while encoding data on the data sheet. This will reduce errors on data encoding.
Data Sheet Structures:
This screen allow user to manage data on the data sheet. A data sheet can be linked with a specific existing provisioning file that will give a list of values available while encoding.
Decision values are also displayed in order to give indication of what must be encoded. Once record is encoded, a link can be created between the data sheet record and the decision value
meaning that coverage can be calculated. On a practical view, user select a decision table, decision value, get information of the decision value to use, select a provisioning file, select a data sheet
structure and finally will be able to encode records on the QTP data sheet. Once the data sheet is ready, on export can be done on Excel format. This excel file will be put on Quality Center
in order to launch the QTP scripts.
As the application under is a financial one, I needed to format accounts on a GUI format. Therefore, I create a module where user will encode the account type and structure.
While encoding the values on the data sheet, the account numbers will be formatted using the encoded definition. The module manage IBAN and Domestic representations.