FME Form

I want to filter all unique values of an attribute with the attributeFilter. Iam importing the values stright from the data source using the import Wizzard but it is failing to list all availabel values. It really caught me of guard.I checked the database for unique values marked “Correct” in the image vs the wrong output by AttributeFilter.I used DuplicateFilter to aslo check for unique values and it returned the same as my SQL Query. Am i using AttributeFilter wrong or is it not trustworthy?   

Hi all.We’re migrating email submittals to a http based service, which takes a JSON body in a POST request.One of the fields in the post body is “emailBody”, which can be text or html.So I’m attempting to use a JSONTemplater to build this, but it fails:JSONTemplater (XMLTemplaterFactory): All features receivedJSONTemplater (XMLTemplaterFactory): The following error occurred near line 7, column 50 of the query:JSONTemplater (XMLTemplaterFactory): invalid expression: syntax error, unexpected "QName", expecting "," or "}"An error has occurred. Check the logfile above for detailsTranslation FAILED with 1 error(s) and 4 warning(s) (0 feature(s) output)Line 7 in the ROOT expression is the HTML, with escaped apostrophes and removed linefeeds and whitespace between tags:{ "emailFromId": "planinfo@lifa.dk", "emailFromName": "planinfo@lifa.dk" ,"emailAddresses": [{fme:process-features("TO")}] ,"emailCcToId": "","emailCcToName": "" ,"emailBccToId": "","emailBccToName": "" ,"emailSubject": "T

Hi All I have an FME Server App configured for data streaming with two output: one a HTML page, the other an MS Excel file. Independently, either output is streamed to the browser but when both selected, a zip file containing both is streamed. Is it in any way possible for the HTML to be streamed to display, with the Excel file streamed for download?

Hi all,I’m working with FME 2025.1 on a LandXML export-import workflow and encountering an issue: LandXML Reader and Writer do not have a Version 1.2 option. My goal is to export a corridor alignment, but the vertical alignment (profile) data is not coming through correctly. Without 1.2 support, how can I tolerate or work around these missing elements in FME? Specifically, I’m wondering: Is there a way to properly bring vertical alignment data from a LandXML 1.2 file into FME? Are there alternative formats or preprocessing steps to compensate for missing data? How can I avoid data loss on the Writer side, since 1.2 is not supported for export? Thanks in advance for any guidance!

I am using FME Form 2025 and the ChangeDetector to identify differences in records from two tables with the same schema. I have ChangedOutput create List(s) named “Changes”. What Transformer do I need to connect to the Inserted and Deleted Ports to get a look at the Lists? 

One of the greatest new features of the IFC4x3 schema is that we can write 2D lines to IFC, which was not supported in IFC2x3.Why does the new IFC writer support only 3D surfaces and solids and not 2D line geometries? 

Setting up writer by default adds attribute: fme: fill-opacity="0.1" to each feature. Is there a simple way to add  fill-opacity="0.1"to each feature instead ?  UPDATE: As per a comment by @chrisatsafe, I am interested in setting style per feature in this scenario to obtain this transparency effect you see below. The thing is, 'fill-opacity' has to be set to the same value 0.1 for all features within dataset.  Thank you,Aleksei

In addition to the defaults “name” and “type”, I would like to add a third, custom member named “data_owner” at the start of a GeoJSON file I am creating using the GeoJSON Writer (see example below). Is there an easy way to do this - I can’t find anything in the writer parameters - or do I need to use the JSONTemplater or another transformer? (FME 2023.2.0.0){    "name": "gis_assets",    "type": "FeatureCollection",    "data_owner": "CompanyName",    "features": [      {        "type": "Feature",        "geometry": {          "type": "Point",       etc.

Hi everyone,I'm working on a workflow that writes/updates features to an ArcSDE database using FME. The process completes successfully without any errors or crashes. However, I've noticed that for certain tables, the geometry (and possibly other data) is not actually updated in the ArcSDE database.I'm fairly new to ArcSDE and would appreciate any guidance on what might be causing this issue. Specifically, I’d like to understand: What table properties or configurations could prevent updates from being written, despite a successful translation? Are there permissions, versioning, or schema-locking issues I should be aware of? This is a non versioned table but the writer only works if I select versioned. Archiving is activated for the specific table. Is there a difference in how certain tables are registered with the geodatabase that could affect write operations? Any tips on how to investigate this further or best practices when working with ArcSDE and FME would be greatly appreciated

Hello everyone, I would really appreciate your support.I have a CSV file that contains a column named "LINK" (file attached), which includes the URLs to download orthophotos (.tif).I’d like to understand how to download them all using FME: How should the HTTPCaller transformer be properly configured? Is it necessary to create an attribute to assign a name to the orthophoto files? Could someone share an example script or workflow? Thank you very much for your help and support!

I am attempting to find the file sizes for each Feature Class within a FGDB, both within a Feature Dataset and at the root of the FGDB.  All research yields that the file size is not available via the PythonCaller and we are trying to isolate the FC filesize output via:PythonCaller > getFeatureClassSizeimport os def getFeatureClassSize(feature):    fc_path = feature.getAttribute("FC_path")    total_size = 0     # Common file extensions in a File Geodatabase    valid_extensions = {'.gdbtable', '.gdbtablx', '.atx', '.spx', '.freelist', '.gbx', '.cat', '.gdbindexes'}     if os.path.exists(fc_path):        if os.path.isfile(fc_path):            ext = os.path.splitext(fc_path)[1].lower()            if ext in valid_extensions:                total_size = os.path.getsize(fc_path)        else:            for dirpath, dirnames, filenames in os.walk(fc_path):                for f in filenames:                    ext = os.path.splitext(f)[1].lower()                    if ext in valid_extension

I want to transform a geotiff to an ecw while removing the nodata. The geotiff has just one band (band 0: Gray8). I do not have a clipper, so I think cannot use option 2 or 3 mentioned here, but only the first: use a rasterbandnodatasetter.So I used a rasterbandnodatasetter to set 0 as nodata, but when writing to the ECW this is not retained and still a black border is shown around the georeferenced image.What should I do to remove it definitely? 

Hi,Getting an error while publishing the workbench.Publish failed - FME Server encountered an error and reported the following message. The resource name must not contain any of the following characters: \ / : * ? " < > | & = ' + % #Regards, Dheeraj

So I’m configuring a service (an automation) which is triggered by an webhook. The automation will process data and then send the requester an email when the job is done.I want to add a little more feedback to the process for the end user. This is in part to reduce the amount or possible duplicate submissions - As I see it I have a couple of options:Send an email when the request comes in confirming that the request is being processed. Most likely this will be enough. (The user will already get a confirmation form the webapp where they submitted the request)Send an email after a certain amount of time (e.g., 15 mins) in case their job is taking a while or they are stuck in a queue.  Try to detect duplicate submissions and send an email to the user that their duplicate request was cancelled.As I see it option 1 is the only one which doesn’t require an extra free engine to run another job. Am I missing something?Are there clever way to do either 2 or 3 without an additional engine? 

Hello ! Does anybody have a clue how to transform a polygon reprensenting a text to a text ? See attached image.

About once or twice a year I have to dig out the SystemCaller, mostly just because I have to trigger a PowerShell command or script file. Without fail, I end up frustrated by the byzantine syntax (quotes galore) and limited way to capture output, finally succumbing to unnecessarily re-implementing the whole thing in Python.So my pick for the transformer that really needs some love and attention from the developers is the good-old SystemCaller :-)Do you also have a pet peeve Transformer that you think could be improved upon?

Hi there,I have created a Mosaic Dataset in ArcGIS Pro from downloaded 1m DSM GeoTIFFs. This displays fine in ArcGIS Pro.  The boundary of the mosaic is clipped to the extent of the data I want to analyze.  I need to convert this to LAS to run some ArcGIS GP tools. So I have done this using the Mosaic Dataset as an input in FME:Esri Geodatabase Raster  → Point Cloud Combiner → LAS WriterThe output shows some incorrect data striping and looks like it missed some areas. In ArcGIS Pro:In FME Inspector:I don’t see any out of memory errors or issues with reading the Mosaic data in the FME logs.Any ideas?Thanks,Marc

Hi, Just wondering: Is there a transformer that reads Esri *.pagx layout file? Greatly appreciate your help. Thanks, Willy 

I have a point dataset representing the locations of streetlights. I want to replace each point with a small line drawing that symbolizes a streetlight. This symbol is stored as a set of line geometries and can stay line geometry.I suspect I may not be using the correct approach, but here’s what I’ve tried so far:I used a GeometryExtractor to extract the line geometry of the symbol, and a GeometryReplacer to apply that geometry to each point. This almost works — however, instead of placing the symbol at the location of each point, the points are being moved to the location of the symbol. As a result, I end up with over 4000 symbols stacked on top of each other at the original symbol location.I’ve included an image of my workspace to illustrate the issue. 

Hi all,I am working on a script to replicate a set of feature classes from one enterprise geodatabase that we use for transactional editing purposes to another enterprise geodatabase that we use for publication purposes for the organization. This replication script would be scheduled in FME Server to run on a nightly basis.The issue is that the feature classes I plan on replicating have several domains and subtypes applied to them that don’t translate correctly.I’ve been advised to use the ‘Resolve Domains’ functionality and change the configuration from ‘coded domain’ type to ‘char’.My test workflow involves the below:Copying the feature class via the ‘Import Feature Class’ tool in ArcGIS Pro into the target Enterprise Geodatabase to have the feature class available in both geodatabases With FME:Selecting the ‘Resolve Domains’ checkbox in the Writer at the outset, and using the ‘Insert’ and ‘Truncate Existing’In the Writer configuration, changing the ‘coded domain’ type to ‘char’ and

I have a building footprint layer that I am using an oriented bounding box transformer (blue line) and trying to keep the result as close as possible to the original polygon (black line) but for some reason the bounding box is getting squeezed out of shape.  Does anyone have any suggestions as to why the bounding box is not aligning better?I am using it to try and automate the georeferencing of a CAD drawing and using the AffineWarper with lines that come from the corners of the bounding box. I am using the long side angle in the bounding box to rotate the CAD drawing, which in this example is still correct but the length of the long side is incorrect which puts out the affine points and scale calculation.  This is a case where the footprint is a basic rectangle but there are many cases where the footprint is an irregular shape.      

Hi, I have a dxf file with objects in it, their representation is fine, I’m happy with it.However I need to filter these object using an polygon extent. So I read the dxf file using and Autodesk AutoCAD DWG/DXF reader and then lose the linetypes.The information seems to be read because an inspector shows me that the attribute autocad_linetype is correctly read (e.g. symbolLayer1), so it feels like the problem is that the style is not defined and thus FME uses CONTINUOUS in the end. Colors seem fine though. Is there any way to keep these types without recreating everything in FME? FME versions:Form 2023.1.1.1 Best Regards, Julien

 I have an Excel spreadsheet that serves as a data dictionary. After reading a shapefile in FME Workbench, is it possible to use this spreadsheet to dynamically define the data type of each field in the shapefile?

Hi all,I have a CSV file containing stops with fields stop_lon and stop_lat. I’m trying to turn them into geometry and reproject them so I can use them with other layers.My workflow looks like this:CSV → Tester → VertexCreator → CoordinateSystemSetter → Reprojector In VertexCreator I assign X = stop_lon, Y = stop_lat. In CoordinateSystemSetter I set the source coordinate system to EPSG:4326. In Reprojector I reproject to EPSG:7856 (GDA2020 / MGA Zone 56). After running this, the points don’t land in the right place compared to my suburb polygon layer (which is already in EPSG:7856). In QGIS, both layers line up fine (on-the-fly reprojection), but in FME they don’t.Clearly I’m missing something in how I’m handling coordinate systems — but I can’t see where the mistake is. 

Hi, I have a polygon that looks like it has some floating point issues in measures around 0. What is the best way to fix those values without affecting the legitimate values.I’m thinking extracting the measures as a list and then editing the list in python and resetting all the measures from the new list, but that seems a little convoluted.