Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reload Qlikview document using EXECUTE command

Hi

I am trying to reload a Qlikview document through another Qlikview Document using the below commands:

EXECUTE cmd.exe /C "D:\Program Files\QlikView\QV.exe" /r "$(v_File_Path)";

When I reload through the Qlikview document it works fine, but when I try to reload through QMC the task just stays there like waiting for something to happen.

I looks like its waiting for some user input or for someone to close the progress bar. Has anyone got an idea to what is happening?

Regards

1 Solution

Accepted Solutions
Not applicable

Re: Reload Qlikview document using EXECUTE command

Alright Qliktech support pointed me in the right direction. Instead of using QV.exe to reload I should use QVDistributionservice.exe.

EXECUTE cmd.exe /C ""D:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="$(v_TESTE)"";

(Don't forget the Initial and final double quotation)

For future reference:

Note:

Set the EnableBatchMode to "True" in the QVdistributionservice.exe.config file and restart the QDS service.

 

Server Reference Manual:

More functions parameters can be found in the QV Server Reference Manual.

Helpful post:

http://community.qlik.com/thread/49090


Thank you Troy Raney from Qlikview

Cheers

8 Replies
Luminary
Luminary

Re: Reload Qlikview document using EXECUTE command

Why don't you set a reload task on the QMC with a dependency instead of triggering QV reloads via the script?

Not applicable

Re: Reload Qlikview document using EXECUTE command

Hi,

Can't you copy paste the script in a batch file and try running the batch file in QMC first??.

If succeed, then make  an external event in the QMC trigger and call this batch file to run the job.

Hope it helps

Kiru

fkeuroglian
Honored Contributor

Re: Reload Qlikview document using EXECUTE command

Hi, pherhaps you can create a windows task that run the D:\Program Files\QlikView\QV.exe , using this you do not have to create an execute command in a new qlikview document.

good luck

Fernando

Not applicable

Re: Reload Qlikview document using EXECUTE command

Hi Martin

Thanks for your reply, but I can't set a dependency because I don't know which app I need to reload, because they don't exist yet... I know it sounds a bit complicated. Let me try and explain:

1 - I get huge files from a data source, there is no pattern for the file name. The Files contain the same column structure.

2 - I would like to create one app per file so I don't load all the apps at one given time.

So I created and app that looks for new files and creates an app for each one of them, because I don't know their names I can't set them up in QMC.

Not applicable

Re: Reload Qlikview document using EXECUTE command

Hi Kiru

I can't copy the script to the batch file because there is more to the script than just the reload statement.

The script looks for new files from a Data Source then creates new apps for those files and then try to reload the newly created apps.

Any ideas?

Luminary
Luminary

Re: Reload Qlikview document using EXECUTE command

I'll be honest and admit that I don't like that setup but I'm sure you have your valid reason for doing this.

Another question is why you would need to create one app per file?

Not applicable

Re: Reload Qlikview document using EXECUTE command

Because the files are huge and I only want the user to see one file at a time, otherwise it will take up all of the servers memory.

Not applicable

Re: Reload Qlikview document using EXECUTE command

Alright Qliktech support pointed me in the right direction. Instead of using QV.exe to reload I should use QVDistributionservice.exe.

EXECUTE cmd.exe /C ""D:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="$(v_TESTE)"";

(Don't forget the Initial and final double quotation)

For future reference:

Note:

Set the EnableBatchMode to "True" in the QVdistributionservice.exe.config file and restart the QDS service.

 

Server Reference Manual:

More functions parameters can be found in the QV Server Reference Manual.

Helpful post:

http://community.qlik.com/thread/49090


Thank you Troy Raney from Qlikview

Cheers

Community Browser