topic Re: Extension for writing variable to a serverside .txt/.xlsx in QlikView

Extension for writing variable to a serverside .txt/.xlsx

pradosh_thakur — Tue, 17 Jul 2018 12:03:49 GMT

Hi All,

Is anyone aware of any extension that can write variable values to a server side text file or excel file from access point. Variable can be put in a text box and then exported to the server as well. I am trying to send the current selection to the server for further use in another document .

Please point me to anything that can help.

regards

Pradosh

Re: Extension for writing variable to a serverside .txt/.xlsx

pradosh_thakur — Tue, 17 Jul 2018 12:52:09 GMT

marcus_sommer‌ jontydkpi‌ gwassenaar‌

Re: Extension for writing variable to a serverside .txt/.xlsx

pradosh_thakur — Thu, 19 Jul 2018 06:16:15 GMT

rwunderlich‌

Hey Rob!! Can you help me out here ?

Re: Extension for writing variable to a serverside .txt/.xlsx

rwunderlich — Thu, 19 Jul 2018 22:44:03 GMT

I don't know of any extension, but you may be able to create something with a macro that uses Export or ServerSideExport in a macro.

-Rob

Re: Extension for writing variable to a serverside .txt/.xlsx

pradosh_thakur — Sat, 21 Jul 2018 15:54:22 GMT

Hi rwunderlich‌

I have some macro written to download excel file with some formatting . Due to a huge number of reports and licensing issue Npriting is not used. So my job was to make the macro usable in ajax. What i am trying is passing the current selection to a text file to the server side and then use the variable value in another qvw and open the macro on open.

As Macro won't work in ajax i wanted to do this by extension using java script. I referred to an article of yours in which you were importing and exporting Qliksense script by clicking a button. but looks like the export happens to the client side. I tried but was not able to find any solution for that using javascript.

So i am trying another approach let me know if this is a good approach or not.

1: I am creating a dot net page which will fetch the variable from access point and save it on server side.

2: Use EDX to trigger a batch file which will open a document on the server which in turn will use the variable to make selection on open and do the same job macro was doing.

Let me know if you have any solution to the above problem. I will keep you posted if you are interested in this.

regards

Pradosh