FME Form

there is a feature service layer (i’m the owner) with a filter statement on it.when I view the layer’s properties on AGO, I can see the filter. When I add it to an arcpro project, I can see the filter in the definition query. Looking at the REST end point (the one that has the <organization>.maps.gis.com address), i see all records. When I add the layer into FME either by AGOL reader or feature Service reader, I only see the filtered records and I don’t know how to get all the records. AI is telling me to put 1=1 in the where statement to bypass, but it didnt. 

Hello all!I have a question regarding accessing data in an Enterprise Geodatabase in a branch-versioned Feature Service scenario:Using FME’s Esri Geodatabase (ArcSDE Geodb) Reader, can I read branch-versioned feature classes directly from my Enterprise Geodatabase (SDE connection) now that I have published a branch-versioned Feature Service? If I point it to the “sde.DEFAULT” version, will it access the features correctly?I would like to perform some heavy geoprocessing tasks, and my Feature Service performance isn’t keeping up, so the Esri ArcGIS Connector is a no-go

I'm quite new to CAD. I have an Oracle database with parcels. I would like to convert these to DGN (for users in Microstation) and DWG (for users in Autocad). The parcelnumbers should be a text field as the centroid of the parcels.  I have only a licence for Microstation to test the DWG's over there before I can sent them to the users using Autocad. I can create and convert the parcels and texts to DGN. These work fine.When converting the parcels to DWG I can see the number of features (elements) in Microstation, but not the geometry itself.What should I do get the geometry right?  

Hello all - grateful for some suggestions here - I’m being driven slowly mad…We are developing a ‘data portal’ style workbench running in FME2025.1, using a dynamic writer to deal with multiple input and output datasets and multiple possible output formats - the dataset and output format are specified by user parameters.The source datasets are point or polygon datasets stored in an MSSQL Esri SDE and output formats  include all the usual GIS data formats.This is generally working well but one polygon dataset is failing to wite out. In this case the log reports the following:=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `GENERIC' writer using keyword `GENERIC_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Hi FME Community,I came across this presentation from the 2017 FME User Conference on integrating GIS data into PSS®SINCAL:https://fme.safe.com/presentations/pss-sincal-network-modelling-from-gis-data-using-fme/From what I understand, the workflow relies on a custom FME process combined with a third-party DLL to generate and populate the SINCAL database schema.I’m currently exploring a similar use case (GIS → electrical network modeling in SINCAL), and I’d like to ask:Has anyone implemented a more recent workflow for integrating FME with PSS®SINCAL? Are there any newer approaches using FME (e.g., PythonCaller, APIs, CIM, etc.) instead of direct database writing? Is there any official or community-supported FME reader/writer for SINCAL available today?From wh

I have been using Topologybuilder to merge attributes from overlying features. This worked fine as long as empty cells where set to NULL. Now for some unknown reason this does not work any longer. Example of two overlying features:Feature 1: attributeA = NULLFeature 2: attributeA = 'valuesomething'The output used to be one feature with the value 'valuesomething', but now I get the value NULL in stead. Has the way the Topologybuilder works been changed? Does anyone have a workaround?

I have line features . When two lines really intersect, I would like to create a new vertex at the intersection point .My requirement is:if two lines intersect, create a vertex on the lines at the intersection location if it does not exist the new vertex should get a Z value that is 1 meter lower than the other existing vertices of the lineFor example, if the line vertices have Z = 145, then the new intersection vertex should have Z = 144.Currently I am using Insector, and to filter out the nodes that share a node between consecutive lines, I cobination of coordinate extractor and FeatureJoiner. Afterwards, I extract all coordinates of the lines and join them again with the remaining points from Insector to identify the real intersecting points, as well as the intersecting points that do not exist as vertices on the line.Then I gave new z values to this vertex candidate but how can i insert them onto l

InlineQuerier documentation states:  The InlineQuerier creates a temporary SQLite database, and creates a table for each input object that is connected to it.  This is not always true. If an incoming flow is empty, the table is not created. This should be stated clearly in the documentation. I would prefer that the table is created anyway. The transformer will fail otherwise. Related question: InlineQuerier Fails When One Input Port Receives No Data in FME Form 2024.2.1 | CommunityEdit: Tested in FME 2025.1.3

This is one of those questions, where you think the answer should be straightforward yet eludes you, so hopefully somebody is able to help me out here.I have 20,000 property IDs in my workbench, and I need to get additional attributes from a large PostGIS database table that contains several million records. This should be a simple join on the property IDs, but the problem is that FME is feature-based whereas any database is table-based.If I put these 20,000 property IDs through a DatabaseJoiner, SQLExecutor or FeatureReader, it runs 20,000 individual queries rather than 1 single one, so is very slow and inefficient.The second option (suggested by AI) is to write my property IDs to a temp table in PostGIS, and then do an inner join on the temp table. I don’t like this option as it means writing into my source PostGIS database, which is not a good idea. And writing the data into a table is ‘expensive’.The third option would be to read a

Hi everyone,I’m currently facing an issue with CSV FeatureWriter transformer writing in a ZIP folder. We recently migrated from FME Workbench 2020 to 2025 and the behaviour of the writer changed in between.2020: when writing a CSV in a ZIP folder, the entire ZIP folder would be overwritten. Meaning that if it contained several files, only the newly written CSV would remain. 2025: when writing a CSV in a ZIP folder, only the specified CSV file in the folder is overwritten. Meaning that all the other files are still existing. I get the same result with FME2024.1.3.Main question here: Which FME version has the correct behaviour ? Case 1 or case 2?If it’s case 2, then it means that I will have to update all the workspaces in my infrastructure that are writing files in a ZIP folder, leading to a lot of extra work → I probably need to clean up the ZIP folder upstream through a SystemCaller or PythonCaller. Have you other opt

Hi,I’m using an API (https://docs.transpoco.net/?version=latest#52611862-77b1-4fe6-8a1d-67fc4904cb54) and need to send a post request for authentication. The issue is that the post request takes the username and passwork on the body of the request as a JSON. Any ideas of how I can create a webconnection to run this request in a way i can safely store the credentials on the webconnection instead of on the httpCaller transformer?  

Hi all,I’m validating polygons (DB tables) and currently using GeometryValidator and SpikeRemover in FME. I’m looking for a short, repeatable workflow that reliably flags:Self‑intersections / bow‑ties Holes outside shell / overlaps / tiny slivers Degenerate parts / zero‑area rings Duplicate vertices/nodesQuestions:Which transformers & order do you recommend for detect only polygon checks? Any tips on tolerances (min area/angle) that avoid false positives when paired with SpikeRemover?If you have a small sample workspace or parameter hints, I’d really appreciate it. Thanks!Sahan

Hi,I have a strange issue when writing to excel. I have a feature writer to excel in dynamic mode. To prevent numbers being converted to a scientific notation I added a Excel Styler where I set the custom numer format to 0. This works perfect.The problem is that now my dates and datetimes are suddenly shown as number. When I change the cell format to date it shows the date, but I want it to directly show the date. When I remove the ExcelStyler, dates are shown as dates. Anyone any idea how to fix this?I use FME 2023.2.5.

Hello,to simplify/reproduce my problem:  I added a User-Parameter on my Attribute-Remover: Which grants me a choice to select which to ignore, but (same as here Attribute Remover does not work with User Parameter | Community 8 years ago) it only removes the values and not the attributes, so when I write it into my database or even a new excel, it creates unneeded columns.Manually selecting attributes in the Attribute-Remover works fine, this only happens when using user parameter. Am I missing something or is there another way?P.S. I also tried AttributeKeeper with User-Parameter, but then they’re unexposed, so I wo

I am trying to get the labels in this map to offset so that they “print” on their lines (two different labels, one is for pipes and the other one is for manholes).Manholes - is the label like 71100144 - the first row of this label should sit perfectly above the line there.The pipes are the values like KM_… - this one should offset entirely to sit on top of the pipe lines.I hope that makes sense.Is there an attribute I can set? I am using AtributeCreator + TextAdder + PDFStyler.Thanks a lot! 

I have a network of connected points and lines, and I’m looking for a way to create a selection set of points along the network, the key being I want to only select every other point. I tried modular selection counts (odd vs even numbering), network topology build for start and end node, but I can’t seem to get the results I’m looking for. Below is a screen capture - I want to eliminate the grey colored points in between. At intersections these points would be retained if necessary according to the ordering.  Select all points in Orange, skip points in Grey 

What happened to the reader and writer drop down menus in FME 2025.2? Why would they remove them? Am I just missing how to add them back in? So frustrating.

I have some columns within my Excel template that have a lot of text, so I thought to put the wrap text feature on for basically the whole spreadsheet. Thing is, only some of the cells wrap text instead of all of the cells. In the screenshot you can see what I mean - I have tried everything to try and fix this. Hoping someone in this community can assist! I tried using the ExcelStyler transformer too to no avail. 

I have an AGOL feature layer with a DateOnly field that I am trying to filter out the last 365 days worth of data. Is there an easy way to complete this?The data is formatted in the following way:2021-01-01

i have many PDF , that PDF i want to merge in single PDF  how can i do this 

The zoom slider bar is missing in FME Flow 2026.1. Please bring it back. It makes zooming more convenient. It was in FME Desktop 2021. Are there plans to bring it back? Or is there identical functionality in FME Form 2026.1? If so, where?

Hi, is there any way to see the full request that was sent by OpenAPICaller? I struggle with a PUT request to api.avima.app and the Avima support team would like to se my full request. Thanks 

Hello everybody,I am trying to build a flow app: The user has an Excel file with 3 columns.  the flow app must show the values of theses columns as one parameter (I want to have the chance to filter the list using one of the 3 columns). My Problem is to get the contents of the excel file. If I try it with the User Paramters Window, I can import from dataset or reader formats. But with these options I do not get the contents but the headers or the name of the readers.I can save the contents of the File in a SQL Database. But I do not know how I can read them and show them in the user parameter List. Has anyone any Idea, how I can get a List with a filter to show those values of the excel?Thanks in advance!Manuel

I have a very simple workflow setup:read a table (typically either a .CSV or Excel file) which then connects to an Attribute Manager set up with multiple fields from a template that adds and renames them so they can be seamlessly imported into another database with exactly the same field names; and then this connects to  Excel Writer (the file format required for import)Since the files I’m reading into FME Workbench do not have all the fields or match exactly those in the template/Attribute Manager has (the point of the workflow), I get an “incomplete transformer” error message. The workflow executes flawlessly, however, and I’m getting the results I need.I’m wondering, however, if there is a way to eliminate the error - the red “incomplete transformer” icon in the navigator window is a bit disconcerting. 😉 PS: I have added the following annotation to the AttributeManager should there be no way to get rid of the error m

Just sharing information about a new feature I found."Enable Performance Profiling" would be introduced in FME 2025.2 Workbench. You will be able to log detailed performance profiling on workspace run easily whithout editing header.Have been waiting for 10+ years :-)Sharing: Detailed Profiling of Workspace Running Performance[Addition] The command is available since FME 2025.1. I have overlooked that...