Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😞
http://community.qlik.com/message/255028#255028
http://community.qlik.com/message/254657#254657
http://community.qlik.com/message/254552#254552
http://community.qlik.com/message/253928#253928
http://community.qlik.com/message/253970#253970
http://community.qlik.com/message/253964#253964
http://community.qlik.com/message/253963#253963
http://community.qlik.com/message/253962#253962
http://community.qlik.com/message/253960#253960
http://community.qlik.com/message/253958#253958
http://community.qlik.com/message/253956#253956
http://community.qlik.com/message/253955#253955
http://community.qlik.com/message/253952#253952
http://community.qlik.com/message/253951#253951
http://community.qlik.com/message/252820#252820
http://community.qlik.com/message/253949#253949
http://community.qlik.com/message/253947#253947
http://community.qlik.com/message/253946#253946
http://community.qlik.com/message/253929#253929
http://community.qlik.com/message/253927#253927
http://community.qlik.com/message/253926#253926
http://community.qlik.com/message/252325#252325
http://community.qlik.com/message/252145#252145
http://community.qlik.com/message/252143#252143
http://community.qlik.com/message/252142#252142
http://community.qlik.com/message/251924#251924
http://community.qlik.com/message/251875#251875
http://community.qlik.com/message/251862#251862
http://community.qlik.com/message/251817#251817
http://community.qlik.com/message/249903#249903
http://community.qlik.com/message/249902#249902
http://community.qlik.com/message/249900#249900
http://community.qlik.com/message/249899#249899
http://community.qlik.com/message/249896#249896
Thanks
qvforum
Does the SErvice account running QVS has access and rights to the Sharepoint site? That would be where I would start looking...
have you looked at the log files to see if the account is getting denied access?
Does the SErvice account running QVS has access and rights to the Sharepoint site? That would be where I would start looking...
Sorry I don't know how to find whether it is having access and rights to the sharepoint site. Could you please help me out on how to find the same!
have you looked at the log files to see if the account is getting denied access?
It is not showing any message as I am refreshing through excel and not through QV. I am just opening the excel using macro, once the excel gets opened as I have enabled the background refresh excel should fetches data from sharepoint site. But that is not happening here!
OK, I see now. You are trying to refresh Excel to Sharepoint. If you can, create an RDP connection to the Sharepoint server and go through the Event logs, and Application Logs. See if there are any messages where Sharepoint is denying access to an incoming request. IF you can't do this, call your help desk and describe what you are seeing and see if an admin can go through the log files for you and find out if there is an issue.
The other thing you may need to do is pass your credentials through Excel. If you go back to the window where you set your data refresh, there is the Definitions tab. In that tab there is a spot for a connection string, and checkbox to "Save Password". I'm guessing that you need to configure that to pass your credentials. Once you do that, it may solve your issues.
Try this and let me know.
I think we don't have rights to connect to Sharepoint server to go through Event logs. Also we cannot ask the helpdesk(of our client) to go through the same.
I have tried replicate the same as per your instructions but the "Save Password" option is disabled. Any idea what could be done now?
Thanks your all your help. so nicely you have guided me... I am sure that you can help me out to resolve this issue. If not I need to go back to the client on what exactly it is stopping us from refreshing the excel.
I also want to let you know that when I am trying to replicate the samething which I am doing in the development machine. It is throwing following error could you please guide further!
Well, I think the above message hits the nail on the head. We'll need to enable the data connection. This is likely one of the reasons you can't get data. Looks like this connection method is turned off, as a security measure. I thihk that you can trust the Sharepoint server, so enabling this shouldn't be an issue. However, you need to make sure that all parties are aware of what you doing.
Enable the connection and let's see what happens...
If I remember correctly I think I was able to enable the connections few months ago but at that time I was not able to refresh the excel. Anyway let me forget the past now.
Currently as I couldn't enable to connection. May I know how can I do the same please? Any help is appreciated!
Just a thought:
Instead of using excel to fetch the data from sharepoint. Can we try to load the data directly into QlikView? As I don't think client can enable the data connections due to security reasons. I thought it could be better if we can load the data directly into qlikview. Please let me whether is this possible! If so I kindly request you to guide me on the same in your convenient time.
Here is what I know so far. I have never pulled data from sharepoint, but it is a database. Start with this thread and see what you can accomplish. I think the main point is that the Sharepoint data is stored in a file, of some sort. we need to know what the file type is.
http://community.qlik.com/message/110134#110134
Let me know what the results are.
Hi Nate
I have already read this post and followed the instructions but couldn't achieve the task. Any other thoughts please?
Thanks
qvforum
How are you not achieving, are you getting an error or an access denied message? 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...