Loading data from sharepoint list work in local but couldn't make it work in the development server
Hi All
Scenario:1 (In my local machine: Sharepoint link can be accessed without passing the userid and password)
1. Click on actions in sharepoint site and export it to excel. Save the excel in the required location.
2. Go to Data tab of excel and do the following
Connections --> Properties --> check: Enable background refresh and Refresh data when opening the file
3. Save the file
After this I have created one macro which opens up the above excel as we have enabled the above properties in Data tab it will automatically fetch the latest data from the sharepoint link.
Scenario:2 (In server machine: Sharepoint link can only be accessed by passing the userid and password)
Here I am not able to do step:2(Mentioned). May be it is asking for the userid and password to access the sharepoint link. I think the problem here might be because of the security.
So any idea what could be the possible reasons for been able to achieve the same in scenario:2. Also would like to know what need to be done for the scenario:2 so that it can achieved same like scenario:1.
Hope someone can helpme out on this!
Have already refered this in the following post but unable to find the solution yet 😞
I tried to achieve the same like below. I tried to find out for owssvr.dll but couldn't find the same. But I have changed the link to something like below but unable to achieve it.But it throws the message as "Object not found".
An easier way is to use RPC-calls using owssvr.dll, like:
listGUID and viewGUID must be in the format {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.
The listGUID can easily be found by navigating to the list in Sharepoint and go to List Settings. The listGUID will then show up in the address-field in your browser.
If viewGUID is omitted, the default view will be retrieved. To find the viewGUID locate the list in Sharepoint and activate the view needed. Select View Soure in IE to see the source code. Search for view={ to locate the viewGUID.
The response will be in XML, so when reading into QlikView make sure you select XML Files and Internet File. Add the correct crafted URL as described above. The data retrieved can be found in the node xml/data/row.
Example URLs to be used in QlikView:
The thing is that the SharePoint database is stored in a file, on the sharepoint server. You need to be able to get to that server, and then that DB file. If you are getting denied access, the only thing to do is to contact IT as ask for access. If they won't do it, then you have to contact a business leader and have them get it for you. There isn't a lot we can really do if you are being denied access.
Let me know...
I am not sure where the Sharepoint server lies. So obviously never tried to connect to it. All these days I have trying to fetch the data from an aspx page assuming this is the sharepoint site. Please guide me on if I have get to know about the sharepoint server how should I able to connect to it.
I need to acheive this task but I feel I am no away near to it as I am not sure about the approach. Tried to google it as well but it seems nobody has achieved it before :-(.
I see what you are trying to do, and I have seen that work for sites where there is data displayed on that page, but not from a Sharepoint site. Let me see what I can find out. As far as I can tell though, you will need to get authorizations into the Sharpoint server, either through the QV service account you will use to run QVS or through your own login.
