Difference between revisions of "CSV Importing Guide/pt-br"

From TaticView
Jump to: navigation, search
(Created page with "link=")
(Created page with "==== Expressões ====")
Line 16: Line 16:
  
  
==== Expressions ====
+
==== Expressões ====
  
 
When importing CSV or text files, we also support creating [[Expressions]] as well as Excel files.  
 
When importing CSV or text files, we also support creating [[Expressions]] as well as Excel files.  

Revision as of 18:10, 7 August 2019

Other languages:
English • ‎português do Brasil

As instruções abaixo irão ajudá-lo a formatar corretamente seus arquivos CSV ou Texto para importação no TaticView.


É possível baixar um arquivo de exemplo formatado corretamente em: Vendas.csv

Se após seguir o guia, ainda ocorrerem problemas de importação, verifique Problemas de Importação.


Cabeçalhos

Cabeçalhos não são obrigatórios, mas se estiverem presente devem estar em uma única linha (a primeira).

Header csv pt-br.png


Expressões

When importing CSV or text files, we also support creating Expressions as well as Excel files.

To consider expressions in CSV files, the composition of the expression must be in the header line of the data.

Below is an example of a spreadsheet containing two expressions (Avg Price and % Profit):


Expression header csv.png

To create expressions in CSV files the following rules must be observed:

  • The expression must begin with the character equal and be enclosed in parentheses. Examples: =(Price/Quantity), =((Profit*100)/Price)
  • To reference other columns in the file, use the column/header name
  • It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression