Difference between revisions of "Supported File Formats"
| Line 3: | Line 3: | ||
'''Supported Extensions''': XLS, XLSX e CSV (or other compatible with CSV); | '''Supported Extensions''': XLS, XLSX e CSV (or other compatible with CSV); | ||
| + | |||
| + | |||
| + | Files can contain formulas and expressions, see [[File Formulas]] for more information. | ||
Revision as of 14:29, 23 May 2013
The TaticView Data Sources support the following file formats and types for import or update:
Supported Extensions: XLS, XLSX e CSV (or other compatible with CSV);
Files can contain formulas and expressions, see File Formulas for more information.
CSV Especific Requirements:
- Any field delimiter is supported (with the exception of line breaks);
- Date fields must be in the "dd/MM/yyyy" format. Ex.: 31/01/2013.
Important
To maintain the correct operation of the created dashboards, some definitions and settings can not be changed latter in the data source and its import file:
- Columns can not be added between the original columns in the file;
- It is possible to add column to the end of the file;
- Columns names can not be changed in the file header;
- Column names can be changed in the Input Data Format step, but objects that already use this column will keep the previous name.
- To update, remove and add again the column to the object;
- Columns can not be removed from the file;
- Columns must maintain its original order in the file;
- Columns data type can not be changed;
