Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rob_insley
Partner - Contributor III
Partner - Contributor III

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

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.

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

For qvd's you can try something like this

let Vpath = 'D:\qvd\';

Test:

LOAD * Inline

[

Field

a

b

c

d

e

];

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

rob_insley
Partner - Contributor III
Partner - Contributor III
Author

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.

ashfaq_haseeb
Champion III
Champion III

Hi

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