How to generate a specific ID # for an issue??

[Lakshmi Narayana Mukkapati]

Hi,

I have created a project to track all the issues those we were tracking using an spreadsheet. Now when create an issue in Jira, it automatically assigns an id(CMG-1, CMG is our project key) but i want to know if i can map the issues number i have in the spreadsheet with the JIRA created issue numbers ex: For issue number 19 in the spread, i want JIRA to create the "CMG-19" as the issue number.

Please help.

[Nic Brough -Adaptavist-]

You can't set the issue key, JIRA generates it for you.

However, it does it sequentially, and when you're importing from a spreadsheet, you can trick it:

1. Add dummy issues into your spreadsheet.  In your case, add 18 lines above the row that will create CMG-19.  Give them a clear summary that flags them as a placeholder (I usually use "please delete me + <sequence>")
2. Import the spreadsheet
3. Do a search for "summary ~ "please delete me" and project = CMG", and then use bulk-edit to delete the dummies

[Lakshmi Narayana Mukkapati]

Thank you Nic for the quick response.