Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Issue in import file Excel

Hi all,
I'm trying to import a lot of excel files using Talend etl jobs, but, when i create the metadata the following message is displayed:
Warning:  Usage of a local non-builtin name
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

Files I'm trying to import have 97-2003 excel format (xls) and I'm using UTF-8 encoding.
If I convert these files using excel the error doesn't occur more.
Because I need import these files automatically no convert operation shoud be performed.
I use TOS DI 6.0.0
Does anybody can help me, please?
Labels (3)
21 Replies
Rosanero4Ever
Contributor
Contributor

Hi all,
I can confirm that the described bug was solved in TOS DI 6.1.
Congratulations to the development team for its work!  0683p000009MACJ.png
Anonymous
Not applicable

I am getting the same error while using the 7.3.1 verison. Can some one please help. 

 

Error Message: The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)