Difference between revisions of "Importing Problems/en"

From TaticView
Jump to: navigation, search
(Importing a new version from external source)
(Updating to match new version of source page)
 
(65 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
 
<div style="float: right;">__TOC__</div>
 
<div style="float: right;">__TOC__</div>
 +
 +
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 [https://support.taticview.com Support Team].
 +
  
 
See also [[Excel Importing Guide]].
 
See also [[Excel Importing Guide]].
Line 9: Line 12:
  
 
<span style="color: red;">'''Important:'''</span>
 
<span style="color: red;">'''Important:'''</span>
 
  
 
Some settings cannot be modified in the data file or import file during the data import so the dashboards can work properly. For instance:
 
Some settings cannot be modified in the data file or import file during the data import so the dashboards can work properly. For instance:
Line 21: Line 23:
 
* The columns data type (text, value, date) 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 [https://support.taticview.com Support Team].
 
  
  
Line 28: Line 28:
  
  
==== <span id="ThereAreNoColumnsException"><span id="FileWithoutRowsException">We could not detect any data column in the file</span></span> ====
+
==== <span id="ThereAreNoColumnsException"><span id="FileWithoutRowsException">File without columns of data</span></span> ====
* Check if the file you are trying to import is in a format accepted by TaticView. See more [[Excel Importing Guide]];
+
We could not detect columns/rows of data in your file. Please check the following:
* 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;
+
* If your file is configured in a format supported by TaticView. See more in [[Excel Importing Guide]] and [[Supported File Formats]];
* Check if there is data in the first tab (spreadsheet) of the file you are trying to upload. We always consider the first tab;
+
* TaticView reads the first 10 rows of the file to interpret data columns, make sure your file has data in the first 10 rows;
 +
* TaticView always considers the first visible file (tab) file (''XLS'', ''XLSX'' or ''XLSM''). If your file has more than one worksheet, position the file you want to import first;
  
 
==== <span id="EmptyFileException">File is empty</span> ====
 
==== <span id="EmptyFileException">File is empty</span> ====
* Check if the file you are trying to import has any data;
+
We have detected that the file you are trying to import into TaticView is empty. Please check the following:
* Check if the file is in a format accepted by TaticView;
+
* If the file you are trying to import has data;
* 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;
+
* If your file is configured in a format supported by TaticView. See more in [[Excel Importing Guide]] and [[Supported File Formats]];
  
==== <span id="InvalidXLSXFormatException">XLSX file is in an invalid format</span> ====
+
==== <span id="InvalidXLSXFormatException"> <span id="NotOOXMLFileException">XLSX file is in an invalid format</span></span> ====
* The file's structure does not respect the XLSX format. Try saving the file again using Excel. See how on [[Save File Supported Format]];
+
We are unable to read your ''XLSX'' file, because the structure of the file is apparently in an invalid format. If the file was generated by a third-party software, it could be a problem in the program that generated the file. In this case, try the following:
* Check if the file is secured with a password if so, remove it;
+
* Save the file again using Excel. See how [[Save File Supported Format|here]];
 +
* If your file is password protected, remove the protection;
  
 
==== <span id="StrictOOXMLNotSupportedException">XLSX file in Strict Open XML format</span> ====
 
==== <span id="StrictOOXMLNotSupportedException">XLSX file in Strict Open XML format</span> ====
* 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]].
+
We do not support files with the ''XLSX'' extension that were saved with the ''Strict Open XML'' format. We recommend that:
 +
* Try to save the file using the standard format of Excel. See how [[Save File Supported Format|here]];
  
 
==== <span id="InvalidXLSFormatException">XLS file is in an invalid format</span> ====
 
==== <span id="InvalidXLSFormatException">XLS file is in an invalid format</span> ====
* Verify if the file is an XLS file. Try saving the file again using Excel. See how on [[Save File Supported Format]];
+
We were unable to read your ''XLS'' file. Please check the following:
 +
* If your file really is an ''XLS'' file;
 +
* Try to save the file using the standard format of Excel. See how [[Save File Supported Format|here]];
  
 
==== <span id="EncryptedXLSFormatException">XLS file encrypted</span> ====
 
==== <span id="EncryptedXLSFormatException">XLS file encrypted</span> ====
* Remove the encryption if the file is encrypted. TatciView does not support encrypted XLS files;
+
We have detected that your ''XLS'' file is encrypted. TaticView does not support encrypted files.
 +
* Remove encryption from file;
  
 
==== <span id="FileReadingFailureException">File type not supported</span> ====
 
==== <span id="FileReadingFailureException">File type not supported</span> ====
* TaticView detects the file type based on its extension. If you are having problems with the file type, during data import, see [[Supported File Formats|here]] which are the currently supported file types;
+
TaticView detects the file type based on its extension. We have identified that your file is not a supported file.
 +
* See [[Supported File Formats|here]] what types of files are currently supported;
  
 
==== <span id="ODFFormatNotSupportedException">File in ODF format</span> ====
 
==== <span id="ODFFormatNotSupportedException">File in ODF format</span> ====
* Files in the ODF format (OpenOffice, LibreOffice) are not supported. See the [[Supported File Formats|supported formats]];
+
TaticView does not support ''ODF'' (OpenOffice, LibreOffice, etc.) files. See the [[Supported File Formats|supported formats]].
* Try converting the file to the Excel's standard format or CSV, see hoe on [[Save File Supported Format]];
+
* Try to convert the file to the standard format of ''Excel'' or ''CSV''. See how [[Save File Supported Format|here]];
  
 
==== <span id="OldExcelFormatException">Old Excel format</span> ====
 
==== <span id="OldExcelFormatException">Old Excel format</span> ====
* The file was generated in an old Excel version. Try converting the file to a more recent Excel format. See how [[Save File Supported Format]];
+
TaticView does not support files that have been saved in older versions of Excel. Please try the following:
 +
* Convert the file to a newer Excel format. See how [[Save File Supported Format|here]];
 +
 
 +
==== <span id="OfficeXmlInXLSFileException">XLSX file with XLS extension</span> ====
 +
The file you are trying to import has an ''XLS'' extension, but by analyzing its structure we have detected that it is an ''XLSX'' or ''XLSM'' file. To be able to import this file, we suggest that you try the following:
 +
* Try to save the file using the standard format of Excel. See how [[Save File Supported Format|here]];
 +
 
 +
==== <span id="AttNameAlreadyUsedInDatamartException">Changing column name to an existing column name</span> ====
 +
You are trying to rename a column to the same name as an existing column. This is not allowed in the same process.
 +
* You will have to do the process in two steps. First import by renaming the first column. And then import again renaming the desired one to the name of the first.
  
 
== Data Formatting Problems ==
 
== Data Formatting Problems ==
  
  
==== <span id="ColumnNameIsBlankException"><span id="TitleIsBlankException">Columns with the name in blank</span></span> ====
+
==== <span id="ColumnNameIsBlankException">Columns with the name in blank</span> ====
* Check if there is a column with the name in blank on the header in your file;
+
To preserve the integrity of the information, you can not import data when there are one or more columns with the blank title.
 
* Make sure that in the [[Input Data Format]] screen, any column is blank;
 
* Make sure that in the [[Input Data Format]] screen, any column is blank;
  
 
==== <span id="CharactersExceedLimitException">Columns when the name is too large</span> ====
 
==== <span id="CharactersExceedLimitException">Columns when the name is too large</span> ====
* Check if there is a column's title that exceeds the 50 characters limit. If so, reduce the column's title;
+
The current limit for the column title is 50 characters. If any column in your file is longer than 50 characters, reduce the name to proceed with the import.
 +
* You can rename the columns on the [[Input Data Format]] screen;
  
 
==== <span id="ColumnsWithSameNameException"><span id="TitlesWithSameNameException">Columns with the same name</span></span> ====
 
==== <span id="ColumnsWithSameNameException"><span id="TitlesWithSameNameException">Columns with the same name</span></span> ====
* 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;
+
You can not import files where there are two or more columns with the same name in the columns.
* Also check that there are columns with the same name in the [[Input Data Format]] screen;
+
* On the [[Input Data Format]] screen, identify which columns have the same name by renaming them if necessary;
  
 
==== <span id="InvalidExpressionException">Columns with invalid expressions</span> ====
 
==== <span id="InvalidExpressionException">Columns with invalid expressions</span> ====
* Check your file's expressions (formulas) and correct the incorrect ones;
+
At the time of importing your file, the formulas in it are pre-validated. If there are any invalid formula, try the following:
* Make sure your file expressions are supported expressions. See the supported expressions [[Expressions|here]];
+
* Verify that all expressions (formulas) in your file are correct and correct those that are incorrect;
 +
* Check that your file expressions are expressions supported by TaticView. See the supported expressions [[Expressions|here]];
  
 
==== <span id="ColumnRemovedException">File's columns removal</span> ====
 
==== <span id="ColumnRemovedException">File's columns removal</span> ====
* 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;
+
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;
  
 
==== <span id="CircularReferenceException">Expressions with circular reference</span> ====
 
==== <span id="CircularReferenceException">Expressions with circular reference</span> ====
* 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;
+
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;
  
 
==== <span id="MissingTypesOfColumnsException">File without the minimum requirements</span> ====
 
==== <span id="MissingTypesOfColumnsException">File without the minimum requirements</span> ====
* 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]];
+
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]];
  
 
==== <span id="NumberOfColsExceedLimit">Column limit exceeded</span> ====
 
==== <span id="NumberOfColsExceedLimit">Column limit exceeded</span> ====
* Your file has exceeded the supported column limit. Check the limits [[Supported File Formats|here]];
+
TaticView has a limit of columns that can be imported per file. Currently this limit is 256 columns in total.
 +
* See all limits [[Supported File Formats|here]];
 +
 
 +
==== <span id="NumberOfDateColsExceedLimit">Date Columns limit exceeded</span> ====
 +
TaticView has a limit of Date columns that can be imported per file. Currently this limit is 62 date columns.
 +
* See all limits [[Supported File Formats|here]];
  
 
==== <span id="NumberOfTextColsExceedLimit">Text column limit exceeded</span> ====
 
==== <span id="NumberOfTextColsExceedLimit">Text column limit exceeded</span> ====
* Your file has exceeded the limit of supported text columns. Check the limit [[Supported File Formats|here]];
+
TaticView has a limit of Text columns that can be imported per file. Currently, this limit is 62 text columns.
 +
* See all limits [[Supported File Formats|here]];
 +
 
 +
==== <span id="NumberOfNumericColsExceedLimit">Numeric Columns limit exceeded</span> ====
 +
TaticView has a limit of Numeric columns that can be imported per file. Currently this limit is 254 numeric columns.
 +
* See all limits [[Supported File Formats|here]];
 +
 
 +
==== <span id="NumberOfDimensionsColsExceedLimit">Dimension Columns (Date + Text) limit exceeded</span> ====
 +
TaticView has a limit of Dimensions columns that can be imported per file. Currently this limit is 63 dimension columns.
 +
* See all limits [[Supported File Formats|here]];

Latest revision as of 14:48, 18 December 2020

Other languages:


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.


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;


Problems Uploading a File

File without columns of data

We could not detect columns/rows of data in your file. Please check the following:

  • If your file is configured in a format supported by TaticView. See more in Excel Importing Guide and Supported File Formats;
  • TaticView reads the first 10 rows of the file to interpret data columns, make sure your file has data in the first 10 rows;
  • TaticView always considers the first visible file (tab) file (XLS, XLSX or XLSM). If your file has more than one worksheet, position the file you want to import first;

File is empty

We have detected that the file you are trying to import into TaticView is empty. Please check the following:

XLSX file is in an invalid format

We are unable to read your XLSX file, because the structure of the file is apparently in an invalid format. If the file was generated by a third-party software, it could be a problem in the program that generated the file. In this case, try the following:

  • Save the file again using Excel. See how here;
  • If your file is password protected, remove the protection;

XLSX file in Strict Open XML format

We do not support files with the XLSX extension that were saved with the Strict Open XML format. We recommend that:

  • Try to save the file using the standard format of Excel. See how here;

XLS file is in an invalid format

We were unable to read your XLS file. Please check the following:

  • If your file really is an XLS file;
  • Try to save the file using the standard format of Excel. See how here;

XLS file encrypted

We have detected that your XLS file is encrypted. TaticView does not support encrypted files.

  • Remove encryption from file;

File type not supported

TaticView detects the file type based on its extension. We have identified that your file is not a supported file.

  • See here what types of files are currently supported;

File in ODF format

TaticView does not support ODF (OpenOffice, LibreOffice, etc.) files. See the supported formats.

  • Try to convert the file to the standard format of Excel or CSV. See how here;

Old Excel format

TaticView does not support files that have been saved in older versions of Excel. Please try the following:

  • Convert the file to a newer Excel format. See how here;

XLSX file with XLS extension

The file you are trying to import has an XLS extension, but by analyzing its structure we have detected that it is an XLSX or XLSM file. To be able to import this file, we suggest that you try the following:

  • Try to save the file using the standard format of Excel. See how here;

Changing column name to an existing column name

You are trying to rename a column to the same name as an existing column. This is not allowed in the same process.

  • You will have to do the process in two steps. First import by renaming the first column. And then import again renaming the desired one to the name of the first.

Data Formatting Problems

Columns with the name in blank

To preserve the integrity of the information, you can not import data when there are one or more columns with the blank title.

Columns when the name is too large

The current limit for the column title is 50 characters. If any column in your file is longer than 50 characters, reduce the name to proceed with the import.

Columns with the same name

You can not import files where there are two or more columns with the same name in the columns.

  • On the Input Data Format screen, identify which columns have the same name by renaming them if necessary;

Columns with invalid expressions

At the time of importing your file, the formulas in it are pre-validated. If there are any invalid formula, try the following:

  • Verify that all expressions (formulas) in your file are correct and correct those that are incorrect;
  • Check that your file expressions are expressions supported by TaticView. 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.

Column limit exceeded

TaticView has a limit of columns that can be imported per file. Currently this limit is 256 columns in total.

  • See all limits here;

Date Columns limit exceeded

TaticView has a limit of Date columns that can be imported per file. Currently this limit is 62 date columns.

  • See all limits here;

Text column limit exceeded

TaticView has a limit of Text columns that can be imported per file. Currently, this limit is 62 text columns.

  • See all limits here;

Numeric Columns limit exceeded

TaticView has a limit of Numeric columns that can be imported per file. Currently this limit is 254 numeric columns.

  • See all limits here;

Dimension Columns (Date + Text) limit exceeded

TaticView has a limit of Dimensions columns that can be imported per file. Currently this limit is 63 dimension columns.

  • See all limits here;