topic Re: Export Table to XML by Script or Macro in QlikView

Export Table to XML by Script or Macro

Wed, 31 Jul 2013 11:50:02 GMT

Hello everybody,

I work for a year with QlikView and got today a task I can not solve seemingly without your help.

I need to export a table to XML format. To do this, I wrote a macro, which exported the table.

The macro is started automatically when the script is run. Trigger in the document properties.

However, the macro will not run if the document is updated by the Server service. I open the document and start the script by hand, then it works.

Is there a solution for this?

I am grateful for each approach.

Using QV 11.20 SR2

Regards

Marcel

Re: Export Table to XML by Script or Macro

marcus_sommer — Wed, 31 Jul 2013 12:17:50 GMT

See in APIGuide.qvw for examples like this:

rem create new straight table and export in xml

set chart = ActiveDocument.Sheets("Main").CreateStraightTable

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

chart.ExportXml "C:\test.xml"

- Marcus

Re: Export Table to XML by Script or Macro

Wed, 31 Jul 2013 13:11:22 GMT

Yes, I do so, it ist working, but the Macro wouldn´t start, if you won´t open the document and reload the script manually (I prepared the doc, that the macro runs, when the Script ist reloaded).

But I don´t want to reload manually. I configure the automatic reload in the QlikView management console. And if the reload runs there, the script did not start.

Also noch kurz auf deutsch:
Das Makro läuft und exportiert die Tabelle. Eingestellt habe ich es so, dass der Reload des Skripts als Auslöser für den Makroaufruf verwendet wird.
Da funktioniert aber nur, wenn man das Skript manuell und in der Anwendung ausführt. Dann wird auch das Makro gestertet.
In der QV-Management-Console bei automatischem Reload, wird das Makro nicht ausgeführt ... 😞 Aber genau da muss es laufen, weil ich ja nicht jedes mal die Anwendung öffnen will.

Marcel

Re: Export Table to XML by Script or Macro

marcus_sommer — Wed, 31 Jul 2013 13:20:44 GMT

Yes macros on server are difficult to don't work. Check the settings in QEMC under System/Setup/QVS-Server/Security/Miscellaneous. If this not work you could use a cmd-file like this:

"D:\YourPathToExe\QV.exe" /r "D:\YourApp.qvw"

- Marcus

Re: Export Table to XML by Script or Macro

Wed, 31 Jul 2013 13:30:04 GMT

Yes, cmd-file works!
Thanks a lot

Marcel

Re: Export Table to XML by Script or Macro

SohaibAkhtar — Sun, 14 Apr 2019 14:47:55 GMT

Hi,

I was facing the same problem. Can you help me with the macro u wrote to export the report to XML format. Would really appreciate your help here