Forum Discussion
- AlexKarasChampion Level 3
Hi,
Maybe I missed something in your question... but just go through all fields on web page that are subject to get data from Excel file and check if their value corresponds to the one from Excel.
- atn3dxdOccasional Contributor
The problem is if I have 70 records, each with say 15 columns, how do I loop through each field in the web page and the compare to the field(s) in the DB, especially if the rows in the web page could be in different order. I had use checkpoints but I do not see a way to read data from an excel worksheet and use that as the checkpoint data to compare. Sorry if I am making this confusing. I am not looking to click on each field in each row, for 70 plus records and set a checkpoint. I would like to be able to read in the data from Excel and then have the tool search the Web page to make sure that data exists in the correct field for the correct row. I do have a key that I maybe able to use to do the initial search, say a order # and then would want to go to each field in that record and compare to that same record in the web page. Hopefully that makes sense.
- Marsha_RModerator
Give us an example with 2-3 rows of data and screenshots of your web page with the data loaded and we can try to give you a more specific answer.
- rraghvaniChampion Level 3
For example, you have a data driven test that reads the contents of an Excel file,
which populates the appropriate fields to you web app, in no particular order
To ensure that the data is populated correctly, you will have to read each item (row) from your web app, and then look up this value to see if it exists in your spreadsheet. Using some sort of unique key.
You might be able to do this during data driven testing, or after, once all data has been populated.
Related Content
- 3 years ago
- 6 years ago
- 4 years ago
Recent Discussions
- 11 hours ago
- 15 hours ago