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.

Improve this question
1
  • 1
    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
    Commented Jun 27, 2018 at 20:38

2 Answers 2

Reset to default
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
Improve this answer
1
  • Thanks for your reply, can you elaborate more?
    – orientChaloo Oreo
    Commented Jan 30, 2018 at 10:12
-1

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!

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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