Bulk import of issues from CSV - how to maintain correct sequence + missing story points mapping

Hi,

We have a CSV file of standard issues which we import into each new GH/Scrum project. The issues are ordered sequentially in the CSV file. However I notice that after the import, the stories are out of order. So I have to manually reprioritize them to get them in the right order.

How can I import and yet maintain the sequence?

Also, I notice that there isn't a Story Points field in the mapping phase of the import. I have to create a Story Points custom field to map top the corresponding column in the CSV file. I read that it is possible to have the Story Points field visible by making it a 'globally visible' - how do you do that?

Thanks very much.

Prem.

5 answers

1 accepted

This widget could not be displayed.

You can setup the csv column to have a Pr# column where the order is listed. In GreenHopper you can then edit one of the project contexts to show the issues in Pr# order.

This widget could not be displayed.

Prem, does the CSV file include also the ranking column that is used in GH for sorting? I am just guessing that if this is present you can keep the sort order same as in CSV. But am not sure whether it can be used since there are chances that the ranking gets a conflicting value while importing.

This widget could not be displayed.

A good point Renjith. I was thinking about including it but was hesitant for the same reason you point out. Multiple projects are sharing the same rapid board. And the same standard issues are being imported for each project. An issue that is imported into each project would have the same rank value - I wonder how GH/JIRA would deal with it?

This widget could not be displayed.

You should just go ahead and try in on a staging Jira server :) You mentioned Rapidboard, but your original question says importing when ever a new project is created. Do you really need Rapidboard or isn't the original GH is sufficient as you don't need prioritization across projects.

This widget could not be displayed.

We want to standardize our processes & procedures, and since Rapid Boards will eventually replace Planning/Task boards, we'd rather be standardizing on them. That's why we'd like to get things working right with Rapid Boards.

Will have to experiment with the ranking field.

Thanks Renjith.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Thursday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

78 views 0 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you