Skip to main content
  • EN

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


Community Stats

30,167
Posts
114,519
Replies
37,824
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.