Transformers

I am trying to join SQL data with csv data.  The field coming from SQL is uint32.  The field in the CSV is Char but converted to uint32.  Im joining the sets on this field and I get no matches.  here is the SQL data:Here is the CSV date after conversion to uint32:Feature Joiner information:Ive tried the following:Changing comparison mode between numeric and automatic - no change Changing both datasets to be char(4) - no change used Feature Merger - no result change.What am I missing here?

Hi, Is there anyone able to make the Quebec Adresses Geocoder work ?https://servicescarto.mern.gouv.qc.ca/pes/rest/services/Territoire/AdressesQuebec_Geocodage/GeocodeServerI can’t make it work and don’t know why.Thanks! 

Found that I had an old thread on the same subject. My question now should be: Are there any new methods that are faster than those suggested in the thread above?  --original question---I am trying to speed up a work bench. What I have: DTM georasters where the highest (statCalcMax) cell value of each raster has been extracted into an attribute. The other cells have been given a nodata value. What I want: I need to find the x-y postiton of the cells that have a value in each raster as fast as possible. I would like to find a way to somehow filter out only pixels that have a value before any spatial/geometry processing. What I tried but found to slow:The methods below convert the cells into points before identifying the cells I need. This makes them really slow.RasterPolygonCoercer › CentrePointReplacer › CordinateExtractor RasterCellCoercer › CordinateExtractor PointCloudCombinerAny ideas on how to find the position of the desired cells with as little spatial/geometry processing as pos

Hello All!I am trying to geocode a series of addresses that are in a CSV using a geocoding service on Portal/ArcGIS Server (11.x). I have the web services connection authenticated and specified in the tool, and have tried the URL with and without the “findAddressCandidates” section - the results are still being rejected stating that the address hasn’t been supplied. I’ve also tried using a string concatenator to create the address string before connecting it to the Geocoder transformer & I’ve also tried to call out the address using its individual components using the text editor and calling out the specific fields in the format of “100 Street Name, City, State Zip”.I feel like there’s something obvious that I might be missing - I’m just not 100% sure what it may be. Thank you for the help in advance! 

Good morning yall, Im banging my head trying to find the issue as to why I cannot read this.I have TemppathnameCreator before my google drive connector. google drive is saving a folder to that temp locationfeature reader is supposed to grab that drive folder and read a csv out of it.Ill paste some screenshots below. Hopefully is some setting in the feature reader. Much help is appreciated!

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.