automatic retrieval of data from a remote sharepoint site

[#1]

Is this possible at all from the QV script? Thanks.

[fosuzuki]

Maybe. Can you be more specific?

I did create some QVWs retrieving data from Excel files stored in a Sharepoint site. Is this what you need?

Regards

[#3]

Thanks for your reply,

I have to open an accdb file stored on a sharepoint site of our client. I have URL address to the file and via IE can access it with password. Then I can either open or save it on my machine. I don't want to do this manually but want to connect from my QV script to the file to load the data in QV on my computer (later I will put the application on our server to automatically retrieve the data).

I use OLEDB with URL path name in the menu and when I tested the connection it gave me an error message:

"Test connection failed because of an error in initializing provider. Not a valid file name."

I would appreciate your help.

[#4]

My friend found found this discussion on http://community.qlik.com/message/52867#52867:

"you need the UNC path for qlikview to open it

from your sharepoint in the actions menu click "open in windows explorer"

now from the Windows Explorer screen right click the file you want and select properties the location is the unc path.

When you are building your qvw you will want a table file and then enter the unc path as the path for the sheet, don't forget to add the file name if you copy the path from the properties dialog."

I will ask our client about the UNC path, hope this will work.

[fosuzuki]

Hi,

I created a sample Accdb with password protection and uploaded it to a Sharepoint folder, and my sample QVW loaded the data with no problems. It really seems like you need to check the file path.

For example, here in my client’s Sharepoint, the file path was something like:
server\DavWWWRoot\escritoriocentral\Cargas QlikView\Folder\ <file:///
server\DavWWWRoot\escritoriocentral\Cargas%20QlikView\Folder\>

Hope this helps you.

Regards,

Fernando Suzuki

QlikView | Nórdica Distribuidora de Software

Tel: (55) (11) 5505-4866

De: borislav

Enviada em: quinta-feira, 17 de novembro de 2011 06:40

Para: Fernando Suzuki

Assunto: - Re: automatic retrieval of data from a remote sharepoint site

<http://community.qlik.com/index.jspa> QlikCommunity

Re: automatic retrieval of data from a remote sharepoint site

created by borislav <http://community.qlik.com/people/borislav> in Development (QlikView Desktop) - View the full discussion <http://community.qlik.com/message/165908#165908

[#6]

Thanks, Fernando, for your detailed answer. I had to wait for a while to get the UNC path and now I also have full access rights to the server and still can't do the connection.

On the forum (http://community.qlik.com/message/52867#52867:

) people say that "you also have to install the webclient service on your server or the server will not be able to reload the document. In windows server 2008 this service is not installed by default. You have to add the User experience feature to the OS since it is not installed by default."

I don't understand which webclient service is this. Do you know? Also how can I add this User experience feature?

Thanks again for your time.

B.I.

[fosuzuki]

Hi borislav,

to install the User Experience feature:

Windows Server 2008's Server Manager > Features > Add Features > Desktop Experience. After this, go to Services > WebClient > set as automatic startup type.

Hope this helps you.

Regards,

Fernando

[#8]

Thank you so much. Definitely there is a change, and the program tries to connect longer this time. Maybe it actually reaches the database, but again doesn't connect to it and gives me the message:

Test connection failed because of an error in initializing provider. The Microsoft Access database engine cannot open or write to the file <UNCpath\file name> . It is already opened exclusively by another user, or you need permission to view and write its data.

Since I have the permission, I suppose there is some setting that doesn't allow multiple users to use/view the database at the same time. Do you know how to organize the access, or what settings on their server to change, so that my QVW application can load these data automatically every several hours.

[fosuzuki]

Hi,

I have a feeling that the problem is with the user permissions in the Sharepoint folder. Can u check if your user has permissions to create/modify a file to the folder? Because when you connect to Access, it creates/updates a .laccdb file.

Regards,

Fernando

[#10]

Hi

and thanks again for the useful information.  Many users of this site had similar problem even when accessing the file from applications other than qlikview. The people running the site want to change it, maybe they'll move the file to other place.

Thank you for your help. I appreciate it really

with best regards,

BI