Transformers

Hi guys,how can i handle to read in Excel sheets (with other column names from time to time) and have the possibility to choose from a schema (xls) the right attribute names for the workflow…..Parameters on the reader?I’ve tried the Attributemanager and import a excel file...but the names from the excel sheet are only added to the default output attribute names a dropdown list on the Output Attribute name would be great……..any help to handle it or a link to another articleGreetz and thanksFranco

I have the following table, very simple:DATE_START ID 19921101 0502010000013950 19950209 0502010000013950 20031231 0502010000013950 20040115 0502010000013950 20040120 0502010000013950 20110704 0502010000013950

This issue seems to appear again in FME 2025.1! 

I'm trying to update (or rather replace) rows with new features and write them to geopackage. The problem is geopackage primary key is "id" that is generated when writing geopackages and I'm reading features from postgres where that same id doesn't exists and another id (let's call it ChangeID) is used as a primary key. ChangeID does exist in the geopackages and postgres table but geopackages primary key must be "id".  Unfortunately I have no control over why the id's is implemented like this. Also I know i could read those geopackages in to fme to get the "id"s but the problem is the dataset is hundreds of geopackages resulting in 100 millions of rows so the whole workflow is designed no to do that because that would result to weeks of runtime. I have a workflow to get rows that need to be replaced but fail to write them into geopackages because i can't use ChangeID to replace the rows because of different primary

I'm having a set of polygons and for every polygon a raster with height values. I'm combining them in the TIN generator to create TIN's for every polygon. Now I see a big difference in behaviour of the TIN generator, depending on the amount of polygons I'm sending to it. For example: when I use one single polygon as input, as a result I get a TIN with 234 triangles.If I use 459 polygons as input and proces them individually by using Group processing, the result of the same polygon is a TIN with 3602 triangles. Can anyone explain why this is happening and how to prevent it?

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.

I got this error when trying to add attachments to AGO: The ArcGIS REST API returned an error: HTTP Error Code: 413 : '' Message Code . Further details: 'The page was not displayed because the request entity is too large.'Esri community has a solution to edit the header, but there’s no option to edit header on transformer? 

I have used a PythonCaller to flatten a xml dataset and have many handfulls of attributes that need to be exposed. Cutting and pasting into the AttributeExposer does not feel appealing. Surely there must be an easier way to do this? After all the features already have these attributes, only they are set to be Unexposed. It should be just a hide-unhide setting that is needed? 

We upgraded FME from 2022.2.2 to 2024.0.2.2 one week ago, and I found out today the SQLExecutor gives an error for the SQL Server T-SQL Merger statement.  The SQLExecutor is set up as follows:----------------------------------------------------------------------------------------------------------FME_SQL_DELIMITER ;use VENDOR_GLOBAL_SPGI;MERGE INTO SPGI_INT.BLOCKS_VALID_INT AS tUSING (select distinct GA_ID,BLOCK_NAME,ONS_OFFSHORE from SPGI_INT.BLOCKS_VALID) AS sON t.GA_ID = s.GA_ID and t.BLOCK_NAME = s.BLOCK_NAMEWHEN MATCHED THEN    UPDATE SET t.ONS_OFFSHORE = S.ONS_OFFSHORE;--------------------------------------------------------------------------------------------------------It gives this error:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement.  Query Text `MERGE INTO SPGI_INT.BLOCKS_VALID_INT AS tUSING (select distinct GA_ID,BLOCK_

Hi All,We have deployed FME Flow 2024.2.2 with ArcGIS 3.4 and wanted to run a few tests to ensure that Flow works correctly with the arcpy library. Below is the installation setup on the same virtual machine:FME Flow 2024.2.2 ArcGIS 3.4I have created a very simple Workbench in FME Form that invokes arcpy, and it works fine with the following Python compatibilities:Esri ArcGIS Python 3.9+ Esri ArcGIS Python 3.11I uploaded the same Workbench into FME Flow 2024.2.2 and encountered the following error after running the tool:Any idea? I have tried with 3.9 and 3.11 already,Thanks in advanced :)

Hello,Created a nice workbench with FMe. However, there are also many individual points in the data, which are poorly visible.Which transformer can you use to replace a point in the data with a symbol (e.g., a circle with a specific diameter)?This improves clarity and better visualization in the final result.

Hi I am uploading data to S3 using the S3 connector. However, empty folders are not being uploaded, even though I have selected “Contents only” as No. I need to upload some projects that contain empty folders and subfolders as well.!--startfragment>  Many thanksNasir

I’m running FME 2024 soon to be 2025.My workflow is reading tables from SQL Server and writing them to Snowflake.Can someone please advise if it is possible to have the workflow automatically handle new columns being created on the source table?I don’t want to have to publish a new version of a workflow just because a source table has a new column added to it.Thanks in advance.

Hi,I have 3 raster’s that I wish to merge into one. Two of the 3 are of the exact same extent, cell size and CRS. The third has a larger extent (but overlapping the first two) and a smaller cell size. The issue I am having is that once I have resampled and clipped the 3rd raster to the extent of the other two they are mis-aligned, and I can’t figure out how to fix it. I need them to be exactly aligned so I can merge them. So far this is my method:Read in all 3 raster’s and ensure their CRS is the same (Using ... Resample the 3rd raster to the cell spacing of the other two (5000 x 5000) Raster 1

I'm running into a small issue in the canvas. When I start typing "AS" in the transformer search bar, I expect AttributeSplitter to pop up, but it doesn't show in the suggestions. 

 Hello, I use FME Forms 2024 and I have a very basic workbench just to test the emailer transformer and the configuration of our email system.The Emailer is the following version When I run I have this error and it fails: <class 'socket.gaierror'>: [Errno 11001] getaddrinfo failed Any Idea ?Is it a probleme of mail smtp mail server accessibility. What is the configuration to adapt ?RegardsFred ​​   

Do you know the best way to convert a Raster.gdb (with 31 records and no Length or Area fields) to Vector .gdb (would have probably around 5 million records)  in FME ? The only unique field is OBJECTIDI used RasterToPolygonCoercer but it is not bringing any of the attributes from the Raster dataset to the vector dataset- everything is blank Also I want the new vector data to be smoothed if possible.

Hi!I’m using FME Workbench 2022.I’m trying to insert some data in a table in PostgreSQL. The table has a composite key, like this: (id, feed_id, env_id). The table, obviously, has the constraint: CONSTRAINT agency_pkey PRIMARY KEY (id, feed_id, env_id).In FME, I’m reading from a GTFS file, doing some transformations, and then, trying to write into the DB with a FeatureWriter using PostgreSQL as Format. I have all the configurations right. I checked it so many times, and before posting this question, I talked to some experienced mates.The problem I have is, in runtime, the FeatureWriter is not adding the attribute called “id” to the insert, so the database is sending the error “null value in column id violates not null constraint”. It happens with and without bulk mode.Now I’ll provide some images for visual context and information.Flux:

I'm trying to reproject a DWG file from AGD 1966 ISG 56 (EPSG:102077) to GDA2020 Zone 56 (EPSG:7856). I'm using the original DWG as a template to preserve layers, colours, line styles, etc.I've set up a workbench to handle the reprojection and all the data looks good and in the correct location when viewed at the final step in the inspector:However, when I open the output DWG, most of the data is correctly reprojected (matching what I see in the Inspector) but some features remain in the original coordinate system, thus showing up in Antarctica:

Anyone having this issue ? Even if everything is fine with the parameters in the transformer, I see the red arrows. When I zoom in / out everything is ok. Kind of annoying. I’m using 2025.1.3.  

I feel like everytime I try the PythonCaller I really struggle with the scripting and usually switch to a start up script to avoid it. Can anyone help me figure out why I don’t have any outputs when I run this in my PythonCaller.  import fmeimport fmeobjectsimport reclass FeatureProcessor:    def __init__(self):        pass    def input(self, feature):        """        Processes a feature to extract and set address components.        Args:            feature (fmeobjects.FMEFeature): The feature containing the address attribute.        """        # Retrieve the address attribute from the feature        address = feature.getAttribute('ADDRESS')        # If the address is missing, set all related attributes to empty strings        if not address:            for attr in ['Suite', 'AddressNumber', 'StreetName', 'StreetType', 'Direction', 'Street']:

Hi,I created a parameter in my custom transformer of the following form:PARAMETER_NAME: LRF_FILEPARAMETER_TYPE: OPTIONAL FILE_OR_ATTR LRF(*.lrf)|*.lrfPARAMETER_PROMPT: Label Rule File:PARAMETER_DEFAULT: $(FME_MF_DIR)No matter what value I enter for the Parameter_Default, the file box on the transformer GUI always initially shows up empty in Form. Can someone suggest what I’m doing wrong?Thanks,Martin

Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:

Hello, the workspace is close to “Creating CityGML Solitary Vegetation Object | Community” but without the issues. I would like to randomly rotate the instances along the Z axis. Dimensions are set as in the first matrix shown below. When I use the last row to rotate, as shown in the second matrix below, the rotation is ignored and dimensions change. I tried the rotators, and the 3D affiner after defining the matrix to no good results. It seems that CityGML only looks at the transformation matrix.  Any advise or workaround to force instance’s rotation is appreciated. I have a random rotation value stored in an attribute brought as an attribute of the location point. +++++ Matrix withOUT rotation +++++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.0

Hello, new to FME here and am looking for some advice on which transformers might work for a workbench that I am trying to create. I have 2 road line feature classes stored in an SDE geodatabase. The lines store similar information but are created and maintained by two different departments (they have different road name standards and the geometry does not match). I would like to compare the lines and identify which ones from Roads_A are missing from Roads_B.  My main concern at this point is identifying missing subdivisions like the one in the screen capture below.