Posts

Amazon offers

Strip off Html tags from excel

When data is exported from any web page into excel or from any other sources into excel. It gets copied with html tags. This is making it difficult to read it. If there are few rows then we can remove them manually but if we there are more number of rows then we can go for below steps. Follow these steps: 1.     Open up the VBE with Alt+F11. 2.     Locate your workbook in the top left Project Explorer window. Right-click on your workbook and choose Insert>Module. 3.     Paste the below given code in to the code module that will open. 4.     Go back to Excel, select the cells you want to clean and activate the macro with Tools>Macro>Macros. (Macro can also be activated by clicking Run icon in Visual Basic). 5.     All the html tags will be replaced. 6.     But sometimes some cells will be displayed as hashes. In such cases, select the Description column again and select Home > Clear > Clear Formats. This will get back your description.

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.       {      [              (       

Estimation of the test effort

Estimation is the base step of any project. If it is not strong then the whole project and sometimes the client itself will be out of our hands. It is not an easy task and not a difficult one too. Not every estimation is successful. Too much of estimation will lose the client and less estimation will scare the employee. Balancing both and winning the project is what needs to be learned. Here are the factors which should be considered before making estimation 1.        Technical a.        Experience and Knowledge of test team in the technology which is used. b.       Type of application – web application, executable file, games or any other. c.        Technical dependencies (if development and testing team is not at one location). d.       Tools used and their flexibility 2.        Functional a.        Number of requirements free zed b.       Number of critical functionalities c.        Types of testing done – User interface testing, cross browser testing, localization testing and ma