Issue in import file Excel

[_AnonymousUser]

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?

[_AnonymousUser]

Looks like your issue is with the excel sheet itself. You can do this, open the excel sheet navigate to formulas-> click on name manager-> in that you can see the refers to field, which you can remove the values in that field and save it or else you can delete that formula if you dont use it. After that Talend works fine, can preview data and as well as able to load/read the excel by creating metadata. hope this helps

[Anonymous]

Many thanks! your solution works well...but...it's a workaround.
If you need to schedule the process, how can you remove the references? 
You before might edit the excel file and then execute the Talend job...right?
I don't understand because the same file works well using TOS DI 5.1 

[_AnonymousUser]

ya, thats the only option you have for now. 

[Anonymous]

or..I come back to TOS DI 5.1 

[Rosanero4Ever]

Does anybody of Talend team suggest any other workarounds or solutions? I can't go back TOS DI 5.1 as wroted above. 
 

[Rosanero4Ever]

up....

[Anonymous]

Hi Rosanero4Ever,
We have made a testing on studio 6.0 with your Cartel4.xls file and got the same error.
Could you please create a jira issue of DI project on Talend Bug Tracker so that our developer will check it to see if it is a bug?
In addition, can you import another exce file in metadata successfully on studio 6.0?
Best regards
Sabrina

[Rosanero4Ever]

Hi Sabrina,
I import successfully other excel files.
As described above, the issue is due to references which are in "name manager" in Excel formulas menu. If there aren't references the excel file is imported successfully.
I created the jira issue at https://jira.talendforge.org/browse/TDI-33863
I hope Talend team will solve this issue as soon as possibile (i have to import  many excel files with references !!!)
In the meantime I'll also install  TOS DI 5.1 to import excel file with references
Many thanks for your precious support.

[Anonymous]

Hi Rosanero4Ever,
Thanks for your feedback. We will keep you posted on this issue.
Best regards
Sabrina

[_AnonymousUser]

I'm having the same issue.  My file was a very simple two column 10 row file.  I copied the data and moved it to a new sheet, deleted the original sheet and it finally worked.  But that shouldn't happen.  Please advise of bug fix.