Difference between revisions of "Input Data Format"

From TaticView
Jump to: navigation, search
(Created page with "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 automaticall...")
 
Line 14: Line 14:
  
  
* '''Columns options''': Left click the columns header to select it and change the columns options:
+
* '''Columns options''': Left click the columns header to select it and change the selected column options:
** '''Column data type''': Left click the columns header to select it and change the columns options;
+
** '''Column data type''': Specifies the column [[Data Columns Type|data type]]: [[Date]], [[Text]] or [[Value]];
** '''Column name''': Left click the columns header to select it and change the columns options;
+
** '''Column name''': Specifies how the column will be identified;
** '''Decimal places''': Left click the columns header to select it and change the columns options;
+
** '''Decimal places''': Specifies the amount of decimal places. For [[Value]] columns only;
  
  
Click on the ''Next'' button.
+
Click the ''Next'' button.
  
  
See [[Generate dashboards|Automatic Dashboard Generation]] for information on how to continue.
+
See [[Automatic Dashboard Generation]] for information on how to continue.

Revision as of 20:19, 30 April 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.