Macro to export straight table to csv after reload on server.

[pgriffiths]

I have been trying to do this for some time, but I can't seem to find an answer.
I need to export a straight table to a CSV file.
Below is a test setup I am using to simpify the process while investigating the problem.

I first create some test data in a load script as follows;

//Example Data
QUALIFY *;
Example_Data:
LOAD * Inline 
[Asset,User,OS
UK01,sparnaby,WinVista
UK02,tbrown,Win7
UK03,mrichards,Win8
];

To test the output folder has access, I output this table using the Store command as follows;

STORE Example_Data into c:\TestCSV\Table_Example_Data.csv (txt);

I then create a straight table to output the example data and add a count field with a total. I call this stright table "Table_Data".

I create a Macro to output the straight table as follows;

Sub ExportTest
 Set obj = ActiveDocument.GetSheetObject("Table_Data")
 obj.ExportBiff "c:\TestCSV\Data.csv"
End Sub

In the Edit Module section this macro is in, I set the following fileds;
Requested Module Security: System Access
Current Local Security: Allow System Access

In the main Qlikview document I also go into Settings->Document Properties->[Triggers] tab.
I select "OnPostReload" and click [Add Action(s)] button.
I add "Run Macro" and set the Macro Name to "ExportTest".

I then setup security Settings on the Qlikview Management Server.
[System] tab->[Setup] subtab->Select Server from the list.
[Security] tab on the server.
[Tick] Allow macro execution on server
[Tick] Allow unsafe macro execution on server
Clicked [Apply]

I then setup the output folder c:\TestCSV and added full permissions for the AD accounts the qlikview services run on.

I open and run the report fine from the qlikview client and c:\TestCSV folder contains both the output files
Data.csv
Table_Example_Data.csv

The problems is if I create a task on the Qlikview Management Server, it only outputs the one file.
Table_Example_Data.csv

Anyone got any idea how to do this?.

Many thanks in advance.

EDIT - I have added the example QVW file.

[pgriffiths]

I have been reading the APIGuide and as a result tried the following macro that I believe should of worked.

Sub ExportTest 
Set obj = ActiveDocument.GetSheetObject("Table_Data") 
obj.ServerSideExport "c:\TestCSV\Data.csv", ";", 0 '0=ANSI(Default)
End Sub

This still doesn't output.

I even tried setting the folder permissions to allow everyone read write access, just to make sure.

This ServerSideExport seems to be a function to do exactly what I need, but it doesn't work?. Anyone know why?

Many thanks.

[pgriffiths]

From testing it would seem the "OnPostReload" event is not being triggered when the Qlikview Management Console reloads the QVW via a task and this might be why the Macro isn't being run.

[pgriffiths]

Does anyone know how to trigger a macro when a task is run in Qlikview Management Console?.

[marcus_sommer]

Macros won't executed per qmc reload-task. You need to run such macros per Fat-Client either per command-batch or vbs, see here for examples:

Re: Run Macro on Reload (From Server)

Re: QlikView Batch Jobs execution using CONTROL-M

Re: Sending mails macro vbs

- Marcus

[pgriffiths]

Thank you Marcus, I can see why it was not working now.

Done some testing and can see how the batch file works.

I should be able to trigger the batch file from the load script of a QVW, but wondered if it was possible to instead detect if the load script was running on a Qlikview Management Console from within the load script?

Something like

if(Application.Parent.Name = 'GMC', {Do-Something-To-Launch-Batch-File})

[marcus_sommer]

I use for such detecting in front tasks which writes variable-values (stop/run) in txt-files which are not only used directly in qlikview also to control various batches, vbs-routines and excels with OnOpen-routines. But in your case might (I haven't tested it yet) a check on systemvariables like QvRoot or WinRoot easier.

- Marcus

[pgriffiths]

I like the idea. Many thanks.

I could look for a custom made file that exists only on the server to determine if the script if being run on the server.

Maybe there is already a file that is unique to the server.

I will post what I find.

[gandalfgray]

Hi

What I don't understand is why you want to export the table using macros, when you could do it in the load script with the Store command?

[pgriffiths]

I thought the Store command only worked with Tables, not Straight Tables.