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

Announcements
Join us in Toronto Sept 9th 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)