Skip to main content
Solved

Get the user to select schema and tables from list before workspace execution


Forum|alt.badge.img

Hello,

I am looking for an easy way to get the user select the tables that they want to read and translate before the workspace runs. Is there an easy way to set this up using FME transformers or it has to be done resorting to other methods (i.e python scripting with specific postgis drivers) and if so, could I get some help on how to accomplish this?

At the moment I have a creator, an SQL executor that extracts all tables from the schema I want the tables to be selected from, how can I convert this list into a parameter and then let the user select the tables they want to be then submitted to the PostGIS (or generic reader maybe) to then work with only that subset of tables?

Best answer by oscard

Use a FeatureReader transformer and create a User Parameter with the parameter "Feature Types to Read"

That way the user will be prompted with a window to choose the tables to read:

View original
Did this help you find an answer to your question?

oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • January 18, 2018

Use a FeatureReader transformer and create a User Parameter with the parameter "Feature Types to Read"

That way the user will be prompted with a window to choose the tables to read:


Forum|alt.badge.img

Yes @oscard it works thanks


oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • January 19, 2018
alex_chris wrote:

Yes @oscard it works thanks

Glad I could help!

 

 


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