Skip to main content
Question

The feature classes written in the file geodatabase form SDE writer are written in improper names (not like if they are copied and pasted)

ahmad_saleh
Forum|alt.badge.img
Hello All,

 

I am using a simple workbench that reads ESRI ArcSDE and writs to a dynamic API file geodatabase, the workbench should work as if I am copying the data stored in SDE file (SQL server ) to a fil Geodatabase, but the issue here is that the FME writes the features with wrong names Not as expected.

 

 

 

The FME workbench adds “DBO” prefix and the type of the feature class as suffix

 

 

Manual copy/past works fine and names the features as intended

 

 

 

Is there any method to truncate the prefix and suffix which is added by the FME to have the names as if I am using copy/past ?

 

 

 

Best regards,

 

Ahmad Saleh

2 replies

takashi
Influencer
  • takashiInfluencer
  • July 22, 2015
Hi Ahmad,

 

 

Try this.

 

Expose "fme_feature_type" in the SDE reader feature type.

 

Copy the value of "fme_feature_type" to a new attribute (e.g. "_feature_class") with an AttributeCopier.

 

Remove the unpreferable prefix from the value of "_feature_class" with a transformer. e.g. StringReplacer.

 

Modify the parameters of the Dynamic FILEGDB writer feature type as below.

 

- Feature Class or Table Name: _feature_class

 

- Geometry: First feature defines geometry type  (this prevents adding the suffix indicating geometry type)

 

- Schema Definition Name: fme_feature_type

 

 

Takashi
ahmad_saleh
Forum|alt.badge.img
Many thanks Takashi, this is really a great help, I have noticed that the FME changes the names to capital letter (Upper case ) and I have tried to use “StringCaseChanger” with Case Change: Title case but the issue here is that my old F.C names was a mixture of Upper and lower case letter e.g: the old name was “UrbanMasterPlans_UMP_DUMP_Edits_Locations” and after using the stringcasechanger the new name became “Urbanmasterplans_ump_dump_edits_locations” is there any method to let the FME store the name of the F.C as it is?.

 

 

 

Thanks,

 

Ahmad Saleh

Reply


Helpful Members This Week

Community Stats

31,175
Posts
118,175
Replies
38,791
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.