FME Form

I'm trying to replicate an analysis in FME that we have done both Esri and GDAL Zonal Stats tools. It is pretty basic. I have a single band raster layer of percent tree cover spanning the contiguous US. I need to summarize that data at the tract level. I.e. what is the mean tree cover for each tract within the US. I get identical results when doing the analysis with Zonal Statistics in Esri and GDAL. When I conduct a similar analysis in FME by clipping the raster to the tracts (merging attributes) and then use the RasterStatisticsCalculator on the result, I get a completely different answer. 

is there a way I can only display "Translation parameter values" window when I run a process via quick translator ? The background window "FME Quick Translator" somehow is redundand I think since I dont need it.   

Hi, I have installed FME desktop and server, my organization has a license server that i was able to define for the desktop client, but, i am unsure how to configure the FME server instance to that license server?  Is it not meant to work that way? Thanks, Jared

Used arcmap to import xml of data schema only from arcsde into a file geodatabase. Using esri geodatabase (ArcSDE Geodb) reader to esri geodatabase (file geodb). receiving error message:An error occurred while attempting to open an insert cursor on the table 'Beacons'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [Beacons]}  

The data needs to output from Row 5 cell A to U. I can see you can use the start position of 5 which works but everything above get's wiped out so I loose the headers. How to I stop loosing the titles and headers from the output in Excel in FME?

I have tried to convert an IFC file to Cesium 3D Tiles with the Cesium 3D Tiles writer.This results in one JSON file and one or more B3DM files (depending on the IFC file structure).When I try to add the JSON and B3DM file(s) to Cesium ion, the model does not appear. How can I fix this?Is there another method to convert IFC files to 3D Tiles with FME?

Hi everyone,I'm trying to restore a arcgis polygon feature layer (feature 1) (that someone accidently ran a simplify geometry tool on) with the geometry of a backup feature layer (feature 2) from a older copy of the dataset. Problem is that I ONLY want to replace the geometry of feature1 and keep the attributes. The workbench that I build (see picture below) will replace both the geometry and the feature values/attributes of feature 1 Any tips on ONLY replacing the geometry? thanks in advance. 

Attribute Splitter and List Exploder? or is there a better way?

Hello,I'd like to use feature attribute in another function. something likeclass FeatureProcessor:  def __init__(self):    pass  def input(self, feature):    col1 = feature.getAttribute('col1')    col2 = feature.getAttribute('col2')    self.pyoutput(feature)  def close(self):    passdef myFunction(col1,col2) another code etc.  I do not know how I can get attributes col1 and col2 to use it in another function.. (first time using python caller) .. thanks for help.

I'm trying to update/delete from an SDE featureclass using fme_db_operation, The changes are grouped in 4 groups: 2 delete and 2 updates. The Deletes work fine, the first update group (updates both geometry and attributes) works fine.But the the last update group (updates only attributes) does not write data to DB. There is no errors, there is 5 exspected warnings (non existing keys) but for the rest of the +70.000 records there is no indication of anything is wrong - except the data is not updated.Best regards  

i need to reprojection from (wgs1984-utm-zone39n) to (KSA-GRF17 )but don't find KSA-GRF17 in coordinate system?

I want to merge small polygon (<0.01) to adjacent large polygon same the same commune. Could you tell me how to make it? Thank you

This is how I get after entering the portal in which my fme server is running.There is a 401 error initially in the console and then also 503 and 500 

The workflow looks like this: I'm downloading a .zip file via an API and unzipping it using the ZipExtractor. Connecting the ZipExtractor 'File' output to a Feature reader, I was hoping to be able to upload the gpkg-file from 5 different output ports to 5 tables in a postgis database. This works fine if I specify the geopackage file manually in the 'Output' section of the feature reader. Is there a way to use a transformer or to edit the FeatureReader to make it read the output ports directly/automatically from the gpkg-file in the folder the ZipExtractor has unzipped?  Thanks!  /Alex

Hi All, Does anyone have any experience getting a pointcloud out of PostGIS? We're using the PostgreSQL extension "Pointcloud" - https://github.com/pgpointcloud/pointcloud  Currently the data is stored in pcpatch data types and we extract it with pc_explode(column)::geometry. This returns to FME all of the individual points which if desired we can then recombine into a pointcloud.  But is there a way to get a pointcloud out *as* a pointcloud? I've tried PC_AsText, but the JSON it returns isn't GeoJSON so I can't just feed it straight into a GeometryReplacer. And there's no PC_AsBinary for the pcpatch datatype.  Anyone have any thoughts or experiences with this? Thanks, Jonathan

Hello, I have a wms that I'm clipping with a polygon bounding geometry. It work but the problem is that FME don't refresh the maps to the level of zooming of my bounding geometry. So It cut the whole planisphere and I have only one giant pixel as result of clipping ... how can I do to have a a detailed map ? Here is url if you want to test : http://ows.terrestris.de/osm/service

Hello Sir/ Madam, My goal is to run a batch processing so that I can count all the attributes in each input excel file in a particular folder. Then, I would like to output the result in a single excel file. Is it possible? My caseData - 2 excel files: A.xlsx & B.xlsxWorkbench: "Value count" by using statisticCalculator transformerOutput : 1 single excel file Problems that I encountered:1) I try to run the "Batch Deploy" in the workbench and it returns the result files indivdually. Can I group all the output into a single excel file? 2) In my workbench, May I ask how can I count all the attributes values? The "StatisticsCalculator" must defined the attribute name in order to do the counting. However, I would like count all the attributes in the excel file. It is because my input excel files may have slightly different attribute names in it. Thank you very much. Zachary

When writing data to a zip shp. file often the data doesnt comply with the 3 decimal points put down in the CoordinateRounder. It usually ends in a couple decimals and then ending on 00001. In the AttributeRounder description it states that this is an issue that can occur: The CoordinateRounder may not always behave as expected, due to known limitations in floating-point computing. I am looking for a way to always make coordinates end on 3 decimals. The data comes from an Oracle Spatial reader, which after some transformers, goes through a Generalizer and then a CoordinateRounder before writing the data as a zip shp. Hopefully anyone here can help me out?

Hi I need some help with parsing the json response from the rest server api /transformations/jobs/completed with parameter competedState: failed What I want is a complete table with all attributes except TMI and NMI Directives. From PublishedParameters I only need subsorter and its corresponding value. This is a problem I cant solve. As it is now I can get subsorter and its value but no other attributes like "timeStarted". It would be great if it was possible to parse the whole json file and get a nice table with only 1 fragmenter. I attached a workspace where the json code is embedded as an attribute. Thanks in advance if someone could point me in the right direction. 

Could anyone help me understand why I get the following error. It currently occurs at a junction but if I replace the junction with a normal connector then it just occurs elsewhere so it doesn't seem to be related to the transformer. Junction_139_Output Feature Recorder -1 2147615843 (RecorderFactory): File C:\\Program Files\\FME\\metafile\\ffs.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\ffs.fmf could not be opened I've tried running FME as an administrator in case that helped but got the same result. I also googled and found a similar issue but that related to just \\.fmf file and was apparently caused by databasejoiner which I'm not using. I've also uninstalled and reinstalled FME. If I disable feature caching then the workspace runs fine but that means I can't debug anything unfortunately.

Hello!  I have a CityGML dataset consisting of MultiSurfaces - atleast that is what FME tells me:  an example of a surface:  I would like to extract the surfaces' triangles, so each triangle has its own feature/record in the output.  So far i have tried 3 methods: using the deaggregator. Looks like it didnt do anything. using the geometryPartExtractor. I have extracted the "IFMEface" geometry-type from the surface, but this just looks like original geometry, where all triangles are one geometry. Afterwards i added another geometryPartextractor and tried to extract the IFMEPolygon - but this seemed to just remove the triangles from the geometry. using the Triangulator. Using the triangles output, input these into a geometryPartExtractor where you extract the newly created faces. This worked somewhat, however the triangles it made do not always correspond with the original triangles. the example from above gets a new triangle: If possible i would like the original triangles

Hi! I'm trying to download a .zip-file using HTTPCaller. The zip-file is accessed via API by an order number generated when I placed the order for the data.  The response body looks like this: [{"href":"https://download-geotorget.lantmateriet.se/download/99d120aa-9532-43a9-a5a7-6128b333bc88/files/root/anlaggningsomrade_kn0125.zip?q=_9yzl22V_4v728pM........"}] (shortened down, was way to long to post here).  The 'anlaggningsomrade_kn0125.zip' is what I'm after. Is this possible? Any help is much appreciated 🙂   

Having recently disabled older SSL & TLS versions on our servers, fme desktop/server sql connections have broken. The workaround for other applications was installing OLE DB v19. I've tested this using a blank .udl file and confirmed it works creating a db connection with v19 but not the other. How do i get fme desktop/server to recognize this new version? As the error still suggests its using the basic oledb driver. The connection string fme complains about i think should have'provider' set to MSOLEDBSQL19 instead of just MSOLEDBSQL Any suggestions are appreciated! 🙂

Hi,I have a question regarding the AreaGapAndOverlapCleaner and I dont know how to solve my problem...I have multiple polygon layer which I want to overlay. The lines of the polygons are not totally coincident as different data sources are used. Many sliver polygons are created when the layers are overlayed. I would like to remove these small sliver polygons with the AreaGapAndOverlap Cleaner (it does it job well - I used a tolerance of 1 m). My only problem is, that the AreaGapAndOverlapCleaner itself creates some little gaps between the polygons. Is there a way to prevent the transformer from doing it? Using Fill All Gaps does not make sense in this case, as there are some big gaps (exclaves) that I want to keep. Do you have any idea to prevent the AreaGapAndOverlapCleaner from creating gaps? Or is there any other transformer which suits better?Thank you!