Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-77926

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

XMLWordPrintable

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? 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.


      Workaround

      There are some possible workarounds to get the correct value:

      • The endpoint Get issue worklogs returns the field started, which is the field that contains the date entered in the log work rather than the date from when the entry was created
      • The endpoint to perform advanced searches is able to return the worklog field, and it will contain the started value as well
        • E.g. /rest/api/3/search?jql=filter=10014&fields=key,worklog
      • Our integration with Google Sheets or Jira Cloud for Excel offer the option to export the started value as well. Although if you need the worklogs in order to import values into a Jira instance it would require some manual work to merge the cells correctly:

        1. screenshot-1.png
          screenshot-1.png
          10 kB
        2. Screen Shot 2017-02-07 at 4.32.57 PM.png
          Screen Shot 2017-02-07 at 4.32.57 PM.png
          62 kB
        3. Screen Shot 2017-02-07 at 4.35.04 PM.png
          Screen Shot 2017-02-07 at 4.35.04 PM.png
          14 kB
        4. Screen Shot 2017-02-07 at 4.36.07 PM.png
          Screen Shot 2017-02-07 at 4.36.07 PM.png
          120 kB
        5. Screen Shot 2017-02-07 at 4.37.09 PM.png
          Screen Shot 2017-02-07 at 4.37.09 PM.png
          62 kB
        6. Screenshot 2020-12-14 at 10.50.03 AM.png
          Screenshot 2020-12-14 at 10.50.03 AM.png
          1.31 MB
        7. Screen Shot 2021-11-26 at 10.26.40.png
          Screen Shot 2021-11-26 at 10.26.40.png
          154 kB
        8. Screen Shot 2021-11-26 at 10.28.16.png
          Screen Shot 2021-11-26 at 10.28.16.png
          141 kB

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

            Ben Carter added a comment -

            I didn't expect this behaviour and am now having to use the Google Sheets integration to work around it.

            Ben Carter added a comment - I didn't expect this behaviour and am now having to use the Google Sheets integration to work around it.

            Maxwell Jones added a comment -

            I also need a resolution for this, defiantly seems like an error.... 

            Maxwell Jones added a comment - I also need a resolution for this, defiantly seems like an error.... 

            Tara Bell added a comment -

            I would love a resolution for this as well.

            Tara Bell added a comment - I would love a resolution for this as well.

            jyi added a comment -

            I would like a resolution for this issue.

            Echoing Jim's comment above, what does Timed Out mean? 

            jyi added a comment - I would like a resolution for this issue. Echoing Jim's comment above, what does Timed Out mean? 

            Jim Cloughley added a comment -

            What does the Resolution "Timed Out" mean?

            Jim Cloughley added a comment - What does the Resolution "Timed Out" mean?

            Dan Goyette added a comment -

            Thanks, Jim. That should work for me. I appreciate it.

            Dan Goyette added a comment - Thanks, Jim. That should work for me. I appreciate it.

            Jim Cloughley added a comment -

            I do a server backup that exports raw XML. Parsecthe XML for <worklog> records. Swap the dates as this backup has the correct dates in it.

            Jim Cloughley added a comment - I do a server backup that exports raw XML. Parsecthe XML for <worklog> records. Swap the dates as this backup has the correct dates in it.

            Dan Goyette added a comment -

            Another user looking for a resolution to this, or a workaround. How can work log be exported with the correct dates? 

            Dan Goyette added a comment - Another user looking for a resolution to this, or a workaround. How can work log be exported with the correct dates? 

            Louis Lam added a comment -

            Can you please let me know when will you resolve this issue?

            Louis Lam added a comment - Can you please let me know when will you resolve this issue?

            Jim Cloughley added a comment -

            If this is going to be fixed, I'd like a heads up to understand what changed.  I wrote a work around that relies on how the <Worklog> tag is built.

            Jim Cloughley added a comment - If this is going to be fixed, I'd like a heads up to understand what changed.  I wrote a work around that relies on how the <Worklog> tag is built.

              9d5c751d4fd0 Ben Tilden
              bcasaroli Bernardo Casaroli (Inactive)
              Affected customers:
              40 This affects my team
              Watchers:
              52 Start watching this issue

                Created:
                Updated: