File name in Chinese Language is not retained in CSV report instead it includes garbled texts are available.

Products

• Data Loss Prevention Network Monitor and Prevent for Email
• Data Loss Prevention
• Data Loss Prevention Cloud Package
• Data Loss Prevention Cloud Prevent for Microsoft Office 365
• Data Loss Prevention Discover Suite
• Data Loss Prevention Endpoint Prevent
• Data Loss Prevention Enforce
• Data Loss Prevention Enterprise Suite
• Data Loss Prevention Network Email
• Data Loss Prevention Network Monitor
• Data Loss Prevention Network Monitor and Prevent for Web
• Data Loss Prevention Network Prevent for Email
• Data Loss Prevention Network Monitor and Prevent for Email and Web
• Data Loss Prevention Network Protect
• Data Loss Prevention Network Web
• Data Loss Prevention Plus Suite

Issue/Introduction

The file name in Chinese Language is not retained in CSV report for the "Endpoint Filename" instead different texts are available.

CSV Spreadsheet displays: 

这是用酷炫的语言对福特汽车的考验.xlsx

 

Environment

Release : 16.0 +

Cause

The issue is that Excel is not handling the UTF-8 without having the byte order marker

Resolution

This issue is set to be addressed in a future release

Workaround:

The output is comma delimited in UTF-8 as required for several languages. Look at the CSV in notepad++ and it displays just fine. 

This is a known issue and Microsoft advises to use the Data import feature of Excel where UTF-8 can be forced to avoid misinterpretation of the encoding.

 

Additional Information

How to reproduce? 

Go to Incidents and select any Reports (Endpoint, Network, Web etc)

1. Incidents => Endpoint

2. Select the incident(s) you wish to export to CSV

3. Click on Export as CSV

4. Export as CSV

Open the CSV with Excel application it will show you garbled text for the Endpoint File Name - This is not a defect but Excel loading the incorrect format

Open the CSV with Notepad ++ it will show you the correct file name: