Five Stars

[resolved] FTPGet - Problem with Excel File

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
5 REPLIES
Four Stars

Re: [resolved] FTPGet - Problem with Excel File

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

Re: [resolved] FTPGet - Problem with Excel File

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] FTPGet - Problem with Excel File

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
Five Stars

Re: [resolved] FTPGet - Problem with Excel File

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

Moderator

Re: [resolved] FTPGet - Problem with Excel File

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

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