topic Re: QMC Reload vs Qlikview Desktop Reload in QlikView

QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 07:06:31 GMT

Can someone help me with the functions which identities the reload between QMC and Qlikview Dektop?

the requirement is i have to use two different databases respectively for QMC and Qlikview Desktop reloads.

Thanks

Hari

Re: QMC Reload vs Qlikview Desktop Reload

micheledenardi — Mon, 04 Dec 2017 07:28:09 GMT

You can do something like this.

Suppose that your QMC reload start at 7am:

If hour(now(1))=7 then
    Connection to QMC Reload Database
else
    Connection to  QlikView Desktop Reload Database
End If

Re: QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 07:32:45 GMT

Thank you, but i need to identify the difference.

Re: QMC Reload vs Qlikview Desktop Reload

tresB — Mon, 04 Dec 2017 07:34:40 GMT

You can check the computer name using computername() and then decide on connection, like:

If Computername()='YourServerName' then
Connection to QMC Reload Database
else
Connection to QlikView Desktop Reload Database
End If

Re: QMC Reload vs Qlikview Desktop Reload

Peter_Cammaert — Mon, 04 Dec 2017 10:06:03 GMT

Another variation on the same theme:

On your server, create an include file (let's call it ServerSettings.qvs) that says something like:

SET vReloadEngine = QMC;

In your document script, do two things.

Add a default value for vReloadEngine by adding the following SET statement to your script front (for example at the end of the initial series of SET statements). Like
SET vReloadEngine = Desktop;
After that, add an optional include to load the server include file. If it doesn't exist, no worries. The reload engine won't complain and revert to the default value. Like
$(Include=.\ServerSettings.qvs)

As long as you maintain that file on your server, the script will be able to make out where it's running. Whatever the name of the machine...

Best,

Peter

Re: QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 10:09:35 GMT

Thank you nice idea, but there are lots of servers, i cant maintain a file, i am looking for function to find the engine and load

Re: QMC Reload vs Qlikview Desktop Reload

Peter_Cammaert — Mon, 04 Dec 2017 10:34:04 GMT

That may be what you want, but that will be difficult to get.

You see, the engine that is reponsible for reloads on your server is actually a QV Desktop without user interface called QVB.exe (QlikView Batch) that still thinks its name is QV.exe.

AFAIK if you want to figure out where the reload is taking place, you may have to rely on the environment telling you. Not the engine itself.

Re: QMC Reload vs Qlikview Desktop Reload

marcus_sommer — Mon, 04 Dec 2017 12:37:34 GMT

I use for similar tasks (triggering OnOpen excel-macros which must know who is executing them) external parameter either created by small store-statements or per vbs-writing in a text-file which will be evaluated from the depending routines. After finishing the excel-macro reset this parameter to its default-value.

I think you could adapt this approach to your task whereby purely inside of Qlik I would go with the suggestions from Peter or Tresesco maybe by extending the computername() logic to a mapping (if there are really multiple server) maybe something like this:

Map:

mapping load * inline [

ComputerName, Database

Server1, DB1

Server2, DB2

...

Desktop, DBx

];

DataBase: load applymap('Map', computername(), '#NV') as DataBase autogenerate 1;

let vDatabase = fieldvalue('Database', 1);

...

- Marcus

Re: QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 12:46:23 GMT

Thank you, but i am looking for solution where unknown users and unknown servers are there, we cannot really keep track of everything, anywhere, anytime the script should identify the engine and load the respective db for desktop or server.

Re: QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 12:49:30 GMT

Currently i am using the below script to identify the servers and desktop using registry string, but if QMC is running on desktop client, it will fail.. i need something which more robust.

LET vOS = GetRegistryString('HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion', 'ProductName');

Thanks

Hari.

Re: QMC Reload vs Qlikview Desktop Reload

marcus_sommer — Mon, 04 Dec 2017 13:22:09 GMT

It's not really clear what do you want to do ..."solution where unknown users and unknown servers" .... and why? Are there really so many users/servers that they couldn't be maintained manually or read from somewhere?

- Marcus

Re: QMC Reload vs Qlikview Desktop Reload

Anonymous — Mon, 04 Dec 2017 13:26:40 GMT

yes, there are thousands of them. it's clear, that i need some function which identifies QMC engine and Desktop Engine with out any dependencies. so that desktop reload always fetch data from no production db, and QMC always fetches data from production db.

Re: QMC Reload vs Qlikview Desktop Reload

marcus_sommer — Mon, 04 Dec 2017 13:46:52 GMT

Really thousands of users which should reload data from a database within the desktop client? Beside engine and OS how do you want to control which user could pull and see which data?

If there is only to differ if qmc respectively production db or not the suggestion from Peter would fit perfectly - you could also embed this logic within an error-handling with ERRORMODE and MUST_INCLUDE or extending it on this to some further checks.

Beside them there are probably some further (security) measures on the database- or network-side possible how is allowed to access and who not.

- Marcus

Re: QMC Reload vs Qlikview Desktop Reload

atoz1158 — Mon, 04 Dec 2017 14:17:32 GMT

If the QMC has been set-up to use a Service User style account to do the reloads then you could use the following to get the user name and check if it is the service user and therefore a QMC reload any other user name name return would then be a desktop reload.

IF OSUser() = 'Service User Name'

use OMC settings

else

use desktop settings

end if