How to deal with special characters

Orgvue supports all characters encoded in UTF-8.  

During a data upload or refresh, you may run into issues with data containing special characters (such as accented letters, and letters from the Japanese and Chinese alphabets). When issues are encountered, characters are usually displayed as a question mark in a diamond box:

 

This is because by default, Excel exports csv files using old encoding called Windows-1252.

To get around this issue, you can Save As the csv file with the encoding type 'UTF-8':

 

However, this may not be possible in older versions of Excel where UTF-8 is not an option in the dropdown list. If this is the case, then you will need to follow these steps:

• Click on the Save As button
• To the left of the Save button, you will see Tools - click this and choose Web Options:

• Select the Encoding tab and save the document as Unicode (UTF-8):

Once this encoding has been selected, the special characters will appear as expected.