topic how i can load data from windows network shared folder in qlikview in QlikView

how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 11:47:31 GMT

Hi Guys,

i had my data in network shared folder in that folder all my data in 6 different excel files.

so how should i connect to particular network shared folder path.

(in my local machine thru table files am able to connect & reload . but same thing in QA its failing. in QA its not picking the data from particular folder, so not refreshing the data)

please help me

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 12:25:37 GMT

It sounds like the User running the service on QA maybe have no access to this shared folder.

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 12:52:16 GMT

Are you having issues with the syntax in the load script? If so, you would use a UNC path in the FROM statement (i.e. \\server\share\file). Also you may want to uncheck the "Relative Path" option.

Re: how i can load data from windows network shared folder in qlikview

sudeepkm — Thu, 24 Jul 2014 13:00:42 GMT

As advised You need to check if the QA Publisher service account ID has access to the Network drive.

It is better to use relative path instead of full path.

When you use relative path then you do not have to worry about the root.for example while using relative path your from clause will be like this:

From [..\DataSources\abc.xlsx]

you do not have to use the root name here and it will work as long as you have the application folder structure same across all environments.

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 13:09:25 GMT

1) i used same way which u mentioned below is my from stmnt:

FROM

[\\colo-lonfrcel01\HR-QlikviewData\Mapping - Location.xlsx]

2) i already unchecked relative path.

but not working.

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 13:13:08 GMT

Are you running QlikView from your desktop and trying to load files from the network share?

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 13:21:54 GMT

when am running from my desktop am able to load the data from network share folder properly.

in my desktop thru table files i have loaded manually for each time mentioning the network shared folder.

But same file in QA environment not reloading.

Re: how i can load data from windows network shared folder in qlikview

Thu, 24 Jul 2014 13:24:34 GMT

So I think as Daniel and Sudeep mentioned, its possible that the account that you are using in QA environment might not have the appropriate permissions to the share.