Bulk CSV upload - Sprint Question

[Hayley Yates]

Using the external upload tool to bulk load tasks

How do you map to sprint?

Sprints are already created

[Kishan Sharma]

Hi @Hayley Yates 

In your CSV, include a column titled "Sprint" where you will enter the existing Sprint IDs against the issues you intend to create. After uploading the CSV, the system will create the issues and fill in the Sprint field as required. Refer example below -

Step 1: Get the sprint ID - Hover over any existing sprint, in the bottom left you will get the sprintID, in this case its 41.

Step 2: Prepare the CSV 

Refer Import data from a CSV file for details steps on how you can prepare the CSV and import it in Jira cloud.

Step 3: Map CSV Fields to Jira field during the import -

Hope this helps.

[Atlass Monster]

Hello @Hayley Yates 

I suggest you edit the CSV to already include the Sprint information before you upload them. If that's not possible or it's too late...

Other ways I can think of:

1. Manually select all issues and use the bulk editor https://support.atlassian.com/jira-software-cloud/docs/edit-multiple-issues-in-bulk-on-your-timeline/  (not to be confused with the importing csv)

2. Using Jira automation

You can use if blocks with conditions if there issues contain enough similar information to bulk edit them. I suggest you use the  Scheduled trigger and run the rule manually. Once done disable the rule to avoid problems.

3. External tools for automations like ScriptRunner and JMWE.

If my answer was helpful you can mark it as solution, if not I will be glad to try to help you further with your issue :)