Transformers

Hello,I have a workspace in FME Form that reads a large number of tables from a PostgreSQL database and writes them into another PostgreSQL database with the same schema structure but without data.Workspace designI use a FeatureWriter configured for PostgreSQL with the following settings: Table name is dynamic and taken from the incoming feature type: Table Name = fme_feature_type Attribute Definition = Automatic The destination database already contains the tables (same structure). Each feature is therefore written to the corresponding table in the destination database.

I need to connect to a PostgreSQL database via an SSH connection. How can I do that ?Thank you

How can one rasterize a vector where all cells touched by a polygon/vector get drawn during rasterization?I have tried the NumericRasterizer, but I believe there’s an issue with tolerance values greater than 0.5 not being respected when using the NumericRasterizer transformer.With tolerances like 0 and 0.5, I can see a difference in output. However, a tolerance value of 1.0 has no change in the output (see below). Output from NumericRasterizer with tolerance set to 0.0, with the input vector overlayed  Output from NumericRasterizer with tolerance set to 0.5, with the input vector overlayed

I had a hard time with the integration of GDAL and FME raster transformers. So, for the record, I posted a short tutorial:https://blog.fiorino.fr/index.php/2022/05/11/fme-python-api-working-with-rasters-and-gdal/

Hi all.I just experimented with a small workflow, that scans a folder for files, and attempts to read those files using the generic format.I tried with CSV and DGN, and both worked well.I then tried with Geopackage, and then it blew up.First because FME’s guess using the extension was wrong, so I had to parametricize the format used.Then it blew up with an internal error message (“Too many recursive macro substitutions”):2026-03-03 15:14:24| 2.6| 0.0|WARN |UniversalReader -- readSchema resulted in 0 schema features being returned2026-03-03 15:14:24| 2.6| 0.0|ERROR |Too many recursive macro substitutions -- line currently is: `SOURCE_READER GENERIC REAL_FORMAT "$(REAL_FORMAT)" EXPOSED_ATTRS "$($(FORMAT_SHORT_NAME)_EXPOSE_FORMAT_ATTRS)"'2026-03-03 15:14:24| 2.6| 0.0|ERROR |class stk::ex::UString<0> __cdecl tabrdr::ClassicTableReader::macroSu

I have a donut geometry (see WKT below) which I am trying to validate. Using the GeometryValidator only looking for self intersections I get an error on the start/end point of the outer ring: Error report:Coordinates from the inspector: I would expect this to not be reported as a self intersection since polygons normally require intersection at exactly that point.  Why is FME reporting this? I have tried using both FME Desktop 2021.2 and 2022 beta. Geometry WKT: POLYGON Z ((558000 6142955.0838 0,558000 6142917.0404 0,557997.11 614

I need to update environmental data in our system. The input data comes from an ESRI Shapefile, and I am using FME 2021.2. The output is stored in Oracle Spatial.However, the system that reads the data from Oracle only accepts simple polygons. When I try to insert multipolygons, part of the geometry is ignored by that system.Is there a way in FME to convert multipolygons into single polygons while maintaining a 1:1 relationship between input and output features?If I use the Deaggregator, the number of records grows exponentially, which is not viable for our database.I also started working with FME recently, so I may be missing a simpler or recommended approach.What would be the recommended way in FME to transform multipolygons into valid simple polygons without increasing the number of features?

My long time transformer friend FMEFlowLogFileRetriever is not avaliable in FME 2025. The error asked me to use HTTPCaller to retrieve the job log file. So I used this rest point in the HTTPCaller’s Request URL with GET - https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/@Value(jobid)/log. I tried the Basic and Web Connection authentications, but both gives the error “HTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/98/log'”. I have no problem publishing using the same Web Connection for the authentication, so don’t understand what the issue is. The jobid = 98 was run successfully on the FME Flow.

Hi,In a workbench, I created a Custom Transformer to loop batch of features.It is a workaround to prevent machine reboot on large feature datasets processing. At least, writing-along features in the Output to .csv. file help to recover features processed in PythonCaller and it is easier to resume for the remaining features… Here is the workbench, with Inputs:batch = 10counter = 54000 (total of features)loop = 0 (to keep track of iteration)offset = 0The Tester_counter transformer filter out batches 10 features at each iteration, sent to PythonCaller. At the end of processing the Tester_Loop tests if there is remaining features to process. Anything processed is sent to the Output and written in a .csv Writer transformer in the ‘Main’ workbench, whereas ‘failed’ remaining features from Tester_counter have their attributes incremented for variables loop and offset for the next iteration.However, when running the workbench, t

Hi there,We recently installed ArcPro 3.3 with the data interoperability extension FME version 2024.0.1.0.I have succesfully used WorkspaceRunner in the previous version of ArcGIS PRO 2.8.But now, when I use the WorkspaceRunner transformer to run a simple workspace the transformer fails to read the published parameter, it says "Specified workspace has no parameters or could not be read". The workspace I am loading into workspacerunner does have a published user parameter. Does this happen because of the new version of ArcGIS? Anyone else have this experien

I’m using the Esri Reprojector transformer with a feature reader that reads feature classes from an ArcSDE connection. They all share the same coordinate system and I need to transform them. I can do this successfully using three separate transformers but seems a bit silly. I’m assuming there is a way that I only need to use one and feed the three feature classes through it? I’ve tried doing this and adding a FeatureTypeFilter transformer but this returns no values if I click ‘Update’.  

Hi all,I’m currently working with several Revit files hosted on ACC, and I have put together a workflow that can read a specific ACC folder and identify a federated model. The process successfully reads and downloads the host file; however, I have been unable to download the associated linked files.Is there a way to use the AutodeskDocsConnector to access and retrieve the linked files as well?Thanks :)

I believe there’s an issue with the tolerance values greater than 0.5 not being respected when using the NumericRasterizer transformer.With tolerances like 0 and 0.5, I can see a difference in output. However, a tolerance value of 1.0 has no change in the output. Output from NumericRasterizer with tolerance set to 0.0, with the input vector overlayed  Output from NumericRasterizer with tolerance set to 0.5, with the input vector overlayed 

Recently our network has been segmented which causes an issue with sending mail (emailer transformer) with FME Form from server X using an smtp mailserver which is in another part of the network. A firewall has been added in between these two. The firewall blocks mails being sent because fme form (20241202 - Build 24801 - WIN64)) supposedly uses an outdated version of OpenSMTP giving this issue: CVE Record: CVE-2020-7247Does anyone recognize this? It seems to be an old issue dating back to 2020. I would expect this to be solved in a 2024 version. I can't find anything in the documentation. Help would be appreciated since I know very little about firewall, mailservers etc. 

Hi,I am currently working on an assignment in FME and have run into some difficulties regarding how to structure the workflow to meet all the required criteria.In particular, I am unsure how to best combine the distance requirements. For example, how to approach buffering and overlay operations to ensure the area is within the correct distance from both the sandy beach and a major road, while also being sufficiently far from buildings. I am also uncertain about the most logical order of steps to avoid creating an unnecessarily complex workflow.I would really appreciate any advice on how to approach the structure of this task in FME in a clear and efficient way. I am mainly looking to better understand if there is any other transformers who would make the workflow more efficient?Thank you in advance for your help.Best Regards Anton

I am using the Precisely MapInfo Extended TAB Writer to generate a MapInfo table that is over 2GB (total) in file size. I estimate it should be between 3GB and 4GB in size.I am indexing five attribute columns in the table.And the process of indexing the attribute columns is extremely slow.When I do not index any columns, it takes about 20 minutes to Write the tableWith indexing the columns, it can run for twelve hours before I halt the process in frustration to check my process.Does anyone have any experience of this? Is the Precisely MapInfo Extended TAB Writer just bad at generating indexes?

Hi everyone,In FME 2023, does anyone know the correct way to create a 3D vector starting from a list of 3D coordinates referring to two different moments in time?In the past, it was possible to connect two Vertex Creator transformers to generate a 3D vector by linking two 3D points. However, it seems that this is no longer possible in the same way.Any suggestions or alternative solutions?

I'm trying to read a OGC geopackage which contains fields of the type 'datetime'.In FME 2025.1 (which uses version 16 of the FeatureReader) something unexpected happens: in case the number of seconds starts with a 0 (zero), this zero gets dropped after reading the data. See record 21 in the screenshots for an example:In FME 2025 the field ‘tijdstipRegistratieLV' misses a 0 after the '1009' (10 hour 9 minutes).In FME 2023 the readout is correct: 20101214100907 (2010 december 14th, 10 hour 09 minutes 07Is this a known issue/bug?

I have a simple job reads points from a spreadsheet and buffers my pipeline. I would like to set up the SpatialFilter to see which points on the spreadsheet are outside my buffer.  For some reason, all points go to the Failed port. I have exported the buffer that is created and verified they correct and most of the points fall within the buffers.  Any tips are appreciated! 

Has anyone had success with using the updated 2025.2 Excel writer to write data to a table in Excel?  I see that this idea was implemented with 2025.2:  Excel Writer: Explicit Table Support | CommunityHowever, the instructions for the writer don’t go into a lot of detail on how to have the writer create a new table on a sheet and load it with the incoming data.I personally tried to follow some of the older demo’s that walk throughs for writing to a named range.  Those walkthroughs require you to create a template xlsx file with the named range already created.  So for my 2025.2 test, I create a new template.xlsx file, then created a table named tData on Sheet1.  The table is blank.  After that I created some dummy data in FME and tried to write it to a new excel file using the template.  The output excel file does l

Hi All,I am currently working an automation process to convert XYZ files into LAS format for use in ArcGIS. I have successfully generated the point cloud and exported it to LAS; however, the classification information is not being retained.The custom classifications are based on codes contained in the original XYZ files as text, and these values are stored in a table, an example of which is shown below:  How can I convert the XYZ files to LAS while preserving the Feature attribute as the classification?Attached fmwt fileThanks :) 

Dear community,I am currently working on FME Workbench 2025.0. My project take into entry areas in 3D that represent buildings roofs. It then spreads the data into two datasets: roofs and building using the latest ground footprint. In order to do that, I am using the 'Dissolver' Transformer with the Group Processing option on. My issue is that some of the edges inside the building are remaining because they do no fit on the Z axis (see screenshots below). Dissolver operation: purple edges are classified as ‘Remanents’ after the operation, red one remain.Result of Dissolver : on a 2D perspective, internal edges are remaining.

HiI am encountering a critical issue when using the ArcGIS Online Feature Service Writer (within a FeatureWriter transformer) in a dynamic workspace.When a specific column contains data that AGOL deems "invalid HTML" (e.g., strings containing <, >, or specific URL parameters), the translation fails with a Fatal Error. Instead of rejecting only the problematic feature or failing just that specific layer, the entire FME Engine stops, preventing the rest of the workspace from processing other layers. I have a custom Transformer that read, process and write individual layer. this custom transformer has a group by set to unique layer id.Current Configuration:Writer: ESRI Feature Service Writer (Dynamic).Transformer: FeatureWriterError Message: ArcGIS Online Feature Service Writer: 'column_name' has invalid HTML content.What I Need Help With:Error Handling: How can I configure the FeatureWriter or the

Hi all, I’m fairly new to FME learning a lot but still get stuck at the odd point.II’m using attribute manager to set 2 attribute values to later be used in httpcaller. here I am setting the values and trying to use the values in the below url.  this is going through to the url without the actual value. I have tried both the ${myvalue} and @value() methods but both simply put what i’ve written below into the actual url but not actually the values.  I used the logger to view the above values and they are definitely showing as 100 and 1 but I can’t get them to show up in the below url. Can anyone direct me to what I’m doing wrong here?   

Hi I am using projectwise wgs connector to upload a file into pw. I was wondering if their a way to uprev the version metadata attribute within pw. When the file is uploaded to pw.