question about csat plugin

Lika Tabatadze July 20, 2020

hello, we've installed trial version of customer satisfaction plugin in jira service desk , when we export data to csv document,rating comments, which are made in georgian language, are with question marks , can you help us to resolve this problem?

 

1 answer

0 votes
Joseph Huynh July 21, 2020

How to import a .csv file that uses UTF-8 character encoding

Follow the steps outlined below to use Microsoft Excel 2007 to open a .csv file that uses UTF-8 character encoding.

  1. Open Microsoft Excel.
  2. Click on the Data menu bar option.
  3. Click on the From Text icon.
  4. Navigate to the location of the file that you want to import.  Click on the filename and then click on the Import button.  The Text Import Wizard - Step 1 or 3 window will now appear on the screen.
  5. Choose the file type that best describes your data - Delimited or Fixed Width.
  6. Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.
  7. Click on the Next button to display the Text Import Wizard - Step 2 or 3 window.
  8. Place a checkmark next to the delimiter that was used in the file you wish to import into Microsoft Excel.  The Data preview window will show you how your data will appear based on the delimiter that you chose.
  9. Click on the Next button to display the Text Import Wizard - Step 3 of 3.
  10. Choose the appropriate data format for each column of data that you want to import.  You also have the option to not import one or more columns of data if you want.
  11. Click on the Finish button to finish importing your data into Microsoft Excel.
Lika Tabatadze July 22, 2020

Thank you for your answer, are you planning any better solution for unicode? I think this solution will make process more difficult.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events