Hey Everybody,
In my work, I generally get the question from clients to build a FME Server Web Application. Often, the question involves a MS Excel file, which needs to be analyses and converted to points/lines/polygons (GIS). Mostly, I use a Creator to kick-off the Workspace and a FeatureReader to load in the Excel. Also, I force the FeatureReader to have one single output port (Generic) and load in the Excel file using a User Parameter when kicking off the Workspace. This means that I need to Expose all attributes individually in the Workspace.
However, this limits the flexibility. When I want to create a Web App from the Workspace, the input Excel always needs to have the same columns (so a Template Excel as input). An potential extra column is therefore not exposed an not in the result of the Workspace. However, in some cases, it is for my clients not possible to always use an Excel Template. Or they want to add additional information.
My question therefore is, is it possible to dynamically read in an Excel file with all the existing columns exposed? So that there is no manual actions required and a Web App can be made. To my knowledge, the AttributeExposer doesn't contain a “Expose all” option… Or can I use the Schema output port of the FeatureReader? I don't really understand how I can work with that either...
