topic Re: Excel File Corrupted after uploading to Sharepoint using tFileFetch in Talend Studio

Excel File Corrupted after uploading to Sharepoint using tFileFetch

bpchang — Fri, 15 Nov 2024 23:48:08 GMT

Hello all,

I have been trying to find a solution to upload password protected Excel file to Sharepoint.

I tried using tFilefetch to upload the excel file - it is successful but it was corrupted when i tried opening in Sharepoint. The output excel file (from the pipelines) was not corrupted as I can open them in my local.

The error message I got is as attached.

I tried opening the corrupted file in notepad format and found out that the response from the HTTP is included in my excel file (as attached). After searching online, I suspected that this might be the issue.

Does anyone knows how can I not have the lines included in excel? I tried it with txt file, csv file, I am able to open them but the dirty lines are still there.

Does anyone knows how can I upload file to Sharepoint using Talend?

Thanks

Re: Excel File Corrupted after uploading to Sharepoint using tFileFetch

bpchang — Wed, 01 Sep 2021 09:08:56 GMT

Found the answer is to use tHttpRequest and attach the file as the POST PARAMETER FROM FILE.

Works fine now!

Re: Excel File Corrupted after uploading to Sharepoint using tFileFetch

MStegmaier — Mon, 22 Nov 2021 15:20:31 GMT

If proxy needs to be set then tSetProxy can be used together with tHttpRequest . It is strange that there is not proxy settings in tHttpRequest component.

Re: Excel File Corrupted after uploading to Sharepoint using tFileFetch

bpchang — Tue, 23 Nov 2021 09:58:55 GMT

Thanks a lot! I do not have to do that fortunately. 🙂