Automating app having lot of calculation
I have asked to do the automation feasibility of an application having umpteen number of calculations.
in the UI, if you upload an excel sheet having a record, and after that if we click on calculate button, we will get projected supply data in the UI.
the calculate opeation will take the parameters from the excel sheet and send to "I-Series" where there are having 100's of really big stored procedures and formulas and result will send back and displayed in the UI.
what should be my approach in this scenario? Is it feasibile for automation.
if yes, what should i do?
Help me in this
Re: Automating app having lot of calculation
Of course it is feasible.
Consider how you might manually test this process:
1. You would create your test data (an Excel sheet?)
2. You would determine the expected result of the calculation.
3. You would upload the sheet, click on the calculate button and look at the UI.
4. Then you would compare the results as displayed in the UI to the expected results.
In order to automate this, you might still need to perform steps 1 and 2 manually. Perhaps you would create a list of Excel sheets along with their expected results.
Steps 3 and 4 would then be automated.