Skip to main content
Open

Respecting field name length limitations and reserved keywords per feature write

Related products:Integrations
  • July 22, 2020
  • 0 replies
  • 13 views

embeezy
Participant
Forum|alt.badge.img+7

***Note from Migration:***

Original Title was: Respecting field name length limitations and reserved keywords per feature writer type


1) Field name length

As the maximum length of a field name in various formats is known (databases, shapefile, etc), it would be very helpful if FME Writers validated this on attributes entered.

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htm
https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/enterprise-geodatabase-limits.htm
https://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-file-gdb/file-geodatabase-size-and-name-limits.htm

2) DB Keywords

In a similar fashion, there are reserved keywords which can't be used as field names in many formats - this could also be validated on writers.
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15

Error messaging for this in the translation log could also be clearer.