Hello.

I am in need of dynamically moving data from one spatialite database to another.

Both of these databases (.gigdb files) in this case use same schema. However in the example files I have attached one file (DTMK-2022_07_1.gigdb) has one more feature in feature type (table) a0100000321 than the other file. I would like to copy this extra feature to the second file, same table name.

I have encountered several problems.

Our company uses FME 2021.1.2 -> there the now obsolete spatialite writer does not allow me to create uppercase / camelcase attribute names, so even when manually creating attributes in the writer, it does not allow me to and then I lose them in the translation. Dynamic writing also converts them to lowercase and I get plenty of error messages saying that my schema does not match.

Now my second problem: I am trying FME 2022, just released. When trying the new Spatialite writer, now I get correct attribute names, so that appears to be fixed, however I cannot figure out, how to force geometry to be also written. Each and every time I have tried something, I get only attributes and nothing written in the geometry column, when writing dynamically or even when using automatic attribute creation. When creating "new" spatialite file, it works and geometry is created, however when I try to write into one of these files, it simply does not get created and I am getting really desperate.

Any help would be really welcome.

Thanks,

Radek