2,155
edits
Changes
Marked this version for translation
<languages/>
<translate>
<!--T:10-->
<div style="float: right;">__TOC__</div>
<!--T:14-->
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].
<!--T:11-->
See also [[Excel Importing Guide]].
<!--T:12-->
<span style="color: red;">'''Important:'''</span>
<!--T:13-->
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 == <!--T:15-->
==== <span id="ThereAreNoColumnsException"><span id="FileWithoutRowsException">File without columns of data</span></span> ==== <!--T:16-->
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;
==== <span id="EmptyFileException">File is empty</span> ==== <!--T:18-->
We have detected that the file you are trying to import into TaticView is empty. Please check the following:
* If the file you are trying to import has data;
* If your file is configured in a format supported by TaticView. See more in [[Excel Importing Guide]] and [[Supported File Formats]];
==== <span id="InvalidXLSXFormatException"> <span id="NotOOXMLFileException">XLSX file is in an invalid format</span></span> ==== <!--T:19-->
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 [[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> ==== <!--T:38-->
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> ==== <!--T:21-->
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> ==== <!--T:22-->
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> ==== <!--T:23-->
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> ==== <!--T:24-->
TaticView does not support ''ODF'' (OpenOffice, LibreOffice, etc.) files. See the [[Supported File Formats|supported formats]].
* 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> ==== <!--T:25-->
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> ==== <!--T:42-->
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> ==== <!--T:43-->
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 == <!--T:26-->
==== <span id="ColumnNameIsBlankException">Columns with the name in blank</span> ==== <!--T:27-->
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;
==== <span id="CharactersExceedLimitException">Columns when the name is too large</span> ==== <!--T:229-->* Check if The current limit for the file column title 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 50 characters and dots (.) from headers titles;* Remove non-mathematical and complex expressions ([[Expressions]]);* If using headersany column in your file is longer than 50 characters, fill it for all columns;* Check for data type mixed columns. All cells in a column must be reduce the same data type;* Check if some column its not exceeding name to proceed with the size limit ([[Supported File Formats|See limits]]);import.* Check if the file it not exceeding You can rename the columns limit ([[Supported File Formats|See limits]]);* Check if on the file it not exceeding the rows limit ([[Supported File Formats|See limitsInput Data Format]])screen;
==== <span id="ColumnsWithSameNameException"><span id="TitlesWithSameNameException">Columns with the same name</span></span> ==== <!--T:330-->* Specific for CSV You can not import files:where there are two or more columns with the same name in the columns.** Check if selected file encodingOn the [[Input Data Format]] screen, identify which columns, decimal separator and date mask match have the file;** Try to save as XLS or XLSX to importsame name by renaming them if necessary;
==== <span id="InvalidExpressionException">Columns with invalid expressions</span> ==== <!--T:32-->
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 [[Expressions|here]];
==== <span id="ColumnRemovedException">File's columns removal</span> ==== <!--T:433-->'''Download a sample TaticView does not support column removal after the file here: [http://wikihas been imported for the first time.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]The current file must have the same existing columns if you are updating the data;
==== <span id="CircularReferenceException">Expressions with circular reference</span> ==== <!--T:34-->
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> ==== <!--T:35-->
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> ==== <!--T:536-->'''Important'''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> ==== <!--T:39-->
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> ==== <!--T:637-->To maintain the correct operation TaticView has a limit of the created dashboards, some definitions and settings Text columns that can not be changed later in the data source and in the import 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> ==== <!--T:40-->
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> ==== <!--T:741-->* Columns TaticView has a limit of Dimensions columns that can not be added between the original columns in the imported per file;** It . Currently this limit is possible to add column to the end of the file;* Columns names can not be changed in the file header;63 dimension columns.** Column names can be changed in the See all limits [[Input Data FormatSupported File Formats|here]] 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;
</translate>