Excel File Corrupted after uploading to Sharepoint using tFileFetch

[bpchang]

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

[bpchang]

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

Works fine now!

[MStegmaier]

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.

[bpchang]

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