Transformers

There are a series of similar posts but still not seeing a way to expose attributes dynamically.I have a a large number of geodatabases which have multiple layers and different attributes, which I am merging with a geometry layer so I end up with a single layers with lots of attributes.The geodatabases have a series of tables and a geometry layer, but there is no consistency in attributes between the geodatabases.How do I expose and have these exposed attributes output to a merged dataset? 

I have a workspace on FME Flow that ultimately creates records in a SQL Server non-spatial database using two SQLExecutor transformers with queries that came directly from the DBA.  I didn’t write the queries and I only basically understand what they do because I’m not a SQL person, but they both are sandwiched between “BEGIN TRANSACTION  → COMMIT” statements.  Up until recently, the SQLExecutor transformers in question used hard-coded server/username etc and it all worked fine.  However, during our most recent FME Flow software update (to 2024, but I don’t think Flow is the problem here as it is present in my Form testing as well) I was informed by our FME administrator that I could no longer use hard-coded server/username details, I had to switch to using an ESRI ArcSDE Geodb connection file to connect to this SQL Server database.  This change worked just fine for other, more simple, Select and Insert sql queries, but these two mentioned above just stopped working.  I confess I find

Hello everyone, I have the following problem with a solid (possible bug) (see screenshots) (minimal example included)FME-Version: 2026.1.1.0 (20260415 - Build 26121 - WIN64) I have a digital elevation model. I extrude the model.I slice the resulting solid at a fixed Z-value. I pick the part under the slicing plane.Up until here a GemoetryValidator does not find any issues ✅Next step is to dissolve the solid and after this the GemoetryValidator does find 3 issues ❌(Self-Intersections in 2D, Invalid Solid Boundaries, Incorrect Solid Orientation)  The issue only occurs at a very specific slicing level. Slicing the solid + - 0.000001 m above or below does not cause an issue. Removing the issue locations before dissolving also prevents the issues from appearing. Does anyone have an idea what could cause these issues? Many thanks in advance.  Minimal example to demonstrate the problem:  Configuration of the GeometryValidators:    

I have a workspace that creates a CSV file from an ArcGIS feature service. I have five attributes that contain 0 to 5 comma-separated 5-digit integers. I sort the integer list then look up text values in an Excel file. I’d like to put this task in a separate workspace and call it from a WorkspaceRunner. For example, I convert “12345, 12346, 12347” to “Desc1,Desc2,Desc3”I have a programming background and was thinking of a WorkspaceRunner as a function or sub-routine with a return value. I understand how to pass a parameter to a workspace, but how do I get a return value (e.g. “Desc1,Desc2,Desc3”) back to the parent workspace? I have a feeling that I’m misunderstanding what a WorkspaceRunner can do. Thanks.

Good day, I have a couple of points on a line feature. I would like to draw one polygon around each point, the point serves as center point of the polygon. The polygons should be 1.5m x 1.5m. Two sides should be parallel, two sides perpendicular to the line. See screenshots. What is the fastest way to achieve it ?

I am working with a fairly large dataset and using FeatureWriter to write more than 200 data layers to a GDB. You could say that it is a complete template that can be reused. However, FeatureWriter seems to have an issue where it automatically defaults the Geometry Type of all features to a fixed type when I click on each input row to inspect it, even though my 200+ layers contain many different geometry types (points, lines, and polygons), all of which have been explicitly configured rather than using the “From First Feature” option.Initially, I thought I might have configured the Geometry Type incorrectly for some of the layers. However, after I manually configured the Geometry Type for all 200+ layers and clicked on FeatureWriter again, the same issue occurred.To be honest, I preferred the FeatureWriter in previous versions. I believe the version before 2024 was very stable. However, since the FeatureWriter interface was changed and the “From First Feature” option was introduced, I

I read in a PoinCloud with Component x,y and z_2025_gem. The year changes as time passes by so I use a Parameter to define the component. For reading the point cloud, the component is read as z_$(JAAR)_gem. That works fine.When I want to use a User Parameter within the expression of the poincloudfilter I get an error on Flow but when I try it on Form with default values for the parameters, it works fine. If I try the workspace with default values on Flow it works fine as well.I checked the values for the Parameters on Flow by sending an email to myself with the values of the Parameters and the values are fine. So I guess that cannot be the problem. The parameters are used for reading the file and components as well and there are no problems there, only using them within the PointCloudFilter I have tried the following Expressions:1: @Component(z_$(JAAR)_gem) != -999992: @Component($(Z_JAAR_GEM)) != -99999by which JAAR = 2025Z_JAAR_GEM = z_2025_gem With the first expression, the Filter d

I have various FeatureReaders I use for reading both schemas and features. I also create new features and use the SchemaScanner to create the corresponding schemas.When using a FeatureWriter I need the schema to arrive before the features. This can be done using a Sorter but it also fill up my RAM very fast because it is blocking.I am ideally looking for a FeatureHolder with Group By (by fme_feature_type?) which supports release features when the corresponding schema has passed.Alternatively if someone has an idea for a similar functionality combining a set of transformers?

FME currently logs successful Azure Blob Storage responses with HTTP 206 (Partial Content) as ERROR messages. Since 206 is a normal success response used during chunked downloads, these messages should not be classified as errors. They generate noise in logs and lead users to believe workflows have failed when they have actually completed successfully.

FME Flow using a directory and pathname reader transformer. it has run in this folder before (different fme version) and not had this error.PATH Reader: Error reading path '\\Tx-mio-miso1\mi-shared2\SUR\MoDC_TXAS_NRGY\COUNT_FLEET_\ASBUILT\WORKING' with error message: 'The media is write protected.'Why does a reader transformer need write access?It doesn’t even get to the writer and fails  

Whenever I try to open the AttributeRenamer transform properties, FME Form crashes. It doesnt matter if it is an existing workflow or if I start a new one woth nothing but only one AttributeRenamer. Any thoughts, anyone? The screenshot below if from FME Academy: But it also happens on an otherwise empty workflow:  

We're using the TrimbleUnityConnector in FME Workbench 2026.2 and have noticed that when creating a new activity, the connector displays template options for items such as inspections. However, no Work Order Template options are available.As a workaround, we've been passing the Work Order Template ID as an attribute, which works, but we'd expected the templates to be selectable in the connector like the other activity types.Has anyone else experienced this behavior, or is there additional configuration required to expose the Work Order Template options?Here is inspections for comparison 

Hi,I have two questions about writing from IFC to Revit:Is it possible to write objects such as walls or columns from IFC as actual Walls or Columns in Revit, rather than having them as Generic Models? I am using FME 2026.2, and when I write to Revit using a template file from either Revit 2024 or 2025, the output from FME is created in Revit 2026. Why does this happen? Is it possible to create the output from FME in Revit 2025?Thank you in advance for your help.

Hello, We have recently upgraded our FME Form to 2026.2.0.0 and I have been updating my workbenches that used the old Cityworks Inspection/Work Order Creators that have since been deprecated to the TrimbleUnityConnector. However, I am running into an issue of being unable to add assets to the inspection./work order which I did previously with an HTTP Caller. Is there a native way using the TrimbleUnityConnector to add assets?

Hi,I’m using FME 2026.1.1 Build 26121.I have observed strange behavior of SQLCreator today.User attributes which are created using “Create User Parameter” option are not getting saved (Step3.jpg). If we create then though “Manage User Parameters” and add user parameter with text option. User parameter is saved in user parameters in navigator but SQLCreator is saving the user name or password. Two screenshots are attached for reference with names step1 and Step2.This issue I have seen just today and everything is fine till yesterday. Even I entered the username and password as constant values directly, values which are entered are not saved. When I open the SQLCreator constant values are not saved. Waiting for response...Thank you! 

I want to calculate upstream and downstream distances along river polylines between barrier points. I’ve got as far as generating a topologically correct river network divided at barrier locations, river intersections and junctions complete with network_id. I’m stuck on the next steps! The main challenge is what to do upstream when a river branches out. Any help would be greatly appreciated! Process so far 

Hi,We've FME Workbench installed on a Azure virtual desktop. It all works fine but there are nog FME Hub transformers in the list: Also, when browsing, the installation of a found transfomer from the hub gives an error: Is this a problem of the user not having the correct permissions or an URL that is not allowed or any other ideas? Thank you. Arno

Hi, I have a LAS file already normalized, ground z value = 0, and other class z = height above ground. I need to set the z value to “0” to building class. I try this workflow and it’s seem to work but when I check the LAS writer, build and ground have the 8.847607091e-10 z value.I dont know why this, but when I check property in FME, I realize that z value it’s different.In my normalized LAS the z valueBut in the output LAS I get this in z valueI tryied with PointCluidExpressionEvaluator instead remove and adder component but I get the same in Z valueAny idea why this happens?

I am running into a issue with OffsetCurveGenerator. There are some instances where it drops nodes from the original linework and breaks the output line into an aggregate, I assume this is beacuse it folds on itself.The uppermost grey line below is the original. The green lines are generated offsets at various distances. Note that the one at the bottom has lost a vertice towards the corner. The linecount coming out of the transformer is correct, but if I run a deaggregator, the total number of lines has increased. As the red line illustrates it has split at the corner. This is not an issue in most occurrences, but I want to run some Snippers on the start and end vertex downstream and the Snipper treats the lines as if they where deaggregated. I tried working around this by first running a Deaggerator followed by a LineCombiner. But if I do the lines sometimes flip their original direction (depending on the order in which it was rebuilt), which results in the end vertexes I wanted to sn

Hi,I tried this through the V4 REST API, but when I add a conditional statement to the Request URL, I’m seeing <not specified> in the Request Preview for the URL.I also noticed something in the Automating FME Flow App Customization article. They created a user parameter named SOURCE_FILE, but in the Request URL they use UPLOAD_FILE.Could you please clarify why these parameter names are different and how the conditional statement should be configured in the Request URL?Thanks!  

I am trying to convert from FME2024 to FME2026.2.  I am using a feature read, converting from “Esri ArcGIS Portal Feature Service” to “Esri ArcGIS Feature Service”.  I have been able to make a connection to our enterprise portal, select the relevant group and feature service (image 1). But when i try to select just the relevant feature class i need (not all feature classes) i receive an error below.  If i leave this as <All Feature Types> this works but obviously I dont want to call every feature class where its not required. Has anyone seen this before?  Is there a work around?

Hi all,We overlay/intersect datasets containing circular arc geometry (Arc By Center Point With Ends) using AreaOnAreaOverlayer, LineOnAreaOverlayer, LineOnLineOverlayer, Clipper, and Intersector.  The source data comes from an ArcGIS Geodatabase (ESRI SDE). We'd like to understand how these transformers handle arcs internally, since this directly affects positional accuracy for our (cadastral-grade) use case.Specific question:When an arc is intersected with a line or polygon (Arc By Center Point With Ends -> overlay -> output is again Arc By Center Point With Ends), is the intersection point computed:(a) analytically/exactly on the true circle equation, comparable to Esri's ArcGIS Pro "Curve Processing Method = Exact" environment setting, or(b) by internally linearizing/approximating the arc into line segments, finding the intersection on that approximation, and then reassembling the arc for the output — comparable to Esri's "Curve Processing Method = Approximate", where the doc

So I noticed that when using a parameterized INSERT statement in SQL Executor:INSERT INTO MYTABLE(FIELD1, FIELD2)VALUES ('@Value(FMEATTR1)','@Value(FMEATTR2)',)Any NULL becomes an empty string. How do I use logic like the above and still keep my NULLs? I've tried to wrap the entries in VALUES in case statements to catch NULLs and handle them differently - but to no avail. 

 Good Evening! I have a problem i would like to share with this amazing community and i hope ill get an answer that solves it. I am writing data to an Microsoft Excel file. I use the feature writer to dynamically write 3 datasets to Excel. The normal Microsoft Excel writer does this without a problem. Now i want to do it with an Feature Writer set to Microsoft Excel, but when i run the feature writer with, i believe, the same settings as the Excel writer, it results in a fatal error, where it states FME daemon is shutting down. Can anyone help me? That would be greatly appreciated. Thanks!Error log TranslationOther settings are default.Interesting here: number 164. I dont know why of what. 

I am trying to make a workspace that generates information reports, but the featureReader give me unexpected output. Sometimes it works, but sometimes it gives me "stale caches”, where it should work. I am trying to let the user choose which attributes to expose by using a UserParameter, so they can choose what information attributes they want to use or not, but it gives me weird results.  If i run it, it might do it and give me the required information, but if i run it another time, with other attributes selected to expose, it gives me the result that was asked before. Or, if i run it again with the same configuration it gives me the "stale or incomplete cached data”. since Users can select multiple layers out of the 500 we have, i think i have to use the generic port, and let the users choose what attributes they want, because they dont need everything and their needs change from time to time. How do i change this process so that it will be reliable? That my users can get any attribu