Skip to main content
Released

Allow writing of empty tables - schema creation

Related products:Integrations
siennaatsafe
danilo_fme
erik_jan
lifalin2016
tcrossman
+23
  • siennaatsafe
    siennaatsafe
  • danilo_fme
    danilo_fme
  • erik_jan
    erik_jan
  • lifalin2016
    lifalin2016
  • tcrossman
    tcrossman
  • bwn
    bwn
  • fgiron
    fgiron
  • kennyo
    kennyo
  • chriswilson
    chriswilson
  • paalped
    paalped
  • nn_sonomacounty
    nn_sonomacounty
  • rdebliek
    rdebliek
  • aarcra
  • r5
    r5
  • mattias
    mattias
  • maryse_bucking
    maryse_bucking
  • jochgem
    jochgem
  • ifitch
  • tiler
    tiler
  • lobsterboy
    lobsterboy
  • hwilson
    hwilson
  • patriciakneen
  • salvaleonrp
    salvaleonrp
  • stevenjh
    stevenjh
  • kole
  • gispro
  • kiahwarren
  • mark2atsafe
    mark2atsafe

chriswilson
Supporter

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+18
  • Contributor
  • May 2, 2019

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


  • 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
Supporter
Forum|alt.badge.img+11
  • Author
  • Supporter
  • 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+15
  • Safer
  • October 29, 2024
OpenIn Development

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

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

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

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