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

"byte order mark (BOM)" option for CSV export

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Issue - Actions
    • None
    • 0
    • 7
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Hello,

      Please, make it possible to export issues lists as CSV with UTF-8 encoding.

      It should be quite simple by adding byte order mark (BOM) to result file before actual CSV output. 

      It may be another CSV export option in menu  like "export  as CSV (UTF-8)" 

      or with option allowing to chose simple text CSV  or UTF-8.

      BR VaidaS K.

      Workarounds

      • Following this forces Excel to correctly interpret the characters:
        1. In Excel, go to the Data section, and select the option From Text/CSV (should appear on the let part of the panel).
        2. Select the CSV file.
        3. In the emergent window, select the File Orifin Unicode (UTF-8) (see my example image-2018-03-07-17-38-26-848.png).
        4. Click on the Load button.
      • Another workaround would be to use the Export to HTML and open the file directly with Excel, and the characters are displayed correctly.
      • You could use a script to insert the BOM in the CSV like the following python script, kindly shared by one of our Jira users:
        import sys
        import os
        
        f = open(sys.argv[1], "rb")
        data = f.read()
        f.close()
        
        head, tail = os.path.split(sys.argv[1])
        
        f = open(os.path.join(head, "bom-" + tail), "wb")
        f.write(bytearray([239, 187, 191]))
        f.write(data)
        f.close()

         

        1. image-2018-03-07-17-43-09-156.png
          12 kB
          Rene C. [Atlassian Support]
        2. image-2018-03-07-17-38-26-848.png
          97 kB
          Rene C. [Atlassian Support]

              Unassigned Unassigned
              afa7b9317b79 Antti Keinänen
              Votes:
              21 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated: