topic OnPostReload export to XML in QlikView

OnPostReload export to XML

Tue, 19 Oct 2010 18:59:38 GMT

I need to export an object (straight table) to an XML file nightly after reload. In theory, the easiest way to do this would be to set up a trigger for OnPostReload to an XML file, however that is not a valid file type. I believe a macro will be the way to go, however I'm not proficient at writing them.

Every time the server reloads the document, I need to have an object (CH381) export to an XML file. Can someone please assist me with this?

Thanks!

OnPostReload export to XML

Wed, 03 Nov 2010 22:12:30 GMT

I need the same sort of functionality 🙂 can someone please help us.

OnPostReload export to XML

Thu, 04 Nov 2010 02:53:25 GMT

You can use ServerSideExportEx sample program below:

set tb = ActiveDocument.GetSheetObject("CH05")
tb.ServerSideExportEx "C:\QVTemp\test.xml" , ";" , 3

'0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

I hope this helps.