Skip to main content
  • EN

I use FTPCaller to download zip files from a vendor FTP site. The number and name of the zip files can vary. Each zip file has one ESRI file geodb and its name can also vary. I have no problem downloading those zip files and unzip them. I want to load all the feature classes/tables in a file geodb into ArcSDE. As the object names in the file geodatabase can vary, I tried to use one FeatureReader with "Esri Geodatabase (File Geodb Open API)" to retrieve the feature type names, and then use a second

FeatureReader with "Generic (Amy Format)" to retrieve the Schema and Data Features. However, in the Data Inspector, I can see the features, but not the feature schema. If connect the 2nd FeatureReader to a dynamic file geodatabase, I will get the error like "

Unable to find the schema definition 'di_LegalLease' for feature with feature type name 'di_LegalLease'. Ensure the feature type name is correct and that its schema definition exists in the schema source

A fatal error has occurred. Check the logfile above for details"

See attached fwmt file. What is the best way to do this?

The key to doing this is, when creating the reader, to select "single merged feature type"

This will read any table in the GDB and output it into the same table (using fanout on fme_feature_type) in the geodatabase.

The key to doing this is, when creating the reader, to select "single merged feature type"

This will read any table in the GDB and output it into the same table (using fanout on fme_feature_type) in the geodatabase.

@erik_jan I can't use this "static" reader as the Dataset does not allow specifying a parameter. My file database is dynamic in both name and location

 

OK. I make this work by using three ArcSDE gdb writers with Dynamic Schema Definition turned off and the feature class = @UpperCase(@Value(fme_feature_type)) and the Geometry set to geodb_polygon/line/point, each connecting to a port by an attribute filter on fme_geometry. The fme_geometry is exposed on the Generic Port of the FeatureReader. Works great.

Reply


Community Stats

30,194
Posts
114,613
Replies
37,855
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.