LOGIN
התחברות או הרשמה
Avatar
להמשך הרשמה ידנית – לחץ על כפתור ההרשמה, להרשמה/כניסה מהירה בעזרת חשבון רשת חברתית – לחץ על הלוגו בכותרת

אפס סיסמה - שכחתי את שם המשתמש

שם משתמש
סיסמה
זכור אותי

he icon   en icon

בכדי להוסיף פוסט בבלוג יש להרשם או להתחבר - ההרשמה/כניסה מתבצעת מכותרת האתר.

כיצד לפתח מערכת שליחת דוחות אוטומטית ל Bugzilla

נכתב על ידי 
חמישי, 03 אוקטובר 2013 06:33
דרגו כתבה זו
(2 הצבעות)

 

 

 

 

 

How to develop you own Bugzilla report server

 

As part of Q.A manager tasks you are required to send various reports on your project quality.

If doing it the right way these reports can give you a lot of information on you projects for example:

Which module has the most critical bugs, how may bugs you team produces, what is the reopen bugs rate , bugs trends and a lot of other KPI which can give your managers information how to improve the quality of your projects.

There is a lot of knowledge in the Bugzilla Data base and you as a Team leader should use it to reflect this in formation correctly.

Several months ago I was asked to setup an automatic solution for generating Bugzilla reports based on several KPIs which our managers defined.

After searching the web I could not find a simple solution which suite our needs (at least not a simple one).

All of you probably familiar with a simple program called “excel” J.

Wouldn’t it be nice to get every day an excel report to you mail which reflect your products status, trends etc..

So…. Let’s start.

Bugzilla is using MySql DB, you can download mysql connector

http://dev.mysql.com/downloads/connector/odbc/5.1.html

And set up an ODBC connection

http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-examples-tools-with-wordexcel.html

(you will need the correct privileges for connecting directly to the Bugzilla DB like username , password and port, ask you IT guys for that)

Now that you have the connection you can easily import data from Bugzilla DB to your excel file, perform all kind of calculations, generate graphs and use all of excel features as you like.

I have setup a windows schedule task for rendering the excel file on a daily bases and sending it to several managers.

Now I had to deal with another problem, our managers liked it so much that they started to ask me for additional reports which were very hard or even impossible to extract form Bugzilla the way the DB structure is.

So to overcome this I have setup additional MySql DB which saves snapshots from the original Bugzilla DB (it is very simple to install MySql DB , generate tables using HeidiSQL client).

You can export MySql queries from the original Bugzilla DB and import it to you snapshots DB.

Once again generate your reports from the snapshots DB.

All of the reports can be on the same excel file connecting to both MySql DB (see example)

I am sure that there are other ways achieving this task but I needed a free simple and flexible solution which everyone knows. 

Enjoy

 

 

 

 

שונה לאחרונה ב שישי, 04 אוקטובר 2013 11:31

חובה להיות משתמש רשום במערכת בכדי להגיב - ההרשמה/כניסה בכותרת האתר

חדשות מעולם הבדיקות

  • 10 Amazing Reasons to Attend TestBash Brighton

    by Rosie Sherry Want to go to TestBash Brighton , but struggling to put good reasoning together for yourself or your boss ?   There’s no doubt that the world of conferences, software testing and TestBash has changed in the past few years.  In the case of TestBash(es) we’ve evolved and grown in many different ways, I thought it would be helpful to point out some key points and ideas we are working on. Belonging ‘I feel like I belong.  I now understand what TestBash is all about.’  This is one of the most frequent comments we get.  I've heard it many times over the years. For some it can be an almost instant feeling. For others it  can take years for people to get around to coming along to a TestBash.  And sometimes it even takes a few TestBashes for them to get into the flow of it . When we talk about community we mean it.  When you come to a TestBash - you are welcome and you belong.   Sometimes these things take practice and effort. You may look around and feel that people connect with others more easily, whilst you are struggling.  This is a natural way to feel and to be clear, what you see is not always the truth. People at TestBash are always practicing, seeking and exploring ways to connect better.  The more you put in, the more you will get out.  We work hard to encourage everyone to help each other out.  Just[…]

    13.01.2019 | 6:00 קרא עוד...
  • TestBash Manchester: TestBash Of The North

    The North remembers what an absolute belter TestBash Manchester 2018 was, so we are coming back, Manchester! For a fourth time! And, we can’t flipping wait! It going to be a spectacular action-packed week-long extravaganza at The Lowry , filled with opportunities to learn, network, have fun, and of course, space to reflect on all that’s going on. Here’s the itinerary for the week: Automation In Testing (Monday 30th September - Wednesday 2nd October) - a fantastic three-day training course taught by Richard Bradshaw and Mark Winteringham. You’ll learn all about the current state of automation, how to design and implement reliable, targeted automated checks, and create new automation tools to test products at your company. TestBash Workshops (Wednesday 2nd October) are a series of ½ day workshops, some of which focus on technical testing and some on the softer skills a tester needs. A workshop ticket gives you the chance to choose two workshops that appeal to you on a first come, first served basis. TestBash (Thursday 3rd October) is our original software testing conference. It’s a single track event, meaning every talk is a keynote and all attendees have lots to talk about during the breaks and socials. Expect a balance of talks that cover the important aspects of testing, quality and working in software development. It’s fun-filled, jam-packed day! Test.bash(); (Friday 4th October) is our technical testing and automation focussed conference. It’s a single track event, with fun and unique elements sprinkled throughout. Expect talks that include[…]

    12.01.2019 | 6:00 קרא עוד...
  • December RoundUp of All Things MoT

    December was a great month, a nice end to 2018.  We're all ready for 2019 and no doubt full of resolutions.  Is one of them to  speak at a TestBash ?  Or maybe to focus on your professional growth with a  pro member account ?       The Club A few selected discussions from  The Club  that we thought you might find interesting. How to test a mobile game?  posted by nitin1387. When you're new to mobile games testing, it can be difficult to know where to start or what skills are transferable. Do you have  beef  with the idea that anyone can test software?  posted by rosie. How do you respond to the arguments that anyone can test software, so professional software testers are not needed, in a meaningful way? How Would You Test An ATM?  posted by heather_reid. What behaviour would you expect, and not expect, from the ATMs you use? Test Team Structure  posted by inkyfreak. What way are teams in your organisation structured and what have you found to be the most effective structure for test teams? Your Most Used or Favourite Swag Item  posted by heather_reid. We're mindful of the environment and keeping waste levels low at MoT, so we're wondering what swag items you use every day no matter where you got them from.   The Club Ninja Each month we select one of our Club users to be our  Ninja of the Month .  Our Club Ninja this month is Tuan Tran!  […]

    9.01.2019 | 6:00 קרא עוד...

טיפים

  • אל תבזבזו שעות וימים על הכנת דו"ח שבועי - השתמשו ב- Dashboard.
    אל תבזבזו שעות וימים על הכנת דו"ח שבועי - השתמשו ב- Dashboard. אל תבזבזו שעות וימים על הכנת דו"ח שבועי - השתמשו ב- Dashboard. נצלו המידע שכבר קיים במערכת דיווח הבאגים ומערכת ניהול הבדיקות, וודאו שה- dashboard נגיש לאנשים הרלוונטיים בקלות ומציג מידע עדכני.
    קרא עוד...
  • בודק - למד להסביר
    בודק - למד להסביר בודק - למד להסביר – כבודקים אנו נאלצים להעביר הלאה מידע רב בשלבים שונים של עבודתנו, החל מהסבר על התקדמות ומצב משימת הבדיקות שלפנינו, דרך הסבר מהות הבאגים, מקורם, חומרתם והשלכותיהם. מעבר לכך פעמים רבות אנו…
    קרא עוד...
לרשימה המלאה >>