Sharepoint excel File.

[Former Member]

Hi ,

I have a excel file in SharePoint , Kindly help me to extract this file using SAP BODS. Please provide the necessary steps needed to extract the file.

If we need to write a script please provide the exact steps which needs to be executed.

Note : Please don't give your answers on Fly. Provide the exact solution.

Regards

Teja

[Former Member]

Hi Experts,

I have the same requirement. Need to extract CSV file from SharePoint and store into HANA Studio Table. Could you please help me out this with solutions.

Thanks in Advance!!

Puneet

[former_member198401]

Puneet, refer to

The CSV file generated by the script(mentioned in above thread) would act as a Source for BODS job and then you can load the contents in SAP HANA table

Regards

Arun Sasi

[Former Member]

Hi ,

I have only SAP Data Services, Kindly help me to extract SharePoint excel file through BODS. Your Inputs are highly appreciated.

Regards

Teja T

[former_member198401]

Hi

You need to automate the task of extracting the data from Sharepoint site to Excel or CSV.

This can be done by VB script or through macro.

The excel file should be available for BODS to be used as a source.

Regards

Arun Sasi

[former_member198401]

Hi Teja,

Do  you have only Data Services or SAP BW installed? If you have SAP BW then you can follow below link.

Regards

Arun Sasi

[former_member580328]

arun.sasi :

Am trying to write script to download file from SharePoint to local bods server folder using below script but unable to do it. Could you please let me what should be the correct format to do it.

exec('cmd.exe','copy "\\\xxx.sharepoint.com@SSL\sites\......" "network folder path")

[former_member598107]

Hi Mahendran,

First of all check if the copy command is working from windows prompt. Also make sure that the Job server is having access to the sharedpoint folder and the network folder which it is trying to access.

Now try printing the exec() command inside print() and see what error does it gives?

Or Just call a windows batch file which will contain the above copy command

exec('cmd', 'C:\Foldername\copy_script.exe', 8);

Refer to Data services reference guide Section 6.3.41 exec

Regards

Arun Sasi