Open main menu

TaticView β

Changes

Supported File Formats/en

657 bytes added, 15:01, 5 April 2022
Updating to match new version of source page
'''Supported Extensions''': XLS, XLSX and CSV (or other compatible with CSV);
* <span style="color: #153c78;">'''XLS'''</span>
* <span style="color: #153c78;">'''XLSX'''</span>
* <span style="color: #153c78;">'''XLSM'''</span>
* <span style="color: #153c78;">'''CSV'''</span> (or other compatible with CSV)
'''Supported Data''':
<span id="limits">'''Limits Supported''':</span>
 
* XLS* files size are limited to 100MB (20MB for XLS)
* 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 256;** maximum text + date columns63;** maximum numeric columns 254
* [[Text]] data type columns have a limit of 255 characters;
* [[Value]] data type columns are limited to 11 integers and 5 decimals;
* Files Column headings (headers) can also contain formulas and expressions, see [[File Formulas]] for more information.a maximum of 50 characters;
'''CSV Specific Requirements''':
* CSV files size are limited to 500MB
* 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 a dot ''"."'' or a comma ''","'' as decimal separator.
Files can also contain formulas and expressions, see [[Expressions|File Formulas]] for more information.
<span style="color: red;">'''Attention. Very Important:'''</span>
To maintain the correct operation of the created dashboardsIf your worksheet is set up properly, some definitions and settings but you still can not be changed later in import, you may have a structural problem. We recommend that you try to save it again using the data source and its import file:standard Excel format. [[Save File Supported Format|See how]].
* '''New Columns can not Some settings cannot be added between the original columns modified in the data file or import file''';during the data import so the dashboards can work properly. For instance:* You cannot add new columns between already imported columns:** It is possible to add column to New columns must be added at the end of the file;* '''Columns names can not titles cannot be changed in modified after the file header''';first import:** Column names The columns nicknames can be changed modified in the [[Input Data Format]] step, but the dashboard's objects that already use this column created previously will keep the previous name.nickname;** To update, You must remove and add again the column to update the dashboard's objectnickname;* '''Columns can not The columns cannot be removed from the file'''after the first import;* '''Columns must maintain its original order in The columns position cannot be modified after the file'''first import;* '''Columns The columns data type can not (text, value, date) cannot be changed'''modified after the first import;
11,677
edits