Difference between revisions of "Input Data Format"

From TaticView
Jump to: navigation, search
Line 24: Line 24:
  
 
See [[Automatic Dashboard Generation]] for information on how to continue.
 
See [[Automatic Dashboard Generation]] for information on how to continue.
 +
 +
If you are [[Import/Update data|updating]] a data source, go directly to the [[New Data Source Summary|import summary]].

Revision as of 14:40, 2 May 2013

File:Data source data format.png


  • Charset: Choose the file charset between UTF-8 and ISO 8859-1. Usually the system select the correct option automatically;


  • Start row: Specifies which row of the file the system should start reading. Headings should be included if the Header row option is checked;


  • Delimited by: Specifies the delimiter character. Select between Tab, Semicollon, Collon or Other character (for Other type the desired delimiter in the field). Usually the system select the correct option automatically;


  • Header: Check if the file have a Header row that identifies the columns (The header will be used as the initial name for the columns in the data source, but you can change it freely);


  • Columns options: Left click the columns header to select it and change the selected column options:
    • Column data type: Specifies the column data type: Date, Text or Value;
    • Column name: Specifies how the column will be identified;
    • Decimal places: Specifies the amount of decimal places. For Value columns only;


Click the Next button.


See Automatic Dashboard Generation for information on how to continue.

If you are updating a data source, go directly to the import summary.