topic Re: How to read a .ods file with talend in Talend Studio

How to read a .ods file with talend

Anonymous — Mon, 20 Jan 2014 10:03:42 GMT

Hello !
I would like to work with an .ods file in Talend (Open Document Spreadsheet).
I try to use tFileInputExcel composant to read it, but I have an error which says "Unable to recognize OLE stream".
I also try with tFileInputDelimited but without success. Encoding does not seem to be good and talend returns me unreadable symbols.
Do you have a solution for reading ODS files ?

Thanks !!

Re: How to read a .ods file with talend

Anonymous — Mon, 20 Jan 2014 10:41:50 GMT

Hi,
Could you please vote for the related feature jira issue https://jira.talendforge.org/browse/TDI-26288, thanks for your contribution in talend.
Best regards
Sabrina

Re: How to read a .ods file with talend

Anonymous — Mon, 20 Jan 2014 10:59:24 GMT

Done, thanks !
if someone has a workaround I'm always interested

Re: How to read a .ods file with talend

Anonymous — Mon, 20 Jan 2014 14:58:51 GMT

Hi, please check Apache Tika, using it from tJava may help you.
As a side note it can be interesting to review the possibility of having an optional/separately downloadable Apache Tika Talend component which would process most of the well-known file formats out of the box
Sergey

Re: How to read a .ods file with talend

AciD1 — Thu, 24 Feb 2022 00:58:19 GMT

The question about being able to read .ods files is _still_ open in 2022.

Even more so that the ods format is ubiquitous in the administration, and even Microsoft is supporting it in its Office suite.

It's baffling that in 2019, after 2 years without any messages nor apparent activity, the https://jira.talendforge.org/browse/TDI-26288 issue as been rejected, without any explanation.

Since you cannot get an account for the Talend Jira, you cannot do much, except adding a rant here.

Please consider adding a tFileOpenDocument component, specially since the format is open and standard.

Not doing so would be foolish.