Upload excel file on Sharepoint and set the properties

[Former Member]

Hi All,

We have scenario, wherein data would be received from SAP system via proxy and we have to transform it in an excel sheet, and upload it on the SharePoint.

Post successful upload, it is also required to update the file properties (in Custom time) corresponding to each file.

Could anyone please provide your valuable inputs how could we achieve the SharePoint file upload and the properties set.

Thanks,

Ruchi

[anupam_chakraborty]

Hi Ruchira,

Please check my blog in .

This would help you in connecting Sharepoint to SAP PI.

Thanks,

Anupam

[Former Member]

Hi Ruchita,

What is the version of PI?

with PI 7.3 it is possible to upload the files using java HTTP adapter.

Please check this link.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/3b/280fa6a8ab4dd4a6755f8ed5b9fc9c/content.htm

Also to convert xml message to excel, you may do this in java mapping.

Regards,

Beena.

[Former Member]

Hi Beena,

Thanks for your quick response.The PI version I am working on is 7.1

Please suggest a way to implement this in 7.1 version.

Regards,
Ruchi

[Former Member]

Hi Ruchita,

You may try sharepoint webservices. Please check below link:

http://msdn.microsoft.com/en-us/library/dd878586(v=office.12).aspx

(copy or list service)

Also check this link to convert xml to excel:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/16/convert-incoming-xml-to-excel-or-...

Regards,

Beena.