Difference between revisions of "Input Data Format"
Line 2: | Line 2: | ||
− | * '''Charset''': Choose the file charset between ''UTF-8'' and ''ISO 8859-1''. Usually | + | * '''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 | + | * '''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 delimiter character. Select between ''Tab'', ''Semicollon'', ''Collon'' or ''Other character'' (for ''Other'' type the desired delimiter in the field). Usually | + | * '''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 | + | * '''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''': Left click the | + | * '''Columns options''': Left click the column header in the preview table to select and change its options: |
− | ** '''Column data type''': Specifies the column | + | ** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]]; |
− | ** '''Column name''': Specifies | + | ** '''Column name''': Specifies the column name.; |
− | ** '''Decimal places''': Specifies | + | ** '''Decimal places''': Specifies how many decimal places. For [[Value]] columns only; |
Revision as of 13:48, 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: Left 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.