topic Re: Reload with batfile and macro in QlikView

Reload with batfile and macro

johnan — Wed, 23 Oct 2019 05:52:09 GMT

Hi , i have a macro that export images, when i run this in the qlikview with a button it works perfect.

When i run this with a batfile, it's reloading the qv but the last thing happend is that the macrowindows stays open and nothing more happens.

Batfile:
"C:\Program Files\QlikView\Qv.exe" /l /NoSecurity "C:\Qv\MXXX.qvw"
Macro:

function exportImages
' Test if export should be made
set v = ActiveDocument.Variables("RunNow")
if v.GetContent.String = "Yes" then
v.SetContent "No",true
exportAll
ActiveDocument.GetApplication.Quit
end if
end function

function exportAll
export("CH01")
export ("TX01")
end function

function export(chartId)
set obj = ActiveDocument.GetSheetObject(chartId)
obj.ExportBitmapToFile "C:\UTL\Chart_" & chartId & ".png"
end function

What can i do to get this working?

Re: Reload with batfile and macro

marcus_sommer — Wed, 23 Oct 2019 06:46:54 GMT

Try it in this way:

sub exportImages
' Test if export should be made
set v = ActiveDocument.Variables("RunNow")
if v.GetContent.String = "Yes" then
v.SetContent "No",true
call exportAll
ActiveDocument.GetApplication.Quit
end if
end sub

sub exportAll
call export("CH01")
ActiveDocument.GetApplication.Sleep 1000
call export ("TX01")
end sub

sub export(chartId)
set obj = ActiveDocument.GetSheetObject(chartId)
obj.restore
ActiveDocument.GetApplication.WaitForIdle
obj.ExportBitmapToFile "C:\UTL\Chart_" & chartId & ".bmp"
end sub

The grey statements are optional - especially in larger export-routines they are necessary to ensure a stable workflow.

- Marcus

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 07:01:54 GMT

Okay, i will try.

To call the macro is exportAll?

Re: Reload with batfile and macro

marcus_sommer — Wed, 23 Oct 2019 07:09:28 GMT

Yes, exportAll - the essential point is the switch from a function to a sub because a function couldn't be "called" and it expect a return-value. The call itself is optional but it improved the readability.

- Marcus

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 07:24:19 GMT

It's the same, it will open the macromodule at the end 😞

And it works when i open it manually and press the button

Something else that i missing?

Re: Reload with batfile and macro

jaibau1993 — Wed, 23 Oct 2019 07:41:52 GMT

Hi!

Can you please share a screenshot of the macro module when it opens when you run it from the bat file, please?

Jaime.

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 07:48:32 GMT

Yes, here you go!

Re: Reload with batfile and macro

marcus_sommer — Wed, 23 Oct 2019 07:48:43 GMT

What do you mean with?

"... And it works when i open it manually and press the button ..."

Right click on the object and exporting it, executing it within the module-editor, from the UI per button/action, from the outside per EXECUTE or windows task, ...?

- Marcus

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 07:55:28 GMT

I have a button on the QV application. In that button i have call run Macro -> exportAll.

So if i open the QV manually and press that button it's work.

If i run the batfile, after the reload it's just open the Macrowindow and nothing happens.

Re: Reload with batfile and macro

jaibau1993 — Wed, 23 Oct 2019 08:06:35 GMT

Quite weird, can not reproduce your problem.

Got to ask: have you configured a trigger "on open" as in the following image?

BTW, shouldm't you call "exportImages" instead of "exportAll"?

On the other hand, when the macro is run from the bat file, is it run with a user with writting permissions in "C:\UTL\"?

Regards,

Jaime.

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 08:07:04 GMT

I try to open manually (without batfile) and reload and it's open the macrowindow here to.

Something wrong here?

Re: Reload with batfile and macro

marcus_sommer — Wed, 23 Oct 2019 08:15:50 GMT

The most practicable way to find the issue is usually to check the code partly, for example by commenting some routines or parts of them, adding some msgbox to show until when the routine runs and which values certain variables have and also setting some variables/parameter differently.

In your case I would set the UI variable to "No" and check and then adding msgbox's (with 1,2,3, ...) below/above the sub-statements to track when it breaks.

In your case I could imagine that the button is within the sheet of the charts - but if the application is saved within another sheet as active-sheet your routine might need an extra-statement to go to wanted sheet and activate it.

- Marcus

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 08:29:58 GMT

Okay, can i mail the application?

Re: Reload with batfile and macro

jaibau1993 — Wed, 23 Oct 2019 08:35:12 GMT

Marcus is right: you can force the problem by reloading your app so add breakpoints to your code (exit sub and msgbox) so you can check where exactly is the problem.

Let us know!

Jaime.

(can you share an example app that reproduces the problem?)

Re: Reload with batfile and macro

rwunderlich — Wed, 23 Oct 2019 08:44:01 GMT

How are you triggering the macro from the batch reload? A trigger? Which one?

-Rob

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 08:55:08 GMT

Hi Rob,

Not in the batchfile at all.
The batfile contains:

"C:\Program Files\QlikView\Qv.exe" /l /NoSecurity "C:\Qv\Man2Bild.qvw"

And then i have a trigger in qv-app that should run after script execution.

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 09:23:09 GMT

Here you go!

I't seems to work manually, but with batfile itt just want to open macrowindow after reload

the batfile (can't attach)

"C:\Program Files\QlikView\Qv.exe" /l /NoSecurity "C:\Qv\emtpy.qvw"

Re: Reload with batfile and macro

jaibau1993 — Wed, 23 Oct 2019 09:48:17 GMT

Works perfectly (manually and from bat) in my PC and I have only changed the path where images are saved.

Let's see if Marcus or Rob figure it out! May be it is because the QV version, Operative System, environment (are you running the QV file and the bat file inlocal machine, in a server,...?)...

Regards,

Jaime.

Re: Reload with batfile and macro

marcus_sommer — Wed, 23 Oct 2019 10:26:02 GMT

Agree, worked without any issue per button and per external batch. Take a look in the document- and your user-properties in tab security if all settings are set properly.

- Marcus

Re: Reload with batfile and macro

johnan — Wed, 23 Oct 2019 11:12:40 GMT

This is mine:

Version QlikView 12.20