topic Re: Execute vbscript from QMC in QlikView

Execute vbscript from QMC

dapostolopoylos — Fri, 03 Oct 2014 12:07:15 GMT

Hello everybody, i have this problem and i would like some help...

I have this vbsrcipt that opens a qvw and extracts the contents of a table chart into a qvd...

The vbscript is the following:

Set MyApp=CreateObject("QlikTech.QlikView")

Set MyDoc=MyApp.OpenDoc("C:\Folder1\DIFS.qvw")

MyDoc.ActivateSheet("SH05")

Set obj = MyDoc.GetSheetObject("able1A")

obj.ExportEx "D:\Folder2\Export.qvd", 4

MyApp.Quit

Set obj=Nothing

Set MyDoc=Nothing

Set MyApp=Nothing

The script works fine...

When i try to execute it through QMC, i create a supporting task and i call it either with

cscript "C:\StorePPMTablesNEW\exportMissingRBU.vbs"

or by creating a batch file whitch includes the command above, that i call it by its name, for example

C:\Folder1\export.bat

The problem is that even though the task on the QMC executes succesfully, the qvd is never created or updated...

Any ideas?

Re: Execute vbscript from QMC

Colin-Albert — Fri, 03 Oct 2014 12:13:46 GMT

Macros are best avoided on QV Server.

Can you create the QVD using a store command in your load script.

Re: Execute vbscript from QMC

dapostolopoylos — Fri, 03 Oct 2014 12:16:58 GMT

I tried to follow your suggestion earlier in the day but the result wasn't what i expected...

Do you have any idea for the including macros senario?

Re: Execute vbscript from QMC

fkeuroglian — Fri, 03 Oct 2014 12:56:17 GMT

Hi, using a store command in the script should be work as @Colin Albert Say, why wasnt as you expected? do you have any error or what happend?

Re: Execute vbscript from QMC

dapostolopoylos — Fri, 03 Oct 2014 13:11:09 GMT

The qvd file exported by the store command was smaller than the one exported by the vbscript...

The truth is that after @Colin Albert 's comment i compared some things between the two qvds like row counts or sums of balances and they are exactly equal...