Skip to main content
Solved

SpatiaLite

  • July 24, 2015
  • 1 reply
  • 19 views
B
Forum|alt.badge.img
I'm trying to read a SpatiaLite table with a Primary Key Unique ID (PKUID) field, made in QGIS. All the fields of the SpatiaLite table can be read, except for this PKUID field. Even an AttributeExposer does not do the trick. Is there a reason for this?

 

 

For the moment, I created a workaround: I read the table, together with the spatial data, in a SpatiaLite reader. Then I read the same table in an SQLite reader, which can detect the PKUID field, but does not contain the spatial data. A FeatureMerger does the rest.

Best answer by brianatsafe

Hi @bakkermans,

I am writing to let you know that this issue should be fixed in the latest beta of FME 2017 (b#17159). If you have any issues with the fix please do let us know.

 

 

One note here is that the attribute won't come up as "PKUID" or alike. It will come up as a "spatialite_id" format attribute instead.

Regards,

 

Brian

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.

1 reply

brianatsafe
Safer
Forum|alt.badge.img+13
  • brianatsafeSafer
  • Safer
  • Best Answer
  • November 19, 2016

Hi @bakkermans,

I am writing to let you know that this issue should be fixed in the latest beta of FME 2017 (b#17159). If you have any issues with the fix please do let us know.

 

 

One note here is that the attribute won't come up as "PKUID" or alike. It will come up as a "spatialite_id" format attribute instead.

Regards,

 

Brian

Community Stats

32,154
Posts
122,047
Replies
39,812
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.