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

Question

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!

Miklós Tix · Answer

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.

Karin Kirschner · Answer

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!

Miklos Tix · Answer

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:

Let me know if cannot manage it.