FME Form

In postgis i can flatten compound geometries like soSELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('COMPOUNDCURVE (CIRCULARSTRING (576285.49817038781 7034469.7208286244, 576325.10797829565 7034483.5911118472, 576367.02 7034485.76), (576367.02 7034485.76, 576396.53 7034483.05), CIRCULARSTRING (576396.53 7034483.05, 576447.15568394249 7034473.94116881, 576495.46 7034456.26, 576500.76470677822 7034454.0120333815, 576506.21 7034452.13, 576508.88920362911 7034451.3602161128, 576511.59 7034450.67), (576511.59 7034450.67, 576517.82000000007 7034449.45), CIRCULARSTRING (576517.82000000007 7034449.45, 576521.86965882347 7034448.9300352931, 576525.94000000006 7034448.61, 576543.62140925834 7034449.5502338214, 576560.694903961 7034454.2419341141))')))But how do i do the same thing in FME?ArcStroker can only flatten Circular strings, but not compound geometries?

I noticed that the WKT output from GeometryExtractor is not the same as the feature in the source data.If i run Geometri_SPA.STAsText() on a feature from  in SQL Server Management Studio my return is CIRCULARSTRING Z (576285.5719837358 7034448.923522126 0,576284.6966432678 7034459.3191996245 0,576285.4981703878 7034469.720828624 0) But i run the same feature through GeometryExtractor with Geometry Endocing OGC Well Known Text my return isLINESTRING Z (576285.5719837358 7034448.923522126 0,576285.1277140373 7034452.078045797 0,576284.8387646212 7034455.250568986 0,576284.705831592 7034458.433448807 0,576284.729235197 7034461.619017426 0,576284.9089190548 7034464.799600528 0,576285.2444502913 7034467.967535808 0,576285.4981703878 7034469.720828624 0)Why is the geometry type changed by the transformer?I want to identify features of type compoundcurve, circularstring, curverpolygon etc and flatten dem to pure line og polygons. But as for now i am not sure how i can validate the results of

I had a look at this documentation:gtfs-measures/docs/GTFS_Script_Documentation.md at master · VolpeUSDOT/gtfs-measuresAnd it is exactly what I would like to do in FME. I already found the script to create lines from shapes, routes and stop text files, the problem is that those lines follow the stop coordinates. I need it to follow an existing road network. I couldnt get the Python script to work and it is pretty old as well. I tried snapping the bus stops to the road network before I run the script, creating a bus_stops_snapped but it still doesn’t really follow the road network. Any idea of how this would be done? I have the road network as both shp or geoDB.  I creates line using this FME scriptTranslating from GTFS – FME Support Center 

Hello,I am reading a folder with two shapefiles.I am exposing fme_dataset.fme_dataset takes the first values of the two shapefiles and does not change.I’m using FME(R) 2024.2.3.0 (20250130 - Build 24825 - WIN64

Hello everyone, I'm currently imitating this example from FME to generate 3D buildings from 2D polygons, but with my own data. I expected that, being 4 perfect squares, I'd get 24 tiles after running the deaggregator, but instead I have a few more.It looks like some walls have been wrongly divided. I need to "simplify" these parts into an unique wall or else the appearence setter will not correspond. The issue is that I can't seem to find the transformer or process to do this. I've tried changing the parametres to deaggregator and planarityFIlter, I've tried using Orientor and OrientorExtractor, I've been looking for some patterns in the orientation, surface coordinates or other attributes that could allow me to join them together… but none of them have worked. Has anyone got an idea how to solve this?BTW the original 2D polygon comes a FGDB and it's a fme_composite_surface by the time the geometrycoercer is run. The behaviour may be different from Mesh Objects, CityGML or Interpolis,

I have a point cloud with a certain class. This class will be scattered and in clusters within the point cloud, and I want to a) identify these clusters and b) create a point feature layer for the lowest point within these clusters and get the height.  Is this possible with FME? 

I’m using FME 2023.2.I thought I understood parallel processing but clearly there are some intricacies that I don’t understand and I’d appreciate any insights people can provide.I have a custom transformer that processes Lidar tiles and takes some time to run, so I enabled parallel processing and saw some significant performance improvements with my test set of 20 tiles.However, when I enable the full data set of 10,000+ files I get an error:2025-03-28 11:26:41|  63.6|  0.0|ERROR |Could not bind port to socket2025-03-28 11:26:41|  63.6|  0.0|ERROR |Failed to create transporter2025-03-28 11:26:41|  63.6|  0.0|ERROR |TransporterSender (TransporterFactory): An error has occurred. Check the logfile above for details2025-03-28 11:26:41|  63.6|  0.0|ERROR |An error has occurred. Check the logfile above for details2025-03-28 11:26:41|  63.6|  0.0|ERROR |f_25 (TransformFact): Transformer 'ProcessSingleTile': Unable to create worker; try reducing the parallelism level (currently 'MODERATE') or

data source CSV file each day populated with date stamp, my requirement need to load CSV each day to SQL server

Hi,I am new to FME, and I am trying to build an FME workspace that reads multiple .csv files from a folder and write each file to separate table in SQL server. Each CSV file:has different schema should became it is own SQL tableHere is what I tried so far:I used Directory and File Pathnames reader I used Feature ReaderThe <Generic> port of Feature Reader shows no data, I am assuming because the schema of each is different. the <initiator> port give me the correct file name and path.

Hi All,  I have been getting my head around FME Server and Webhooks with Survey123 data collection, and I am loving it! I can competently capture data via a Survey123 form, then trigger some FME automation to manipulate the data and email a specific user results dependant on what was captured in the Survey123 form. This is working well.  I would now love to take this to the next level by using the formal Survey123 Report rest API. So ideally I want to get a copy of the Survey123 report PDF that is generated each time the webhook is triggered, and email this PDF to particular people. I have been searching this forum and I do not see any tutorials or any mention of working with the Survey123 Report API itself. Has anyone had any experience with setting up an automation that works with the ESRI Survey123 Report creation API, that they would be willing to share with me? note: I know with FME I can do pretty much everything the Survey123 report generator can do, in the long run with the doz

The website Dynamic Workflows: Destination Schema is Derived from a Lookup Table > Creating a Table-Based Schema > Geometry Type tells me that valid values for the `geometry_type` column are the values from the `fme_type` format attribute. It provides the full list of values under this link. The link is incorrect. This is the list of FME internal data types. These are NOT valid values from the `fme_type` format attribute and these are NOT values from the `geometry_type` column in the screenshot above in the tutorial.Where is the correct list of values for the `geometry_type` column or the `fme_type` attribute?

Is there a way through FME to automate the creation of plates (3D planar surface), from the following data:XYZ position (centroid) Shape: Always has 4 sides but not necessarily always a rectangle Dimensions info: Width and Length Orientation info: Azimut (DipDIR) and DIP

In the reader file I have multiple full names “John Doe”.  I want to ensure my Writer 1 / Output 1 should only have the first entry of John Doe and the rest of the John Doe entry should be mapped to Writer 2 / Output 2.  Ex.Name Address John Doe 31 xxx st John Doe 41 yyy st John Doe 51 zzz st  John Doe on 31 xxx st should go to output 1, and other two John Doe should go to output 2

I’m trying to add a new database connection (FME Form 2024.2). I haven’t had any problems with this in the past but today the Add Database Connection dialog just freezes when I click Save. I’m able to click the Test… button to test the connection and that works.I’ve tried various connections to various databases and get the same behaviour - I’m able to test the connection successfully but not able to save it, so it does not appear to be a DB connection issue.I suspect it’s a file lock / permission issue on the connections file/DB that is being used but I have rebooted the computer and that did not help. I’m trying to save the connection for my own user (not a shared connection).Has anyone else experienced this and know how to resolve it?

Remove space and Space* from the name ensuring John Doe*/ John Doe * converts to John Doe.  What transformer and parameters should be implemented?  Tried to use the Attribute Trimmer but it only removes either of it. 

Hey Everybody, In my work, I generally get the question from clients to build a FME Server Web Application. Often, the question involves a MS Excel file, which needs to be analyses and converted to points/lines/polygons (GIS). Mostly, I use a Creator to kick-off the Workspace and a FeatureReader to load in the Excel. Also, I force the FeatureReader to have one single output port (Generic) and load in the Excel file using a User Parameter when kicking off the Workspace. This means that I need to Expose all attributes individually in the Workspace.However, this limits the flexibility. When I want to create a Web App from the Workspace, the input Excel always needs to have the same columns (so a Template Excel as input). An potential extra column is therefore not exposed an not in the result of the Workspace. However, in some cases, it is for my clients not possible to always use an Excel Template. Or they want to add additional information. My question therefore is, is it possible to dyn

I am reading dwg file, but i cant set him the right coordinate systemThe file i am reading is from autocad 2012In autoCad coordinate system is set to EPSG : 31277, i dont have that system in my fme workbench  Thank you in advanced 

I can't subtract solid geometry with the fme csg-builder.My goal ist to subtract the terrain (extruded by -10m) from buildings, to evaluate the volume that is above the terrain (subtract the basement under terrain). 3D-View:2D-View:  I tried several fme-transformer before plug them into the csg-builder. I used combinations of geometrycoercers and solid-builders with no success. My approach is to negative-extrude the terrain convert it to a solid and then substract it from the building-solids.The result ist always “nothing” (rejected):Or i just get one building dissolved (union) or cut (difference) when i dont use grouping: 

I have various values in a 'code' field.A sample would be: A33, B111W, B12, C3V etc, etc.This issue is, there should be decimal points between all numbers, i.e, these should correctly read: A3.3, B1.1.1W, B1.2, C3V. There does not need to be points between the letters.I can string replace “33” with “3.3” and continue to do that for all values if I have to, but I’m hoping that there is a more efficient way of capturing these values and using regex or something to force decimal points between the numerical characters. I’m not well adept at using the stringformatter, but maybe there is something there? 

I have a FME 2022.1 Desktop workspace with dynamic reader and dynamic writer. The reader generates several lists in some feature classes, in addition to attributes.How can I parameterize e.g. ListIndexer or ListExploder transformers to treat all appearing lists within various features of various feature classes streaming through my dynamic workspace at once, not explicitly knowing their list names (and hence not being able to indicate them as transformer parameter) ?

I was just trying to load a wms into my fme workbench using the OGC WMS reader and i get the image with a resolution of 22m yet the image has a resolution of 8cm.I then loaded the same wms as a background map and it comes with the desired resolution of 8cm. Did i miss something or the calls made to the wms server using the background option is different from those made using the OGC WMS reader?i also realised that without setting the map width and height the resolution is very coarse then on setting the width and height, the resolution gets better, but i cant go beyond the maxheight and maxheight specified in the wms xml file. Below is the wms url.https://service.pdok.nl/hwh/luchtfotorgb/wms/v1_0?request=GetCapabilities&service=wms Kind regards,Keller.

I have error messages when trying to run python script. I installed fme.exe python -m pip install pywin32 before import win32com.client but encountered a lot of error messages. Please see script attached. Please help. Thank you.

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated!Many thanks!!

Does FME support reading Geosoft Geodatabse with the extension .gdb? If yes, which reader can be used?

I am trying to create a workspace that identifies consecutive duplicate point in DWG polylines. and outputs their coordinates for future review.As per my example, Autodesk AutoCAD DWG/DXF (normal reader or FeatureReader) does some autorepair on the features while reading. The DWG feature has 12 vertex in AutoCAD but only 7 in FME.Please see attached sample feature in dwg format.I want FME to read the same geometrie that AutoCAD gives.Using FME 2024.2.1.0 build 24801