Question

Is it possible to read & write empty feature classes using FME

H

I am using "Esri Geodatabase (ArcSDE Geodb)" reader and writer (For read and write features dynamically), but empty feature classes not listing under feature types.

2 replies

j.botterill
Rank
Userlevel 2
Badge +19

Hi hakkeem85, a few questions

Which version are you using?

You are using an SDE connection file, so can you confirm it is connecting properly from ArcGIS.

Do you have ESRI database edition FME license?

Can you include a few screen grabs

 

david_r
Rank
Userlevel 4

It's a bit complicated since FME is using the features themselves to trigger behavior such as creating a feature class. This means that if there is no feature (no trigger), then no feature class is created.

I've previously worked around it as follows:

  • NoFeaturesTester (from the FME Hub) and create a dummy feature for each feature class if none exist. This dummy feature then triggers the feature class creation. Make sure that the dummy features have some identifying trait that you can use to isolate them later.
  • Writer all features (not just the dummy features) with one or several FeatureWriters rather than the "classic" writers
  • After the FeatureWriter(s), use something like the SQLExecutor or DatabaseDeleter to delete all dummy features.

It's pretty roundabout, but it works.

Reply


Community Stats

28,731
Posts
109,530
Replies
36,565
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.