How to get Sprint ID for CSV import

Question

We are attempting to migrate from Team Foundation Server to JIRA. I am looking into importing all of our stories into JIRA and it's going pretty well except that I'm having trouble getting them into the appropriate sprints. My plan was to create the right number of sprints in JIRA by hand then import all the stories from a CSV file into each sprint as appropriate.  However, I keep getting this error:

Cannot add value [ [Sprint 18] ] to CustomField Sprint in Issue with summary 'Update multiselect control to allow adding values'. Exception Message: Sprint id must be a number: Sprint 18

The CSV file sprints values are things like "Sprint 18". Apparently the importer wants to map that to the internal JIRA sprint ID but I'm having trouble finding out what that is. How does one determine that?

Here is some sample data from the CSV file:

ID,ParentID,Work Item Type,Title,Assigned To,State,Iteration Path,Effort,Description
1716,,Story,Title 1,,Done,Sprint 18,8,Some text
1722,1716,Sub-task,Title 2,John Smith,Done,Sprint 18,,
1884,1716,Sub-task,Title 3,Fred Jones,Done,Sprint 18,,
1737,,Story,Title 4,,New,Sprint 19,5,More text

Jennifer Jennifer_54uay4 · Answer

I have 3 sprints, but only two are coming up in the query results.   Does anyone know why the one is missing?

Thanks!

Bridy Frett · Answer

I created a sample issue and added it to the appropriate sprint.  The issue history shows the new sprint value with both the sprint name and sprint ID.  This worked well since I created all sprints back to back and could simply increment the mapping value in Excel.

You can also get a list of sprints and their IDs using SELECT * FROM AO_60DB71_SPRINT.

Since sprints can be shared across projects, you'll need to ensure it has a unique name to ensure you are mapping to the correct sprint.

Derek Sheeman · Answer

Not terribly useful when trying to export/import thousands of issues and hundreds of different sprints.