topic Re: Trigger without Qmc in Management & Governance

Trigger without Qmc

Chanty4u — Mon, 12 Sep 2016 08:36:35 GMT

Hi all,

Toni Kautto

I have one issue on Qliksense Server.

Issue: I have small Qvf file with 10 records. and i have added in Qmc for Trigger by hourly basis.

Now my user needs without going to Qmc user wants to refresh data by External event.

how it is possible can anyone explain?

Thanks

Chanty

Re: Trigger without Qmc

ToniKautto — Mon, 12 Sep 2016 08:50:44 GMT

Qlik Sense Developer help introduces you to any customization and extension of the product.

Home ‒ Qlik Sense Developer‌

External execution of reload requires that you call the Qlik Sense Engine API. Perhaps take a look at Reload an app ‒ Qlik Sense‌ for an introduction how this would be done.

Re: Trigger without Qmc

Chanty4u — Mon, 12 Sep 2016 08:58:57 GMT

Thanx tony.

But wihout API"s Is it possible?

For example : i have Html file with one button so that wen user cliks on button the Qmc data should be relod and get new data.

Could you please suggest on this?

Re: Trigger without Qmc

ToniKautto — Mon, 12 Sep 2016 09:22:51 GMT

Qlik Sense is basically based on APIs. The QMC and Hub also run on the same APIs as you can find in the Developer Help.

For the trigger to work form a HTML page, you have to apply API calls through your button press. Just in the same way as reload button in QMC or Hub trigger the Engine API to reload the app.

Re: Trigger without Qmc

eightieschild — Mon, 12 Sep 2016 15:49:40 GMT

Hi Chanty

Try this extension from the Qlik Branch site, which we've used to enable users to reload a published app manually:

http://branch.qlik.com/#!/project/56728f52d1e497241ae69836

It provides a button that you can add to your apps that reloads the data from one of the sheets, without the need to enter the Data Manager or access Tasks.

HTH

Chris

Re: Trigger without Qmc

Chanty4u — Mon, 12 Sep 2016 17:21:08 GMT

thanq chris happy to hear some better output from you.

but this can check by me Tomorrow only. if i get any issues while doing this i will come back to you.

Best

Chanty

Re: Trigger without Qmc

Chanty4u — Mon, 12 Sep 2016 18:52:00 GMT

Hi Michael Tarallo

Any suggestion from you?

Re: Trigger without Qmc

Michael_Tarallo — Mon, 12 Sep 2016 19:06:48 GMT

Hi Chanty - what Chris and Toni have both mentioned is the same path I would take as well. The pre-built extension that Chris mentions will allow a business user to "manually" reload the app from within Analysis mode ( in other words, no need for a task to load it or developer to click reload in the data manager) - BUT I am not sure that is what you want as you mentioned a trigger? Do you need to ONLY perform the reload AFTER something happens such as an event, a new file is received etc? If so - you would still need some process to handle that.

If you want to see the reload button in action here is a quick example where I used it.

You can see an example here:

Qlik Sense in 60 - Art of the possible - YouTube

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Trigger without Qmc

Chanty4u — Wed, 14 Sep 2016 06:10:13 GMT

Hi eightieschild

It is working very much fine in Qliksense Desktop.

As not working on Qliksense server3.0.2 the error is showing as

" The visualisation failed to render. " and Cannot Create the connection "how to get the same on server ? is there any workaround please share it ?

Re: Trigger without Qmc

Chanty4u — Wed, 14 Sep 2016 06:12:05 GMT

Thanks mto . as it working fine enough . but in server it not working.

yes what you mentioned is exactly correct. i need the data should be reloaed and that updated data should be appeared in QMC.

Re: Trigger without Qmc

eightieschild — Wed, 14 Sep 2016 08:33:09 GMT

Hi chanty4u‌

Have you set up permissions to the extension correctly? Afraid I can't replicate your scenario as we run v2.2.3, though worth raising an issue with the developer to see if your version is supported.

Another possible approach you may wish to consider is a utility called 'QlikSenseTask':

http://branch.qlik.com/?&_ga=1.42942567.310294989.1405955583#!/project/56f2e998f1c173fc24afe6ec

This allows you to call a command line utility on the server that runs Qlik Sense reload tasks.We've used it to integrate with an external data workflow scheduling tool.

HTH

Chris

Re: Trigger without Qmc

Michael_Tarallo — Wed, 14 Sep 2016 13:24:07 GMT

OK - this definitely sounds like a custom solution is needed - 1 thing I know you can do to reduce some of the custom coding burden is use an ETL tool such as Pentaho Data Integration. There is a free open source version available as well. PDI can create a JOB (graphically) that uses a file listener - you can configure that listener to look for a file - then kick off a "process" - when that file is received - such as an .exe , .bat, .cmd etc or even a RESTful API call to reload the Qlik Data etc. I don't know the specifics of it - but it can be done with a combination of tools that do not require any coding etc. as well.

Imagine an HTML page that someone uses to upload a new dataset. When they click upload, that dataset is put in a specific folder where a file listener is listening - the file is received and the process is started to reload the data in Qlik (API) - then you go to the app and the data is refreshed.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Trigger without Qmc

Anonymous — Mon, 26 Sep 2016 23:39:26 GMT

Hi Chanty, we have had a similar request from our users, I posted a similar question, if you have the ability to use C# the user could trigger the code to run which would tell a reload task to run.

Re: Working with REST API to trigger reload tasks