Difference between revisions of "Input Data Format"

From TaticView
Jump to: navigation, search
 
(16 intermediate revisions by 5 users not shown)
Line 1: Line 1:
[[File:data_source_data_format.png]]
+
<languages/>
  
  
* '''Charset''': Choose the file charset between ''UTF-8'' and ''ISO 8859-1''. Usually the system select the correct option automatically;
+
<translate>
 +
<!--T:1-->
 +
[[File:Formatação dos dados+en-US.PNG|link=]]
  
  
* '''Start row''': Specifies which row of the file the system should start reading. Headings should be included if the ''Header row'' option is checked;
+
<!--T:2-->
 +
* '''Charset''': Specifies the file charset. Usually, the correct option is automatically selected. For CSV files only;
  
 +
<!--T:3-->
 +
* '''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. For CSV files only;
  
* '''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;
+
<!--T:4-->
 +
* '''Date mask''': Choose the [[Date]] fields mask in the file. The selected mask must be exactly equal to the format used by dates in the file. For CSV files only;
  
 +
<!--T:5-->
 +
* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''Semicolon'', ''Collon'' or ''Another character'' (for ''Other'' type the desired delimiter in the field). Usually, the correct option is selected automatically. For CSV files only;
  
* '''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);
+
<!--T:6-->
 +
* '''Header''': Check if the file has a ''Header row'' that identifies the columns. The header will be used as the default name for the columns in the datasource;
  
 +
<!--T:7-->
 +
* '''Decimal Separator''': Specifies the decimal separator used in the file. For CSV files only
  
* '''Columns options''': Left click the columns header to select it and change the selected column options:
+
<!--T:8-->
** '''Column data type''': Specifies the column [[Data Columns Type|data type]]: [[Date]], [[Text]] or [[Value]];
+
* '''Columns options''': Click the column header in the preview table to select and change its options:
** '''Column name''': Specifies how the column will be identified;
+
** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];
** '''Decimal places''': Specifies the amount of decimal places. For [[Value]] columns only;
+
** '''Column name''': Specifies the column name.;
 
+
** '''Decimal places''': Specifies how many decimal places. For [[Value]] columns only;
  
 +
<!--T:9-->
 
Click the ''Next'' button.
 
Click the ''Next'' button.
  
 +
<!--T:10-->
 +
See [[Automatic Dashboard Generation]] for information on how to continue.
  
See [[Automatic Dashboard Generation]] for information on how to continue.
+
<!--T:11-->
 +
If you are [[Import/Update data|updating]] a datasource, go directly to the [[New Data Source Summary|import summary]].
 +
</translate>

Latest revision as of 14:25, 30 September 2022

Other languages:
English • ‎português do Brasil


Formatação dos dados+en-US.PNG


  • Charset: Specifies the file charset. Usually, the correct option is automatically selected. For CSV files only;
  • 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. For CSV files only;
  • Date mask: Choose the Date fields mask in the file. The selected mask must be exactly equal to the format used by dates in the file. For CSV files only;
  • Delimited by: Specifies the columns delimiter character. Select between Tab, Semicolon, Collon or Another character (for Other type the desired delimiter in the field). Usually, the correct option is selected automatically. For CSV files only;
  • Header: Check if the file has a Header row that identifies the columns. The header will be used as the default name for the columns in the datasource;
  • Decimal Separator: Specifies the decimal separator used in the file. For CSV files only
  • 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 datasource, go directly to the import summary.