Wednesday, April 8, 2015

Mantis Bug Tracker step by step Installation on Windows 7

Here one another topic. Today I am going to discus about Mantis Bug tracker tool . Which is one of widely used bug tracking tool. Mantis is open source bug tracking tool or you can say defect tracking tool. Now days there are many tools available in market both open source and Paid source. Before starting i would like to tell you system requirement .

-Windows PC  with , Wamp server
- 50 MB Disk space.
- Downloaded Mantis setup

Now about Installation of Mantis bug tracking tool in Windows 7 using wamp server
Before starting installation you need to install Wamp server on your machine and start it ( Stop IIS server and then start wamp server). Follow below steps

Copy the mantis folder and store it in Wamp server www root directory.

Open internet Explorer and in address bar type http:// localhost
it will open localhost server screen for Apache server and You can see Mantis folder Under   Your Projects

 Click on Mantis Folder under  Your Projects  You will see  Configuration page for Mantis 

Enter details in fields
Type of Database – MySQL (Default)
Host Name – Local Host
Database Username – root
Database password –root password
Database name – bugtracker
Admin username –  Add this if required
Admin password – add this if required
Print SQL Queries instead of Writing to the Database- Keep it uncheck

Click on button “Install / upgrade Database”

Installation will take place 5 minutes to create database . (Do not refresh the page)

After successful installation it will display screen like this with installation status GOOD / BAD

All installation status need to be in GOOD.Mantis Installation done successfully on Windows 7 step by step

 On Same page go to bottom and click on link
Please log in as the administrator and create your first project.

Mantis default  username – administrator , Password- Root 

Tuesday, January 27, 2015

Sample Test case format in Excel sheet

Starting of testing first time it is need to know how to write test case. Easy to use and Easy to Understand. Many organization now days started to use of  HP Quality center for test case writing Execution and complete testing process . Some organization use Opensource tools like Testlink , also some organization use basic approach is to use of Excel sheet. It's very simple way to start with testing. Here i am prescribing simple format of test case in Excel

Download Sample Test case format in Excel 

Below are the details of simple software test case format 

Project Name :-  Here logical have to write project name . 
Test Case ID :-   It's require to easily identify test case and providing unique id to each test case
Test Case Name :- Name of Test case
Test Priority:-  It's always good to give test case priority. So in case we need to run test cases only high level or priority base then it would be easy.
Product / Module Name:-  Here you can mention Product name or module name. Logically there may be many modules or application in project to test so its easy to categorize test case for specific module.
Description :- You can write detail description about test case and Functionality going to test
Prerequisite :- In every testing there may be some prerequisite need to be completed without it test cannot be performed. It's good to mention prerequisite in test case so executor can verify prerequisite before starting of execution of test case

This is all about header level of test case. Now we will see about detail test case columns 

Step number :- Logically it starts from number 1 its just a step number to identify each step
Test step :- Details about step 
Test data :- Test data is data which is required for testing . E.g- step is Enter user name then test data ill be username "ABCD"
Expected Result :-  Result expected after performing respected step
Actual result :-  Actual result received after performing respected step
Pass/ Fail :- It's status based on actual and expected result. status need to update
Defect ID :- If test case is fail then need to log defect  you can mention defect id here 
Notes :-   Here you can add notes