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

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.

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.

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?

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.

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

75 views 0 5
Read article

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