Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-64025

CSV export shows date/time worklog entry was created, not the date/time entered for the worklog itself

XMLWordPrintable

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Problem 

      When user log work for a date that is different from the actual time, the CSV export only shows actual date.

      Steps to Reproduce

      1. Log work for a different date than the current time
      2. Export this issue using the Export Excel CSV (All fields)
      3. Check the work log fields on the exported file

      Expected Results

      You can find the log work date.

      Actual Results

      You can only see the date when the log work was submitted.


        1. Screen Shot 2017-02-07 at 4.32.57 PM.png
          62 kB
        2. Screen Shot 2017-02-07 at 4.35.04 PM.png
          14 kB
        3. Screen Shot 2017-02-07 at 4.36.07 PM.png
          120 kB
        4. Screen Shot 2017-02-07 at 4.37.09 PM.png
          62 kB

            [JRASERVER-64025] CSV export shows date/time worklog entry was created, not the date/time entered for the worklog itself

            Rose Ríos added a comment -

            Hi,

            this is an important issue; is there any comment about a resolution date?

            Rose

            Rose Ríos added a comment - Hi, this is an important issue; is there any comment about a resolution date? Rose

            WilliamFrasson added a comment -

            Hello All,

            every friday we need to report the WorkLog export; Kindly raise the priority of this Ticket.

            WilliamFrasson added a comment - Hello All, every friday we need to report the WorkLog export; Kindly raise the priority of this Ticket.

            warpbu added a comment -

            A print/write statement that needs to be extended with a semicolon and a timestamp from an object it is already outputing from. Surely there must be someone working at Atlassian that knows a low hanging fruit when they see one?

            warpbu added a comment - A print/write statement that needs to be extended with a semicolon and a timestamp from an object it is already outputing from. Surely there must be someone working at Atlassian that knows a low hanging fruit when they see one?

            Regis Marco added a comment -

            Can someone increase the priority of this bug?? all my reports are incorrect because of this bug!!

            Regis Marco added a comment - Can someone increase the priority of this bug?? all my reports are incorrect because of this bug!!

            louisv added a comment -

            https://community.atlassian.com/t5/Jira-Software-questions/Work-Log-date-not-matching-the-Export-Issues-file-output-of/qaq-p/1869506

            I am running into the same issue...

            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.

            https://community.atlassian.com/t5/Jira-Software-questions/Work-Log-date-not-matching-the-Export-Issues-file-output-of/qaq-p/1869506

            louisv added a comment - https://community.atlassian.com/t5/Jira-Software-questions/Work-Log-date-not-matching-the-Export-Issues-file-output-of/qaq-p/1869506 I am running into the same issue... 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. https://community.atlassian.com/t5/Jira-Software-questions/Work-Log-date-not-matching-the-Export-Issues-file-output-of/qaq-p/1869506

            LCD added a comment -

            Please dear god in the name of all that is holy, please fix this. Why would anyone want the date the entry was made instead of the date that the entry is specified for?

            LCD added a comment - Please dear god in the name of all that is holy, please fix this. Why would anyone want the date the entry was made instead of the date that the entry is specified for?

            Maxwell Jones added a comment -

            I agree with Jacek, this is really important

            Maxwell Jones added a comment - I agree with Jacek, this is really important

            Jacek Pliszka added a comment -

            Please fix this bug - this makes worklog reports useless.  We are using customer's Jira and API does not really work for us.

            Jacek Pliszka added a comment - Please fix this bug - this makes worklog reports useless.  We are using customer's Jira and API does not really work for us.

            Katherine Pilongco added a comment -

            where do you run this?

            Katherine Pilongco added a comment - where do you run this?

            Aliaksei added a comment -

            apparently the only way to get something useful from Jira is to use macros and restAPI, json output would be like this:

            "worklogs":[
            {
            "self":"https://jira.com/rest/api/2/issue/xxx/worklog/xxx",
            "author":{},
            "updateAuthor":{},
            "comment":"",
            "created":"2020-09-18T12:11:49.000+0300",
            "updated":"2020-09-18T12:11:49.000+0300",
            "started":"2020-09-14T12:11:00.000+0300",
            "timeSpent":"2h",
            "timeSpentSeconds":7200,
            "id":"xxx",
            "issueId":"xxx"

            Aliaksei added a comment - apparently the only way to get something useful from Jira is to use macros and restAPI, json output would be like this: "worklogs":[ { "self":"https://jira.com/rest/api/2/issue/xxx/worklog/xxx", "author":{}, "updateAuthor":{}, "comment":"", "created":"2020-09-18T12:11:49.000+0300", "updated":"2020-09-18T12:11:49.000+0300", "started":"2020-09-14T12:11:00.000+0300", "timeSpent":"2h", "timeSpentSeconds":7200, "id":"xxx", "issueId":"xxx"

              Unassigned Unassigned
              bcasaroli Bernardo Casaroli (Inactive)
              Affected customers:
              59 This affects my team
              Watchers:
              59 Start watching this issue

                Created:
                Updated: