Skip to main content
Released

Allow writing of empty tables - schema creation

Related products:Integrations
  • May 2, 2019
  • 7 replies
  • 215 views

chriswilson
Enthusiast
Forum|alt.badge.img+22

I need to create a schema in geodatabase format and would love to use FME for this. To avoid writing null or junk features to the tables it would be good to be able to write out a schema without features. I know this defeats the very name of FME if there is no feature, but it would be useful.


On this occasion I'll play with the idea of writing out one feature per table then truncating them all, to achieve the same outcome.

7 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • May 2, 2019

Adding this as a checkbox option on the feature types would be helpful.


aarcra
Contributor
  • Contributor
  • May 22, 2019

bump - I'd like this as well. It would also help to be able to overwrite existing tables/feature services that previously had records, but may no longer. Without this ability, you have to read the existing table the attach delete keyword or use a creator to initiate the writer, to truncate with a blank record (which still needs to be read afterwards again to delete itself.


chriswilson
Enthusiast
Forum|alt.badge.img+22
  • Author
  • Enthusiast
  • May 23, 2019

At present I think either truncating after creation or a shutdown python script to delete the feature is the way to go. A 'schema-only' setting on each writer/feature type would be ideal. currently


LizAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • October 29, 2024
OpenIn Development

LizAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • October 29, 2024
OpenIn Development

LizAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • February 5, 2025
In DevelopmentReleased

LizAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • April 5, 2025
This is now available in FME 2025.0