Execute vbscript from QMC

[dapostolopoylos]

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?

[Colin-Albert]

Macros are best avoided on QV Server.

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

[dapostolopoylos]

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?

[fkeuroglian]

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?

[dapostolopoylos]

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...