Service Virtualization

  • 1.  Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Posted Mar 08, 2019 05:39 AM

    Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format-

     

    I am using "SQL Database execution" step for my test case and then a "Do-nothing" step. At "Do-Nothing" step; i have added a filter to "Save resultset to an excel file."

    I used "Test & Run" option it shows connection successful and 10 rows were read.

    But after I run ITR; it saves an excel file which is coorrupt and I cannot open it.

    I also tried to save it as .txt file. But it saved the SQL DB rows & columns as a diffrent format- something like this- "_(* #,##0_0##[] [] []

     

    Can someone help me get the correct SQL columns and data stored in excel as a resultset please



  • 2.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Broadcom Employee
    Posted Mar 08, 2019 07:20 AM

    Hi,

          May I know the version of Devtest and could you share a screen shot of the filter step indicating the 'save resultset to excel file' filter.

     

    thanks

    Sankar



  • 3.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Posted Mar 08, 2019 04:50 PM

    +1 please show as many screenshots as possible. I am not familiar with a Save Resultset to Excel file filter in DevTest. Could this be a custom filter?



  • 4.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Broadcom Employee
    Posted Mar 11, 2019 01:25 AM

    HI Joel

             You are right, to my knowledge this filter is not part of the product. I see a custom filter contributed in the community, wondering if the same is in use here:

     

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

     

    -Sankar



  • 5.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Posted Mar 09, 2019 01:50 AM

    Devtest version is 10.0.1.283

    And I can provide only this much screenshot -

    - After JDBC step, I have added a Do-nothing step which has "Save resultset to excel file" filter 

    - For "Filter in" field I have selected "lisa.JDBC.rsp" 

     

    @joel : I already have "Save resultset to excel file" filter in my devtest workstation, it is not customized.



  • 6.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Broadcom Employee
    Posted Mar 11, 2019 01:25 AM

    Hello

           Could you please confirm if you are using this custom filter which was a contribution from the community:

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

     

    regards

    Sankar



  • 7.  Re: Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

    Posted Mar 11, 2019 09:20 AM

    My guess is that this Save to Excel filter was originally created and compiled against an older version of libraries in LISA_HOME\lib\... .

    When the jar is moved to a newer version of DevTest, the newer JARs do not sync with the custom code. 

    If you have the source code for the customization, drop it into an IDE (IntelliJ or Eclipse), include the references to LISA_HOME\lib and determine where the compile errors and exceptions are. Correct the logic, add logger / debugging, compile, and test components to solve the issue.