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

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

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

  • AirTest Automation Framework For Games and More

    AirTest Automation Framework For Games and More Do you need to test hard to automate some applications? Games, for instance? I just learned about an open-source tool that can make it easier. It’s called AirTest, and I wanted to write a quick post about it. AirTest is an open-source, test automation tool aimed at hard-to-automate […] You’re reading AirTest Automation Framework For Games and More, originally posted on Test Automation Made Easy: Tools, Tips & Training Awesomeness - and copyrighted by Joe Colantonio

    18.10.2018 | 4:16 קרא עוד...
  • GDPR – the Forgotten Tests – Test 2

    Black box testing is quite popular: the tester only has to focus on the functions of the system. There is no need to know about things like programming and other techy things. “But the box in the picture is not completely black.” “That is a good observation, because it is part of a black box. … Continue reading GDPR – the Forgotten Tests – Test 2 →

    18.10.2018 | 1:12 קרא עוד...
  • How to protect your code against malicious hackers without spending days on refactoring

    During our work as penetration testers, we found that there are lots of vulnerabilities being introduced in applications. Vulnerabilities that could have been prevented in an early stage of development. Sadly these are often the same vulnerabilities over and over again. Luckily the IT development landscape is changing. We can see the latest trend in […] The post How to protect your code against malicious hackers without spending days on refactoring appeared first on Xebia Blog.

    18.10.2018 | 8:58 קרא עוד...

טיפים

  • טיפים לאוטומציה יעילה - Dale Emery
    טיפים לאוטומציה יעילה - Dale Emery (How to Survive the Coming Test Automation Zombie Apocalypse (PDF slide deck By Dale Emery bit.ly/15XFGkp סט שקופיות מעולה המתאר את מרבית המחלות התוקפות פעילויות אוטומציה - ומדגיש כיצד לטפל בהן! על כל שקופית ניתן לפתוח…
    קרא עוד...
  • בודק - בחן את דרך פעולתך מידיי יום
    בודק - בחן את דרך פעולתך מידיי יום בודק - בחן את דרך פעולתך מידיי יום "בחן את דרך פעולתך מידיי יום" – לעיתים קרובות אנו חושבים כי הגענו לשיטת העבודה האידיאלית, או כי אין לנו היכולת לשנות את דרכי הפעולה, וכי השיטות שנבחנו…
    קרא עוד...
לרשימה המלאה >>