4 Replies Latest reply: Sep 18, 2013 7:37 AM by dhiraj kumar RSS

    Task Dependancy

    renjith pl

      Hi All,

       

      Can QMC triggers a task based on the availability of a folder or a .mdb file.?

       

      How can i achieve this ?

       

      Regards

      Ren

        • Re: Task Dependancy
          Dicky Mohanty

          Dependencies can be created in QMC using triggers..no doubt. You can have multiple files dependent on each other for reload.

          You have to select "On event from another task" for the subsequent files. For the first file, you have to select "on a schedule"

          Screenshot below:

           

          Test.png

          • Re: Task Dependancy
            Kabilan Kumarasamy

            I thing we cant do this.

             

            we can do this in script with If statement.

             

            if(fileexists(filepath))

            statement;

            end if

             

            Reagrds,

            Kabilan K.

            • Re: Task Dependancy
              Peter Cammaert

              The best way to do this, I guess, is to monitor files and folders outside of QlikView.

               

              A small program or batch (CMD) file checks the availability of this file or folder. Upon detecting the right stuff, it sends an EDX request (there is a command line tool for that, see QMSEDX_commandline in doc http://community.qlik.com/docs/DOC-2650) to your reload task. Configure your reload task to also trigger on receiving an EDX request.

               

              Now schedule your monitoring tool using Windows Task Scheduler to go and check with the preferred frequency and you're on your way.

               

              Luck,

               

              Peter

              • Re: Task Dependancy
                dhiraj kumar

                Hi,

                you can do but with the help of external task.

                1. Use the EDX task trigger for the same and write script accordingly. else you can follow the below steps(both) for your requirement but it not exactly what you want.

                 

                2. Create a batch file which execute the reload when the required file exist :- Algoritham

                 

                if file exist

                     reload qvw

                     else

                print Not present

                3. Create a external task using above file and sechedule it every 5 min.

                 

                Thanks,

                D J