Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-83157

Importing a CSV from External System Import overcalculates the Time Tracking value

XMLWordPrintable

      Issue Summary

      External System Import service overcalculates the value of the Time Tracking field. For example, if the total amount of time spent is 3H by summing the Worklog entries available in the CSV, after the importing of the issues, the value of the Time Tracking field (Time Spent), will be higher.

      Steps to Reproduce

      1. Create a CSV file with the issues fields.
      2. import the file into Jira using the External System Import tool in:
        Global Settings > System > Import and Export section > click External System Import and then click CSV.
      3. Map the desired fields, including "Log Work" and "Time Spent"
      4. Complete the import operation.

      Expected Results

      The value of the Time Tracking (Time Spent) field should be the same as in the CSV file.

      Actual Results

      The value of the Time Tracking (Time Spent) field is higher, sometimes could be double. 

      Workaround

      When importing the CSV, exclude the "Time Spent" field from the mapping and keep the "Log Work" mapped. This will make the system calculate the Time Tracking (Time Spent) using only the worklog values.

              Unassigned Unassigned
              ad5abbdc65b1 Marco Velasco
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: