Hello,
I’m trying to import tickets into JIRA using a CSV file, but I’m facing an issue with the Original Estimate field.
I’ve tried entering the value in multiple formats (seconds, minutes, hours), but JIRA does not interpret the values correctly.
"3600"
), and when I try use in hours I get the following errors: Any help or suggestions would be greatly appreciated. Thanks in advance!
Try with 21600 (3600 * 60)
The import file can look like this. Then import it using "import issues from csv". This will create a new issue of type Story.
if you want to update an existing issue, then you can add existing key as Akash mentioned.
I have tested with 21,600 in my instance and it correctly updates the original estimate to 1 hour.
Issue Type | Summary | Original Estimate |
Story | My Test Issue | 21600 |
Thank you very much, it worked for me this way, you helped me a lot.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Glad to know it worked for you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Daniel Dayan Welcome to Atlassian community!
As suggested in the Atlassian documentation, the value of Original Estimate field needs to be specified as number of seconds.
Your import file should look like this,
Key | Summary | Original Estimate |
OS-2 | My Test Issue | 3600 |
Also, please ensure that the CSV file is saved in UTF-8 format with comma delimiters. Try importing/updating one issue at a time and see if it make a difference.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.