11,677
edits
Changes
Importing a new version from external source
'''If your file is failing to import, check this important tips:'''
* Check if the file is supported ([[Supported File Formats]]);
* Remove full empty columns (without data and header);
* Remove full empty rows/lines;
* Remove all non date, text or number data type column (like images);
* Remove merged cells;
* Remove or format correctly date column not identified by the spreadsheet;
* Remove unknown, strange or control characters;
* Remove special characters and dots (.) from headers titles;
* Remove non-mathematical and complex expressions ([[Expressions]]);
* If using headers, fill it for all columns;
* Check for data type mixed columns. All cells in a column must be the same data type;
* Check if some column its not exceeding the size limit ([[Supported File Formats|See limits]]);
* Check if the file it not exceeding the columns limit ([[Supported File Formats|See limits]]);
* Check if the file it not exceeding the rows limit ([[Supported File Formats|See limits]]);
* Specific for CSV files:
** Check if selected file encoding, columns, decimal separator and date mask match the file;
** Try to save as XLS or XLSX to import;
'''Download a sample file here: [http://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]
'''Important'''
To maintain the correct operation of the created dashboards, some definitions and settings can not be changed later in the data source and in the 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;
* Check if the file is supported ([[Supported File Formats]]);
* Remove full empty columns (without data and header);
* Remove full empty rows/lines;
* Remove all non date, text or number data type column (like images);
* Remove merged cells;
* Remove or format correctly date column not identified by the spreadsheet;
* Remove unknown, strange or control characters;
* Remove special characters and dots (.) from headers titles;
* Remove non-mathematical and complex expressions ([[Expressions]]);
* If using headers, fill it for all columns;
* Check for data type mixed columns. All cells in a column must be the same data type;
* Check if some column its not exceeding the size limit ([[Supported File Formats|See limits]]);
* Check if the file it not exceeding the columns limit ([[Supported File Formats|See limits]]);
* Check if the file it not exceeding the rows limit ([[Supported File Formats|See limits]]);
* Specific for CSV files:
** Check if selected file encoding, columns, decimal separator and date mask match the file;
** Try to save as XLS or XLSX to import;
'''Download a sample file here: [http://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]
'''Important'''
To maintain the correct operation of the created dashboards, some definitions and settings can not be changed later in the data source and in the 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;
