Content Comparison

Worklog Extractor

...

A worklog extractor in Jira is a tool that allows you to extract worklog data from Jira and store it in a desired format. This can be useful for tracking employee productivity, analyzing team performance, or generating reports for clients.

We have created worklog extractor for one of our client Experian

We have written a Python script that extracts the worklog data into a csv file.

View file
name JiraWorkLogExtractor - v2.zip

Attached is the Python script that runs the worklog extraction job.

Features we have in Experian

The features of the Worklog Extractor in Experian include:

1. Filter by Projects: For every projects in Jira(whichever we have mentioned projectKeyScopeList in config file), it will check for the issues to extract worklogs from.

2. Filter by Date Range: Users can select a specific date range in config file to extract worklogs within.

3. Output Format: The Worklog Extractor allows users to select the output format for the extracted worklogs, such as CSV or XML(Issue,Project,Issue Type,Business Value,epicLink,Initiative,Work Categories,Worklog Day,Worklog Reporter,Worklog Reporter ID,TimeSpent).

4. Time Tracking: The Worklog Extractor includes time tracking information such as total time spent in a particular Jira issue.

5. Email: At last it will send an email which contain csv report of worklog extraction.

So, similar to Experian, we also planned to create a marketplace cloud app by taking reference from Experian features.

In this documentation, we will guide you through the process of creating a worklog extractor in Jira using Python.

...

1. Connect to the Jira API using the requests library in Python. You can do this by sending a GET request to the Jira API endpoint.

2. Authenticate with Jira using your user credentials or an API token. This will allow you to access the worklog data.

3. Retrieve a list of issues with worklogs from Jira using a JQL search. This can be done by sending a GET request to the Jira API endpoint with the appropriate parameters.

4. Loop through each issue and retrieve its worklogs using the Jira API. This can be done by sending a GET request to the Jira API endpoint for each issue.

5. Parse the worklog data and store it in a desired format. For example, you could store the data in a CSV file or a database.

6. End the extraction process.

Features we have in Experience:

The features of the Worklog Extractor in Jira includeExtra features we can add:

1. Filter by IssueUser: Users can select a specific issue user or a set of issues users to extract worklogs from.

2. Filter by Date Range: Users can select a specific date range to extract worklogs within.

3. Output Format: The Worklog Extractor allows users to select the output format for the extracted worklogs, such as CSV or XML(Issue,Project,Issue Type,Business Value,epicLink,Initiative,Work Categories,Worklog Day,Worklog Reporter,Worklog Reporter ID,TimeSpent).

4. Time Tracking: The Worklog Extractor includes time tracking information such as total time spent.

Extra Features we can add:

...

Below are some similar marketplace apps available:

Worklogs - Time Tracking and Reports : https://empyrajira.atlassian.net/jira/marketplace/discover/app/com.soldevelo.apps.worklogs

Team Worklog Reports: https://empyrajira.atlassian.net/jira/marketplace/discover/app/com.gebsun.atlassian.reports

Worklogs Report: https://empyrajira.atlassian.net/jira/marketplace/discover/app/biz.epicreport.worklogs

Timela - Worklog and Timesheet: https://empyrajira.atlassian.net/jira/marketplace/discover/app/jp.dssolution.jira.timela

Basic App We can and are going to create a worklog extractor by analyzing the other apps in the Jira marketplace:

You can access Worklogs - Time Tracking and Reports via Jira’s top menu, under Apps. 

...