Difference between revisions of "Importing Problems/pt-br"

From TaticView
Jump to: navigation, search
(Created page with "<div style="float: right;">__TOC__</div>")
Line 3: Line 3:
  
  
−
Veja antes [[Excel Importing Guide/pt-br|Guia de Importação Arquivos Excel]].
+
<div style="float: right;">__TOC__</div>
  
 +
See also [[Excel Importing Guide]].
  
−
'''Se o seu arquivo está apresentando erro ao importar, verifique essas dicas:'''
 
  
−
* Verifique se o arquivo é suportado ([[Supported File Formats/pt-br|Formato de Arquivo Suportados]]);
+
<span style="color: red;">'''Important:'''</span>
−
* Remova colunas totalmente vazias (sem dados e cabeçalho);
 
−
* Remova linhas/registros totalmente vazias;
 
−
* Remova todas as colunas que não são datas, textos ou números (como imagens por exemplo);
 
−
* Remova células mescladas;
 
−
* Remova ou formate corretamente colunas de data que não estão sendo identificadas na planilha;
 
−
* Remova caracteres desconhecidos, estranhos ou de controle;
 
−
* Remova caracteres especiais, como pontos e linhas do cabeçalho;
 
−
* Remova expressões complexas ou não matemáticas ([[Expressions/pt-br|Expressões]]);
 
−
* Se usar cabeçalhos, preencha-o em todas as colunas;
 
−
* Verifique por tipos de dados diferentes na mesma coluna. Todas células de uma coluna devem ser do mesmo tipo;
 
−
* Verifique se alguma coluna não está excedendo o tamanho limite ([[Supported File Formats/pt-br|Veja os limites]]);
 
−
* Verifique se o arquivo não está excedendo o tamanho limite ([[Supported File Formats/pt-br|Veja os limites]]);
 
−
* Verifique se o arquivo não está excedendo o limite de linhas ([[Supported File Formats/pt-br|Veja os limites]]);
 
  
−
* Específico para arquivos CSV:
 
−
** Verifique se a codificação do arquivo, separador de coluna e separador decimal selecionados são iguais ao do arquivo;
 
−
** Tente salvar o arquivo como XLS ou XLSX para importar;
 
  
−
* Específico para arquivos XLS e XLSX:
+
Some settings cannot be modified in the data file or import file during the data import so the dashboards can work properly. For instance:
−
** Verifique se o arquivo possui mais de uma planilha (aba). O TaticView considera apenas a primeira planilha (aba) do arquivo, ignorando as demais;
+
* 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;
  
  
−
'''Faça o download de um arquivo de exemplo aqui [http://wiki.taticview.com/taticfiles/Vendas.xlsx Vendas.xlsx]'''
+
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].
  
  
 +
== Problems uploading a file ==
  
−
'''Importante'''
 
  
 +
==== <span id="ThereAreNoColumnsException"><span id="FileWithoutRowsException">We could not detect any data column in the file</span></span> ====
 +
* 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;
  
−
Para manter o correto funcionamento dos painéis criados, algumas definições não podem ser alteradas no arquivo de dados e no arquivo de importação:
+
==== <span id="EmptyFileException">We've detected that the file is empty</span> ====
 +
* 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;
  
−
* Verifique por diferenças da importação inicial/anterior:
+
==== <span id="InvalidXLSXFormatException">XLSX file is in an invalid format</span> ====
−
** Colunas não podem ser adicionadas entre as colunas originais;
+
* The file's structure does not respect the XLSX format. Try saving the file again using Excel. See how on [[Save File Supported Format]];
−
*** Colunas somente podem ser adicionadas no final do arquivo;
+
* Check if the file is secured with a password if so, remove it;
−
** Os títulos das colunas não podem ser alterados;
+
 
−
*** O apelido das colunas pode ser alterado na [[Input Data Format/pt-br|importação do arquivo]], mas objetos previamente criados continuarão com o apelido antigo;
+
==== <span id="NotOOXMLFileException">XLSX file is out of Excel's standards</span> ====
−
*** Para atualizar o apelido num objeto, remova e adicione novamente a coluna;
+
* The file's structure does not respect the XLSX format. Try saving the file again using Excel. See how on [[Save File Supported Format]];
−
** Colunas não podem ser removidas do arquivo;
+
* If the file was generated by a third party software, the problem can be with the software used;
−
** Colunas não podem ter suas posições alteradas;
+
 
−
** O tipo de dados da coluna não pode ser alterado;
+
==== <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]];
 +
 
 +
==== <span id="EncryptedXLSFormatException">XLS file encrypted</span> ====
 +
* Remove the encryption if the file is encrypted. TatciView does not support encrypted XLS files;
 +
 
 +
==== <span id="FileReadingFailureException">File not supported</span> ====
 +
* The file type is based on its extension. The submitted file has an unknown extension. See the supported formats [[Supported File Formats]];
 +
 
 +
==== <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]]. Try converting the file to the Excel's standard format or CSV, see hoe on [[Save File Supported Format]];
 +
 
 +
==== <span id="OldExcelFormatExceptio">Excel format not supported</span> ====
 +
* The file was generated in an old Excel version. Try converting the file to a more recent Excel format. See more [[Save File Supported Format]];
 +
 
 +
 
 +
== Data preview problems ==
 +
 
 +
 
 +
==== <span id="ColumnNameIsBlankException"><span id="TitleIsBlankException">Columns with the name in blank</span></span> ====
 +
* Check if there is a column with the name in blank on the header in your file;
 +
 
 +
==== <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;
 +
 
 +
==== <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;
 +
 
 +
==== <span id="InvalidExpressionException">Columns with invalid expressions</span> ====
 +
* Check your file's expressions (formulas) and correct the incorrect ones;
 +
 
 +
==== <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]];

Revision as of 17:35, 13 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

We could not detect any data column in the file

  • 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;

We've detected that the 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;

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;

XLSX file is out of Excel's standards

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

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 not supported

  • The file type is based on its extension. The submitted file has an unknown extension. See the supported formats Supported File Formats;

File in ODF format

Excel format not supported

  • The file was generated in an old Excel version. Try converting the file to a more recent Excel format. See more Save File Supported Format;


Data preview problems

Columns with the name in blank

  • Check if there is a column with the name in blank on the header in your file;

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;

Columns with invalid expressions

  • Check your file's expressions (formulas) and correct the incorrect ones;

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;
Retrieved from "http://wiki.taticview.com/index.php?title=Importing_Problems/pt-br&oldid=18792"