topic Re: Trigger "execute script" - how to get that working in Browser_view? in QlikView

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

datanibbler — Wed, 10 Dec 2014 14:44:52 GMT

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

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

Anonymous — Wed, 10 Dec 2014 14:51:58 GMT

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

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

marcus_sommer — Wed, 10 Dec 2014 15:03:55 GMT

Hi DataNibbler,

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

- Marcus

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

jerrysvensson — Wed, 10 Dec 2014 15:15:41 GMT

It can be done with EDX tasks.

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

jaimeaguilar — Wed, 10 Dec 2014 16:16:21 GMT

Hi,

Maybe this example can be useful for you:

Triggering an EDX Task from the Ajax Client

regards

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

datanibbler — Fri, 12 Dec 2014 11:05:26 GMT

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

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

jerrysvensson — Fri, 12 Dec 2014 11:22:16 GMT

It can be done without extensions.

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

datanibbler — Fri, 12 Dec 2014 12:21:06 GMT

Great!

How would I do that, then?

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

jerrysvensson — Fri, 12 Dec 2014 13:14:08 GMT

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.

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

datanibbler — Fri, 12 Dec 2014 13:29:59 GMT

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.

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

jerrysvensson — Fri, 12 Dec 2014 13:33:17 GMT

Trust me, it can be done if the server guys allows you put an exe file on the QVS server.

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

datanibbler — Fri, 12 Dec 2014 13:36:15 GMT

Okay,

then how would the EXECUTE command in QlikView have to look to execute that file?

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

jerrysvensson — Fri, 12 Dec 2014 14:02:16 GMT

Set objShell = CreateObject("WScript.Shell")
objShell.run( " batchfile ",0,true )