Difference between revisions of "Importing a New Data Source/pt-br"

From TaticView
Jump to: navigation, search
Line 1: Line 1:
  
 +
Essa seção irá lhe mostrar como importar um novo arquivo de dados.
  
Para importar um novo arquivo de dados ('''veja também [[Importing a New Data Source Tutorial/pt-br|tutorial em vídeo]]):
+
See also:
 +
* [[Importing a New Data Source Tutorial|See a Tutorial]]
 +
* [[Excel Importing Guide|Excel Importing Guide]]
 +
* [[Importing Problems|Check Importing Problems]]
 +
* Download a sample file here: '''[http://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]'''
  
E nosso [[Excel_Importing_Guide/pt-br|'''Guia de Importação Arquivos Excel''']].
 
  
 +
First select the ''New datasource'' option in the [[Main Page Overview#Menu (Sidebar)|Menu (Sidebar)]] in the [[Main Page Overview|Main Page]];
 +
 +
[[File:Barra_Lateral+en-US.PNG|100px]]
 +
 +
 +
'''On the next screen.'''
 +
 +
 +
 +
 +
* '''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]]''';
 +
* '''Description''': An optional description for the new data source.
 +
 +
 +
If you have doubts click on the links "''Tutorial Video''", "''A sample spreasheet''" and other "''Importing Tips''".
 +
 +
Click '''Send File''' button to continue.
  
Selecione a opção ''Novo arquivo'' do [[Main Page Overview/pt-br#Menu (Sidebar)|Menu (Lateral)]] na [[Main Page Overview/pt-br|Página Principal]];
 
  
 +
'''On the next screen you must inform the file specifications.'''
  
 
[[File:Novo arquivo+pt-BR.PNG]]
 
[[File:Novo arquivo+pt-BR.PNG]]
Line 13: Line 35:
  
 
Veja [[File and identification/pt-br|Arquivo e identificação]] para informações sobre como continuar.
 
Veja [[File and identification/pt-br|Arquivo e identificação]] para informações sobre como continuar.
 
  
 
'''Importante'''
 
'''Importante'''
  
 
Se você tiver problemas ou erros ao atualizar, veja [[Updating Problems/pt-br|Problemas de atualização]].
 
Se você tiver problemas ou erros ao atualizar, veja [[Updating Problems/pt-br|Problemas de atualização]].
 +
 +
E nosso [[Excel_Importing_Guide/pt-br|'''Guia de Importação Arquivos Excel''']].
 +
 +
* '''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;
 +
 +
* '''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 set the right type for each column. When the type isn't right normally NULL will be show 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 data source.
 +
 +
 +
Click the '''Next''' button to continue.
 +
 +
If you are [[Import/Update data|updating]] a data source, go directly to the [[New Data Source Summary|import summary]].
 +
 +
 +
'''On the next screen you can generate automatically a set of dashboards with your imported data.'''
 +
 +
The process will try to find compatible dashboards with the information you provided. New generated dashboards will have the [[File:db_genenerated.png]] icon.
 +
 +
 +
[[File:Colunas geração+en-US.PNG|500px]]
 +
 +
 +
Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic generate dashboards.
 +
 +
Click the '''Next''' button. To skip the automatic dashboards generation, click '''Skip step'''. You can do this later. See [[Generate dashboards]].
 +
 +
 +
[[File:Resumo importação+en US.PNG|500px]]
 +
 +
 +
Check the summary information and click the '''Finish''' button to complete the operation and schedule the data import.
 +
 +
 +
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.

Revision as of 17:22, 20 October 2015

Essa seção irá lhe mostrar como importar um novo arquivo de dados.

See also:


First select the New datasource option in the Menu (Sidebar) in the Main Page;

Barra Lateral+en-US.PNG


On the next screen.



  • 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;
  • Description: An optional description for the new data source.


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

Click Send File button to continue.


On the next screen you must inform the file specifications.

Novo arquivo+pt-BR.PNG


Veja Arquivo e identificação para informações sobre como continuar.

Importante

Se você tiver problemas ou erros ao atualizar, veja Problemas de atualização.

E nosso Guia de Importação Arquivos Excel.

  • 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;
  • 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 set the right type for each column. When the type isn't right normally NULL will be show 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 data source.


Click the Next button to continue.

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


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

The process will try to find compatible dashboards with the information you provided. New generated dashboards will have the Db genenerated.png icon.


Colunas geração+en-US.PNG


Select the main Date, Text and Value columns that TaticView will use to automatic 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.


Use the Refresh option in the main page to update the data source information with it current status and check whether the import is finished.