Preserving the order (priority) of issues when importing (CSV)

When importing a CSV file into an OnDemand version of Jira, how can I preseve the order (priority) of my issues? The resulting order in Jira seems to be random. I attempted to use "rank" values that don't conflict with our existing issues, but the result remained the same (random order) and after inspecting the issues in the "issue browser" I can see that the provided rank value was not assigned in the import process.

4 answers

1 accepted

This widget could not be displayed.

I create an issue at https://studio.atlassian.com/browse/JIM-751 to track this problem. I'm not sure if we ever supported that (I understand that Rank field is available in the selection, but implementation might be trickier than that). Going to schedule it with other issues.

Ranking field in modern version of GreenHopper (when it was switched to use AO) is a special field which is not compatible with how JIRA Importers Plugin set custom field values. I.e. it ignores whatever we set there. We will probably need to use GH API for setting the ranking.

Hi all, I'm quite fresh to Greenhopper and JIRA, but have been customising it for a day now and think it will work out nicely for us.

I've reformatted our backlog to come together with the JIRA/GH philosophy, but am lacking the possibility to map GH fields during a JIRA CSV import. I have not yet found a GH CSV import to add agile data:

Story points, Business Value, Rank and Sprint

to the issues I imported previously.

I'm in the lucky position that the project we will start with has a relaxed backlog of 160 issues, of which about 40 are current. We are a creative digital agency with software projects that typically do not span years or 100s of people. I think that if I was into more "serious" software, with 100s of linked backlogs, this would be a total dealbreaker.

If anyone does have an import-based solution, I'd love to hear it!

Thanks, Franz

PS: I looked at the issue link you list which now links to a dead page.

Hi all, was there a resolution to the ordering problem with the import/GreenHopper board? The JIRA that was created by Pawel no longer exists: https://studio.atlassian.com/browse/JIM-751

I'm still seeing that my imported issues are showing in random order in the Backlog section of the GreenHopper board. How is rank being set at the time of creation when you don't specify a rank to begin with?

Jenny, JIM project is now tracked on ecosystem.atlassian.net and https://studio.atlassian.com/browse/JIM-751 should redirect you to https://ecosystem.atlassian.net/browse/JIM-751.

But this feature hasn't been yet implemented. CSV importer creates issues in random order (not as they were listed in CVS) and they are automatically put at the end of the current backlog. That's why effectively you see random ranking order.

Thanks for the clarification Wojciech.

This widget could not be displayed.

Priority is a field which has values that you determine, you should be able to map them on import.

Rank is a little different, but essentially still a field with values - you should have included a rank field on import, told the importer to map csv-rank to your custom field rank and imported it. If you weren't offered a mapping on import then you need to check the data in the import sheet, and that your rank custom field is available.

Thanks for clarifying, and by "priority" I did indeed mean "rank" - i.e., the order in which the stories are listed (high to low value). To further clarify, I did provide a csv-rank column and I did map it to the jira-rank field, but to no avail. The order was not preserved. When I viewed the records in the "issue browser" (using JQL), the reflected rank values were not what I had imported.

This widget could not be displayed.

I think I0I'm having the same issue with this, as well as story

This widget could not be displayed.

Hi all, I'm quite fresh to Greenhopper and JIRA, but have been customising it for a day now and think it will work out nicely for us.

I've reformatted our backlog to come together with the JIRA/GH philosophy, but am lacking the possibility to map GH fields during a JIRA CSV import. I have not yet found a GH CSV import to add agile data:

Story points, Business Value, Rank and Sprint

to the issues I imported previously.

I'm in the lucky position that the project we will start with has a relaxed backlog of 160 issues, of which about 40 are current. We are a creative digital agency with software projects that typically do not span years or 100s of people. I think that if I was into more "serious" software, with 100s of linked backlogs, this would be a total dealbreaker.

If anyone does have an import-based solution, I'd love to hear it!

Thanks, Franz

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 7 hours ago in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

17 views 0 4
Join discussion

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