Open main menu

TaticView β

Changes

Supported File Formats/en

617 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 100MB (20MB for XLS), 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 [[Expressions|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:''' To maintain the correct operation of the created dashboards, some definitions and settings can not be changed later in the data source and its import file:</span>
* '''New Columns If your worksheet is set up properly, but you still can not be added between the original columns in the file''';** It is possible to add column import, you may have a structural problem. We recommend that you try to save it again using the end of the file;* '''Columns names can not be changed in the file header''';** Column names can be changed in the standard Excel format. [[Input Data Save File Supported Format|See how]] 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''';
<!--Some settings cannot be 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:** New columns must be added at the end of the file;* Columns titles cannot be modified after the first import:** The columns nicknames can be modified in [[Save File Supported Input Data Format]]-->, but the dashboard's objects created previously will keep the previous nickname;** You must remove and add the column to update the dashboard's object nickname;* The columns cannot be removed from the file after the first import;* The columns position cannot be modified after the first import;* The columns data type (text, value, date) cannot be modified after the first import;
FuzzyBot
11,677
edits
Retrieved from "http://wiki.taticview.com/index.php/Special:MobileDiff/18869...29371"