Jamie Wardlaw
My feedback
1 result found
-
expose a structure's "order" so JQL queries and filters can be created to list issues in that order.
9 votesAn error occurred while saving the comment An error occurred while saving the comment Jamie Wardlaw commentedHello Igor,
When you export to excel the indentations on the task name are incompatible with MS Project import. I have got round this by removing the indents so that is not a big deal.
What i'm finding problematic is the Original Estimate / Time Spent. These fields are converted using a custom format. MS Project see's this as invalid and just drops 0 hrs in each time I synchronize. If you could export to excel in simple text format the calculated hours value that would be better. Or, I think the native format of the data in JIRA is seconds, just export the seconds and a simple excel formula can be used to convert before MS Project Import.
A final, trivial point, is that sheetname seems to have invalid characters in it preventing excel from accessing the sheet (this could of course just be due to my structure name). I just rename the sheet just now. If your standard export function just left the sheet name as "Sheet 1" then the problem would not occur.
An error occurred while saving the comment Jamie Wardlaw commentedFollowup to this, I spotted the 'x' in the latest structure version views and exported my structure to excel. This is really useful, but the native data types exported to excel are not compatible with an MS Project import which is a shame.
An error occurred while saving the comment Jamie Wardlaw commentedEven something as simple as an export of the struture 'tracking' view to excel would facilitate my need.
An error occurred while saving the comment Jamie Wardlaw commentedI would like to see something like this such that the order of the structure would be used in an export of the JIRA fields. We are working on projects where we still use MS Project for longer range dependancy forecasting and end of project estimation. Through a simple JIRA filter export we can export all tracking to the Gantt chart for easy update and synchronization. If we were able to also export the order within the structure it would make it easier to maintain the Gantt on a biweekly / monthly basis such that the task depedancies could be built quickly in the Gantt chart to reflect that which has been "structured". All I need is a filter ordered as per the structure to make this super easy.
It looks like you export in fractions of days so I can use a formula to get it to a compatible format.
It would be better just to export the numerical number of hrs/secs though.
On import to project I still get some errors and crashes but that is perhaps MS Projects problem.