topic Re: Load excel sheet into talend in Talend Studio

Load excel sheet into talend

Anonymous — Wed, 14 Feb 2018 20:42:06 GMT

Hi!

I'm trying to load an excel sheet into talend using encoding ISO 8859, since it has brazilian portuguse content, but it won't work.

In attach is the excel sheet.

Re: Load excel sheet into talend

TRF — Wed, 14 Feb 2018 21:31:15 GMT

Hi,
Instead of share your Excel file, tell what's the problem you're facing.
Any error? Which one?
Unexpected result?
You may also share your job design or any component settings suspected to be the source of your problem.

Re: Load excel sheet into talend

Anonymous — Wed, 14 Feb 2018 21:49:55 GMT

Ok. Will share the error.

Re: Load excel sheet into talend

Anonymous — Wed, 14 Feb 2018 21:59:17 GMT

Hi! I tried puting the error message. But it keeps saying "Invalid HTML", and it would not let me post the question.

Error:

java.lang.ClassCastException@16ceb30f
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:461)
org.talend.designer.codegen.config.TalendJetEmitter.generate(TalendJetEmitter.java:684)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:441)
org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:432)
org.talend.designer.codegen.proxy.JetProxy.generate(JetProxy.java:54)
org.talend.designer.codegen.CodeGenerator.instantiateJetProxy(CodeGenerator.java:444)
org.talend.designer.codegen.CodeGenerator.generateContextCode(CodeGenerator.java:361)
org.talend.designer.core.runprocess.Processor.updateContextCode(Processor.java:637)
org.talend.designer.runprocess.java.JavaProcessor.generateContextCode(JavaProcessor.java:1585)
org.talend.designer.runprocess.ProcessorUtilities.generateContextInfo(ProcessorUtilities.java:693)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:929)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:741)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1463)
org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1432)
org.talend.designer.core.runprocess.Processor.run(Processor.java:178)
org.talend.designer.runprocess.java.AbstractJavaProcessor.run(AbstractJavaProcessor.java:272)
org.talend.designer.core.runprocess.Processor.run(Processor.java:136)
org.talend.designer.runprocess.shadow.ShadowProcess.runWithErrorOutputAsException(ShadowProcess.java:371)
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:86)
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)

Re: Load excel sheet into talend

Anonymous — Thu, 15 Feb 2018 18:24:18 GMT

Then at least screenshots of job and exact error...

I tried with UTF8 and ISO8859, i can create metadata for your file without issues. PFA the attachment.

Now the question is when you are getting the error, while creating metadata or loading data into DB table.

- if issue with metadata :- use attached file.

- if issue with the loading data to db table :- then you have to remove the accent using below function.

TalendString.removeAccents("")

Regards,

Ajinkya

BRAZIL.zip

Re: Load excel sheet into talend

Anonymous — Thu, 15 Feb 2018 20:59:02 GMT

I managed to fix! I unistall talend, then I did a downgrade on Java, because I had Java 9 installed and aparently talend only accepts till Java 8. Then I re-did the Java enviroment variables process and re-installed Talend and "voi lá". My excel sheet loaded.

Basically, i followed this installation tutorial: https://help.talend.com/reader/gQMygegdhKbdenCL3LTGSg/zOczPWm3KuUqQw78e5doMw

Thanks anyway!