Solved

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

Forum|Forum|7 years ago
January 18, 2018
3 replies
32 views

alex_chris

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:

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.