How to import the Original Estimate Field using CSV?
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
How to import the correct value of the Original Estimate Field using CSV?
Solution
The value of the original estimate field should be in seconds in the CSV file. It's calculated as follows:
(The value in days) x 8hours/day x 3600 seconds/hours = The value in seconds.
Given that the day is 8 hours in the Time Tracking setting
Example:
Original Estimate = 2d
2days x 8hours/day x 3600 seconds/hours = 57600 seconds.
The CSV file should be as follows:
1
2
Issue key,Issue Type,Summary,Original Estimate
1, Task, test issue,57600A new issue will be created with original estimate of 2 days.
Updated on May 31, 2024
Was this helpful?
Still need help?
The Atlassian Community is here for you.