12 Replies Latest reply: Sep 26, 2016 7:39 PM by David Maurice RSS

    Trigger without Qmc

    Chanty 4u

      Hi all,

      Toni Kautto

      arul settu

      Rohit Kumar

      Miguel Braga

      Michael Tarallo

      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
          Toni Kautto

          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
              Chanty 4u

              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
                  Toni Kautto

                  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
                Chris Turner

                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
                  Chanty 4u

                  Hi Michael Tarallo

                   

                  Any suggestion from you?

                    • Re: Trigger without Qmc
                      Michael Tarallo

                      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
                          Chanty 4u

                          Thanks Michael Tarallo . 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
                              Michael Tarallo

                              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
                          David Maurice

                          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