Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to be missing something and it is probably a very simple question.
I have a spreadsheet stored in sharepoint. I want my script to load data from that sheet. What is the syntax to get the sheet? Do I have to write a macro to download the file locally then consume the data from there?
Thanks
Chris
Hi,
Using UNC paths fails for exampel in 64 bit Windows Server 2003 (and possibly other 64 bit clients)
Why don't you download the fiel from SharePoint ( wich is a glorified WebDAV ) using the open-source cURL client ? Mind the %% escape needed in batch files
rem download
curl --ntlm -u "DOMAIN\USER:PASSWORD" --url "https://workspaces.company.com/site/Shared%%20Documents/file.txt" -o file.txt
-Alex
This is correct, the site must be added as a trusted site while logged in with the account that runs the jobs. This was our sticking point.
If it helps anyone, I was able to read the excel file with qlikview using the http address:
Use the web file option
http://servername/sites/thefolder/thesheet.xlsx
Regards,
Erich
Hi All
The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.
Created the new thread for the same below.
http://community.qlik.com/message/249859#249859
Thanks,
qlikview forum
Hi chriscammers,
I am not able to find "open in Windows explorer" in actions. But I have managed to get the path after exporting to spread sheet. So could you please let me know what is the next step once I get the path?
Thanks,
Qlikview Forum
Hi chriscammers,
I have checked in my server but WebClient is not been installed in the server. May I know what is the next step once the WebClient has been installed? So that I can do the same once the WebClient has been installed.
Thanks,
Qlikview Forum
Hi Chris
We are waiting for your reply. Please help!
Thanks,
qlikviewforum
All,
Where i can get web client service installation.
Regards,
Karthi