This topic describes how to address problems you may encounter when exporting event source information.
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.
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.
The exact steps differ depending on the spreadsheet program being used but the basic process is as follows:
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.
- Open up your spreadsheet program independently.
- Create a new workbook or blank spreadsheet in the program.
- Look for your spreadsheet program's import functions.
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.
Before selecting the format type, be sure to select all of the columns in the file, then proceed:
- Select text for the format that the data will be displayed in.
- 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.