CSV-Import: Values for Field Original Estimation are not importet

Karin Kirschner
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 24, 2023

I try to import Team Story Estimations as subtasks for Features. Everything works fine, but the values, that I want to import for the Field Original Estimation are not imported.

The field PT from CSV is mapped to "ursprüngliche Schätzung" / Original Estimation.

in csv i tried:

8,25 => error in Import Validation

8.25 => error in Import Validation

8d2h => error in Import Validation

8 => no import error, Values of original estimation after import = 0

then i found in a description of csv that I should take seconds, so i tried:

30000 => no import error, Values of original estimation after import = 0

 

I tries the field definitions in Excel:

Standard

Figure with 2 decs

Figure without decs

Text

 

Can anyone please tell me how i can upload my estimations? Thx a lot!

 

2 answers

0 votes
Miklós Tix October 27, 2023

Hi, I used google spreadsheets without any format changes and I just downloaded the file as csv.

Let me know if still doesn't work.

0 votes
Miklos Tix
Contributor
October 27, 2023

Hi @Karin Kirschner

Do you have the "Work on Issues" permission in the project?

Does the time tracking system field presented on the create screen?

I was able to import estimations and I used seconds. So I imported to the Original Estimation field and imported like this:

image.png

Let me know if cannot manage it.

Karin Kirschner
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 27, 2023

Hi, thx for the answer, The fields are available and I can enter them if I create or change the subtask manually. Only upload fails. :-(

How did you define the excel column for the estimation?

Thx a lot!

Suggest an answer

Log in or Sign up to answer