Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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!
Oct 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

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.

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!
Oct 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