Skip to main content
  • EN

Hello, I have a rather simple request for which I am not finding a solution.

 

I have a Geopackage (multi-polygon geometry with table) already populated with data, let's call it "version 1".

 

This Geopackage is copied and a manual update of some values contained in only 3 columns (out of the total 20) is performed, at attribute level only, let's call it "version 2".

 

My request with FME is to copy the table values that have only been updated in the 3 columns from the 'version 2' geopackage to the original 'version 1' geopackage.

 

Thanks to "ChangeDetector" we were able to compare and isolate these cases, but we cannot "write the update" in the "version 1" geopackage.

 

But, an additional condition to be introduced would be that to "write" the value to the "version 1" table, the field there before the change must be "null"

 

Thank you

Hello @gattoarturo​, thanks for posting! So it sounds like you've successfully used the ChangeDetector to identify differences between 'Geopackage version 1' and 'Geopackage version 2'?

Is the goal now to write updates back to 'Geopackage version 1'?

Can you elaborate on what is meant by "we cannot write the updates"? Are you seeing any errors or warnings in the logfile? If so, are you able to share a logfile please? Otherwise, it may be helpful to see how your workflow is set up, and how the writer is configured! Happy to help, Kailin.

Hello @gattoarturo​, thanks for posting! So it sounds like you've successfully used the ChangeDetector to identify differences between 'Geopackage version 1' and 'Geopackage version 2'?

Is the goal now to write updates back to 'Geopackage version 1'?

Can you elaborate on what is meant by "we cannot write the updates"? Are you seeing any errors or warnings in the logfile? If so, are you able to share a logfile please? Otherwise, it may be helpful to see how your workflow is set up, and how the writer is configured! Happy to help, Kailin.

Hi, thank you for the reply.

Yes there is only an error in the logfile at the time it "writes", below the log:

  • 2023-09-08 08:54:51|  0.2| 0.0|ERROR |OGCGEOPACKAGE writer: Unable to write to feature type 'Analisi edifici'. The table handling method is 'USE_EXISTING', but the feature type does not exist
  • 2023-09-08 08:54:51|  0.2| 0.0|ERROR |OGCGEOPACKAGE writer: An error has occurred. Check the logfile above for details

 

I attach the FMW workflow.

 

It is not clear why the "change detector" correctly detects 5 items but then only proposes 1 item in the output.

 

Basically, the intention is to compare two versions of the same geopackage and write in version 1 the changes made only on certain fields by version 2 to version 1. Maybe there are alternative tools?

Reply


Community Stats

30,162
Posts
114,482
Replies
37,809
Members
Terms & ConditionsCookie settings
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.