Skip to main content
Archived

Add "Force table creation" to list of table handling options

Related products:FME Form
  • February 5, 2020
  • 3 replies
  • 53 views

lifalin2016
Influencer
Forum|alt.badge.img+40

This may have been suggested in the past, but I can't seem to find any mentions, and it's still a good idea.

When translating data to a database of any kind, FME will create the needed tables to accomadate the translated data. If no data is processed to a given destination, no tables are created.

So, FME knows how to create the table, but doesn't due to lack of data.

The often proposed work-around (create a dummy feature, and delete it) is really not good, and is more of a hack than a solution.

If an additional option (Force table creation) was available, when the attribute definition is fixed (manual), which is often the case when using "Generate" to create the workspace, transferring a full database would be a much easier task. FME should then just process all writers without data, and create the table if it has a fixed schema.

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.

3 replies

chriswilson
Enthusiast
Forum|alt.badge.img+22
  • Enthusiast
  • February 6, 2020

lifalin2016
Influencer
Forum|alt.badge.img+40
  • Author
  • Influencer
  • February 18, 2020

Right you are. I did search, but there are obviously many ways of describing the same feature request, hence I missed it. But it doesn't seem to get much support ?


chriswilson
Enthusiast
Forum|alt.badge.img+22
  • Enthusiast
  • February 21, 2020

All good. There's support but not everyone needs to do this and there's a workaround involving arcpy's truncate method after writing. I'm sure those awesome Safers will get it done in good time :).