Difference between revisions of "Importing Problems"

From TaticView
Jump to: navigation, search
(Marked this version for translation)
Line 44: Line 44:
 
* TaticView reads the first ten columns (on the first visible tab in XLS and XLSX files) of the file to detect the data columns. In case the columns are not found, the process is aborted;
 
* TaticView reads the first ten columns (on the first visible tab in XLS and XLSX files) of the file to detect the data columns. In case the columns are not found, the process is aborted;
  
 +
<!--T:39-->
 
{{EmptyFileException}}
 
{{EmptyFileException}}
  

Revision as of 17:01, 17 October 2017

Other languages:
English • ‎português do Brasil


See also Excel Importing Guide.


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;


If the file you are trying to import is presenting an error, check below to see probable causes and solutions. Or get in touch with our Support Team.


Problems Uploading a File

File without columns of data

  • Check if the file you are trying to import is in a format accepted by TaticView. See more Excel Importing Guide;
  • TaticView reads the first ten columns (on the first visible tab in XLS and XLSX files) of the file to detect the data columns. In case the columns are not found, the process is aborted;
  • Check if there is data in the first tab (spreadsheet) of the file you are trying to upload. We always consider the first tab;

File is empty

  • Check if the file you are trying to import has any data;
  • Check if the file is in a format accepted by TaticView;
  • TaticView reads the first ten columns (on the first visible tab in XLS and XLSX files) of the file to detect the data columns. In case the columns are not found, the process is aborted;

Template:EmptyFileException

XLSX file is in an invalid format

  • The file's structure does not respect the XLSX format. Try saving the file again using Excel. See how on Save File Supported Format;
  • Check if the file is secured with a password if so, remove it;
  • If the file was generated by a third party software, the problem can be with the software used;

XLSX file in Strict Open XML format

  • TaticView does not support XLSX files that have been saved in Strict Open XML format. Try to save the file using the default Excel format. See how on Save File Supported Format.

XLS file is in an invalid format

XLS file encrypted

  • Remove the encryption if the file is encrypted. TatciView does not support encrypted XLS files;

File type not supported

  • TaticView detects the file type based on its extension. If you are having problems with the file type, during data import, see here which are the currently supported file types;

File in ODF format

Old Excel format

  • If the file was generated in a very old Excel, try to convert the file to a more recent Excel format. See how Save File Supported Format;

Data Formatting Problems

Columns with the name in blank

Columns when the name is too large

  • Check if there is a column's title that exceeds the 50 characters limit. If so, reduce the column's title;

Columns with the same name

  • TaticView does not support columns with the same name. It will be necessary to change the columns names if your file has columns with the same name;
  • Also check that there are columns with the same name in the Input Data Format screen;

Columns with invalid expressions

  • Check your file's expressions (formulas) and correct the incorrect ones;
  • Make sure your file expressions are supported expressions. See the supported expressions here;

File's columns removal

  • TaticView does not support column removal after the file has been imported for the first time. The current file must have the same existing columns if you are updating the data;

Expressions with circular reference

  • Expressions with circular reference have been detected (expressions on which depend on others). TaticView does not support this behavior. It will be necessary to remove the circular reference to import your data;

File without the minimum requirements

  • Your file does not have the minimum requirements to be imported to TaticView. It is necessary to have at least a DATE, a TEXT column, and a NUMERIC column. See more on Supported File Formats;

Column limit exceeded

  • Your file has exceeded the supported column limit. Check the limits here;

Text column limit exceeded

  • Your file has exceeded the limit of supported text columns. Check the limit here;