topic Re: Any job/batch script to Click a button automatically in a QVW? in QlikView

Any job/batch script to Click a button automatically in a QVW?

dmohanty — Mon, 19 Jun 2017 15:28:34 GMT

Hi All,

I have a Button in a QVW which executes a Macro successfully to generate email. I have to open the QVW, Click the Button once (executes Macro) and the Email will come in Outlook.

But I tried using the OnPostReload and OnOpen triggers but unfortunately Macro never works in that. So doing every day manually to click the button to get the output.

Is there any way, any batch script or any task that can click the Button in the QVW automatically at a desired time period?

Any suggestions are welcome!

Regards!

Re: Any job/batch script to Click a button automatically in a QVW?

passionate — Mon, 19 Jun 2017 15:32:29 GMT

Hi Dicky,

You can control Qlikview through excel macro.

So, try using Excel macro to open Qlikview document and perform required operations.

Regards,

Pankaj

Re: Any job/batch script to Click a button automatically in a QVW?

dmohanty — Mon, 19 Jun 2017 15:54:17 GMT

Hi passionate,

Thanks for suggestion.

I had never used Excel Macros to control Qlik, but surely will give it a try.

I believe again that will be a manual task to Run Excel Macros?

Re: Any job/batch script to Click a button automatically in a QVW?

passionate — Mon, 19 Jun 2017 16:07:31 GMT

Hi Dicky,

- Create a Vba code to open Qlik Document. (Sample of QlikView automation by external VBScript scripts · blog.infovizion.ru)

- Perform Required operations.

Note: You can try auto scheduling the vba script. (.vbs file)

Regards,

Pankaj

Re: Any job/batch script to Click a button automatically in a QVW?

dmohanty — Mon, 19 Jun 2017 18:04:06 GMT

@passionate,

Great help buddy!

Now I can use the VBS to Open a QVW and some small desired actions.

Can you provide some more help in how and where to automate my VBS Script?

Re: Any job/batch script to Click a button automatically in a QVW?

passionate — Mon, 19 Jun 2017 18:16:28 GMT

Hi Buddy,

Best way to trigger VBA script on particular time is through windows task.

Create a task to execute vbs file and schedule it in windows as per your requirement.

Regards,

Pankaj

Re: Any job/batch script to Click a button automatically in a QVW?

dmohanty — Mon, 19 Jun 2017 19:58:25 GMT

Hi passionate,

VBS file is scheduled and running as per triggered schedule. But it's really not opening up the QVW.

However the VBS logs shows no error. When run from local, it opens up the QVW, but not through scheduler.

Note - My QVW is in SAN drive.

Re: Any job/batch script to Click a button automatically in a QVW?

dmohanty — Mon, 19 Jun 2017 20:45:40 GMT

Hi passionate,

I was able to achieve this using a Batch Script that runs as Trigger in Windows Scheduler.

But I will still work, why its not working in VBS while reloaded as Trigger.

Thanks again for the suggestions.

Re: Any job/batch script to Click a button automatically in a QVW?

passionate — Tue, 20 Jun 2017 03:29:58 GMT

Hi Dicky,

So you are handling QVW document through Batch script?

Regards,

Pankaj

Re: Any job/batch script to Click a button automatically in a QVW?

dmohanty — Tue, 20 Jun 2017 11:55:56 GMT

Yes passionate‌,

As of now, only for this particular QVW to fulfill the requirement.

An Open command/scheduler to open the QV.exe and the desired App-

"C:\Program Files\QlikView\QV.exe" "YoyrPath\YourApp.qvw" >> openlog.txt exit

A close command/scheduler with to close the QV.exe to save memory in Task Manager-

taskkill /f /IM E:\Program Files\QlikView\QV.exe >> log.txt

This helps the requirement at least.