Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import jira.client
- from jira.client import JIRA
- from jira import JIRA
- import pandas as pd
- options = {'server':'your server URL here'}
- jira = JIRA(options, basic_auth=('your user name here','your password here'))
- #extracting number of issues loop because of Jira limitation.
- block_size=100
- block_num=0
- allissues = []
- while True:
- start_idx = block_num*block_size
- issues = jira.search_issues('project=your project here', start_idx, block_size)
- if len(issues) == 0:
- break
- block_num += 1
- for issue in issues:
- allissues.append(issue)
- print ('Number of issues:', len(allissues))
- #into pandas
- issues=pd.DataFrame()
- for issue in allissues:
- d = {
- 'assignee': issue.fields.assignee,
- 'key': issue.key,
- 'creator' : issue.fields.creator,
- 'reporter': issue.fields.reporter,
- 'created' : issue.fields.created,
- 'components': issue.fields.components,
- 'description': issue.fields.description,
- 'summary': issue.fields.summary,
- 'fixVersions': issue.fields.fixVersions,
- 'subtask': issue.fields.issuetype.subtask,
- 'issuetype': issue.fields.issuetype.name,
- 'priority': issue.fields.priority.name,
- 'resolution': issue.fields.resolution,
- 'resolution.date': issue.fields.resolutiondate,
- 'status.name': issue.fields.status.name,
- 'status.description': issue.fields.status.description,
- 'updated': issue.fields.updated,
- 'versions': issue.fields.versions,
- 'watches': issue.fields.watches.watchCount,
- }
- issues = issues.append(d, ignore_index=True)
- issues.to_csv(r'your csv path here')
- print(issues)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement