Skip to main content
Archived

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

Related products:FME Form

lifalin2016
Contributor

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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
Supporter
Forum|alt.badge.img+11
  • Supporter
  • February 6, 2020

lifalin2016
Contributor
Forum|alt.badge.img+29
  • Author
  • Contributor
  • 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
Supporter
Forum|alt.badge.img+11
  • Supporter
  • 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 :).


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