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)

  • July 22, 2015
  • 2 replies
  • 60 views
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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Celebrity
  • takashiCelebrity
  • 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
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
ahmad_saleh
Forum|alt.badge.img
  • ahmad_saleh
  • Author
  • July 23, 2015
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

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.