Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

"Original Estimate" not imported during Bulk Issue importing

Tiago S_ August 5, 2022

Hi,

I'm trying to import issues into a project, and the field "Original Estimate" is not imported.
The point is, I have a column "Original Estimate [s]" in my .csv file (in seconds), and JIRA reads it, but the issue is created without any value in the correspondent field.

Please see the pictures:
1st shows the import setup, the 2nd shows the result.

 

Thanks in advance,
Tiago

jira-import-1.pngjira-import-2.png

1 answer

0 votes
Trudy Claspill
Community Champion
August 5, 2022

When I tried to replicate this, the pull down for mapping the Original Estimate field shows "Original Estimate (in seconds)". That is the only mapping field option I have for Original Estimate. Do you have more than one option?

Screen Shot 2022-08-05 at 10.43.05 AM.png

Providing a value in seconds (i.e. "3600") in the import file is importing for me and setting the Original Estimates field to "1h".

Are you using Jira's built in time tracking, or a third party app?

If you go to Settings > Issues > Time Tracking, what do you see for the settings? This is what I see.

Screen Shot 2022-08-05 at 10.47.10 AM.png

Tiago S_ August 5, 2022

Hi @Trudy Claspill , thanks for your answer.

The option "Original Estimate (in seconds)" is not available in my settings. The time tracking settings are the same as yours:

jira-import-3.pngjira-import-4.png

Trudy Claspill
Community Champion
August 5, 2022

Hello @Tiago S_ 

I think you and I discussed a precursor to this in another post. :)

https://community.atlassian.com/t5/Jira-Software-questions/How-to-set-up-issue-importing-with-original-estimate/qaq-p/1971331

I found that if I go through the Bulk Import option on the search screen then the mapping shows "Original Estimate". If I go through administrator screens (gear > System> External System Import), then the field shows "Original Estimate (in seconds)".

For me, both methods successfully updated the Original Estimate value when I imported to both Team Managed and Company Managed Software projects.

Are you importing to a Team Managed or Company Managed project? A Software, Business, or Service project?

What is the exact value you have in the CSV file for the Original Estimate value?

Can you show a screen image of one of the imported issues in Jira showing the Original Estimate field? 

Tiago S_ August 5, 2022

Hey @Trudy Claspill, sure! I asked a similar question few months ago, and your help was decisive. Thanks again!

About the project, it is a Company-managed Software project. I'm using it to plan and manage personal stuff (not company-related).

I'm trying to import a two-row csv file, as a test. The values are 600 and 2400 seconds.

Prints:
1) The screen I see when importing issues from .csv file
2) .csv file
3 and 4) Imported issues

jira-import-5.pngjira-import-6.pngjira-import-7.pngjira-import-8.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events