8,981
edits
Changes
no edit summary
<languages/>
<translate>
<!--T:1-->
'''This section will show you hot how to import a new data source.'''
<!--T:20-->
See also:
* [[Importing a New Data Source Tutorial|Video See a Tutorial]]
* [[Excel Importing Guide|Excel Importing Guide]]
* [[Importing Problems|Check Importing Problems]]
* '''[[Import/Update_data|Update Data]]* [[Automate_Update_data|Data Update Automation]]* Download a sample file here: '''[httphttps://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]''' <!--T:35--><span style="color: red;">'''Important:'''</span> Data import is not allowed through tablets and smartphones.
<!--T:2-->
<!--T:21-->[[File:Barra_Lateral+en-US.PNG|100pxlink=]]
<!--T:43-->[[File:Novo arquivoNovo_arquivo+en-US.PNG||500px800px|link=]]
<!--T:23-->
* '''File''': Choose the file to be imported. Click on the ''Browser'' button to search your computer for files. See [[Supported File Formats]] for more information;
* '''Name''': Data source name. This is the name that will be displayed in on the '''[[Main Page Overview|main page]]''';
* '''Description''': An optional description for the new data source.
<!--T:24-->If you have doubts , click on the below links "''Tutorial Video''", "''A sample spreasheetspreadsheet''" and other "''Importing Tips''".
<!--T:31-->
'''Spreadsheet sample'''
<!--T:25-->
Click '''Send File''' button to continue.
<!--T:326-->* '''Start row''': Specifies which row of On the next screen, you must inform the file the import process should start reading. Headings should be included if the ''Header row'' option is checked. For CSV files only;specifications:
<!--T:4-->
<!--T:5-->
* '''Delimited byCharset''': Specifies the columns delimiter characterfile charset. Select between ''Tab'', ''Semicollon''Usually, ''Collon'' or ''Other character'' (for ''Other'' type the desired delimiter in the field). Usually the correct option is automatically selected automatically. For CSV files only;
<!--T:6-->
* '''HeaderStart row''': Check Specifies which row of the file the import process should start reading. Headings should be included if the file have a ''Header row'' that identifies the columnsoption is checked. The header will be used as the default name for the columns in the data sourceFor CSV files only;
<!--T:7-->
* '''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.;
<!--T:8-->
* '''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:9-->
* '''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 data source;
<!--T:10-->
* '''Decimal Separator''': Specifies the decimal separator used in the file.
<!--T:811-->
* '''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]];
<!--T:927-->Notes:* Is very important to set the right type for each column. When the type is not right, the word NULL will be shown in the cells.* The Formula columns show the expression used in the spreadsheet or text file.* When you add new columns in the imported file, the header color will be red.* You can´t delete existing columns in the data source.* In value columns, empty cells (NULL) will be converted to "0".* In date columns, empty cells or not valid dates will be converted to NULL.* In text columns, empty cells will be converted to NULL. <!--T:12-->
Click the '''Next''' button to continue.
<!--T:1113-->
If you are [[Import/Update data|updating]] a data source, go directly to the [[New Data Source Summary|import summary]].
<!--T:29-->[[File:Colunas geração+en-US.PNG|500px800px|link=]]
<!--T:215-->* Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic automatically generate dashboards.
<!--T:30-->
Click the '''Next''' button. To skip the automatic dashboards generation, click '''Skip step'''. You can do this later. See [[Generate dashboards]].
<!--T:517-->See [[File:Resumo importação+en US.PNG|800px|link=]] <!--T:18-->Check the summary information and click the '''Finish''' button to complete the operation and schedule the data import. <!--T:33-->[[New Data Source SummaryFile:progresso_importacao+en-US.PNG|800px|link=]] <!--T:34-->Wait for TaticView to create/update the required structures and schedule the data import. If everything is ok, click the '''Done!'' for information on how to continue' button.
<!--T:119-->When the data source import/update is completed, TaticView will automatically update the status on the [[File:Resumo importação+en US.PNGMain_Page_Overview|500pxmain page]].
</translate>
