LISA SDK: Filter to save Result Set in an Excel Sheet

File uploaded by Monika Mehta Employee on Apr 16, 2015Last modified by Monika Mehta Employee on May 18, 2017
Version 3Show Document
  • View in full screen mode

Description

In Lisa, there is a JDBC step to execute SQL query or a Stored Procedure which in results will fetch a Result Set. This LISA SDK (Filter) helps in saving the Result Set of a JDBC Step to an Excel file in your file system which further can be compared with the expected results.

Set-Up Instructions

1.      Navigate to {LISA_HOME}/hotDeploy directory and place the “savetoExcelFilter.jar”

Capture.PNG

 

2.      Navigate to {LISA_HOME} and open the file “typemap.properties” with notepad. Navigate to Filters section of the file and insert below text as shown

“,com.itko.excel.filter.FilterSaveResultSettoExcelFile\”

Capture.PNG

3.      Restart LISA, if it is in running state.

 

Steps for Implementation:

1.      Create a Project in LISA workstation.

     Capture.PNG

   

2.      Create a Test Case.

    

     Capture.PNG

 

 

3.      Add a Test Step -> JDBC Step

Capture.PNG

 

4.      Open the step and provide either a SQL query or Stored Procedure call Statement.

Capture.PNG

 

5.      On the right side, under Step Information, Click on  button under Filters Section and select filter “Save ResultSet to an Excel File” under Custom.

 

Capture.PNG

 

6.      Open the Filter and provide values for Location and Sheet Name.

Capture.PNG

 

If current step is JDBC Step then above step is fine. Otherwise provide property name which holds the name of JDBC step in “Filter in:” section.

  1. 7. Click Start a new ITR and execute the Test Case.
  2. 8.     Open the excel file in the provided Location.

Note: This Filter will work only with workbook having “.xls” as an extension.

Benefits:

  1. Generic Utility, Plug and Play.
  2. Save Manual and Coding Efforts
  3. Time Saving as Java Step consumes more time to execute.

Attachments

Outcomes