Skip to main content
Question

Set user parameters from Excel file / 'Read Form Control as Cell Value' parameter ?

  • June 6, 2023
  • 1 reply
  • 40 views
M
Forum|alt.badge.img

Dear All,

 

I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ?

 

Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success...

 

Any help would be welcome !

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+51
  • hkingsburyCelebrity
  • Celebrity
  • June 7, 2023

One approach would be to set this up in a child/parent relationship.

 

The child workspace (being the one you're wanting to run) will be run using a workspace runner in the parent workspace. The parent workspace will read in the excel document with you required parameters and pass them through to the workspace runner

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,436
Replies
38,764
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.