Open main menu

TaticView β

Changes

Input Data Format

504 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 selected column its options:** '''Column data type''': Specifies the column [[Data Columns Type|data type]]: [[Date]], [[Text]] or [[Value]];** '''Column name''': Specifies how the column will be identifiedname.;** '''Decimal places''': Specifies the amount of how many decimal places. For [[Value]] columns only; 
<!--T:9-->
Click the ''Next'' button.
<!--T:10-->
See [[Automatic Dashboard Generation]] for information on how to continue.
See <!--T:11-->If you are [[Automatic Dashboard GenerationImport/Update data|updating]] for information on how a datasource, go directly to continuethe [[New Data Source Summary|import summary]].</translate>