hi,
I'm trying to load data from a WFS service into a database.
The WFS service contains 25 feature types (tables) with a total of more than 153,000 features.
Here is my FME workspace:
Creator
HttpCaller (retrieves the list of layers)
PythonCaller (extracts the 25 FeatureType layer names)
HttpCaller (GetFeature request using typeNames=<layer>)
PythonCaller (retrieves the numberMatched and numberReturned values for each layer)
Tester (numberMatched == numberReturned)
PythonCaller (retrieves the features, transforms the geometry, etc.)
Counter
AttributeManager (adds a unique ID using the counter)
SchemaScanner (collects the 25 schemas with their attributes, along with the 153,000 features)
FeatureWriter
The issue is that the FeatureWriter doesn't correctly associate each schema with its corresponding features.
If I insert a Sorter transformer before the FeatureWriter, the workspace runs successfully, but all attributes end up being written to every table instead of only the attributes that belong to each schema.
Has anyone encountered this issue before, or is there a better approach to dynamically writing multiple schemas and their corresponding features with the FeatureWriter?
