topic Re: Can I retrieve QMC QV Server Settings in a LOAD Script? in QlikView

Can I retrieve QMC QV Server Settings in a LOAD Script?

rob_insley — Wed, 23 Jul 2014 10:41:24 GMT

I would like to dynamicaly obtain information like Root folder and Looging folder from the QMC Settings so that I do not have to hard code Document Path and Server Information into my load script which will be rolled out on numerous servers. Is there a way to do this please?

Thanks,

Rob.

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

ashfaq_haseeb — Wed, 23 Jul 2014 10:48:46 GMT

Hi,

For qvd's you can try something like this

let Vpath = 'D:\qvd\';

Test:

LOAD * Inline

[

Field

];

Store Test into $(Vpath)Test.qvd(qvd);

But I don't think so that you can change Root folder(Document Folder) info from server.

Regards

ASHFAQ

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

rob_insley — Wed, 06 Aug 2014 10:44:01 GMT

Sorry for the slow response Ashfaq. And thanks for your reply. I am aware of the use of a variable but I would like really to obtain the information from the server so I never have to change this has I roll this out across Development / Test / Prod Servers.

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

ashfaq_haseeb — Wed, 06 Aug 2014 10:47:02 GMT

I don't think there is any such universal setting available in server.

There are many different ways but will be similar to the one suggested above.

Edit:

You can use relate path and use same folder structure.

Then you may not need to change anything except connecting strings to database even you can handle that in script.

Regards

ASHFAQ