CSV import - original estimate

[Natia Chincharauli]

Hey Team,

I am trying to create issues from CSV with original estimate time included. (See picture 1 below) Tried to insert in 30m/30 minutes/30/1800 formats and none of it worked. When an issue is uploaded, original estimate stays 0 minutes. (See pic 2)

Can you please, assist?

Pic1

Pic2

[Tansu Akdeniz · Accepted solution]

Hi @Natia Chincharauli 

Original estimate value needs to be specified as second.

I guess you properly match the original estimate field within import wizard. Did you have a chance to investigate detailed log file which becomes available after import process? 

Also please take a look: https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

[Pramodh M · Accepted solution]

Hi @Natia Chincharauli 

You should be able to import the issue with the Original Estimate. You should input the value in seconds

Here's the reference (https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file)

This is the page we get while importing

Sample CSV File

Summary,Issue key,Status,Original Estimate
Issue 2,PT-2,Done,3600

Thanks,
Pramodh

[Natia Chincharauli]

Thanks Pramodh, 

the problem persists since there is no specified time frame when I map original estimate. For 3600 value (which should be 1 hours) is uploaded as one minute in jira. 

[Filippo Marchesi]

This bug persists. 72000 seconds is converted as 20 minutes rather than 20 hours.

[dmitriy_landa]

The issue still there

[Praful Sonarkar]

I am also facing the same issue. not able to import stories with estimations. This defeat the purpose the having import feature, if I still need to go to each story and put the estimations manually.