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

This widget could not be displayed.
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

This widget could not be displayed.

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 Summit 2018

Meet the community IRL

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

Learn more
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,047 views 5 10
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