Importing Excel file in metadata not working

FernandaG10 — Sun, 26 Jul 2020 20:02:05 GMT

Hello,

I would like to import an Excel file in Metadata.

It works until I reach third step with preview. At this moment, preview does not work.

It tells me encoding is UTF-8.

Here's the error message:

Error Message: The import routines cannot be resolved

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)

I have Talend Open Studio for Data Integration version 7.2.1.

JAVA_HOME system variable is configured as:

C:\Program Files\Java\jre1.8.0_261

and PATH is configured as:

C:\Program Files\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;%SYSTEMROOT%\System32\OpenSSH\;%JAVA_HOME%\bin

Thanks for any ideas!

Re: Importing Excel file in metadata not working

David_Beaty — Mon, 27 Jul 2020 11:06:53 GMT

Hi,

Are you sure that file extension is set correctly? So if its an XLS or XLSX its set accordingly?

Thanks

David

Re: Importing Excel file in metadata not working

FernandaG10 — Thu, 30 Jul 2020 13:49:35 GMT

Hello! Yes, I just installed the version 7.3.1 and the problem is no longer happening. Thank you!

topic Re: Importing Excel file in metadata not working in Talend Studio

Importing Excel file in metadata not working

Re: Importing Excel file in metadata not working

Re: Importing Excel file in metadata not working