Skip to main content
  • EN
I have written a script that extracts information from a DB using python. I want this to be a published parameter list. For instance:

 

 

FeatureType: Bus, Car

 

 

And when run after 10 minutes it might be:

 

 

FeatureType: Car, Train

 

 

Depending on how this database looks like.

 

 

Is it possible to use a scripted parameter for this. Or use a startup python script tp generate a published parameter? If I am correct the STartup pythonscript gets executed BEFORE the published parameters? 

 

 
Hi,

 

 

have a look at this: http://safecommunity.force.com/CommunityAnswers?id=906a0000000d27zAAA

 

 

David
Hi! I found alot of articles - but did not find this. Thanks! I did not like the answer though.. 😛 And it should also work on FME Server....
Heisann,

 

 

Yeah, not too fond of either solution either, but unfortunately this isn't supported out of the box and as a consequence the solutions are pretty hacky.

 

 

There is no way of getting dynamic parameter lists to work on FME Server, as far as I know.

 

 

David
I`m thinking a workaround is to run a workspace every minute on FME Server to generate a *.txtfile with the options. And then just let the user know that the dropdown-list is 1 minute old... Or a pythonscript outside of FME generating a *.txtfile as a resource in FME Server that get read on a workspacestartup
Generating the text file is easy. But how're you going to get it into the list of values for the published parameter?
Hm, thought I had it figured out.... too late on a friday I guess....
I guess the pythonscript have to edit the *.fmw - file directly. thats interesting....
Let me know if you're successful in editing a live .fmw on FME Server! :-)

 

 
or simply create the html- file on the fly with the dynamic drop down list?
Has there been any progress on this in FME 2018?

 

 

Has there been any progress on this in FME 2018?

 

 

@jimo I'm not aware of this being a feature in FME, this would be best tracked as an idea to show any updates on it. It looks like these are similar: https://knowledge.safe.com/content/idea/27512/dynamic-lookup-parameter.html

 

https://knowledge.safe.com/content/idea/25358/richer-user-parameters-prompt-ui.html

 

so it may be worth adding your specific use cases here

 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie 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.