topic Re: Run CLI command from a straight table in QlikView

Run CLI command from a straight table

Anonymous — Fri, 17 Aug 2012 07:45:00 GMT

Hi,

I would like to know if it's possible to run a CL command from a chart or a table.

My idea is to add a button for example in an invoice chart. If the user clicks this button our ERP-System automatically starts and opens in the marked invoice.

I hope this table shows you what I have in mind.

Invoice Number	Customer	ERP-System
4081951	Customer A	link or button[]
4081952	Customer B	link or button[]

With this CLI-command everything what I want happens.

\\server\mandant\rungui.exe "<verkauf>4081951<zeigen>" "Mandant" "user"

Is there a possibility to implement this command as a button or link in a straight table.

In this command only the invoice number (in this example 4081951) is variable, everything else is static.

I hope you understand what I want and you could give me a solution or some hints...

Thanks in advance!

Re: Run CLI command from a straight table

swuehl — Fri, 17 Aug 2012 09:15:58 GMT

You can try using an expression in your table chart with representation 'Link' (option on expression tab).

The expression will look like

='Open ERP<url>\\lxabas01\neugart\rungui.exe "<verkauf>'& [Invoice Number]&'<zeigen>" "Neugart" "ABAS-EKS"'

I had some problems with the tag character '<>' used for <verkauf> and <zeigen>, QV seems to interpret these tags (like the mandatory <url> tag), but breaking its intended function.

Is there a way to use different tags for your ERP? Or maybe someone knows a way to use an escape character for this.

Another option could be to select an Invoice Number, then create a button chart object and execute a External-Launch action.

Hope this helps,

Stefan

Re: Run CLI command from a straight table

Anonymous — Fri, 17 Aug 2012 09:35:45 GMT

Thank you for your fast answer!

I will try to implement your given expression.

What do you mean with using different tags for the ERP?

Re: Run CLI command from a straight table

swuehl — Fri, 17 Aug 2012 09:59:50 GMT

The expression as shown above probably won't work, because of the characters '<' and '>' in your command line argument.

QV needs to be parsed a string for the Link representation, with following structure:

TextToDisplayInChart<url>URLtoOpen

I think the delimiter <url>, or more precisely the characters '<','>' will be parsed by QV, but this is probably breaking your command line string (i.e. breaking the interpretation as Link). Just give it a try (for comparison, try a string like

='OpenQVSite<url>http://www.qlik.com'

Re: Run CLI command from a straight table

Anonymous — Fri, 17 Aug 2012 10:37:45 GMT

Thanks for your response!

Calling a website works just fine and calling the .exe is working also. But you are right, if i add the options to the rungui.exe, the link does not work anymore.

Now I have to check, if i can start the erp-application in an other way.