CSV Exporter with Worklog Data (work logger information is diverse)

[Yong Yang]

Hi

I export the worklog data from a JSW project (Cloud instance) and found the possible work loggers are:

• user account id: a6a006a92a7baxxxxx
• ug:0ea34210-8d38-423b-a2d4xxxx
• emial pre-fix
• external.UserName

Anyone help explain why there're 4 formats of this value?

In addition, I found the worklog date is the worklog created date, but not the start date users specify when logging their log/time. Is it the same value for Server/Data Center? 

Thanks,

YY

[Aron Gombas _Midori_]

Are you using Tempo or the built-in worklog features?

[Yong Yang]

Hi Aron,

I don't use any apps/add-ons. I'm using the native/built-in features with exporting all the fields of the searched issues.

[Aron Gombas _Midori_]

It seems that the built-in export feature exports user IDs for some reason. I known that Atlassian changes the format of IDs time to time, but the role of an ID is to be a unique identifier, it is not necessarily "displayable".

If I were you, I'd try our Better Excel Exporter app which exports the user display names:

[Yong Yang]

It seems great. However, we don't have that addon~

[Ash]

You shouldn't have to pay for an add-on to get a basic function like exporting time data.... someone told me that with the on-prem system you can get it from the database directly with sql.

[Aron Gombas _Midori_]

On cloud, you don't have access to the database, so you can't run queries. You can work with the Jira Cloud REST API to solve a use case like this -- if you are ready to write code.