topic Re: Button > Action > start vbs-script with parameter in QlikView

Button > Action > start vbs-script with parameter

Sat, 28 Jul 2012 16:46:53 GMT

I have a vbs-script which I want to start with a button in QlikView. This is working fine, but now I want to add some Parameter to the script.

In Windows-Shell I can start the script like this

script.vbs Para1 Para2

But how can I add the parameters to QlikView? It is possible to get the parameter in QV from a getfieldselection oder variable?

I tried Parameters but I get an errormessage.

Thank you.

Re: Button > Action > start vbs-script with parameter

Anonymous — Sun, 29 Jul 2012 18:42:45 GMT

Consider using your vbscript in Edit Module as a macro, and your button action will be "Run Macro". A variable can be used as parameter in this case.

Regards,

Michael

Re: Button > Action > start vbs-script with parameter

Lee_Matthews — Mon, 30 Jul 2012 01:29:17 GMT

I had to do something similar a while back. Variables cannot be passed in the code from the button. But you can use a preceding action to assign a value to a variable, and then reference the values in variables from within your VB script. As an example, the code below gets the string value from a variable named vObjectID and then strips out the double quotes.

	sTableID = ActiveDocument.GetVariable("vObjectID").GetContent.String
	sTableID = replace(sTableID, """", "")

Re: Button > Action > start vbs-script with parameter

Mon, 30 Jul 2012 09:51:51 GMT

Thanks, I will try it this week and tell you how it works.

Re: Button > Action > start vbs-script with parameter

Anonymous — Mon, 30 Jul 2012 10:21:08 GMT

Lee,

I see the reason of the confusion. I didn't mean "using parameter in the button". I meant use a variable as parameter in the macro. The value of the variable can be set manually in an input box.

If the value of the variable can be set automatically based on some conditions - it can be set in the macro itself instead of an additional action, meaning that parameter not needed at all.

Regards,

Michael

Re: Button > Action > start vbs-script with parameter

Lee_Matthews — Mon, 30 Jul 2012 10:50:30 GMT

Thanks Michael

That’s a good point, there are many ways that the value of the variables could be set. The macro could also reference values from the current field selections.

Re: Button > Action > start vbs-script with parameter

Mon, 30 Jul 2012 18:20:26 GMT

I did not thought of qlikview macro, this is a very good idea.

But I get another errormessage when I use the same script in QV (type VBScript, System Access, Allow System Access)

Set Para = wscript.Arguments

QV tells me 'Objekt erforderlich: 'wscript'' (means Object needed: 'wscript') But I think I need this for my parameters

dim Servername

Servername = Para(0)

Re: Button > Action > start vbs-script with parameter

Anonymous — Mon, 30 Jul 2012 18:25:32 GMT

I think you need to set Module Security to System Access, and Corrent Local Security to Allow System Access - they are in the bottom left part of the window.

Re: Button > Action > start vbs-script with parameter

Mon, 30 Jul 2012 18:40:34 GMT

thanks, but I did -

(type VBScript, System Access, Allow System Access)

Re: Button > Action > start vbs-script with parameter

Anonymous — Mon, 30 Jul 2012 18:50:09 GMT

Sorry, wasn't careful 😞

Are you using "option explicit"? If yes, make sure you have "dim wscript".

Also, maybe you don't need "set" here, just

Para = wscript.Arguments

(Just a wild guess, can't tell for sure without seeing the whole picture. And I'm not a VBScript expert.)

I often use msgbox-es in the macro script to debug, helps to see what is going on.