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

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 7.9.2
    • Issue - Actions
    • None

    Description

      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.

       

      Attachments

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

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dkoh Danson (Inactive)
              Votes:
              82 Vote for this issue
              Watchers:
              66 Start watching this issue

              Dates

                Created:
                Updated: