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

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 vote
Peter DeWitt Community Champion Nov 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

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 Champion Nov 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

0 vote

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

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

11,957 views 15 13
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