Overview

When the chosen Data Source is a CSV file, the Select Data Source dialog will looks as follows:

 

 

Use the Browse button to locate the required CSV input file.  

 

Note:  The format of the CSV file must be as shown in layout section.

Tip:  Prior to 'importing' the CSV file, the user must take care to set the import options as required (see below).

Option:

Description:

Make all Columns into Pens

When checked this option will automatically allocate each item in the CSV file to a pen.  This avoids the need to map each pen manually once the file has loaded.

Assume local time for time stamps

When checked all time stamps will be assumed to be in local time and thus no daylight savings adjustment will be made.  When this is not checked it assumed that the time stamps are in UTC.

Date Format

Select the date format used in within the CSV.  Available options are:

  • MM/DD/YYYY  - US format.

  • DD/MM/YYYY - European format.

  • Automatically Detect - the system will attempt to work out the date format based on the file content.