Contributions
Re: run vba macro from groovy
thanks. finally get a response. do you know how i can display worksheet results from macro in soap ui pro? this is what i am trying to do: 1) submit request and receive response using soapui pro and save files to local drive - DONE 2) using vba macros do some calculations using the request and response files. macro displays results in sheet in excel. DONE as you suggested i ran the step in groovy script. thank you for that!!!!! 3) now i need to see results of macro in sheet displayed in soap ui... Not sure how to this.Any suggestions?? the resultsfrom macro in the excel sheet is nicely formatted and is in table format with proper headers. i will be doing the above for over 100 request files..so i need to be able to see the results in soap ui for each test request.8 years agoPlace ReadyAPI QuestionsReadyAPI Questions3KViews0likes1Commentrun vba macro from groovy
Hi I have Soap UI pro at work and i am wondering whether the following can be automated: 1) Submit a request in soapui pro. A response is successfully received. This step does'nt need to be automated. I will manually run this. 3) Run a vba macro from groovy. The macro's inputs are request and response files from step 1 and also 2other excel files saved locally. 2) Copy calculated data generated from macro back into soap ui and show it to the user in a nice looking report.8 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.1KViews0likes5CommentsRe: using exceldatasink class methods
Hi I Understand that WsdlDataSinkTestStep doesnt have that method. but i need to use the ExcelDataSink methods. Could you please let me know how i can use the ExcelDataSink Class? How do i define the object for that class and then use that its methods?1.5KViews0likes1CommentRe: using exceldatasink class methods
Hi Thanks for your reply could you please try the following two lines of code and see if they work? def te = context.getTestCase().getTestStepByName("dataSinkToSpreadSheet"); te.setFileName("C://tes"); I get the error: groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSinkTestStep.setFileName() is applicable for argument types: (java.lang.String) values: [C://tes] Possible solutions: setName(java.lang.String), setName(java.lang.String) error at line: 221.5KViews0likes3CommentsRe: setting filename of datasink throwing error
Is there anyone who can help out?please?????? basically i am trying to use the following methods of the class ExcelDataSink in soapui pro void setOutFileName(StringoutFileName) void setStartCell(StringstartCell) void setWorksheet(Stringworksheet) but i keep getting the following error groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSinkTestStep.setFileName() is applicable for argument types: (java.lang.String) values: [c:/test] Possible solutions: setName(java.lang.String), setName(java.lang.String) error at line: 42 i need to set the datasinkstep in the test case so i can use the methods above? any suggestions?789Views0likes0Commentssetting filename of datasink throwing error
HI i have soap ui pro at work I have the this code that is throwing out an error. here is some partial code: bla bla code..... def generateStep = testCase.addTestStep("datasink", "test"); generateStep.setDataSink("Excel"); String errorCode ="test1"; String severityCode ="test2"; String shortDesc ="test3"; generateStep.setPropertyValue('errorCode', errorCode); generateStep.setPropertyValue('severityCode', severityCode); generateStep.setPropertyValue('shortDesc', shortDesc); generateStep.setFileName('c:/test') Throwing error at this line..getting the error below :( groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSinkTestStep.setFileName() is applicable for argument types: (java.lang.String) values: [c:/test] Possible solutions: setName(java.lang.String), setName(java.lang.String) error at line: 42 how do i set the generateStep so i can use the .setFileName method?822Views0likes1Commentusing exceldatasink class methods
Hi Can someone please help? I have soap UI pro I posted this elsewhere and no one has responded. I am trying to use the following methods of the class excelDataSink but get an error when i do that in groovy script void setFileName(StringfileName) void setOutFileName(StringoutFileName) void setStartCell(StringstartCell) void setWorksheet(Stringworksheet) the error i get is: groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSinkTestStep.setFileName() is applicable for argument types: (java.lang.String) values: [c:/test] Possible solutions: setName(java.lang.String), setName(java.lang.String) error at line: 421.6KViews0likes5CommentsRe: HI i need to setup datasink using groovyscript
Sorry i wasnt clear enough before. I have Soap UI Pro This is what i would like to do using soapui 1)Pick an XML response file from local drive on my computer. 2) Capture the response file values within the tags. 3) Verify that the response values from XML match to what is inexcel sheet that is also locally saved. 4) Loop steps 1-3 for multiple XML responses to their corresponding excel records. I need a dynamic setup for steps 1-4 because the XML file numbers and records in spreadsheet are different for each service. I have multiple services to work with. Each service has its own spreadsheet and its own xml responses. For example: For service 1: The excel spreadsheet data looks like: Column 1 Column 2 Column 3 Column 4 XML1.XML John Jenny Michael XML2.XML Rita Michel Mat XML3.XML Adam Betty Catlin The XMl response files for service 1 looks like: Filename: XML1.XML random tags here <tag1>John </tag1> <tag2>Jenny</tag2> <tag3>Michael</tag3> random tags here Filename:XML2.XML random tags here <tag1>Rita</tag1> <tag2>Michel</tag2> <tag3>Mat</tag3> random tags here Filename:XML3.XML random tags here <tag1>Adam</tag1> <tag2>Betty</tag2> <tag3>Catlin</tag3> random tags here Aim: Ensure the values in response match the values in an excel row. Loop that through multiple files against corresponding excel rows. Both XML files and excel are stored locally. I have been trying to figure this out for the last couple of days. Can this be done or am i just wasting my time? if you guys could set me on the right path idreally appreciate it. Thanks8 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.4KViews0likes1Comment