Changes

Jump to: navigation, search

Importing a New Data Source

357 bytes added, 17:25, 11 September 2018
no edit summary
<languages/>
 
 
<translate>
* [[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-->
First select the ''New datasource'' option in the [[Main Page Overview#Menu (Sidebar)|Menu (Sidebar)]] in the [[Main Page Overview#Datasource Tab|Main Page]];: 
<!--T:21-->
[[File:Barra_Lateral+en-US.PNG|100pxlink=]]
<!--T:22-->
'''On the next screen.''':
<!--T:3-->
[[File:Novo_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 links "''Tutorial Video''", "''A sample spreasheetspreadsheet''" and other "''Importing Tips''".
<!--T:32-->
[[File:Exemplo_en-US.PNG||800px1000px|link=]]
<!--T:26-->
'''On the next screen , you must inform the file specifications.''':
<!--T:4-->
[[File:Formatação dos dados+en-US.PNG|500px800px|link=]]
<!--T:5-->
* '''Charset''': Specifies the file charset. Usually , the correct option is automatically selected. For CSV files only;
<!--T:6-->
<!--T:8-->
* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''SemicollonSemicolon'', ''Collon'' or ''Other 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 have 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-->
<!--T:27-->
Notes:
* Is very important to set the right type for each column. When the type isn't is not right normally , the word NULL will be show 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:14-->
'''On the next screen , you can automatically generate automatically a set of dashboards with your imported data.''':
<!--T:28-->
The process will try to find compatible dashboards with the information you provided. New generated dashboards will have the [[File:db_genenerated.png]] icon.
<!--T:29-->
[[File:Colunas geração+en-US.PNG|500px800px|link=]]
<!--T:15-->
Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic automatically generate dashboards.
<!--T:30-->
<!--T:17-->
[[File:Resumo importação+en US.PNG|500px800px|link=]]
<!--T:18-->
Check the summary information and click the '''Finish''' button to complete the operation and schedule the data import.
 
 
<!--T:33-->
[[File: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!''' button.
<!--T:19-->
Use When the Refresh option in data source import/update is completed, TaticView will automatically update the status on the [[Main Page Overview#Data SourcesMain_Page_Overview|main page]] to update the data source information with it current status and check whether the import is finished.    
</translate>

Navigation menu