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
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 May 21, 2018 in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

1,012 views 7 18
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