Difference between revisions of "Supported File Formats"
(Created page with "The TaticView Data Sources support the following file formats and types for import or update: '''Supported Extensio...") |
|||
| Line 9: | Line 9: | ||
* Any field delimiter is supported (with the exception of line breaks); | * 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''. | * 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; | ||
Revision as of 17:57, 22 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);
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;
