Skip to main content

Hello, I have to integrate geopackages in PostGIS tables whose schemas are strictly defined. After a first loading of the tables, I restarted the processing with the same geopoackages and all the objects do not leave through the "Unchanged" port. On closer inspection, some numeric values are formatted differently: for example, 20 in the geopackage (read as Real64 by FME) and 20.0 in the PostGIS table (numeric 5,1). Some decimal numbers also exist in geopackages (2.5 for example). Can you explain to me how I can handle this problem. I looked with StringFormatter but am not sure which syntax to use. Thank you!

To change from float to integer/numeric use AttributeRounder followed by StringFormatter with Format Sting set to "d".

In your PostGIS writer set the attribute as integer/numeric.


Reply