Difference between revisions of "Supported File Formats"

From TaticView
Jump to: navigation, search
 
(27 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 +
<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]]:
 
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);
+
<!--T:2-->
 +
'''Supported Extensions''':  
 +
 
 +
<!--T:16-->
 +
* <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''':  
+
<!--T:3-->
 +
<span id="limits">'''Limits Supported''':</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;
 
* 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;
+
** total columns 256;
 +
** maximum text + date columns 63;
 +
** maximum numeric columns 254
 
* [[Text]] data type columns have a limit of 255 characters;
 
* [[Text]] data type columns have a limit of 255 characters;
 
* [[Value]] data type columns are limited to 11 integers and 5 decimals;
 
* [[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.
+
* Column headings (headers) can contain a maximum of 50 characters;
 
 
  
  
 +
<!--T:5-->
 
'''CSV Specific Requirements''':  
 
'''CSV Specific Requirements''':  
  
 +
<!--T:6-->
 +
* CSV files size are limited to 500MB
 
* 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 a supported format. Ex.: ''"dd/MM/yyyy"'' = ''31/01/2013'';
 
* 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.
+
* 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>
  
 +
<!--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]].
  
'''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:
+
<!--T:14-->
 +
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 [[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;
  
  
* '''New Columns can not be added between the original columns in the file''';
+
</translate>
** 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''';
 

Latest revision as of 15:01, 5 April 2022

Other languages:
English • ‎português do Brasil


The TaticView Data Sources support the following file formats and types for import or update:


Supported Extensions:

  • XLS
  • XLSX
  • XLSM
  • CSV (or other compatible with CSV)


Limits Supported:

  • 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;
  • Column headings (headers) can contain 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 File Formulas for more information.


Important:

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. See how.


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 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;