Difference between revisions of "Importing Problems"

From TaticView
Jump to: navigation, search
Line 13: Line 13:
 
* Remove full empty columns (without data and header);
 
* Remove full empty columns (without data and header);
 
* Remove full empty rows/lines;
 
* Remove full empty rows/lines;
* Remove all non date, text or number data type column (like images);
+
* Remove all non-date, text or number data type column (like images);
 
* Remove merged cells;
 
* Remove merged cells;
 
* Remove or format correctly date column not identified by the spreadsheet;
 
* Remove or format correctly date column not identified by the spreadsheet;
Line 21: Line 21:
 
* If using headers, fill it for all columns;
 
* 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 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 some column it's 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's 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]]);
+
* Check if the file it's not exceeding the rows limit ([[Supported File Formats|See limits]]);
  
 
<!--T:3-->
 
<!--T:3-->

Revision as of 18:50, 20 October 2016


Check first our Excel Importing Guide.


If your file is failing to import, check these 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 it's not exceeding the size limit (See limits);
  • Check if the file it's not exceeding the columns limit (See limits);
  • Check if the file it's not exceeding the rows limit (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: 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;