Skip to main content
Question

Using the FeatureWriter

  • November 13, 2019
  • 2 replies
  • 74 views
T

I'm using a FeatureWriter to create an Access Database and for the most part I'm very satisfied with the results.

However there are some quirks that I don't understand.

First, I didn't find anyway to update the created database each time I run the FME. I have to first delete the previous table to be able to generate a new one.

Is there a way to automatically update the table with each run of FME?

Secondly, in one instance, while FME shows 8 206 610 rows have been generated, only ~4000 have effectively been written in the Access database. I added an inspector before the FeatureWriter, and the inspector shows 8 206 610 rows.

Any idea on what happenned? what did I missed?

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.

2 replies

jdh
Contributor
Forum|alt.badge.img+40
  • jdhContributor
  • Contributor
  • November 13, 2019

There are parameters to truncate or drop the existing table, they should both be set to No. The writer mode should be Insert to add new records or Update to edit existing records (key attribute must be specified.

 

 

As for the dropped features, the logfile should give an idea. I could speculate that the features were missing a required attribute, or there was a primary key conflict, or the features per transaction might be off enough to cause an issue.
david_r
Celebrity
  • david_rCelebrity
  • November 13, 2019

Have you checked the log for any warnings or unexpected messages that could explain the discrepancy?

You can e.g. use the DatabaseUpdater transformer to update the contents of an existing table. Alternatively you can use the fme_db_operation format attribute, which is documented here: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/DatabaseWriterMode/feature_operations.htm

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.