Format of Sprint in Bulk Upload

Question

Hi, i am carrying out a bulk upload for stories and tasks in a Jira project, I am facing a issue with the Sprint Format. I had named in my excel the sprint format as JL Sprint 1, but it showed me a warning while validating that the sprint value can only be a number. could you help me out?

Trudy P Claspill · Answer

Hello @Tax Genie

Welcome to the Atlassian community.

You need to create the sprint in Jira first. You cannot create the sprint as part of the data upload.

After you have created the sprint, go to the Filters > View all issues screen. Switch it to Advanced JQL if it is not already in that mode.

In the JQL field enter sprint= and then start typing in the name of the sprint. A list of potential matches will display. Find your sprint in that list. The number you need to include in your upload is shown in parentheses to the right of the sprint.