FME Form

How can I maintain the exact postgre data type of numeric , when write it back to database. The image below is the database datatype (numeric)  used used as a Reader but the above image is the writer output data type as numeric (1000,500) 

Is anyone else encountering  vertices that are not displaying when Mark Coordinates is turned on in the Data Inspector? The coordinates are in the feature record, and display when I select them. Currently using FME 2025.1The features I’ve noticed this in have been donuts, and it’s the inner ring that is not appearing.

 I have workflow that pulls large groups shapefiles of different geometry types from a folder using a feature reader and then exports them to a geodatabase. I would like to export them into a feature dataset inside the geodatabase. I have tried including the dataset in the file path but that either gives me an error or results in a blank geodatabase. If I don’t try and put the data in the featuredataset and just put them in the geodatabase everything exports without any problems. How can I get the data into featuredatasets?Creating the path using an attribute manager.Putting the path in the Feature Class or Table Name parameter.

Hi,I am using the AutoCAD Reader to extract external references from DWG files. When I get to the same file in the directory in results in an “Error running translation” error. However, if I run the Reader against the individual file, it works fine. I have removed the file from the directory and it then errors later on a different file. I believe this could be a memory issue? How can I resolve?I am only running the Reader and no other Transformers.Any help would be appreciated.Thanks.

Hi all,I have two CSV files (A and B) that I've included using CSV readers, and I need to join them using a feature joiner on a specific column. CSV A contains numbers in all rows, whereas CSV B has numerous <Null> cells in the column. When I run the feature joiner it fails. I already tried:Changing both attribute types to number I included attribute managers before each CSV to include letters with the numbers of each CSV file to force matching as textDoes anyone have any suggestions? Many thanks.  

I am looking at implementing something like this: https://support.safe.com/hc/en-us/articles/25407459193613-HTML-Page-with-Link-to-Download-Excel-File-FME-Flow-AppBut I don’t want to create a webhook for public access for the data streaming link, I want this restricted to the same role/group that has access to the server app - is that possible?

Hi,I’m struggling with reading JSON as a flat table, which I could use in GIS.I have the following JSON: I enabled option “Flatten Nested JSON Values into Attributes” but that produced one row with many columns. In some other post someone proposed a query json["collection"][*], but that also didn’t work.What options should I use to produce a flat table with JSON attributes as column names?

StringReplace does not do what I expect (version 2024.2.1.0)Newlines are not replaced, can someone please point out what I'm doing wrong?  

Hello everyone,I’m having trouble reprojecting a shapefile. The file is currently in SIRGAS 2000, and I need to convert it to WGS84. However, when I run the reprojection, an error occurs (see attached image).Additionally, I need to extract the current coordinate system of the shapefile. In the table, the field shows up as _FME_0, but it should display SIRGAS 2000.Does anyone know how to fix these two issues?

HelloIn one tester I enter a value through a published parameter. Then I have a second tester in which I would like to retrieve the previously entered value. How can I do this?Thanks

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?

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?