Python class that extracts issues from a Jira server to an Excel file.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
GRIGOLO Alessandro 73b9991205 Modified README 1 month ago
.gitignore First commit 1 month ago
LICENSE Initial commit 1 month ago
README.md Modified README 1 month ago
errors.py First commit 1 month ago
jiraex.py First commit 1 month ago
requirements.txt First commit 1 month ago
stats.py First commit 1 month ago

README.md

Jiraex

Python class that Extracts issues from a Jira Server to an Excel file.

Usage example :

  • Clone this repository and enter local repo path.
  • RECCOMENDED - Create a new venv :
python3 -m venv.
source bin/activate
  • Install dependencies
pip install -r requirements.txt
  • Create a new Python script, import “jiraex” and define a jql string and a configuration dict. The dict should at least contain the server, password and user fields (see below).
import jiraex

jql = 'project=TEST and created > -365d'

config = {
    'server': 'https://test.com/jira',
    'password': 'jirapassword',
    'user': 'jirauser',
    'fields': ['issuetype.name', 'summary', 'status.name', 'created', 'resolutiondate', 'Story Points'],
    'epics': True
}
  • Create new jiraex instance by passing the configuration dict as parameter:
jiraSession = jiraex.Jiraex(config) 
  • Start the extraction
jiraSession.extract(jql)
  • Write the extraction to an Excel file by passing the desired filename as argument:
jiraSession.writeExcel('extraction.xls')