Create Excel file metadata

Five Stars

Create Excel file metadata

 

Dear all,

 

I Have some problem when i try to create excel metadata,

i stuck in step 3 of 4 and get error code like this :

 

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend.csv.CSVWriter cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.DateUtil cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
org.apache.poi.ss.usermodel.DateUtil cannot be resolved to a type
org.apache cannot be resolved to a type
org.apache.poi.ss.usermodel.Cell cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type

at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.tFileInputExcelProcess(ShadowFileInputToDelimitedOutput.java:653)
at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.runJobInTOS(ShadowFileInputToDelimitedOutput.java:1320)
at office_project.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1193)

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)

 

this error code appear in output when i want to preview the excel data.

i'm using :

 

java version  1.8.0_161

talend 6.4

 

Please tell me any solution for this issue

thank you

Moderator

Re: Create Excel file metadata

Hello,

Could you please clarify on which build version you got this issue? Talend 6.4.0 or 6.4.1?

Please make sure that your installation is not corrupted or incomplete.

Have you tried to re-install your studio completely to see if it works well? Feel free to post your issue on forum.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Create Excel file metadata

Hello xdshi,

 

Thanks for the answer

i'm using talend open studio 6.4.1.20xx

prefer need solution without re-install,cz I just extract talend from zip file, but i will do it, if no more solution.

thank you

 

Moderator

Re: Create Excel file metadata

Hello,

We cannot repro this issue on V 6.4.1 from our side.

Does this issue repro on a specific excel file? Have you tried to use another excel file to see if it work well?

1.png

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog