ContributionsMost RecentMost LikesSolutionsGroovyScript: Getting node value out XMLHello, Can somebody tell me how i can get a node value out of XML. I want to do that with a groovy script because i have to compaire the values. My xml message is: 9003 Bericht voldoet niet aan AZR-bedrijfsregel 3 3 1 250 3 I want to getall the values between the node : I use the code below, but that didn't work. def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) log.info( groovyUtils.projectPath ) //create holder for last response an log requistID def holder = groovyUtils.getXmlHolder( "EI-Bericht#response" ) def strlItems = holder.getNodeValues( "//ns1:Bedrijfsregels") log.info( strlItems["Omschrijving"] ) What do i wrong????? Catch screenshot by log.warning eventHow can i catch the picture from log.warning. for example Log.Warning('Warning Message Text', 'Extended Text', pmHighest, nil, Sys.Desktop); When i go to the event i don't see the image path. How can i get the image path from a warning event? Regards Raymond Wiertz Furore.com The NetherlandsCatch screenshot by log.warning eventhello How can i catch the picture from log.warning. for example Log.Warning('Warning Message Text', 'Extended Text', pmHighest, nil, Sys.Desktop); When i go to the event i don't see the image path. How can i get the image path from a warning event? Regards Raymond Wiertz Furore.com The NetherlandsRe: Editing Excel filesJared, For so far as i know, the way you descript you need excel installed on your pc. When using ADO you only need the excel odbc drivers installed. Regards R. Wiertz Furore.com Re: Editing Excel filesBrad, I use the ADO function to read data from excel. So every excel tabsheet i handle as a database table and i can query on it. perhaps this is a solution for your problem. Below i have a example how you can do it. Regards R. Wiertz Quality Assurance Furore.com Procedure ReadFromExcel(aExcelFile : String); var DBConnection : OleVariant; Command : OleVariant; RecordSet : OleVariant; ConnectionString : String; strQuery : String; SheetName : String; iFieldCount : Integer; begin ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ' + aExcelFile + ';Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"'; if Length(aConnectionString) > 0 then begin DBConnection := ADO.CreateConnection(); DBConnection.ConnectionString := aConnectionString; try DBConnection.LoginPrompt := False; except //do nothing, there is no login prompt end; try DBConnection.Open; SheetName := 'Your excel sheet name'; strQuery := 'Select * from ['+SheetName+'$]'; Command := ADO.CreateCommand(); Command.CommandText := Query; Command.ActiveConnection := DBConnection; RecordSet := Command.Execute(); while not aqConvert.VarToBool(RecordSet.EOF) do begin for iFieldCount := 0 to RecordSet.Fields.count -1 do begin Log.message(aqConvert.VarToStr(RecordSet.Fields(iFieldCount).name)); Log.Message(aqConvert.VarToStr(RecordSet.Fields(iFieldCount).Value)); end; end; RecordSet.Close; DBConnection.Close; end; Re: GroovyScript: Getting node value out XMLTanxs that's just what i wanted.Re: GroovyScript: Getting node value out XMLThank you. But can you also tel me how to work wit the property : GetNodeValues. Because i try to get that work but i don't get it. I tried several declarations but i don't get it!Re: GroovyUtils: Error by declareYes, It works. Thank you for your fast responseRe: GroovyUtils: Error by declareYes, i believe so. soapUI 1.7 Pro, copyright 2007 eviware software ab http://www.soapui.org | http://www.eviware.com Build soapuipro-dist-159, Build Date 2007/04/10 17:44GroovyUtils: Error by declareWhen i use the script below i get an error: def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) log.info( groovyUtils.projectPath ) The error that i get: Tue May 01 11:35:14 CEST 2007:ERROR:org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, Script1.groovy: 10: unable to resolve class com.eviware.soapui.support.GroovyUtils @ line 10, column 19. 1 error Please can you tell me what i do wrong. I use de demo version of SoapUI Pro