Skip to main content
Question

I have made fme workspace by using tester transformer, there I am using postgres table as input tester transformer for filtering , but now i want to run the workspace through shell script and want to send criteria for tester transformer by shell sc


In a way through shell script I should be able to dynamically send the criteria that we apply in tester transformer for filtering the input data. How to do it.

8 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

Create a User Parameter for the test criteria, then if you run the workspace in Workbench you'll see the command line that is used for that run at the top of the log, that includes the user parameter. You can put tha in your shell script and change the parameter value as needed.


redgeographics wrote:

Create a User Parameter for the test criteria, then if you run the workspace in Workbench you'll see the command line that is used for that run at the top of the log, that includes the user parameter. You can put tha in your shell script and change the parameter value as needed.

Hello sir, thanks for the response. I have made the user parameter but I am facing problem, user parameter is not fetching the dynamic value that I am trying to apply through command line, it is only considering default value.command line


redgeographics
Celebrity
Forum|alt.badge.img+50
akshayvaidya wrote:

Hello sir, thanks for the response. I have made the user parameter but I am facing problem, user parameter is not fetching the dynamic value that I am trying to apply through command line, it is only considering default value.command line

I'm not too familiar with Linux scripting, is there a way to show the exact command line?

 

Your workspace expects a parameter $ward to be passed to it and I can't quite see where that would happen in the script.


akshayvaidya wrote:

Hello sir, thanks for the response. I have made the user parameter but I am facing problem, user parameter is not fetching the dynamic value that I am trying to apply through command line, it is only considering default value.command line

Hello sir,

Here I have made blue box there I am passing different parameters that I have mentioned in the above part of the script. At the Blue line inside the blue box I am trying to pass the user parameter value , I have made user parameter with name ward and here I am trying to dynamically provide the value to the user parameter by running the for loop on the ward_numbers array.

I hope this is clear sir.

sorry for bad drawing.

 


akshayvaidya wrote:

Hello sir, thanks for the response. I have made the user parameter but I am facing problem, user parameter is not fetching the dynamic value that I am trying to apply through command line, it is only considering default value.command line

sorry user parameter name is not ward it is Ward_no.

 


redgeographics
Celebrity
Forum|alt.badge.img+50
akshayvaidya wrote:

Hello sir, thanks for the response. I have made the user parameter but I am facing problem, user parameter is not fetching the dynamic value that I am trying to apply through command line, it is only considering default value.command line

Okay, so then you must make sure it's named Ward_no in the workspace.


Hello sir, I have changed the name but still it is not working.

 


redgeographics
Celebrity
Forum|alt.badge.img+50
akshayvaidya wrote:

Hello sir, I have changed the name but still it is not working.

 

Can you show me (screenshots) how you have set up the parameter in the workspace and where you are using it?

 

Can you also check the logfile, near the top it should list all the parameters and their values, that way you can doublecheck what value is passed on through the command line.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings