Difference between revisions of "Input Data Format"
Line 14: | Line 14: | ||
− | * '''Columns 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:
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.