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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.