topic Re: App Preload Qliksense in Integration, Extension & APIs

App Preload Qliksense

Gowtham174 — Thu, 21 Mar 2019 11:24:51 GMT

Hi All,

Based on the below link understood by using .net sdk we can store cache after preload the app before first user login.

https://help.qlik.com/en-US/sense-developer/February2019/Subsystems/NetSDKAPI/Content/Sense_NetSDKAPI/CodeExamples/App-Preload.htm

Do we need any services to connect this to different platform, if yes then please suggest.

Is there any solution to trigger the .net sdk in qliksense.

Thanks,

Gowtham

Re: App Preload Qliksense

Gowtham174 — Fri, 22 Mar 2019 04:32:14 GMT

I'm new to .Net sdk and how to implement this to qliksense server. can you please help me to implement by steps or any guide.

Re: App Preload Qliksense

Levi_Turner — Fri, 29 Mar 2019 11:15:45 GMT

That ought to work, although I haven't done it.

In the past when I need a slim basic tool to do warming, I've used https://github.com/JoeBickley/CacheInitializer. Attached is a compiled version using the Qlik Sense November 2018 SDK. As for usage, it's pretty straight-forward. An example way of doing it would be.

C:\Temp\TelemetrySaturate\cacheinitiazer>CacheInitializer.exe --help
ConsoleApplication1 1.0.0.0
Copyright c 2015
-s, --server Required. URL to the server.
-a, --appname App to load (using app name)
-i, --appid App to load (using app ID)
-p, --proxy Virtual Proxy to use
-o, --objects (Default: False) cycle through all sheets and objects
-f, --field field to make selections in e.g Region
-v, --values values to select e.g "France","Germany","Spain"
--help Display this help screen.

C:\Temp\TelemetrySaturate\cacheinitiazer>CacheInitializer.exe -s https://servername -i $($app.id) -o

Re: App Preload Qliksense

Øystein_Kolsrud — Fri, 29 Mar 2019 12:24:49 GMT

I don't know if you saw it, but the source code for that cache warmer referred to in the developer help can be found here:

https://github.com/AptkQlik/PublicExamples/blob/master/AppPreload/AppPreload.cs

That file also contains a description of the principle behind the cache warming at the top of the file. That example uses direct connection to a desktop version though, and I assume you want to connect to a server instead. You will find examples for doing different types of connections here:

https://github.com/AptkQlik/PublicExamples

Re: App Preload Qliksense

sergio_loza — Wed, 12 Jun 2019 19:52:38 GMT

Levi this is awesome, thanks for compiling it for us!

I can see this being triggered with the external Program Task QRS API . What would be great is if we could chain the end of the app reload task to a an external program Task

Re: App Preload Qliksense

witty — Fri, 11 Oct 2019 22:09:59 GMT

Hi @user which QRS endpoint is doing this preloading? - i was only able to see reload and not preload - sadly in the file it looks like a "manual" browse of all selections possible and no reference on how to trigger this via the API https://github.com/AptkQlik/PublicExamples/blob/master/AppPreload/AppPreload.cs

Any Hints?

Re: App Preload Qliksense

Levi_Turner — Mon, 14 Oct 2019 19:42:54 GMT

@witty : This is done via the Engine API, not the Repository API.

Re: App Preload Qliksense

witty — Wed, 16 Oct 2019 08:49:38 GMT

@Levi_Turner is there a reason we cannot trigger this in an easy way by just calling an endpoint after we updated an app? Like why can i trigger a reload/publish via QRS/QPS but not a preload to index and improve speed? So lets say i have to write a new script to do this action - is there a utility class/function I can call in this API by just providing an app id?

https://help.qlik.com/en-US/sense-developer/June2019/APIs/EngineAPI/index.html

Additionally can you comment on these "Caches" if I use section access in the app - do i need to do one cache process per section access combination or is the cache valid for any section access "view" if I ran it as a user that as "*" or "admin" access to the app?

Re: App Preload Qliksense

Mccutchan1 — Thu, 16 Jan 2020 14:51:37 GMT

Hi Levi,

When using CacheInitializer how do I cycle through all the sheets and cache them? I notice -o defaults to false how do I set it to true?

Thanks

McCutchan

Re: App Preload Qliksense

Levi_Turner — Thu, 16 Jan 2020 14:59:52 GMT

Like this:

D:\Tools\CacheInitializer-master\CacheInitializer\bin\Debug>CacheInitializer.exe -s https://sense.company.com -a "Operations Monitor" -o 09:56:53 - Operations Monitor: Opening app 09:56:56 - Operations Monitor: App open 09:56:56 - Operations Monitor: Clearing Selections 09:56:56 - Operations Monitor: Getting sheets 09:56:56 - Operations Monitor: Number of sheets - 17, getting children 09:56:56 - Operations Monitor: Number of objects - 143, caching all objects 09:56:57 - Operations Monitor: Objects cached 09:56:57 - Operations Monitor: App cache completed 09:56:57 - Cache initialization complete. Total time: 00:00:07.1136044

Re: App Preload Qliksense

tauceef — Fri, 20 Mar 2020 10:36:47 GMT

Hi Levi,

Its working really good for us. Only thing is running cache warmer takes lot of time as my application is bit complex. Is it possible to load only the required objects (using object Id's) instead of loading all objects? as other objects we are using are for on-demand report generation (using Nprinting) which I don't want to cache.

Also I found one issue in the filter values: when we pass value with a space it only takes the first word of the value (before space). How to pass values with space to the application?

Looking forward for your response.

Regards,

Tauceef

Re: App Preload Qliksense

Levi_Turner — Fri, 20 Mar 2020 11:35:11 GMT

> Is it possible to load only the required objects (using object Id's) instead of loading all objects?

I am not aware of a tool which would accomplish this which has already been built. Certainly it could be built, but there's nothing pre-built for this purpose.

> Also I found one issue in the filter values: when we pass value with a space it only takes the first word of the value (before space). How to pass values with space to the application?

I have used this approach before:

CacheInitializer.exe --server https://qliksense.company.com --proxy windows --appname "Operations Monitor" --objects --field "App Name" --values "Operations Monitor","License Monitor"

So I am passing the values of "Operations Monitor" and "License Monitor" into the field named "App Name" as I open every object.

Re: App Preload Qliksense

maks2481 — Thu, 08 Oct 2020 06:40:46 GMT

Hello everyone!
Please tell me why this error may occur?

If you use the full names
--server etc..
the error is the same.
Run on behalf of the user who is assigned a license.

All thanks.

Re: App Preload Qliksense

Levi_Turner — Thu, 08 Oct 2020 18:35:10 GMT

Please open an issue on the GitHub page for the project: https://github.com/eapowertools/CacheInitializer/issues

Re: App Preload Qliksense

maks2481 — Fri, 09 Oct 2020 13:30:05 GMT

Thanks for the answer. Unfortunately, this didn't help. I created a new Windows user.

I gave him a license. Started cmd from this user.

The result is the same ((

P.S :Topic on github created.