Skip to main content
Question

Copying individual changed values from one geopackage to another

G

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

2 replies

kailinatsafe
Safer
Forum|alt.badge.img+19

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.

G
kailinatsafe wrote:

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?

1 Attachments

Reply


Helpful Members This Week

Community Stats

30,942
Posts
117,252
Replies
38,742
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.