Create File Format

You need to inform the application how the data file is formatted. 

Click on Manage File Formats in bottom-right corner and Add a new File Format for your data file.

Note: Open the file in a text editor to see the file format. We recommend Notepad++

Here we have a data file that is comma separated and with . (dot) as a decimal point. We also have a header line in line 1.

So we set up our File Format to match our data file. 

  • File type is CSV as that is our file type
  • Delimitor is comma, Decimal Point is dot and our Header Line is in line 1
  • We add a Time Format for our timestamp which is Year/month/day Hour:Minute:Seconds. 

Sometimes the timestamp can be in two or more columns. Simply add new Timestamp columns as needed.