Difference between revisions of "Input Data Format"

From TaticView
Jump to: navigation, search
Line 14: Line 14:
  
  
* '''Columns options''': Left click the column header in the preview table to select and change its options:
+
* '''Columns options''': Click the column header in the preview table to select and change its options:
 
** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];
 
** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];
 
** '''Column name''': Specifies the column name.;
 
** '''Column name''': Specifies the column name.;

Revision as of 14:00, 7 May 2013

File:Data source data format.png


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


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


  • Delimited by: Specifies the columns delimiter character. Select between Tab, Semicollon, Collon or Other character (for Other type the desired delimiter in the field). Usually the correct option is selected 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);


  • Columns options: Click the column header in the preview table to select and change its options:
    • Column data type: Specifies the column data type: Date, Text or Value;
    • Column name: Specifies the column name.;
    • Decimal places: Specifies how many 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.