Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Work Log date not matching the Export Issues file output of Export Excel CSV (all fields) option

louisv
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 23, 2021

Export Not Populating 11/4/21 where we want the time spent to be recorded.

  • EXPECT: Jira Web Work Log "Logged" Date to match CSV Log Work field
  • RESULTS:  Not Matching 
    • JIRA UI ("Date Started")    = 11/4/2021
    • JIRA Issue Excel CSV        = 11/22/21

NOTE: This is a "Subtasks" issue type. I am using subtask to log our time. This Subtasks does roll up to an Issue type = User Story AKY-310.

 

Possible Workaround: https://jira.atlassian.com/browse/JRASERVER-64025

 

SIMILAR ISSUE: 

  1. https://jira.atlassian.com/browse/MIG-387
  2. https://jira.atlassian.com/browse/JRASERVER-64025

 

Where is the correct recorded committed time.png

 


DESIRE: is for REST API and/or CSV all fields export/extracts to include Started date field from the Time Spent Log Work, which is working as expected within the "Timesheet Tracking for JIRA" add on. For outside JIRA reporting, I have to extract from REST API or CSV PLUS Timesheet Tracking For JIRA for the "Started" date entries/records.

REFERENCE:
https://louisv.atlassian.net/rest/api/3/search?jql=filter=10014
Timesheet Tracking for Jira

1 answer

0 votes
Joshua Sneed Contegix
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 23, 2021

Hi Louis,

The datetime in the UI is adjusted to align with your timezone. The export shows the datetime in alignment with the applications System Time. This is normal and expected. Cheers!

louisv
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 23, 2021

JIRA UI ("Date Started")    = 11/4/2021

I explicitly retro back the date, trying to leverage the Date Started field to when the "Time Spent" was worked.  In addition, the challenge is I do not see 11/4/2021 like in the UI anywhere in the CSV export ALL ISSUES.  

 

Thanks for the feedback.  Please advise.

Joshua Sneed Contegix
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 24, 2021

Hi Louisv,

I have advised, this is not a problem and is expected behavior. You can review Atlassian's Configuring Date and Time page or Contact Atlassian Support, depending on how much you disagree. Cheers!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events