CSV Data Sets Export Error
(Doc ID 2723370.1)
Last updated on OCTOBER 27, 2020
Applies to:Primavera Unifier - Version 188.8.131.52 and later
Information in this document applies to any platform.
On : Unifier Any Version
When exporting data set to CSV when the language is Russian, the file opens with garbage characters. As a work around, after opening the file in Excel, users go to "Data --> From text/CSV-file --> 65001: Unicode (UTF-8) --> Load" and the data adjusts appropriately.
The CSV file that Unifier generates is utf-8 non-BOM (Byte Order Mark) file and it appears that Excel cannot handle these types of files when the language is Russian. Is possible to make Unifier generate .CSV files in UTF-8 with BOM or in UTF-16 to make Excel open the file without any issues?
The issue can be reproduced at will with the following steps:
- Log in to Unifier with a user that has a language preference of Russian
- Navigate to Company Workspace --> Admin mode --> Data structure setup --> Data definitions --> Basic
- Open any Data Set that has Russian
- Click on Data Set tab
- Click on Export button
- Save csv file.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document