2 Replies Latest reply: Apr 20, 2012 9:39 AM by Michael Robertshaw RSS

    Sheduling Qlikview document with out QEMC

    Sampath Kumar

      Hi all,

      I have created a qlikview document. i am not having QEMC installed can anyone help how to shedule a qlikview file with out QEMC and publish to Access point. I heard from my senior as we can do using windows sheduler.

        • Re: Sheduling Qlikview document with out QEMC
          Jason Michaelides

          From the QlikView reference manual which you will have in the program files folder of your desktop installation: C:\Program Files\QlikView\Documentation

          p41:

           

          6.1 Command Line Syntax

          The QlikView command line invocation can be described by the following syntax

          (for a description of the syntax notation used, see page 535 in Book III):

          [ path ] Qv.exe [ { switch } documentfile ]

          The path is the path to the file, either absolute, or relative to the current directory.

          documentfile::= [ path ] documentfilename

          documentfilename is the name of your document file.

          switch is used to mark different options:

          /r

          Reload switch. The document will be opened and the script

          reloaded. Thereafter the document will be saved, and QlikView will

          close itself.

          /rp

          The same as above, but with a partial reload.

          /l

          Load new data. The document will be opened and the script

          reloaded. The document will not be saved and QlikView will remain

          open.

          /lp

          The same as above, but with a partial reload.

          /v

          If this switch is immediately followed by a variable name and an

          assignment, the variable will obtain the assigned value before the

          script execution starts.

          /nodata

          Opens the document without variables, table and field data. This

          feature is also available for previously opened documents on the

          Start Page, see page 43.

          42

          /NoSecurity

          Overrides QlikView security measures against hostile macros and

          scripts embedded in QlikView documents. No warning dialogs

          prompting the user to accept potentially harmful code will be

          shown. Use this switch with caution and only with well-known documents.

          Example:

          qv.exe /r /vMyvar=123 abc.qvw

          Note In order to avoid error messages to appear when executing scripts in

          batch mode, always set the script variable errormode to 0 in the

          script (see page 358)

           

           

          Hope this helps,

           

          Jason

          • Re: Sheduling Qlikview document with out QEMC
            Michael Robertshaw

            My obvious question is "Why" do you want to schedule a reload task without using QEMC and Publisher?

             

            If you do not have the QlikView Server components installed (eg you're using Personal Edition without any licences, or without any Server infrastructure) then yes, you can certainly invoke QlikView Desktop from the command-line in a Batch file to perform a reload (QV.exe /R filename.qvw).

             

            If you do have the Server components installed somewhere, then use of the approach above consumes a Named CAL. You can use the QlikView Reload Engine (or Publisher) to perform Reloads managed through the QlikView Management Console and scheduled internally, or triggered from another Scheduler outside QlikView using EDX (see http://community.qlik.com/docs/DOC-2650). You can also invoke the QlikView Distribution Service from a command-line or batch file to perform a document Reload (QvDistributionService.exe -r=filename.qvw) and none of these methods consume a User CAL.

             

            I find it odd that you want to distribute to AccessPoint (therefore you DO have some QlikView Server infrastructure) yet you don't want to use the QEMC to manage your Reload tasks. Perhaps you merely want integration with an external Scheduler - in which case define your Reload Task in QEMC and use EDX integration from your Enterprise Scheduler to trigger the QlikView Reload Task. Any other approach will devolve into unmanageable chaos quite easily.