Importing worklogs from CSV to Cloud - how?

Question

I have tried and tried to figure out the format for worklog import/updates onto Cloud and for the life of me, cannot figure it out! Can anyone help? Here is my entire CSV : Summary,Issue key,Issue id,Worklog,Worklog Customer was allowed to place order without providing email,FINTS-70,88038,Working on issue FINTS-70;22/Sep/22;james@logicspot;600,Working on issue FINTS-70;22/Sep/22;james@logicspot;900 Using the built-in, Cloud CSV importer I receive:

Unable to import worklog com.atlassian.jira.plugins.importer.external.beans.ExternalWorklog@25ce3297: Worklog for issue with id 27523 did not pass validation due to errors Errors: {timeLogged=Invalid time duration entered.}

Error Messages: []

Anyone any ideas please?

Hana Kučerová · Answer

@Mark Haller

I was able to make this work. my file looks like this:

Key,Summary,Worklog
TK-80,Test worklog issue,Worklog text;25/Sep/22 3:30 PM;user-account-id;3600

TK-80 - change it to your issue key

Test worklog issue - change it to your issue summary

25/Sep/22 3:30 PM - format here is dd/MMM/yy h:mm a (import default) - it is possible to have different datetime format, but you need to set it during the import

user-account-id - instead of username in server/DC you need to use your user account id in cloud

3600 - time spent in seconds

Please try.

Mark Haller · Answer

Hi Fabio

Just tried this and it fails.  This is my file -

Key,Summary,Worklog
FINNS-70,Only time spent (one hour),3600
FINNS-69,With a date and an author,2012-02-10 12:30:10;wseliga;120
FINNS-68,With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200

I then receive:

2022-09-25 16:23:46,882 INFO - Only new items will be imported
2022-09-25 16:23:46,974 INFO - Importing issue: [externalId='autoid--1100892491703224869', summary='Only time spent (one hour)']
2022-09-25 16:23:47,347 INFO - Importing issue: [externalId='autoid-2863127554186853816', summary='With a date and an author']
2022-09-25 16:23:47,545 ERROR - Unable to import worklog com.atlassian.jira.plugins.importer.external.beans.ExternalWorklog@6de14c54: Worklog for issue with id 27582 did not pass validation due to errors Errors: {timeLogged=Invalid time duration entered.}
Error Messages: []
2022-09-25 16:23:47,556 INFO - Importing issue: [externalId='autoid-3266778303944090329', summary='With an additional comment']
2022-09-25 16:23:47,766 INFO - 0 out of 3 issues successfully created

And then when I check the issues, no worklogs show on the issues screens.   Even worse, when click Activity -> I see "Something's gone wrong" as a popup, with "ERROR: HNYO8S"

Fabio Racobaldo _Catworkx_ · Answer

Hi @Mark Haller ,

as described here https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/, a worklog should have the following format

Importing worklog entries

Your CSV file can contain worklog entries. For example:

Summary,Worklog
Only time spent (one hour),3600
With a date and an author,2012-02-10 12:30:10;wseliga;120
With an additional comment,Testing took me 3 days;2012-02-10 12:30:10;wseliga;259200
I think that you ned to update the worklog date format in your file.
Fabio