Itedama
Itdema is the acronym of TEst DAta MAnagement. It has been decided trough workshop on the test preparation phase that we will try to find a common way of working for test data preparation. I suggested trying to have a test set of data that can be reusable before each regression phase. By this processus, test team will spend less time on test data preparation and test cases can be linked with directly physically test data. This can be possible only if a system of updating data exist. It is the case for Fortis client who used specific flat files for updating data on client system.
I decide to try to reproduce these kinds of flat files to be loaded on the system by writing the tool. First step is to implement the configuration of the payload file system with an upload and build payload function.
All data are stored on Access and are available trough the tool in order to manage them before building a payload to be sent to Unix system.
All parameters are available and configurable trough a simple screen. Main parameters:
Payload file managment:
This screen allow user to select parameters in order to build a payload file. This file is part of a Tar compressed file that must be send to Unix system.
The send to Unix function has been implemented using scripting of WinSCP.
Coda file parsing
As the main scope of Itedama is reached, I decide to improve it with some other functions that we can use on different testing phase. One of them is the parsing of CODA
files with an automatic control of content based on Coda specifications that are configurable on the tool. Versions of Coda that can be parse are V1 & V2.1.
Creditors - TVA
Another test data used is the creditor number that is like a Belgian TVA number. How to calculate it? how to generate any creditor numbers?
I added a function that allows user to generate any combination of creditor numbers where the check digit are automatically calculated
Modulo
Business around the financial sector is about account information and number. How to generate an account where check digit must be calculated with the modulo function
in visual basic, the predefined modulo function allow calculation of long integer but not up to 9 numbers. I implemented a Modulo function that can generate any modulo of
very large numbers such as Belgian account numbers.
SQL Engine
On of the scope of Itedama is to manage test data. This can be also possible trough a SQL engine where user is able to manage all data on all tables.
The SQL language must be compliant with the Ms Access SQL language.
MT101 test case file generator
At the client, we performed lot of automated testing using QTP. For a module where files must be uploaded, I implement a file generator of MT101 files regarding the test case
criteria and specifications. Lot of time can be save using this function.
Tracking tool
At the client, they used a reporting tool that was not user friendly. Sometimes, minor problems must be logged of followed without the status of incident.
I decide to implement a general tracking tool that can be completely configurable for most of the parameters.
Remarks, suggestions and comments
All your remarks, comments or suggestions are always welcome. Don't hesitate to send me a email. You will find how to contact me on the Contact Menu.
Top