Import CSV

From EHS Help
Revision as of 16:11, 5 February 2015 by Jan (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Importing CSV File

Once Event Stats is opened the import CSV button is active on the Navigation bar to the left of the screen.

Click Import CSV.

An Import CSV wizard will appear.

OpenCSVFile.jpg

Click Open CSV File then Select the required CSV file from the documents folder.

Please note CSV files must have no more than 256 columns.


The Column Definitions list will appear in the right side section of the Import wizard.

The first 200 data columns will be displayed in the Sample data section to the left of the Import Wizard.

ImportCSVFile.jpg

In the right side section the Field's can be edited and grouped, click on the field name.

A CSV column properties box will appear.

EditColumnProperties.jpg

The current column name is displayed, highlight the column name and type in new name or reference.

Data Type - Displays the data string type format - Don't worry if the date field is displayed as string as this will be converted during analysis.