Difference between revisions of "CSV Importing Guide"
(Created page with "<languages/> <translate> The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data source. '''You can d...") |
(Marked this version for translation) |
||
| Line 2: | Line 2: | ||
<translate> | <translate> | ||
| + | <!--T:1--> | ||
The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data source. | The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data source. | ||
| + | <!--T:2--> | ||
'''You can download a sample file here: [http://wiki.taticview.com/taticfiles/Sales.csv Sales.csv]''' | '''You can download a sample file here: [http://wiki.taticview.com/taticfiles/Sales.csv Sales.csv]''' | ||
| + | <!--T:3--> | ||
'''If you still have problems importing, try [[Importing Problems]].''' | '''If you still have problems importing, try [[Importing Problems]].''' | ||
| − | ==== Headers ==== | + | ==== Headers ==== <!--T:4--> |
| + | <!--T:5--> | ||
Headers are not mandatory, but if present they should be contained in just one row (the first one). For example: | Headers are not mandatory, but if present they should be contained in just one row (the first one). For example: | ||
| + | <!--T:6--> | ||
[[File:Header csv.png|link=]] | [[File:Header csv.png|link=]] | ||
| − | ==== Expressions ==== | + | ==== Expressions ==== <!--T:7--> |
| + | <!--T:8--> | ||
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. | ||
| + | <!--T:9--> | ||
To consider expressions in CSV files, the composition of the expression must be in the header line of the data. | To consider expressions in CSV files, the composition of the expression must be in the header line of the data. | ||
| + | <!--T:10--> | ||
Below is an example of a spreadsheet containing two expressions (''Avg Price'' and ''% Profit''): | Below is an example of a spreadsheet containing two expressions (''Avg Price'' and ''% Profit''): | ||
| + | <!--T:11--> | ||
[[File:Expression header csv.png|link=]] | [[File:Expression header csv.png|link=]] | ||
| + | <!--T:12--> | ||
To create expressions in CSV files the following rules must be observed: | 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)'' | * The expression must begin with the character '''equal''' and be enclosed in '''parentheses'''. Examples: ''=(Price/Quantity)'', ''=((Profit*100)/Price)'' | ||
Revision as of 18:05, 7 August 2019
The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data source.
You can download a sample file here: Sales.csv
If you still have problems importing, try Importing Problems.
Headers
Headers are not mandatory, but if present they should be contained in just one row (the first one). For example:
Expressions
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):
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
