Open main menu

TaticView β

Changes

Supported File Formats

1,095 bytes added, 15:01, 5 April 2022
no edit summary
<languages/>
 
 
<translate>
<!--T:1-->
The TaticView [[Data Sources]] support the following file formats and types for [[Creating a New Data Source|import]] or [[Import/Update data|update]]:
<!--T:2-->'''Supported Extensions''':  <!--T:16-->* <span style="color: #153c78;">'''XLS, '''</span>* <span style="color: #153c78;">'''XLSX e '''</span> * <span style="color: #153c78;">'''XLSM'''</span>* <span style="color: #153c78;">'''CSV '''</span> (or other compatible with CSV);
<!--T:3--><span id="limits">'''Limits Supported Data''': </span>
<!--T:4-->
* XLS* files size are limited to 100MB (20MB for XLS)
* Files must contain at least one [[Date]], one [[Text]] and one [[Value]] column;
** total columns 256;
** maximum text + date columns 63;
** 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;
<!--T:5-->
'''CSV Specific Requirements''':
<!--T:6-->
* CSV files size are limited to 500MB
* Any field delimiter is supported (with the exception of line breaks);
* Date fields must be in the a supported format. Ex.: ''"dd/MM/yyyy"'' format. Ex.: = ''31/01/2013'';* Value (numeric) fields must use a dot ''"."'' or a comma ''","'' as decimal separator. <!--T:17-->Files can also contain formulas and expressions, see [[Expressions|File Formulas]] for more information.
<!--T:13-->
<span style="color: red;">'''Important:'''</span>
'''Important'''<!--T:15-->If your worksheet is set up properly, but you still can not import, you may have a structural problem. We recommend that you try to save it again using the standard Excel format. [[Save File Supported Format|See how]].
To maintain <!--T:14-->Some settings cannot be modified in the correct operation 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 [[Input Data Format]], but the dashboard's objects created dashboards, some definitions previously will keep the previous nickname;** You must remove and settings can not 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 changed latter in modified after the first import;* The columns data source and its type (text, value, date) cannot be modified after the first 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;</translate>
Retrieved from "http://wiki.taticview.com/index.php/Special:MobileDiff/713...29367"