Difference between revisions of "Importing a New Data Source"

From TaticView
Jump to: navigation, search
 
(36 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
<languages/>
 +
 +
 
<translate>
 
<translate>
  
 
<!--T:1-->
 
<!--T:1-->
'''This section will show you how to import a new data source.'''
+
'''This section will show you how to import a new datasource.'''
  
 
<!--T:20-->
 
<!--T:20-->
Line 8: Line 11:
 
* [[Importing a New Data Source Tutorial|See a Tutorial]]
 
* [[Importing a New Data Source Tutorial|See a Tutorial]]
 
* [[Excel Importing Guide|Excel Importing Guide]]
 
* [[Excel Importing Guide|Excel Importing Guide]]
 +
* [[CSV Importing Guide|CSV/Text Importing Guide]]
 
* [[Importing Problems|Check Importing Problems]]
 
* [[Importing Problems|Check Importing Problems]]
* Download a sample file here: '''[http://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]'''
+
* [[Import/Update_data|Update Data]]
 +
* [[Automate_Update_data|Data Update Automation]]
 +
* Download a sample file here: '''[[Special:FilePath/Sales.xlsx|Sales.xlsx]]'''
 +
 
 +
 
 +
<!--T:35-->
 +
<span style="color: red;">'''Important:'''</span> Data import is not allowed through tablets and smartphones.
  
  
 
<!--T:2-->
 
<!--T:2-->
First select the ''New datasource'' option in the [[Main Page Overview#Menu (Sidebar)|Menu (Sidebar)]] in the [[Main Page Overview|Main Page]];
+
First select the ''New datasource'' option in the [[Main Page Overview#Menu|Menu]] in the [[Main Page Overview#Datasource Tab|Main Page]]:
 +
 
  
 
<!--T:21-->
 
<!--T:21-->
[[File:Barra_Lateral+en-US.PNG|100px]]
+
[[File:Barra_Lateral+en-US.PNG|link=]]
  
  
 
<!--T:22-->
 
<!--T:22-->
'''On the next screen.'''
+
On the next screen:
  
 
<!--T:3-->
 
<!--T:3-->
[[File:Novo_arquivo+en-US.PNG||500px|link=]]
+
[[File:Novo_arquivo+en-US.PNG|800px|link=]]
  
  
 
<!--T:23-->
 
<!--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;
 
* '''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 the '''[[Main Page Overview|main page]]''';
+
* '''Name''': Datasource name. This is the name that will be displayed on the '''[[Main Page Overview|main page]]''';
* '''Description''': An optional description for the new data source.
+
* '''Description''': An optional description for the new datasource.
  
  
 
<!--T:24-->
 
<!--T:24-->
If you have doubts click on the links "''Tutorial Video''", "''A sample spreasheet''" and other "''Importing Tips''".
+
If you have doubts, click on the links "''Tutorial Video''", "''A sample spreadsheet''" and other "''Importing Tips''".
  
  
 +
<!--T:31-->
 
'''Spreadsheet sample'''
 
'''Spreadsheet sample'''
  
[[File:Exemplo_en-US.PNG||800px]]
+
<!--T:32-->
 +
[[File:Exemplo_en-US.PNG||1000px|link=]]
  
  
Line 46: Line 59:
  
 
<!--T:26-->
 
<!--T:26-->
'''On the next screen you must inform the file specifications.'''
+
On the next screen, you must inform the file specifications:
  
 
<!--T:4-->
 
<!--T:4-->
[[File:Formatação dos dados+en-US.PNG|500px|link=]]
+
[[File:Formatação dos dados+en-US.PNG|800px|link=]]
  
  
 
<!--T:5-->
 
<!--T:5-->
* '''Charset''': Specifies the file charset. Usually the correct option is automatically selected. For CSV files only;
+
* '''Charset''': Specifies the file charset. Usually, the correct option is automatically selected. For CSV files only;
  
 
<!--T:6-->
 
<!--T:6-->
Line 62: Line 75:
  
 
<!--T:8-->
 
<!--T:8-->
* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''Semicollon'', ''Collon'' or ''Other character'' (for ''Other'' type the desired delimiter in the field). Usually the correct option is selected automatically. 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;
  
 
<!--T:9-->
 
<!--T:9-->
* '''Header''': Check if the file have a ''Header row'' that identifies the columns. The header will be used as the default name for the columns in the data source;
+
* '''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:10-->
 
<!--T:10-->
Line 78: Line 91:
  
 
<!--T:27-->
 
<!--T:27-->
Notes:
+
'''Notes:'''
* Is very important set the right type for each column. When the type isn't right normally NULL will be show in the cells.
+
* 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.
 
* 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 datasource.
* You can´t delete existing columns in data source.
+
* In value columns, empty cells (NULL) will be converted to "0".
* 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 date columns empty cells or not valid dates will be converted to NULL.
+
* In text columns, empty cells will be converted to NULL.
* In text columns empty cells will be converted to NULL.
+
 
 +
 
 +
<!--T:36-->
 +
If you made a sctructure change the header collums apper whit different collors an extra screen will show you the alterations to confirm the changes.
 +
* New columns in the imported file, the header color will be yellow.
 +
* Probably wrong columns the header collor will be red.
 +
 
 +
<!--T:37-->
 +
'''Attention:''' After you confirm this screen and process the importation you can't undo the changes.
 +
 
 +
 
 +
<!--T:38-->
 +
[[File:newfields+en-US.PNG|800px|link=]]
 +
 
 +
 
 +
<!--T:39-->
 +
[[File:newfields1+en-US.PNG|800px|link=]]
  
  
Line 92: Line 121:
  
 
<!--T:13-->
 
<!--T:13-->
If you are [[Import/Update data|updating]] a data source, go directly to the [[New Data Source Summary|import summary]].
+
If you are [[Import/Update data|updating]] a datasource, go directly to the [[New Data Source Summary|import summary]].
  
  
 
<!--T:14-->
 
<!--T:14-->
'''On the next screen you can generate automatically a set of dashboards with your imported data.'''
+
On the next screen, you can automatically generate a set of dashboards with your imported data:
  
 
<!--T:28-->
 
<!--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.
+
The process will try to find compatible dashboards with the information you provided.
  
  
 
<!--T:29-->
 
<!--T:29-->
[[File:Colunas geração+en-US.PNG|500px]]
+
[[File:Colunas geração+en-US.PNG|800px|link=]]
  
  
 
<!--T:15-->
 
<!--T:15-->
Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic generate dashboards.  
+
Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatically generate dashboards.  
  
 
<!--T:30-->
 
<!--T:30-->
Line 114: Line 143:
  
 
<!--T:17-->
 
<!--T:17-->
[[File:Resumo importação+en US.PNG|500px]]
+
[[File:Resumo importação+en US.PNG|800px|link=]]
  
  
 
<!--T:18-->
 
<!--T:18-->
 
Check the summary information and click the '''Finish''' button to complete the operation and schedule the data import.
 
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-->
 
<!--T:19-->
Use the Refresh option in the [[Main Page Overview#Data Sources|main page]] to update the data source information with it current status and check whether the import is finished.
+
When the datasource import/update is completed, TaticView will automatically update the status on the [[Main_Page_Overview|main page]].
 +
 
 +
 
 +
 
 +
 
 
</translate>
 
</translate>

Latest revision as of 14:16, 30 September 2022

Other languages:
English • ‎português do Brasil


This section will show you how to import a new datasource.

See also:


Important: Data import is not allowed through tablets and smartphones.


First select the New datasource option in the Menu in the Main Page:


Barra Lateral+en-US.PNG


On the next screen:

Novo arquivo+en-US.PNG


  • 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: Datasource name. This is the name that will be displayed on the main page;
  • Description: An optional description for the new datasource.


If you have doubts, click on the links "Tutorial Video", "A sample spreadsheet" and other "Importing Tips".


Spreadsheet sample

Exemplo en-US.PNG


Click Send File button to continue.


On the next screen, you must inform the file specifications:

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.;
  • 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.
  • 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;


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.
  • You can´t delete existing columns in the datasource.
  • 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.


If you made a sctructure change the header collums apper whit different collors an extra screen will show you the alterations to confirm the changes.

  • New columns in the imported file, the header color will be yellow.
  • Probably wrong columns the header collor will be red.

Attention: After you confirm this screen and process the importation you can't undo the changes.


Newfields+en-US.PNG


Newfields1+en-US.PNG


Click the Next button to continue.

If you are updating a datasource, go directly to the import summary.


On the next screen, you can automatically generate a set of dashboards with your imported data:

The process will try to find compatible dashboards with the information you provided.


Colunas geração+en-US.PNG


Select the main Date, Text and Value columns that TaticView will use to automatically generate dashboards.

Click the Next button. To skip the automatic dashboards generation, click Skip step. You can do this later. See Generate dashboards.


Resumo importação+en US.PNG


Check the summary information and click the Finish button to complete the operation and schedule the data import.


Progresso importacao+en-US.PNG


Wait for TaticView to create/update the required structures and schedule the data import. If everything is ok, click the Done! button.


When the datasource import/update is completed, TaticView will automatically update the status on the main page.