topic Re: Uploading files from Sharepoint with wildcard in QlikView

Loading files from Sharepoint with wildcard

Anonymous — Thu, 12 Oct 2017 07:23:07 GMT

Hello,

While loading files from Sharepoint, it works fine if I specify the file, but if I put a wildcard, I get an error of "Bad Zip File".

Here's an example:

The commented FROM, works fine.

But if I try with the not commented FROM, I got the error.

So anyone know why is this happening, and how could I do to upload all the files from a folder, instead of specify every file?

According to a post I've found, I tried changing the path to: '\\theshare.Xcompany.com\Week 3\*.xlsm', but it didn't work.

Thank you very much in advance for your help.

EDIT: Title corrected.

Re: Uploading files from Sharepoint with wildcard

petter — Thu, 12 Oct 2017 20:37:46 GMT

You're actually downloading and not uploading by using the LOAD ... FROM with a web-URL.... to be correct.

Wildcards are only supported in the FROM part if you are accessing a drive location and not when you are using the webfile feature (a URL).

So the way to go about it is that you can retrieve a SharePoint list of the files stored in the folder first and then you will have to create a loop in your load script to retrieve each of the files.

Re: Uploading files from Sharepoint with wildcard

Anonymous — Fri, 13 Oct 2017 07:32:16 GMT

Hi Petter. Thank you very much for your answer and correction.

So regarding the list of the stored files, I had tried to do that as doing:

LOAD

FileName()

FROM [...Path].

But obviously it didn't work because I had to use a wildcard in order to get all the filenames.

So now the question is, how could I do to retrieve a SharePoint list of the files stored?

Thank you very much

Re: Uploading files from Sharepoint with wildcard

petter — Fri, 13 Oct 2017 15:22:43 GMT

Microsoft SharePoint API's have changed and evolved over time. Which SharePoint version are you interfacing with?

Re: Uploading files from Sharepoint with wildcard

Anonymous — Mon, 16 Oct 2017 07:05:39 GMT

I'm working with the SharePoint 2010.

Re: Loading files from Sharepoint with wildcard

avinashelite — Mon, 16 Oct 2017 10:30:47 GMT

I don't thing the share point will support the wild card for file name...you need to use the loop method

Re: Loading files from Sharepoint with wildcard

Anonymous — Mon, 16 Oct 2017 10:56:55 GMT

Great. But how can I do to obtain the names of all the files of the folder?

Re: Loading files from Sharepoint with wildcard

avinashelite — Wed, 18 Oct 2017 10:13:15 GMT

In the script , go for web files and use URL where the excels are stored ..select the html mode > to the right you will see the tables in the format @1 , @2 go through each you will get the list of list here and then based on this go for the loop and reduce

Hope this helps you

Re: Loading files from Sharepoint with wildcard

Anonymous — Wed, 18 Oct 2017 10:31:53 GMT

Hey,

Thank you for your answer.

I tried this, but it appears to me this message:

Anyway, I also tried to replace the fields for @1, @2... like this:

Table:

LOAD

@1,

FROM [https://theshare.Xcompany.com/sites/*] (ooxml, embedded labels, header is 8 lines, table is [OA-Quality])

And it didn't work.

I also tried with:

Table:

LOAD

FROM [https://theshare.Xcompany.com/sites/*] (ooxml, embedded labels, header is 8 lines, table is [OA-Quality])

And also it doesn't work.

Thank you anyway for your answer.. and any other possible solution is welcome.

Re: Loading files from Sharepoint with wildcard

meashok07 — Thu, 18 Apr 2019 05:11:46 GMT

Hi Mateil,

did you get an answer to this issue, i also had similar requirement , can you help?