Transformers

Trying to understand how the AreaGapAndOverlapCleaner works. Set to Fill All Gaps No and Repair Method Priority (Edge Preserving) with a tolerance of 1mSo why does it change the boundary of this polygon where it neither overlaps or is a gap (it’s the edge of coverage) 

I’m having trouble finding examples for JSONTemplater when working with a JSON array input attribute.The incoming data looks like this:{"layers": [ { "defaultVisibility": true, "geometryType": "esriGeometryPolygon", "id": 1, "maxScale": 0, "minScale": 0, "name": "Parcels", "parentLayerId": -1, "subLayerIds": null, "type": "Feature Layer" } ]}I’m interested in extracting the first array member id value into an object like this:{"layers": [{"id": 1}]}I can almost get the data into what I want in two steps, first extracting the value with a query json["layers"][0]["id"] and then using the JSONTemplater to use the id value, but bizarrely the value 1 is cast to string “1” byt the templater, which is invalid for downstream work.Anyone know how to make what I want in one step with JSONTemplater?  Thanks.

I have rasters with one alpha channel and one grey channel. I need to ensure that the grey band is grey8. How do I coerce only the grey band and leave the alpha band untouched?The RasterInterpretationCoercer will change both bands and I have not found any other transformer that fits my requirements.  

I’m trying to run some workspace through Task scheduler with FME Form. I’m using an Emailer package and when I run the task as my user, everything is fine. But When I run it as local system it always fails as it can’t find the package. I tried defining Shared folder and setting up environment variables, but couldn’t make it work.As for setting up shared connections it works fine, but not with packages.What would be the right setup for this?

I’m trying to convert those attribute values whichever has comma into an array.Attribute A has values - "ABC" and "ABC","DEF" and "ABC","DEF","GHI".Desired output -“ABC”["ABC", "DEF"]["ABC", "DEF",”GHI”]Any inputs are appreciated. Thanks very much!Tagging ​@danilo_fme , ​@david_r 

I am trying to create a single ArcGIS Enterprise Feature Service that contains multiple layers using the Feature Writer transformer using the ‘Esri ArcGIS Feature Service’If I run it for a single layer, it works fine but as soon as I try for multiple layers, it fails with an error message.“No layers/tables are found matching the name ...” Are there settings that need to be enabled to allow it to write multiple layers or does it only work for a single layer? 

FME 2025.1.3.0 Build 25643I downloaded the new ArcGIS Feature Service Package and set up a connection using the Esri ArcGIS Online OAuth Web service. When I attempt to insert a new feature into an existing AGOL feature service using the default values of the Esri ArcGIS Feature Service format, I get a warningWARN  |ArcGISFeatureServiceWriter: The field 'GlobalID' has a NotNull constraint, but it is NULL, missing, or empty. Skipping feature...The feature is not committed but the FeatureWriter or Writer (I tested both) shows success and the number of features written as 1. Without reading through the warnings, I wouldn’t know there was a problem.Since I’m inserting a feature I don’t have a globalid! And the field is noneditable in the feature service, so it seems like an odd error.Messing around with the settings I found that if I made sure the GlobalID field was exposed in the User Attributes and in the Advanced Parameters “Use GlobalID” was set to Yes, then the feature would insert. Bu

Ya, tokopedia memiliki WhatsApp resmi yang bisa langsung di hubungi di Nomor +62859^3460^8879.

Hi all,I am fairly new to FME. What I wanted to implement I was able to figure out with the community here or the trainings at the Safe academy. But now I struggle as I do not understand, where my mistake is.Goal: I need to write features with a dynamic schema. So, I added via Readers a “Reader as Resource”. It is an Excel file from where I want to use a specific sheet. There a added my columns which shall be written to my target source. Writing a FFS file works as expected by using the following configuration.One important note: a sheet in excel has a limitation for the name. As I need to create a dynamic workbench which can read different source files and handle a different amount of dynamic columns per source file, I want to name it like the feature type - but shortened to what Excel can handle.Dynamic Schema Definition configured and working As I need also to write the same data to an EGDB, I use the JDBC format - with the same configuration:  This does not work as expected. I have

Hi all!I’m looking for some possible help with my FME workflow (dwg to geodatabase). I have a DWG reader followed by several geometry transformers, and the geometry is working well. Where I’m stuck is the attribute schema.I have a CSV/Excel file that defines my target schema. it’s structured row-by-row. each row represents a single attribute, not a feature. All the attribute fields are under the same "attribute_value" column. So, each feature class is represented by many rows. For example, electrical pole has 8 rows—one row each for pole_id, owner, project#, etc.—all sharing the same source layer, output feature class, and dataset. Another feature class (vegetation) follows the same pattern but with fewer rows because it has fewer attribute fields.I need the geodatabase to have each feature class only contain the attributes listed for it in the CSV, and nothing extra. I understand this requires a dynamic writer, but I haven’t had success yet. I currently have a SchemaMapper set up just

In the answer to this questionEsri ArcGIS Feature Service - Reads Dates as Epoch Milliseconds | Communitya URL is given to the FME hub which doesn’t match the address I’m used to seeing for FME Hub, crucially the info on this package is all quite different too This is what i’m familiar withhub.safe.com/publishers/safe/packages/esri-agolEsri ArcGIS Connector - FME Hub and this is the link providedhub.fme.co/publishers/safe/packages/esri-agolEsri ArcGIS Connector - FME Hub

Greetings everyone,I have a large number of 2D polygons for which I want to determine the Z value. I also have a DTM (digital terrain model).Now I have observed the following: If I take only one polygon and, using the FeatureReader, read in only exactly those triangles of the DTM that are touched by the polygon in 2D, and then determine the Z values of the polygon using the SurfaceDraper (always carrying forward only z_max and using that as the Z value via the 3D_Forcer), I get different Z values than when I first create a buffer around the polygon and then pass the buffer to the FeatureReader and include the triangles around the polygon in the SurfaceDraper.The triangles from the DTM do not touch each other.There are deviations of several meters, depending on how strongly the terrain height varies around the polygon.It seems as if the SurfaceDraper somehow takes the surrounding terrain into account, even if it does not touch the polygon.It cannot be due to the tolerance; I have alread

Oh no, I put my question into the wrong Category (Community Q+A). I cant move the thread.Sorry for the double posting, but it seemed, that in the Q+A category is nobody who can move my thread (or?).So I post this one here with the link to my wrong settet Post.  

Hello,I am testing out the Esri ArcGIS Feature Service writer that is in the Esri ArcGIS Online Connector package (Esri ArcGIS Connector v3.13.2). I’m using Form 2024.2.2.0 (20250114 - Build 24820 - WIN64). Screenshots are edited to remove confidential information. I have noticed that the “Target WKID” cannot be left blank even if you have selected “Feature Service Handling: Use Existing” If I am understanding the documentation correctly, this parameter is only needed if the writer is creating a Feature Service. However, as the default is set to WKID 102100, if you don’t change this to the correct WKID, it will write the data out to the wrong location. I initially made this mistake before I realized I had to input my data’s WKID. For the old Esri ArcGIS Portal Feature Service Writer, you were able to leave this parameter blank: I think this parameter being a required parameter is unnecessary when Feature Service Handling is set to “Use Existing” and I like the way it was in the older w

hi everyone! some of my line features (pipes) have text features floating above (top left) of the line, describing what type of pipe it is. I want to add that text as an attribute field to that feature. but also not all of the lines have one and I want it to only match if it's describing that feature (not grabbing a random text field nearby). I'll also note that everytime I've tried to use neighborfinder, the autocad_text_string AND fme_text_string values of lines show numbers (ex. 356.77, 623.44) instead of the descriptive text it should have shown. I've been trying this for hours and would appreciate any help given. thanks in advance!my workflow is: DWG Reader →  Attribute exposer →  Feature joiner1 CSV Reader →  Duplicate filter →  Feature joiner1 Feature joiner1 →  Deaggregator → 2D forcer → Geometry filter → point/text & lines Point/Text → Tester (if fme_type = text) → Attributemanager (create new attribute field: final_textstring, set to @value(autocad_text_string) & dele

Hi,In the headers section, it seems it’s mandatory to define the header parameter immediately.Is there any way to push a Json or a FME attribute to define a dynamic header to use?My issue is, the client API Rest has many methods with different header parameter. I’m trying to setup a custom transformer that will be able to handle dynamically the header to set. But it doesn’t seem possible to do it right now?Any workaround to achieve it?Regards,Jean  

Hi FME Community,I’m working on a project where I need to create a 3D cone shape in FME 2025 and publish it to ArcGIS Online 3D viewer. The cone should:Start at ground level (let’s say Cape Canaveral X, Y, Z coordinates). Have a base radius of 500 m. Extend in a cone shape getting wider upwards at a 7° angle. Reach approximately 50 km into space (so it’s a very tall, tapered cone).I’ve tried using combinations of Creator, Taper Line Bufferer, Rotator, and SurfaceBuilder, but I’m struggling to generate the correct geometry and export it in a format that ArcGIS Online accepts (e.g., Collada, OBJ, or multipatch).Challenges I’m facing:Generating the circular base and apex points accurately. Applying the 7° tilt without breaking the geometry. Ensuring the output works in ArcGIS Online’s 3D environment.Has anyone successfully built something similar in FME?Which transformers or workflow would you recommend? Any tips for handling such large Z values (50 km) and coordinate systems? Variable in

Hi, I have a workspace in which I read features from different postgis tables and attach their schema with the FeatureReader.Then I want to write dynamically the features in a geopackage.When writing, the gpkg writer tries to use the fields defined as primary key in the schema, but sometimes I have several or the primary key is not an int as requested by the gpkg format.How can I easily delete the information on the primary key fields in the list attribute{} created by the FeatureReader ? I assume I have to delete if in the subattributes fme_data_type and native_data_type in the list.Furthermore, some features read contains id column, how to handle this to not interfere with the gpkg writer ? In the past there was an option in the writer to specify the name of the gkpg primary key.Maybe the creation of a gpkg_id field defined as Primary key is enough ? Thanks for any advice !P.S. : I use FME Form 2025.

I have a workspace where the DateTimeCalculator is failing for all records. The rejection code is always INVALID_INPUT. And yet, when I view the data in Inspector the two input fields I’m using both list as Date under Data Type. The dates look fine fine (e.g. - 20251216). It fails for any mode - Add or Subtract, Calculate Interval, etc. Any ideas why it’s failing and what I need to do to fix it? (FME Form 2025.1.0.0)

I have a schema JSON file that I want to use to validate various JSON files. What transformers can I use to perform this functionality? JSON Validator only validates syntax and not schema so what's the alternative for this?I have added pictures of the sample JSON schema and also the JSON file that needs to be validated against that schema.

Hi everyone!I’m learning about dynamic flows in FME and I’ve encountered two issues that I haven’t been able to resolve yet. I’m reading multiple .gpkg files from a folder, but in the output, all the data is saved in a single .gpkg file. I need FME to generate a separate output file for each .gpkg read. How can I set this up? When I insert the Attribute Manager and rename the attribute from acm_id to id, the values of that attribute (acm_id) turn null after the renaming, and the new attribute (id) does not appear in the final output file. Does anyone know how to prevent this from happening? Thanks in advance for any help or suggestions!

I have used a Directory and File Pathnames reader to generate an attribute holding file paths for the .xlsx files that I need to read in to my workbench. My plan was to use a FeatureReader to subsequently read these files in but I am struggling to get this to work.There are multiple worksheets in each .xlsx and I only need the contents of one - in all cases the applicable worksheet has the same name and an identical schema, the column headers are all on the same row as well.I haven’t been able to work out how to configure the FeatureReader as when specifying the dataset from an attribute the parameters to specify ‘Sheets to Read’ and ‘Field Names Row’ are not available.I would be very grateful for any advice - thanks in advance.

I’m currently updating all of our tools to a new input dataset. In the process, I’m relying on the transformers to tell me when there are issues with the new schema. The issue I have found is the TestFilter is not flagging these as Incomplete Transformers. Build is 25237, and all transformers are up-to-date.I want to believe I have seen this behavior on other transformers, but the TestFilter is by far the most prevalent case and has the potential to cause the most problems in our workflows.Is there a work-around to check for Incomplete Test Conditions? Original configurationWhen the connection is removed, the transformer does not become Incomplete. It’s only when you drill down into the Test Conditions that you see the issue.To rule out something weird going on with my workspace, I created a fresh test from scratch. The issue persisted here as well. 

I have an existing process that processes versioned views from an ESRI SQL Server Geodatabase to another SQL Server Database creating SQL Spatial tables with a geometry column that I have reprojected to WGS84 Lat Long. Can I add a second geometry field to the SQL spatial tables and populate that column with Web Mercator geometry? I am trying to figure out a single workflow that would calculate both columns in the same table. Or am I restricted to calculating one geometry column at a time in separate processes?  

Hi, I have set the spike remover to 3D dimensions to read 3D solids however everything is being rejected due to - ‘Invalid Geometry Types’. Any ideas?