topic Re: [resolved] FTPGet - Problem with Excel File in Talend Studio

[resolved] FTPGet - Problem with Excel File

Anonymous — Fri, 28 Aug 2015 16:21:19 GMT

Hi,
i have a Excel File on my FTP Server, if i download the file with FileZilla all is ok , i can open the file wthout problems.
If i download the file in Talen with tFTPGet the the file is download without error, but i cant open it with Excel or read with Talend.
Excel said File Format is corrupt.
Talend Error Message is:
xception in component tFileInputExcel_1
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: 'D:\EDI\Bestellungen\Input\test_pedido_2018_08_v1.xls'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:108)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:224)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
at org.apache.poi.POIXMLDocument.openPackage(POIXMLDocument.java:67)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:263)
I have testet with Tranfermode ascii and binary as well - same error.
Thanks for help
Dani

Re: [resolved] FTPGet - Problem with Excel File

Anonymous — Fri, 28 Aug 2015 22:19:43 GMT

HI,
Please provide sample file, so we can better analyze the problem

Re: [resolved] FTPGet - Problem with Excel File

Anonymous — Mon, 31 Aug 2015 04:46:29 GMT

Hi Dani,
Have you already figured out the issue? We see that this topic is marked as resolved.
Feel free to let us know if you still have any error in your job.

Best regards
Sabrina

Re: [resolved] FTPGet - Problem with Excel File

Anonymous — Tue, 06 Oct 2015 04:46:20 GMT

Hi,
I'm having the same issue. Can anyone please provide the solution?
tFTPGet component is transferring the file to the local location. But when I open the file, I get an error " File cannot be accessed. the file may be corrupted, located on a server that is not responding , or read-only."
I can access or transfer the same file through CORE FTP client tool with out any issues.
Regards
Sunil

Re: [resolved] FTPGet - Problem with Excel File

jasonatunr — Fri, 25 May 2018 23:27:01 GMT

I am having this same problem with sftp. Anyone solve this?

Re: [resolved] FTPGet - Problem with Excel File

Anonymous — Thu, 31 May 2018 13:10:24 GMT

Hello,

Do you have the admin role to read your file? Is it locked? Are you able to open it out side of talend studio?

Best regards

Sabrina