Open main menu

TaticView β

Changes

Input Data Format

464 bytes added, 14:25, 30 September 2022
no edit summary
[[File:data_source_data_format.png]]<languages/>
* '''Charset'''<translate><!--T: Choose the file charset between ''UTF1--8'' and ''ISO 8859>[[File:Formatação dos dados+en-1''US. Usually the system select the correct option automatically;PNG|link=]]
<!--T:2-->* '''Start rowCharset''': Specifies which row of the file the system should start readingcharset. Headings should be included if Usually, the ''Header row'' correct option is checkedautomatically 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;
<!--T:4-->* '''Delimited byDate mask''': Specifies Choose the [[Date]] fields mask in the delimiter characterfile. Select between ''Tab'', ''Semicollon'', ''Collon'' or ''Other character'' (for ''Other'' type The selected mask must be exactly equal to the desired delimiter format used by dates in the field)file. Usually the system select the correct option automaticallyFor 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;
<!--T:6-->* '''Header''': Check if the file have has a ''Header row'' that identifies the columns (. The header will be used as the initial default name for the columns in the data source, but you can change it freely)datasource;
<!--T:7-->
* '''Decimal Separator''': Specifies the decimal separator used in the file. For CSV files only
<!--T:8-->* '''Columns options''': Left click Click the columns column header in the preview table to select it and change the columns its options:** '''Column data type''': Left click Specifies the columns header to select it and change the columns optionscolumn data type: [[Date]], [[Text]] or [[Value]];** '''Column name''': Left click Specifies the columns header to select it and change the columns optionscolumn name.;** '''Decimal places''': Left click the Specifies how many decimal places. For [[Value]] columns header to select it and change the columns optionsonly;
<!--T:9-->
Click the ''Next'' button.
Click <!--T:10-->See [[Automatic Dashboard Generation]] for information on the ''Next'' buttonhow to continue.
<!--T:11-->See If you are [[Generate dashboardsImport/Update data|Automatic Dashboard Generationupdating]] for information on how a datasource, go directly to continuethe [[New Data Source Summary|import summary]].</translate>