search cancel

Fields in the CSV files exported by Endpoint Encryption contain leading spaces

book

Article ID: 174789

calendar_today

Updated On:

Products

Endpoint Encryption

Issue/Introduction

Symantec Endpoint Encryption Manager allows reports to be exported to CSV file. For example, this report can be exported to a CSV file:

  • Symantec Endpoint Encryption Users and Computers
    • Symantec Endpoint Encryption Managed Computers
      • SEE Unassigned

However, if you import the CSV file into a spreadsheet application such as Microsoft Excel you will find the following:

  1. The data in each column apart from the first column contains a leading space.
  2. The last column in the spreadsheet has no heading and each cell in the last column contains only a space.
  3. The data in the last line of the CSV file may not be imported. Note that  Excel does import the last line.
  4. If the computer importing the CSV file has regional settings that are different to the computer that exported the CSV, columns containing a date may not display correctly. 

Cause

  1. The delimiter in the CSV file is a comma plus a space. This results in leading spaces when the CSV file is imported.
  2. Each line of the CSV file ends in a comma plus a space. This results in a superflous last column.
  3. The last line of the CSV file does not end with a carriage return.
  4. The CSV file uses the date format of the computer that exported it.

 

Environment

Symantec Endpoint Encryption prior to release 11.3.1.

Resolution

Upgrade to Endpoint Encryption 11.3.1 or above and always import the CSV using a computer with the same regional settings as the computer that exported it. This will avoid any compatibility issues with the dates. Once you have saved the CSV in the native format of the spreadsheet application, you will be able to open the spreadsheet on a machine with different regional settings.

If you cannot upgrade, please do the following to workaround these issues:

  1. Open the CSV file in a text editor and replace all occurrences of  ", " with ",". In other words, replace comma plus a space with a comma. This will prevent leading spaces when you import the CSV file into a spreadsheeet application.
  2. After importing the CSV file into a spreadsheeet application, delete the last column if every cell in that column contains only a space.
  3. Open the CSV file in a text editor, navigate to the end of the last line of the file and enter a carriage return. This will ensure that the last line is imported.
  4. Always import the CSV using a computer with the same regional settings as the computer that exported it. This will avoid any compatibility issues with the dates. Once you have saved the CSV in the native format of the spreadsheet application, you will be able to open the spreadsheet on a machine with different regional settings.