cstott1
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
LOADUI Reporting
Hi, i am running a Load testing in LOADUI PRO and am looking to create a report that per request contains the data in the log feature i.e timestamp, timetaken, wait time, etc and also contains data that is in the actual SOAP request and response. I would normally use a datasink to get this data but I can't see how I can capture both sets of data in one report. any ideas?2.2KViews0likes1CommentCustomise transaction log
I am trying to create a load test report that contains all of the data in the loadui transaction log such as timestamp, trigger timestamp, timetaken, etc but also add in some of the data that is held in the xml request. Whilst the whole message is stored in log i only want certain fields in this case I want to save the value "tracking number" field and have this this as a column before the rest of the log data . The ability to Customise the transaction log would be a very useful feature.1.1KViews0likes0CommentsGenerate Test Data Using Groovy
Hi, I am looking to generate test data (amended postcodes) from a datasource using a Groovy Script however currently I am only able to pick up one row. Currently my test case is setup as per below: 1) Datasource - Contains a list of postcodes in a grid: H4O 0SD Y68 5LI C1K 6ZI G84 4PJ LI1B 0FC Y08 0TB A1 7ZM OQ5 2SV O1X 6CK P4Z 6PJ CG7O 4HV G8L 6RG J5 1FE DO7 7EV 2) I then have a DataGen setup where I run the below Groovy step in order to amend the postcode def postCode = context.expand( '${DataSource#PostCode return [ postCode.toLowerCase (), postCode.toUpperCase (), postCode.stripIndent (1), postCode.stripIndent (2), postCode.stripIndent (3), postCode.stripIndent (4), postCode.stripIndent (5), postCode.stripIndent (6), postCode.stripIndent (7), postCode.stripIndent (8) ] However this script only picks up the postcode DO7 7EV and runs the above returns on this postcode which results in the below: [do7 7ev, DO7 7EV, O7 7EV, 7 7EV, 7EV, 7EV, EV, V, , ] However i'm looking for the script to run through one Postcode at a time and amend it once with a return. for example if I had this list H4O 0SD y68 5li C1K 6ZI G84 4PJ and these returns return [ postCode.toLowerCase (), postCode.toUpperCase (), postCode.stripIndent (1), postCode.stripIndent (2), I would be looking for the below as an output to use as test data: h40 0sd Y68 5LI 1K 6ZI 4 4PJ Any ideas how I can amend the script or whether this is the correct way of generating test data by amending a list of values?1.8KViews0likes2CommentsRe: Issues datasource looping for a SQL server JDBC request
Hi Rao, That is the issue, I don't understand why it is still running the SQL with no tracking number an additonal number of time. I was only expecting it to loop 5 times and this to be reflected in the DataSink i.e not show the blank tracking numbers just the 5 (Note that in the Datasource options I have put in a start row of A1 & an end row of A5)2.8KViews0likes0CommentsIssues datasource looping for a SQL server JDBC request
Hi, In summary the aim of this part of an end to end test in SOAPUI NG is to run a SQL statement 5 times (and then stop) for the 5 different values in the Datasource and capture the data. I have the below steps setup as part of a test case: 1) Datasource - Excel 2) JDBC Request - uses a SQL server driver to run a SQL statement. In the SQL statement the where clause is populated from the Datasource in step 1 (uses a field called Tracking Number) 3) Datasink - is setup to capture a number of datapoints from the SQL JDBC request 4) Datasourceloop - to loop back to the JDBC request again However when I run it ...it loops to run the 5 queries as required then continues to loop around and runs SQL time. In the Datasink the datafield I am using for the where clause is being captured to <trackingnumber>. I have attached some screenshot to illustrate what I mean by this. can anyone help please?Solved2.8KViews0likes7CommentsRe: XPATH assertion for an expression containing another value, field length, field type and is not NULL
Hi Rao, I have tried to write this for one field in the way below: def pieceid = context.expand( '${OneDX#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/PIECEID[1]}' ) def TrackingNumber = context.expand( '${OneDX#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/TRACKINGNUMBER[1]}' ) assert {!TrackingNumber.contains(Pieceid)} The tracking number is 907598985733 and Pieceid is 1820480....therefore the Pieceid is not in the tracking number. However when I run the script it passes. do you know what i'm doing wrong4KViews0likes0Comments