data refreshing

[mshailaja]

hi , i am having data coming from oltp , i need data refresh  for evry one hour  not in admin part , i wanto to write in script level?

[muthukumar77]

Hi,

Please confirm, Are you asking about Reload process?

[mshailaja]

i want  to refresh the data  by writing code in script level , is there any possibility?

[Kushal_Chawda]

AFAIK, you cannot do this from script. To initiate the reload process you need to call QV.exe which you can do by manually opening application and hit reload button or you can schedule the job from qlikview server or you can schedule the job from windows task manager by calling the batch script.

[Digvijay_Singh]

Follow these -

7.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 Backus-Naur Formalism (page 933)):

[ 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 the 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 (page 36).

/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

[oknotsen]

No, you can not trigger a reload using script in anyway.

The question however is: What is it that you actually / really want to achieve? What is your actual problem?

Maybe there is a different solution to your problem.

[raadwiptec]

yes try calling a command execution parameters with in script

C:/........Qv.exe /r test.qvw