import by csv: how to change the rank in sprint in correct way

Nina November 10, 2017

We imported several tasks to over the External System Import feature. so far all worked fine, but now the new tasks are not in the same order in the sprint as they were in the csv.

this is how the tasks are listed in the sprint:

col-114

col-113

col-112

col-111

col-110

 

and this is how they should be in the sprint:

col-110

col-111

col-112

col-113

col-114

 

 

2 answers

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 10, 2017

Hi Nina,

Jira Software is keeping track of the order that issues appear on boards, sprints, and backlogs using the custom field called "Rank" in Jira Software.   If your source of this CSV data is another Jira Software instances (I presume it is from your description), then it might be possible for you to include the Rank field that appears with each issue in the issue navigator when you create such an export file.  That way you could try to import this rank value directly into the new system in order to keep the order of those imported issue consistent.   You would just need to map this field during the import process on the new system.

Regards,
Andy

0 votes
Peter DeWitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 10, 2017

@Nina, Make sure the filter you are using has this at the end:

ORDER BY Rank ASC

This will allow you to drag the issues into the order you want them to be.

.pd

Nina November 10, 2017

hi @Peter DeWitt, thanks for your feedback. we have this setting already set on our backlog and can drag and drop the tasks.

but when we use the importer and import several tasks at once, it's very time consuming to order each of them. so it would be easier to set the ranking in the csv before we import it to jira..

Peter DeWitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 10, 2017

@Nina, If they are coming from another system (not Jira) there may not be much you can do.  The problem is that the rank values in Jira look something like this 1|hz4pe7: so you wouldn't be able to add your own.

.pd

Suggest an answer

Log in or Sign up to answer