Wednesday, March 3, 2010

Building a simple Issue-tracker application on Google App Engine.. Online.

In this blog post we will walk through the steps in creating a simple issue-tracker application over Google App Engine, using iFreeTools Creator.

Login into iFreeTools Creator (no signup required, your Google Account is sufficient) to start building the application.

The overview of the steps involved..

Edit App Settings under Admin and rebrand your application..


As you might notice, there are options to further rebrand the application providing your logo and also to map the application to your Google Apps sub-domain. But we will leave that for now.

Add an entity to store the Bug / Issue details..

We have allowed the viewing of bug database for guest role users. While to create/edit/delete bug entries, they need to have user or admin role.

Add required attributes..

Our Bug database requires to store the following attributes..
  • Tester
  • Title
  • Description
  • Steps to reproduce
  • Severity
  • Date logged
  • Date closed
  • Notes


Add Tester attribute as a reference to User system-entity..


Notice that the attribute data-type for Tester is Reference and the referenced entity is User - which is a system entity.

Similarly add Title as a String and, Description and Steps to reproduce as a Text attributes. Next will be define Severity..

Adding severity with options to choose from..

The options provided are Critical, Major, Minor and Cosmetic.

Proceed to add Date logged and Date closed attributes with data-type as Date.

That is it.

Now, we are ready to start using our Bug-Tracker App

The form for adding a bug will look like the one given below..

Once added, the bugs will get listed in a Bugs list view..


You may also add users, whom you want to provide access. Just provide their email-id associated with a Google Account. Sample user entries added to the application..


Users with guest role can only view the bug lists. While users with admin and user roles can add modify bug details.

Now we can proceed to add more more bug entries to our bug database..


iFreeTools Creator automatically detects attributes which can be used for charts and provides them readily accessible. The data can be visualized in 3 chart types - Horizontal and Vertical (column) Bar charts and Pie Charts.

Bar Chart visualization..



Pie Chart visualization..



Hope you like the features in iFreeTools Creator. If you have any further queries, feel free to write to raj@sahasvat.com or use our feedback form.

Related :
Also See :

2 comments:

  1. i am doing project on bug tracking system. can u help me?

    ReplyDelete
  2. @hiral jadav : You can get in touch with me on my email : raj@sahasvat.com, with details on how you believe I can help you out.

    ReplyDelete