Log Collection: Exporting Event Source Issues

Document created by RSA Information Design and Development on Sep 14, 2016
Version 1Show Document
  • View in full screen mode
 

This topic describes how to address problems you may encounter when exporting event source information.

Issue

When using a spreadsheet program to edit an exported event source CSV file, some data fields like numbers and dates can be re-formatted into the spreadsheet program’s native field types. This can cause issues when re-importing this information, as some data fields may be garbled or formatted incorrectly.

Guidelines

To work around this problem, the best thing is to not open the file directly into the spreadsheet program, but rather import the text file (CSV) data into the spreadsheet program while it is already open. During the import of text data, your spreadsheet program will give you the option to have the spreadsheet program format the data as text so that mathematical formatting is not used on your CSV file's numbers.

Process

The exact steps differ depending on the spreadsheet program being used but the basic process is as follows:

  1. Export your CSV file from Security Analytics.

    You will have a CSV file on your computer. Most CSV files will open up directly into your computer's installed Spreadsheet program. However, do not double-click the file to open it. Instead, proceed with the following steps.

  2. Open up your spreadsheet program independently.
  3. Create a new workbook or blank spreadsheet in the program.
  4. Look for your spreadsheet program's import functions.

Import Options

The exact method of importing into your spreadsheet is dependent upon which spreadsheet you are using. Some versions of Microsoft Excel will have an Import Wizard located in the Data menu. Other versions will have the import functions located directly in the program's main screen. Please refer to your spreadsheet program's documentation for information on importing data into the spreadsheet.

When importing the data you may be given the option to select the data type. If so, select comma separated. Furthermore, as part of the import you should be given the option to select the formatting that will be used for the display of the imported data.

Tip

Before selecting the format type, be sure to select all of the columns in the file, then proceed:

  1. Select text for the format that the data will be displayed in.
  2. Complete your import.

Your spreadsheet file will now be formatted in text only and preserve your numerical data as it was generated by the store.

You are here: Log Collection Configuration Guide > Exporting Event Source Issues

Attachments

    Outcomes