topic Re: [resolved] user input in runnable jar in Talend Studio

[resolved] user input in runnable jar

Anonymous — Sat, 16 Nov 2024 12:59:56 GMT

I have the following :
tMSSqlInput -> tSortRow->tMap->tFileOutputExcel
In the tMSSqlInput, I use a context variable for the query :
Select ....
From ...
where Num = +context.num
this is working fine in Talend , when I run the job, it ask me to enter the value for num and I extract the good information.
I try to export this job as runnable jar.
When I run the runnable jar, it does nothing, it doesn't ask for anything.
Is there a way to do this, have a user input in the runnable jar
Thank you
Christophe

Re: [resolved] user input in runnable jar

Anonymous — Sat, 02 Apr 2011 02:12:07 GMT

Hi
Using a tmsgbox at the beginning of job to requires a input from user, please see my screenshot.
Best regards
Shong

Re: [resolved] user input in runnable jar

Anonymous — Mon, 04 Apr 2011 20:51:20 GMT

Thank you Shong - this is very good. You answered the exact question. However in the simple scenario the query can be amended as:

"...
where Num = " + ((String)globalMap.get("tMsgBox_1_RESULT"))

One less component. One less context var.
Of course if the "Num" needs to be used again, then the context var is better.

Re: [resolved] user input in runnable jar

Anonymous — Tue, 05 Apr 2011 18:06:10 GMT

I forgot to subscribe to my original message and see the answer just now
It is working fine, I took the second option as it is a simple job.
Thank you