Amazon offers

Check external links in excel

I thought
Testing or checking the hyperlinks which are navigating to external web page is a tedious task.

Searched for a tool very seriously which can test all the hyperlinks in excel and produce a report of the broken links.

Did not found any tool which can take excel with hyperlinks as the input and produce report.

Requirement was - An excel is available with many hyperlinks. I need to check each link and prepare a report of which one is working and which one is not working.

Finally got a solution

1. Copy only links from the excel which are to be tested to new excel sheet.
2. New excel sheet should not have any labels or any cells containing values other than hyperlinks type.
3. Save the excel as web page.
4. It will be saved as .html page.
5. Input this html page to any link checker which takes the web page as input.
6. See that "checking local links" option is set in the link checker.
7. This HTML page should be given as a file input to link checker rather than giving it with http protocol.
8. Obviously you will get the report from the link checker.
9. If the link checker has the option to save the report in excel then its good and best for you.

Enjoy.............


Comments

  1. AnonymousFebruary 21, 2012 at 9:23 AM

    "5. Input this html page to any link checker which takes the web page as input."

    Any recommendation as to which link checkers do this type of command?

    Thanks

    ReplyDelete
  2. JoFebruary 22, 2012 at 3:02 PM

    Hi Chris,

    Link checker tool Xenu can take the html page as input

    ReplyDelete
  3. Software TestingJanuary 17, 2013 at 11:15 PM

    Very Nice and useful article. Thanks for sharing this.
    Thanks for the article Ian, excellent stuff.
    You can get info on cross browser testing tools as well with some guidelines with different.

    ReplyDelete

Post a Comment

Popular posts from this blog

Input Data Validation

Every web application is expected have at least one submit form. Data entered in form is transferred as input to database or to any other application and will decide the output. So, input data plays a very important role in retrieving the output data. Such data needs to be validated by the code. And tester has the responsibility of validating such data. At this point tester thinks about how can the validations be done and what type of data should be provided to validate the input field. Test data needs to be created and passed to the form through the automation tool or manually. Here are few steps or guide lines to validate the data. Let’s consider a sample form which acts as input to signing in as new member in a social networking site like facebook. It contains different types of input fields – Numeric, String, Alpha Numeric, date, preset values (from drop downs or check boxes), file uploads and Email addresses. Name: String input field Password : Alphanumeri
Read More

How to test search functionality

Every web application by default will contain search feature in it. Many search engines’ main functionality is search feature. The parameters to be considered while developing this feature or testing this feature are not limited. There are many factors which should be looked in when checking the coverage and usability of the search text box in the application. Preparation before testing the search functionality 1.        Note down the valid input details for the search feature. 2.        Find out the minimum and maximum range. 3.        Find out the depth of the search – document search, word in a document, image search 4.        Should document search display the size of the document also? Similarly for image? 5.        Any advanced search features like document or image type selection to refine the search are available? 6.        General set of input which can be given are a.        A-Z b.       a-z c.        0-9 d.       {      [              (       
Read More

Scrum Methodology - Quick Info

Image
It is one of the unique methodologies of agile methodology. Scrum  It is an   iterative, incremental   framework for project management . It   is a loose set of guidelines that govern the development process of a product, from its design stages to its completion. It aims to cure some common failures of the typical development process like a. chaos due to changing requirements, unrealistic estimates of time, cost and quality of the product. Meetings 1.      Daily Scrum meeting or daily stand up meeting: agenda:  what is done, what is planned for today, what are the problems in accomplishing the goal? 2.      Sprint planning meeting : Before each sprint cycle (7-30 days)starts, prepare sprint backlog, timelines, 3.      Sprint review meeting: done at the end of sprint cycle, review work completed and not completed, demo the work completed, do not demo incomplete work, 4 hour time will be allocated. 4.      Sprint retrospective meeting: done at the end o
Read More