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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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