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

Inconsistency date Export using Date Custom Field with different Language Configured

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 7.9.2, 8.20.2, 9.4.0, 9.4.14
    • Issue - Actions
    • None

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

      When the language configured in JIRA is different with the Machine OS, exporting filter to excel will cause the date mismatch in term of format and display.

      JIRA should parse the Date format in number(perhaps something) rather than the date as the Excel will use the Regional Language in the Machine.

      Example:-
      JIRA's Language = English

      Machine OS's Language = Dutch (Belgium)

      When exporting Date Custom Field in JIRA which is supposed to be dd/MMM/yy

      Result:-

      Expected Result:-
      The Date in Excel should all be consistence but due to some conversion made by Excel based on Regional Language of OS's Language.

      Workaround:-

      1. Use Google Excel Sheet (Ensure you are using English) / Excel 2016 (Tested it will automatically convert date time accordingly)
      2. Open Google Excel
      3. Select File > Import > Upload > Upload the CSV file
      4. Once import completed, it will prompt up a screen asking for more details, update the Separator type accordingly.
      5. Click on import data and open it
      6. The wrong date data will be imported to Google Excel, we will need to select 2 columns which having wrong date format.
      7. Select Format > Number > Date Time and all date column will be formatted accordingly.

       Another workaround is to set the same language in JIRA and the computer operating system to have same time format. However, this shouldn't be workable for some user as we might not have control over their computer configurations.

       

        1. hauschel1.jpg.png
          hauschel1.jpg.png
          605 kB
        2. im1.PNG
          im1.PNG
          605 kB
        3. im2.PNG
          im2.PNG
          39 kB
        4. im3.PNG
          im3.PNG
          42 kB
        5. im4.PNG
          im4.PNG
          199 kB
        6. image-2018-06-14-21-17-53-047.png
          image-2018-06-14-21-17-53-047.png
          94 kB
        7. image-2018-06-14-21-19-41-817.png
          image-2018-06-14-21-19-41-817.png
          153 kB
        8. SpanishVsEnglishExport.jpg
          SpanishVsEnglishExport.jpg
          411 kB

              Unassigned Unassigned
              dkoh Danson (Inactive)
              Votes:
              85 Vote for this issue
              Watchers:
              70 Start watching this issue

                Created:
                Updated: