topic Re: Macro not working when reloading from command line in QlikView

Macro not working when reloading from command line

Wed, 23 Sep 2015 09:08:43 GMT

Hi all,

this is a very weird situation.

I have a simple script to export a csv file that is called when OnPostReload event is fired.

Sub ExportToCSV

set sObject1 = ActiveDocument.GetSheetObject("ClientiUnivoci")

sObject1.Export "Output\ClientiUnivoci_Week_" & Year(Now()) & LPad(Month(Now()),"0",2 ) & LPad(Day(Now()),"0",2 ) & ".csv", ";", 65001

End Sub

When I launch reload inside qlikview the script works fine and the file is generated, when I lanch qlikview reload from a batch file using the following command:

"C:\Program Files\QlikView\Qv.exe" /r "C:\Qlikview\Project\LastWeek.qvw"

the qlikview file is reload but the macro is not executed and the csv file is not generated.

I made the following attemps without success:

"C:\Program Files\QlikView\Qv.exe" /r /NoSecurity "C:\Qlikview\Project\LastWeek.qvw"
Settings | Document Properties | Security -> All checked except Allow Print, Show All Sheets and Objects and Show Progress for Hidden Script
Settings | User preferences | Security -> All checked except Confirm Launch from Macro
Tools | Edit Module | Request Module Security -> System Access
Tools | Edit Module | Current Local Security -> Allow System Access
Run batch as Administrator

I don't really know what to do more.

Do you have any ideas?

Thanks in advance.

Nicola

Re: Macro not working when reloading from command line

SreeniJD — Wed, 23 Sep 2015 09:17:02 GMT

Hi Nicola,

I guess, you can execute through windows batch file. Btw, do you have QV server?

Execute cmd.exe /C C:\BatFiles\Example.bat

Regards,

Sreeni

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 09:23:09 GMT

I'm already using a Windows bat file.

The bat file contains the following code:

"C:\Program Files\QlikView\Qv.exe" /r "C:\Qlikview\Project\LastWeek.qvw"

When I run the bat file qlikview reloads correctly but the macro is not executed.

I don't have QV server.

Thanks.

Re: Macro not working when reloading from command line

SreeniJD — Wed, 23 Sep 2015 09:41:36 GMT

Hi Nicola,

Your windows bat file script is correct..

cd "C:\Program Files\Qlikview\Qv.exe" /r "C:\Qlikview\Project\LastWeek.qvw"

I wondering, is there any service that is down causing the issue.. Can you please check the services in Control panel?

Regards,

Sreeni

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 11:08:35 GMT

Hi Sreeni, first of all thanks for your help.

I don't believe it's a problem of services, I copied the qlikview file on another machine and the issue remains exactly the same. Furthermore on the same machine I have lot of other qvw files that work in the same manner called by a batch file. So I don't really understand where the problem could be. If I'll find out a solution I will post it,

any other idea is appreciated.

Thanks a lot.

Nicola

Re: Macro not working when reloading from command line

marcus_sommer — Wed, 23 Sep 2015 11:29:37 GMT

Make a try with /l as parameter:

"C:\Program Files\QlikView\Qv.exe" /l "C:\Qlikview\Project\LastWeek.qvw"

- Marcus

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 12:04:00 GMT

Done. The QV file remains open but the macro in not executed.

Thanks

Re: Macro not working when reloading from command line

marcus_sommer — Wed, 23 Sep 2015 12:38:09 GMT

Check this too: Settings | User preferences | Security -> All checked except Confirm Launch from Macro

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 12:50:36 GMT

Nothing to do.

Thanks the same Marcus.

Re: Macro not working when reloading from command line

marcus_sommer — Wed, 23 Sep 2015 12:55:51 GMT

But in general this approach worked - I do the same since years. How do you execute the batch - as normal windows user which clicked on the batch within the explorer quite similar you open the qvw itself to start the reload or is this different from them?

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 13:02:29 GMT

Yes exactly, I double click on the .bat file with the goal of inserting it in a scheduled task.

I use the same approach since years too, but I never faced a case like this. I'm working on it since yesterday evening but I still haven't found a solution...

Re: Macro not working when reloading from command line

marcus_sommer — Wed, 23 Sep 2015 13:12:17 GMT

It sounds stupid now but try to change the trigger maybe to OnOpen, replace the routine with a simple msgbox or selection-action, create a complete new qvw with a small inline-table and a tablebox and use your export-routine again (something files get corrupted), further trial and error ...

Have you those app created himself or it's from another person maybe even downloaded from a server or mailed to you - sometimes windows creates flags for this which could prevent an remote-execution.

Re: Macro not working when reloading from command line

Wed, 23 Sep 2015 13:16:46 GMT

Finally I resolved the issue!!!!! Qlikview doesn't care about a relative path if the reload is executed inside the application. If the reload is executed externally from a command line you need to insert the full path in the script:

WRONG SCRIPT:

Sub ExportPercentileSettimana

set sObject2 = ActiveDocument.GetSheetObject("Percentile")

sObject2.ExportBiff "Output\Percentile_Week_" & Year(Now()) & LPad(Month(Now()),"0",2 ) & LPad(Day(Now()),"0",2 ) & ".xls"

End Sub

RIGHT SCRIPT:

Sub ExportPercentileSettimana

set sObject2 = ActiveDocument.GetSheetObject("Percentile")

sObject2.ExportBiff "C:\Users\sarnic\Documents\Progetti\Aperti\Project\Sviluppo\Report\Output\Percentile_Week_" & Year(Now()) & LPad(Month(Now()),"0",2 ) & LPad(Day(Now()),"0",2 ) & ".xls"

End Sub

Hope this may help someone else.

Thanks to everyone.

Nicola

Re: Macro not working when reloading from command line

marcus_sommer — Wed, 23 Sep 2015 13:20:55 GMT

Mostly it are the small things ...