1

I want to compare my data in CSV with the web content. The data in CSV file comprises of multiple rows and column. How can I verify that the data inputted on the web is correct comparing it with the CSV using Jmeter?

There is a search bar on the website I write any character I get the location of particular dealers along with the details and I have data in CSV and now I want to compare the data entered on the web is correct or not

EDIT: the data on the web is called through AJAX.

  • Your tool choice is not suitable for your stated objective, it appears to be a data validation exercise. JMeter is most suitable for performance/load/stress testing. If your actual objective is functional testing the data loading, transfer and presentation, then look toward appropriate functional test tools. SOAPUI with some Groovy for the AJAX API, Cucumber and Selenium WebDriver if you want the test the data through a WebApp. – Martin Spamer Jun 27 '18 at 20:38
0

Normally you should go something like:

  1. Create a HTTP Request which will perform the search on the website
  2. Extract "interesting" parts of the response using one of JMeter's Post-Processors
  3. Compare expected value (i.e. variable from CSV) with the actual value (i.e. variable from the PostProcessor) using Response Assertion
  • Thanks for your reply, can you elaborate more? – orientChaloo Oreo Jan 30 '18 at 10:12
0

I may not follow you exactly, but it's usual to have some kind of input file with sample test data and expected outcomes. This may be CSV, Excel, or wiki for example. For an old school example of driving tests this way, look into Fitnesse. It looks like there's a similar and newer project, Gauge, that might be worth a look as well--I have no experience with this one. Hope it helps!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.