bulk upload subtask with original estimate

[akash_ramtohul]

Hello ,

Am uploading all my subtask in an excel (csv)format . the issue am facing is that the original estimate is not shown in the subtasks its remains to 0m

sample file : 

after upload :

can someone please help 

thanks 

[Darryl Lee]

Hi @akash_ramtohul --

Apparently there is a known bug with importing Original Estimate, where the values are divided by 60.

In this question and answer thread I'm seeing people say that they put in 3600 "seconds" and it shows up as 1 minute instead of 1 hour.

Similarly, somebody else reported putting 72000 seconds and it got converted to 20 minutes instead of actors.

SO MAYBE the fix/workaround would be to multiply your estimates by 60?

Please let us know if that works.

[Darryl Lee]

Hey, so I finally did some testing (imagine that!) and can confirm that the hack to *60 all of the estimates did work. But I came here to specify that this only works in the CSV Importer that is available when you are in Advanced issue search:

There is another way to import CSVs, via the External System Import and if you use that, you don't have to multiply Original Estimate by 60. But it turns out it's also a bit more complicated!

As @CJ Edwards explains really well, when you use external system import (which is only available to Jira Admins), you have to include the Parent Issue in your CSV file.

• Unable to load sub-tasks from CSV file 

It's a little tricky, and honestly if it was me, I'd just multiple all the estimates by 60 and use the other CSV importer that only needs the subtasks with Parent Id specified. 

[habib rahman]

@akash_ramtohul HI my name is Habib -

It sounds like you are experiencing an issue with uploading subtasks in an Excel (CSV) format and the original estimate not showing up after upload. A few different things could cause this, but here are a few solutions you can try:

1. Check the formatting of the original estimate column in your CSV file. Make sure that the values are formatted correctly as time estimates, such as "2h" for a two-hour estimate or "30m" for a 30-minute estimate. If the values are not formatted correctly, they may not be recognized by the system and will not be displayed.
2. Ensure that the original estimate column is mapped correctly during the upload process. Some systems require you to map the columns in your CSV file to the corresponding fields in the system. Double-check that the original estimate column is mapped correctly to the corresponding field in the system.
3. If neither of the above solutions works, try uploading the subtasks in a different format, such as a plain text file or a different type of spreadsheet file. Sometimes, different file formats can cause issues with data not being recognized correctly.

If none of these solutions works, it may be a technical issue with your system. In that case, you can reach out to the system's support team for assistance.

I hope this help.

Thank you 

Habib 

[akash_ramtohul]

Hello @habib rahman ,

when uploading all the other field value are being reflected except for original estimate.

here is the mapping that am doing.  

while doing the doing the verification test it's not showing any errors 

that I read original estimate should be in seconds

but i don't know what am doing wrong. 

thanks for helping. 

[Darryl Lee]

Hey @habib rahman - I appreciate the efforts you're making to answer questions here on the Community, but you might want to look a little more closely at your answers, and ideally, provide references for them.

I (and some other Community Leaders) are a little confused about your third suggestion here:

3. If neither of the above solutions works, try uploading the subtasks in a different format, such as a plain text file or a different type of spreadsheet file. Sometimes, different file formats can cause issues with data not being recognized correctly.

First off, CSV files are in fact plain text files. The whole process is detailed here:

• Import data from a CSV file 

Secondly Jira Cloud does not allow importing of "different types of spreadsheet files". Jira Cloud does allow for importing of JSON files. That is not a spreadsheet file format.