on 11-04-2015 5:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.