11,677
edits
Changes
Importing a new version from external source
The TaticView [[Data Sources]] support the following file formats and types for [[Creating a New Data Source|import]] or [[Import/Update data|update]]:
'''Supported Extensions''': XLS, XLSX and CSV (or other compatible with CSV);
'''Supported Data''':
* Files must contain at least one [[Date]], one [[Text]] and one [[Value]] column;
* Files must have a maximum of 50MB (10MB for XLS), 100,000 rows, 128 total columns and 32 text columns;
* [[Text]] data type columns have a limit of 255 characters;
* [[Value]] data type columns are limited to 11 integers and 5 decimals;
* Files can also contain formulas and expressions, see [[File Formulas]] for more information.
'''CSV Specific Requirements''':
* Any field delimiter is supported (with the exception of line breaks);
* Date fields must be in a supported format. Ex.: ''"dd/MM/yyyy"'' = ''31/01/2013'';
* Value (numeric) fields must use dot ''"."'' or comma ''","'' as decimal separator.
'''Attention. Very 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:
* '''New 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''';
'''Supported Extensions''': XLS, XLSX and CSV (or other compatible with CSV);
'''Supported Data''':
* Files must contain at least one [[Date]], one [[Text]] and one [[Value]] column;
* Files must have a maximum of 50MB (10MB for XLS), 100,000 rows, 128 total columns and 32 text columns;
* [[Text]] data type columns have a limit of 255 characters;
* [[Value]] data type columns are limited to 11 integers and 5 decimals;
* Files can also contain formulas and expressions, see [[File Formulas]] for more information.
'''CSV Specific Requirements''':
* Any field delimiter is supported (with the exception of line breaks);
* Date fields must be in a supported format. Ex.: ''"dd/MM/yyyy"'' = ''31/01/2013'';
* Value (numeric) fields must use dot ''"."'' or comma ''","'' as decimal separator.
'''Attention. Very 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:
* '''New 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''';
