Open main menu

TaticView β

Changes

Importing Problems/en

2,602 bytes added, 14:48, 18 December 2020
Updating to match new version of source page
<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]].
<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:
* 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].
==== <span id="ThereAreNoColumnsException"><span id="FileWithoutRowsException">File without columns of data</span></span> ====
We could not detect columns/rows of data in your file. Please check the following:* Check if the If your file you are trying to import is configured in a format accepted supported by TaticView. See more in [[Excel Importing Guide]] and [[Supported File Formats]];* TaticView reads the first ten columns (on the first visible tab in XLS and XLSX files) 10 rows of the file to detect the interpret data columns. In case the columns are not found, make sure your file has data in the process is abortedfirst 10 rows;* Check if there is data in TaticView always considers the first visible file (tab ) file (spreadsheet''XLS'', ''XLSX'' or ''XLSM'') of . If your file has more than one worksheet, position the file you are trying want to upload. We always consider the import first tab;
==== <span id="EmptyFileException">File is empty</span> ====
We have detected that the file you are trying to import into TaticView is empty. Please check the following:* Check if If the file you are trying to import has any data;* Check if the If your file is configured in a format accepted supported by TaticView;* TaticView reads the first ten columns (on the first visible tab . See more in XLS [[Excel Importing Guide]] and XLSX files) of the file to detect the data columns. In case the columns are not found, the process is aborted[[Supported File Formats]];
==== <span id="InvalidXLSXFormatException"> <span id="NotOOXMLFileException">XLSX file is in an invalid format</span></span> ====* The We are unable to read your ''XLSX'' file's , because the structure does not respect of the XLSX file is apparently in an invalid format. Try saving 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 on [[Save File Supported Format|here]];* Check if the If your file is secured with a password if soprotected, remove itthe protection;
==== <span id="StrictOOXMLNotSupportedException">XLSX file in Strict Open XML format</span> ====
* TaticView does We do not support files with the ''XLSX files '' extension that have been were saved in with the ''Strict Open XML'' format. We recommend that:* Try to save the file using the default standard format of Excel format. See how on [[Save File Supported Format|here]].;
==== <span id="InvalidXLSFormatException">XLS file is in an invalid format</span> ====
We were unable to read your ''XLS'' file. Please check the following:* Verify if the If your file really is an ''XLS '' file. ;* Try saving to save the file again using the standard format of Excel. See how on [[Save File Supported Format|here]];
==== <span id="EncryptedXLSFormatException">XLS file encrypted</span> ====
* Remove the encryption if the We have detected that your ''XLS'' file is encrypted. TatciView TaticView does not support encrypted XLS files.* Remove encryption from file;
==== <span id="FileReadingFailureException">File type not supported</span> ====* The TaticView detects the file type is based on its extension. The submitted We have identified that your file is not a supported file has an unknown extension. * See the supported formats [[Supported File Formats|here]]what types of files are currently supported;
==== <span id="ODFFormatNotSupportedException">File in ODF format</span> ====
* Files in the TaticView does not support ''ODF format '' (OpenOffice, LibreOffice, etc.) are not supportedfiles. See the [[Supported File Formats|supported formats]]; .* Try converting to convert the file to the standard format of ''Excel's standard format ' or ''CSV, see hoe on ''. See how [[Save File Supported Format|here]];
==== <span id="OldExcelFormatException">Old Excel format</span> ====
TaticView does not support files that have been saved in older versions of Excel. Please try the following:* If Convert the file was generated in to a very old newer Excelformat. 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 convert save the file to a more recent using the standard format of Excel format. 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 ==
==== <span id="ColumnNameIsBlankException">Columns with the name in blank</span> ====
* Check if To preserve the integrity of the information, you can not import data when there is a column are one or more columns with the name in blank on the header in your file;title.
* Make sure that in the [[Input Data Format]] screen, any column is blank;
==== <span id="CharactersExceedLimitException">Columns when the name is too large</span> ====
* Check if there is a The current limit for the column's title that exceeds the is 50 characters limit. If soany column in your file is longer than 50 characters, reduce the column's titlename 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> ====
* TaticView does You can not support import files where there are two or more columns with the same name. It will be necessary to change in the columns names if your file has columns with the same name;.* Also check that there are columns with the same name in 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> ====
* Check At the time of importing your file's , 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 the those that are incorrect ones;* Make sure Check that your file expressions are expressions supported expressionsby TaticView. See the supported expressions [[Expressions|here]];
==== <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;
==== <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;
==== <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]];
==== <span id="NumberOfColsExceedLimit">Column limit exceeded</span> ====
TaticView has a limit of columns that can be imported per file. Currently this limit is 256 columns in total.* Your 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 has exceeded the supported column . Currently this limitis 62 date columns. Check the * See all limits [[Supported File Formats|here]];
==== <span id="NumberOfTextColsExceedLimit">Text column limit exceeded</span> ====
TaticView has a limit of Text columns that can be imported per file. Currently, this limit is 62 text columns.* Your 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 exceeded the a limit of supported text Dimensions columnsthat can be imported per file. Check the Currently this limit is 63 dimension columns.* See all limits [[Supported File Formats|here]];
11,677
edits