Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

How to send Daily Test Execution Report with least manual intervention

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts

Guys, help an intern out :
My boss sent me the details :

Current manual intervention includes:
- Export defect list from JIRA system, copy paste to excel
- Populate data for Daily Defect list
- Populate data for Closure Rate
- Populate data for Ageing JIRA
- Copy all graphs and descriptions to email

You can tackle the problem above by:
- Automate all the points
- Suggest to replace excel with another platform
- Etc.
Currently we are not looking at purchasing tools to do this. What I have in mind is more of a Excel Macro approach to:
- Accessing JIRA DB to retrieve defect data
- Generate an email template based on the reporting data

One of the possible outcome for this is, in Excel:
- One sheet for user to specify details (JIRA Project, defect search criteria, etc)
- A button to click and generate all data, based on pre-build SQL statement in one sheet (using Macro)
- A button to copy everything on the sheet to email template (using Macro)

Any suggestions for me and how to get started

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP