Trigger "execute script" - how to get that working in Browser_view?

[datanibbler]

Hi,

I am looking to using QlikView for ETL tasks, which would help save the employees time they usually spend on assembling all kinds of lists.

For that to work obviously the users will have to be able to reload those apps themselves instead of the server reloading them according to a fixed schedule.

=> How can I get that to work?

Most users (well, assumedly they all do) access the apps via the browser.

I can add a button with the action "execute script" and it works well in the client_software

<=> it does not appear to work in the Browser_view. i cannot see anything happening, so i opened the log_file, but it did not change, so the reload was obviously not executed.

=> Is there something more to that? What do I have to change to get that to work?

Thanks a lot!

Best regards,

DataNibbler

[Anonymous]

You cannot 'out of the box' reload a qvw via Access Point.

If you really, really want to do this then you'll need to get into extensions, API calls & web services.  I would recommend you stuck to QlikView 'out of the box'.

[marcus_sommer]

Hi DataNibbler,

you could try it with the execution from batch-files per buttons or url's.

- Marcus

[jerrysvensson]

It can be done with EDX tasks.

[jaimeaguilar]

Hi,

Maybe this example can be useful for you:

Triggering an EDX Task from the Ajax Client

regards

[datanibbler]

Hi Jaime,

that is a good idea - only I cannot use an extension - I suppose that would have to be installed where the QlikView_Server is, that is, on the company_server - that is out of bounds for me.

@ Marcus,

could you give me an example of a batch file to be used to reload one QlikView_app? Then I could test it.

I have tested that I can - and the Server can - execute a command_line (I have that in one app and it works when reloading via the QMC), so I guess that is possible - I could place the .bat file where I have access, in the directories for the QlikView_Server.

Thanks a lot!

Best regards,

DataNibbler

[jerrysvensson]

It can be done without extensions.

[datanibbler]

Great!

How would I do that, then?

[jerrysvensson]

You create a batchfile on the server that calls qmsedx.exe (you can download that from the forum) with params.

Then create a macro that runs that file on the client. Since all macros in Ajax run serverside, the batchfile is started serverside.

Use Set objShell = CreateObject("WScript.Shell")  to start program.

This will only work if you use Internet Explorer!!!

I can't give you more details on the solution unfortunately. But this works for several of clients.

[datanibbler]

That sounds good - but probably not feasible here:

I cannot run any .exe files - so I guess that a batch file run by me cannot do so, either - the same is true for the Server_user we have created to run the tasks.

It looks like it just cannot be done. What a pity.