Validation error when performing worklog field update via CSV import when the value is in seconds format

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

Summary

Use case 1:

When importing the Worklog field values on Jira issues via CSV import wherein the value is in seconds format, the following error may be seen: 

Worklog for the issue with id XXXXX did not pass validation due to errors Errors: {timeLogged=Invalid time duration entered.} 

Example value: 70 (70 seconds to indicate 1 min 10 seconds)


Use Case 2: 

The user wants to import the values of the time tracking field in days, hours and minutes via CSV, however, the value is imported either in days or hours

Environment

Jira cloud

Cause:

Use case 1: The above-mentioned error occurred as the "Default unit" of the Time tracking setting is set to "Minute" and the value in the CSV file has been passed in seconds hence causing the validation error.

Use case 2: Due to a discrepancy in the time setup. If the time display format setting is configured in "hours" or "days"  rather than "Pretty (e.g. 4 days, 4 hours, 30 minutes)" format, then the value would be visible in Days or Hours format

https://<<instancename>.atlassian.net/secure/admin/TimeTrackingAdmin.jspa



Solution: 

Use case 1:
Please update the time value in the CSV file as per the Default Unit size set in time tracking settings: https://<<instancename>.atlassian.net/secure/admin/TimeTrackingAdmin.jspa

Use case 2: 

In order to mitigate the behaviour, the time tracking setting should be displayed as Pretty (e.g. 4 days, 4 hours, 30 minutes) instead of hour or days.

For assistance in changing the time tracking configuration follow the document: Configure time tracking

NOTE

It is also important to ensure the value of the Worklog field in the CSV field should be defined as per the Default unit like minutes. 

An example for 1 hour of Worklog CSV should be:

Key,Summary,Worklog

TEST-123,Test work log issue,60

Last modified on Aug 31, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.