Importing worklogs from CSV to Cloud - how?

[Mark Haller]

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:

<p>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.}</p><p>Error Messages: []</p>

Anyone any ideas please?

[Fabio Racobaldo _Herzum_]

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

[Mark Haller]

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"

[Hana Kučerová]

Hi @Mark Haller ,

I believe I see 2 problems with your file.

1. Each worklog needs to be on a separate row
2. Each value needs to be separated either with comma or semicolon (but not mixture of both, which is the current status)

[Mark Haller]

Hi Hana

Thanks for the quick reply!

the format is actually from JIRA server Export all fields on the query screen.

how would I export the work log data from JIRA Server quickly and easily from my projects to be able to import into Cloud (this is not using the migration tool)

[Hana Kučerová]

@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.