2

I have been assigned to verify posted data on a website developed on wordpress. Data has been posted manually through wordpress admin panel. I have given ms excel sheet and I have to verify every record from ms excel to website. There are near about 1000 records. It is really weird to verify all 1000 records one by one.

Is there any automation tool for this task?

  • 3
    If you know selenium webdriver and POI then it will be easy task for you. – Helping Hands Nov 23 '15 at 10:07
  • Do you need to do this one time? Not sure automating is worth the time for a single compare run. – Niels van Reijmersdal Nov 23 '15 at 10:48
  • May be I need this again in another projects. So I am going to learn this. Thanks to all. – Muhammad Ali Khamis Nov 23 '15 at 10:49
  • 1
    What does "verify" mean here? Do you mean that the data in each row of the spreadsheet exists in the same format on the website, and you just need to compare the two? Or do you mean something else? – Joe Strazzere Nov 23 '15 at 17:40
  • Exactly! I want .to compare spreadsheet data with the website. I need to compare both to check all data has been posted successfully – Muhammad Ali Khamis Nov 24 '15 at 8:51
2

You can use selenium and Java combination for this.

  1. Create a Script which will read all the data from website.
  2. Using Java POI API for reading data from excel, use this link for help http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/
  3. Compare the data taken from selenium with excel.
1

It may be worth considering Cucumber

This will allow for a fairly low learning curve to get you up and running.

Here is a tutorial to use it in conjunction with excel

Although other tools are available which will accomplish the task, such as Selenium, the setup time may not prove beneficial in the scenario you describe. But here is a tutorial if that is the direction you choose

  • Just wondering, how Cucumber proves more beneficial in this scenario than Selenium ? – JustARandomGuy Nov 24 '15 at 1:05
  • 1
    Selenium tends to have a larger setup time and for a small return, the investment in time might not be worth it on balance. In a previous comment he has said he would learn Selenium and Java. My feeling is that if he not from a programming background, then it will be easier to learn how to use a tool like Cucumber. – ECiurleo Nov 24 '15 at 16:00
  • How Cucumber parses data from Web site? – dzieciou Jan 10 '16 at 9:47
  • If you have a seperate question about cucumber, raise a new question and people will be able to answer it for you – ECiurleo Jan 10 '16 at 21:53
1

If u have knowledge of selenium then, you can use Selenium Webdriver with java.

Approach

  1. Get the excel data using Apache POI
  2. Get the data from website (which you are comparing) using driver.gettext() method with its element locator.
  3. Use assert ,if/else or control structure to verify.
  • 1
    I will learn selenium webdriver with java, if it would help me to solve my problem. By the way, can you share some hints about how to verify 1000 records through selenium webdriver? – Muhammad Ali Khamis Nov 23 '15 at 9:49
  • 1
    It isn't a very complex task, all need to do is write a Java code to loop till the last row, get required columns and keep comparing with visible text on Website. – JustARandomGuy Nov 24 '15 at 1:07
  • @ JustARandomGuy if the person is well versed with language java i dont think it will be complex. – sameer joshi Nov 24 '15 at 4:15
0

It totally depends on what programming language you are familiar with, as selenium webdriver supports multiple interfaces.

Here is one of my suggestion: use Ruby + Selenium Webdriver.

  1. Use Selenium Ruby API to grab text from the web page.
  2. Use Ruby gem - spreadsheet API to grab data from the Excel.
  3. Compare the data.

If you are not familiar with Selenium, I would suggest you to manually grab data from the web page and save it into a file, do the same thing to the Excel, and then open both files in notepad++, use notepad++ diff plugin to compare two files and you will be able to see the difference.

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.