nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get the below columns for all the issues in an excel sheet using Jira python

Mayank jain_v7m3pk

I want the key, Summary, Assignee Name, Worklog(timeSpent), Epic to which it is related, Story it is related to, and the issue type.

Ps: issues.fields.timeSpent shows the error: AttributeError: type object 'PropertyHolder' has no attribute 'timeSpent'.

Accepted answers

All comments

Prince Nyeche - ELFAPP

Hi @Mayank jain

Please elaborate in details what the issue is and what you've tried in future for clarity?

example "I am using this code in python to extract this <data>, I tried the below <code> and I got the below <error>, what went wrong" That way we could actually troubleshoot what went wrong.

from your question I don't know where to start from rather than ask you another question which is "can you show the exact code being used"?

Mayank jain_v7m3pk

I am using the below code for for first 4 details:

import jira.client
from jira.client import JIRA
from openpyxl import Workbook

jira_options={'server': 'server_name'}
jira=JIRA(options=jira_options,basic_auth=('username','pass'))

key_list = []
summary_list = []
description_list=[]
assignee_list=[]
worklog_list=[]

#Add additional lists for fields here
#Example:
#description_list = []
def get_all_issues(jira_client, project_name, fields):
issues = []
i = 0
chunk_size = 100
while True:
chunk = jira.search_issues(f'project = {project_name}', startAt=i, maxResults=chunk_size, fields=fields)
i += chunk_size
issues += chunk.iterable
if i >= chunk.total:
break
return issues
issues_in_project = get_all_issues(jira, '\"Proj Name\"', ["id", "summary", "assignee", "timetracking"])

for issue in issues_in_project:
key_list.append(issue.key)
summary_list.append(issue.fields.summary)
assignee_list.append(str(issue.fields.assignee))
worklog_list.append(issue.fields.timetracking.timeSpent)

wb = Workbook()
ws = wb.active
key_row = 1
summary_row = 1
description_row=1
assignee_row=1
worklog_row=1

start_column = 1

for key in key_list:
ws.cell(row=key_row, column=start_column).value = key
key_row += 1

for summary in summary_list:
ws.cell(row=summary_row, column=start_column+1).value = summary
summary_row += 1
for assignee in assignee_list:
ws.cell(row=assignee_row, column=start_column).value = assignee
assignee_row += 1
for worklog in worklog_list:
ws.cell(row=worklog_row, column=start_column).value = worklog
worklog_row += 1

wb.save("jira-report.xlsx")

Mayank jain_v7m3pk

TypeError: 'TimeTracking' object is not subscriptable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "c:\Users\kaka\Desktop\Jira_Automation\tds.py", line 35, in <module>
worklog_list.append(issue.fields.timetracking.timeSpent)
File "C:\Users\jaja\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.7_qbz5n2kfra8p0\LocalCache\local-packages\Python37\site-packages\jira\resources.py", line 161, in __getattr__
return self[item]
TypeError: 'TimeTracking' object is not subscriptable

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "c:\Users\tata\Desktop\Jira_Automation\tds.py", line 35, in <module>
worklog_list.append(issue.fields.timetracking.timeSpent)
File "C:\Users\nana\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.7_qbz5n2kfra8p0\LocalCache\local-packages\Python37\site-packages\jira\resources.py", line 174, in __getattr__
if hasattr(self, 'raw') and item in self.raw:
TypeError: argument of type 'NoneType' is not iterable

Mayank jain_v7m3pk

print((issue.fields.timetracking.timeSpent))

when I try this for a single issue, it correctly shows the timeSpent on the issue

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

atl-gruland

python