Transformers

I'm working with a JSON file that is a form configuration. Users complete the form through a company website and there are lots of conditional questions and picklists embedded within questions. It's a real nesting doll of data.  Our form system has gotten bloated so I am taking redundant forms and creating one normalized form, but first I need to break down the configuration of each form and represent it in a CSV format so I can easily see the flow of questions and their sub questions. So far I have been able to download the JSON file, add a reader and perform a couple transformations (reader > list_populator > attribute_keeper > list_exploder > list_builder) to isolate the overarching questions and organize each by an index number (the order which they appear in the form). In total there are 8 main branches of questions, but each of those has dozens of nested sub-layers that go deeper and deeper; many of which are long picklists.  F

Hi. I have a DGN file with exploded symbols (img 1).I need to make one line from these 3 following lines and fill the gaps between these lines.Firstly I use Snapper (snapping tolerance set to 2 because gaps are about 1.7) and then LineCombiner. It works well with my test data but at real DGN it works wrong (img 2). I do not want involve marker ("circle" with short line) to process.Thanks.

Does anyone know how to generate a map with FME, I met a resolution issue when creating base map. The wms link looks good in QGIS, but when use FeatureReader in FME, use bbox to get the wanted are, the resolution is super low.

I have a large dataset of points (~21m) with an attribute column that identifies one of 540 groups that they belong to. I need to create a set of polygons that contain all the points in each group and then buffer these polygons so that there are no overlaps or gaps between them. I've tried creating voronoi of the individual points and then dissolving by group, but this was incredibly slow and seemed to generate odd results. The alternative approach I tried was using HullAccumulator by group, which was very fast but I can't think of any way to get around the gaps. Any help much appreciated.

Also "MULTIPOLYGON (((4.9086662233849 52.753664580098, 4.9151035250207 52.749014947513, 4.9148889482994 52.748742188294, 4.9156828821679 52.748157698504, 4.9128719271203 52.746547063843, 4.9067350328942 52.750989153809, 4.9072071016808 52.751261898961, 4.905790895321 52.752222987318, 4.9086662233849 52.753664580098)))"can i create a geometry with this data?

Hi everyone, I have split a pt cloud into 2 : Ground and Rest (Ceiling and Beams). and I would like now to calculate the minimum verticale distance (along z axis) between the 2 clouds. to avoid false results with the beams i want to eliminate any results smaller than 2meters. I am a little bit new on FME and i don't know which transformers would be best for this operation if it's doable. Thank you

I have two datasets, where one (a) is holding x/y/z coordinates and the other (b) contains a distance value. I created a line, based on the coordinates from dataset a, and after densifying the line used a measure to get values I can compare to the distance values provided by dataset b. The distance and measure values are not perfect matches, and I would like to accumulate the attributes from dataset b to dataset a based on an a rule like the following: IF 'ref_length' >= 'start_length' AND 'ref_length' < 'end_length' This is what I have so far 

I am looking to use the output of the postgres/postgis function as an input to my fme workbench model, I want to pass the parameter to such postgres function through fme workbench interface and want to use the output generated after running the function .

Hello! I have problem to write several geopackage data to one geodatabase. I used Attribute filter and Dynamic writers. Attributes from all objects comes to each features. How to write data to geodatabase so that there are each features has own attributes? I am not profs with FME yet :) Would be thankful for tips.

Hello, I'm attempting to use an attribute with HTML as a value into the HTML2PDFConverter. What's odd is that said transformer asks where the HTML will originate from (a file, attribute, or URL), but when you select one of those options, it's still asking for the other two as a requirement. Is this a bug?     

Hi all!I'm reading spatial data from a MapServer hosted in organizations ArcGIS Portal. The query is made with HTTPCaller, and the response is in EsriJSON (by default). I then extract the "geometry" part of the response json, as well as some other attributes from the response, with PythonCaller and replace the geometry with GeometryReplacer to FME Feature Geometry, so that I can perform other spatial tasks with FME later in the translation.  However, I noticed that some polygons returned from the query contains holes inside of them, or they should contain (this is confirmed from the source data), but after the GeometryReplacer, the holes are not holes, but filled with a polygon, and the Geometry returned is a multiarea with polygon part of it on top of the polygon itself! This behaviour happens, when the Geometry source encoding is EsriJSON. The MapServer can be queried so, that the response format is in GeoJSON, and whe

I've created a workspace to call a lot of wms services - and I'm not getting the right response. When I copy the URL to a browser the %EF%BB%BF appears in my string - this I cannot se within FME. How can I fix this ?

Hi, I want to simplify some line geometries which may be single or multi part IF their coordinate count is greater than a fixed value. Is there a simple way that I can apply a generalisation based of max resultant coordinate count rather than a tolerance setting where the post generalisation coordinate count will not be know until until after the generalisation has been applied. In the latter situation if the count still exceeds my threshold the tolerance would have to be increased, and generalised once or multiple times? I was interested to know if I could go straight to my max value rather than having to create a looped process? I am using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64)  Ultimately I want to create a WKT Geom encode which does not exceed a fixed string length. For this I know that each line should have no more than ~1250 vertices, so I want to simplify the line to this number if the coordinat

So essentially the lines are the boundary of this polygon. I have tried spatial relator which only sometimes gives me a 1 to many join on every other line, I tried neighborfinder but I can get the attributes to copy over. I have specified merged attributes but it doesn't seem to be working. Not sure what I am doing wrong and help will be appreciated. The images show what I would like to achieve in FME.

Hi everyone.I am trying to obtain a csv file with some information about several raster files. One of the attributes I need to get is the number of pixels with a determined value (in my case I need, among others, two attributes for each raster: the number of pixels with value=0 and with value=255). Is there any transformer for that?Thanks!

I have some Autocad data where the objects are constructed as 3D solids, like this:The 3D data is nice for many uses, but I would also like to extract a simplified version for our GIS databases. The Surface Footprint Replacer will generate a nice polygon, but will also remove the elevation and return 2D data.  Is there a way to get a footprint that retains the elevations of the "top face" of the solid? I most cases this face is flat, but in some cases, like ducts and pipes, this is not the case.

When I am trying to open GPKG file, I am receiving the following error: Workspace generation failed. Parameter file was C:\\Users\\MITINA~1.UPW\\AppData\\Local\\Temp\\FME_1695313458867_14324. I have tried reinstalling the software.

I have a workspace writes data from one ArcGIS database to another. I used the drop and create option on tthe tableI get the error , [DDL operations are not allowed across database boundaries.]} My question is how can ArcGIS allow you to drop a table but not create it again? This was very inconvenient. Is there anyway to stop FME from droping the table if it does not have the permission to create a new table?Best regards,Kicki M My error message:Geodatabase Writer: Dropping table/feature class `DBO.GVF_GEOM_TMP'Geodatabase Writer: Creating feature class `DBO.GVF_GEOM_TMP' in feature dataset 'gdbhmag.DBO.hmag'An error occurred while attempting to create the feature class 'DBO.GVF_GEOM_TMP'. The error number from ArcObjects is: '-2147220989'. The error message from ArcObjects is: {The operation is not supported by this implementation. [DDL operations are not allowed across database boundarie

I have two data sets - one is a 'main' dataset and the other is a 'lookup' dataset containing further information. In my main dataset I have a columns called 'Visibility' and 'road_condition' that contain a range of values from 1-13. There are over 4000 rows in the dataset. In my lookup dataset, I have 'code' and 'Column' columns that contain further information relating to each record in the main dataset. See screenshots of the data below.  Is there a way to create new columns in the main dataset called 'Visibility_Info' and 'Road_Condition_Info' that merges the data from the main and lookup datasets together without filtering each of the values in the 'Column' column individually before passing the data through to a FeatureMerger?

I need to write a couple of 100 tables from postgis into several geopackage files. This should be a pretty simple job? But the workbench fail OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int' This is related to https://community.safe.com/s/question/0D54Q00009SAyLQSA1/geopackage-dynamic-writer-error-unsupported-type-mediumint?t=1669103461721 and a follow up

I am having problems using the FME Define custom Coordinate System Tool (demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw).​I want to make the ITRF2014 coordinate system that is in ESRI available in FME. I have used this ESRI WKT file from ITRF2014 - EPSG:9000 :​GEOGCS["ITRF2014", DATUM["International_Terrestrial_Reference_Frame_2014", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]]​However, when I test the new coordsys files I get errors. Any help in tracking

 Hello Forum, I notice that when FME Form convert a dataset from one format (e.g.: .tab) to geopackage it adds a field called 'id'. So, two questions: 1) Do geopackage files always have, and have to have, an id field?2) Or is there a way of asking FME Form to not create one/delete it? It doesn’t seem possible via an AttributeManager or in the Writer’s User Attributes. I've noticed that, separately, if I read in the created geopackage I can then use an AttributeManager to remove the id field and then publish again. But there are two problems with this… 1) It's a faff. I'd rather not read in, write out, read in, and write out again. But..2) even after removing the id field via an AttributeManager, the id field always appears in the output geopackage file. This makes me wonder if an id field must always exist in geopackage files.  I've also noticed that when creating geojs

Hello,Has anyone faced issues while trying to read DGN files (V7 or V8) in FME 2022? My current version is FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64). Below an screenshot of the error:I have tried to changed the reading parameters but still unable to read it. Also I have loaded the same DGN onto FME 2020 and works fine.Can this be a bug in the 2022 version?

I am trying to read a parquet file with the "FeatureReader" transformer and I have no problems doing so. However, the three columns that I have in my parquet file, which are datetimes [ns], do not appear in the parquet. If I use an "Attribute Exposer" I can't get them either, they seem to come as "missing". Any alternative in this regard?