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

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

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

  • Fifteen Free Tools to Help With Testing

    Fifteen Free Tools to Help With Testing There are a great many articles, blog posts, and presentations that discuss automation frameworks and strategies.  But even the most robust automation framework won't eliminate the need to do exploratory testing.  There will always be situations where we need to generate a large amount of text to test a text field or where we need to encode a string in HTML to test for cross-site scripting.  In this week's post, I share fifteen of my favorite free tools that make testing faster and easier.  Text Tools:1. Letter Count:  This tool will count the characters or words in a block of text.  I use it for creating strings with a specific character count when I test text fields.2. Lorem Ipsum Generator: I use this tool when I need to generate large amounts of text for text fields where a user will be able to enter several paragraphs of text.3. Convert Case: This tool comes in handy when I'm testing with Postman and my assertions are expecting the exact casing for string comparison.  Convert Case will set all the characters in a string to lower case, upper case, sentence case, alternating case, and more.JSON Tools:4. Pretty Print: JSON objects need indentation to be easily readable.  This tool will take care of all of the indentation and spacing for you.  This is especially helpful when you receive flattened JSON in a response and you want to be able to read through it.5. Online JSON Viewer: This tool will flatten your JSON for you by removing[…]

    15.12.2018 | 2:14 קרא עוד...
  • Hacking Password Reset Functionality

    Hacking Password Reset Functionality So I have recently returned from 3 months travelling around Colombia and Central America and I am ready to get back to work! One thing that stayed with me during my travels is the amount of time technology would generally appear in conversations from Bitcoin to GPS systems – this gave me further motivation to expand my career in this varied and extremely interesting field. I recently got an email from Pluralsight with an invitation to use the platform for their free weekend, so I thought it would be a good opportunity to take some security classes. Especially considering one of my 2019 goals is to complete the CEH qualification. The course I decided to do focused on web hacking password reset functionality. Please continue reading to learn more about the various ways password reset functionality is vulnerable to attacks. There are generally 3 different ways to reset user password on websites: Password reset links (by far the most common) Generating a new Password which is sent (in plaintext) to the users email Question and Answer style A typical password reset link could look like this: https://example.com/reset.php?token=12345ab6 or it could look like this, using two parameters -> user ID and token https://example.com/reset.php?userId=12345&token=12345ab6 The userId parameter is unnecessary in the second example, as each token should be unique to the user, making the userId parameter arbitrary. A vulnerability which can be easily fixed is that the link should only be valid for a certain amount of time (enough time for the[…]

    15.12.2018 | 1:20 קרא עוד...
  • I Represent the User! And We All Do

    As a tester, I try to represent the interests of users. Saying the user, in the singular, feels like a trap to me. There are usually lots of users, and they tend to have diverse and sometimes competing interests. I’d like to represent and highlight the interests of users that might have been forgotten or overlooked. There’s another trap, though. As Cem Kaner has pointed out, it’s worth remembering that practically everyone else on the team represents the interests of end users in some sense. “End users want this product in a timely way at a reasonable price, so let’s get things happening on schedule and on budget,” say the project managers. “End users like lots of features,” say the marketers. “End users want this specific feature right away,” say the sales people. “End users want this feature optimized like I’m making it now,” say the programmers. I’d be careful about claiming that I represent the end user—and especially insinuating that I’m the only one who does—when lots of other people can credibly make that claim. Meanwhile, I aspire to test and find problems that threaten the value of the product for anyone who matters. That includes anyone who might have an interest in the success of the product, like managers and developers, of course. It also includes anyone whose interests might have been forgotten or neglected. Technical support people, customer service representatives, and documentors spring to mind as examples. There are others. Can you think of them? People who[…]

    15.12.2018 | 11:33 קרא עוד...

טיפים

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