Difference between revisions of "Supported File Formats"

From TaticView
Jump to: navigation, search
Line 34: Line 34:
  
  
−
<!--T:7-->
+
<span style="color: red;">'''Important:'''</span>
−
'''Attention. Very Important'''
 
  
−
<!--T:8-->
+
Some settings cannot be modified in the data file or import file during the data import so the dashboards can work properly. For instance:
−
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:
+
* 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;
  
−
 
−
<!--T:9-->
 
−
* 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;
 
  
  

Revision as of 17:05, 18 October 2017

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 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 100MB (20MB for XLS), 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.
  • Column headings (headers) can contain a maximum of 50 characters;


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 a dot "." or a comma "," as decimal separator.


Important:

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;



Retrieved from "http://wiki.taticview.com/index.php?title=Supported_File_Formats&oldid=19250"