FME Form

I am having an issue converting data from an Excel file to xml due to an invalid character reference. In Excel the character appears as a space but as a square or “GS” when read in FME (see images). I am trying to build a validation tool that will find cells in the Excel file that contain these special characters. How do i find these characters using for example  test filter, attribute validator or stringsearcher etc 

Hi allI have been batting my skull against this for some time and havent been able to come up with a solution.I have about 60 datasets (and will be receiving about 60 every month from now on) where every line has a date and a time and a value containing a number. See attached file. its a dataset from a callcenter where every line is and hour and the number is the number of staff that are answering phones. the number of staff varies from hour to hour and from callcenter to callcenter. but the dataset only contains date hours where a staff memeber has been checked in, if none have checked in here isnt a line. My task is to find the ‘missing’ lines/hours where no staff has been active to monitor if the callcenter has been unstaffed when it shouldnt have been. I cant figure out a way to find these missing lines and add them in an automated way the i can use over and over again. Has anyone tried anything similar and found a solution?

Trying to create a new branch version, then update geometry on the existing features. I have the new geometry joined with Object ID from default, but running into issues on the safe.esri-agol writer.Where version was set to "Jan272026b":ArcGISFeatureServiceWriter: The ArcGIS REST API returned an error: HTTP Error Code: 400 : 'Unable to complete operation.' Message Code . Further details: '['Object is missing.']' Where version was set to include username "admin.Jan272026b" -- CASE matters. I went back and changed it to “ADMIN.Jan272026b” and now I’m back to getting the first error of Object is missing.:The ArcGIS REST API returned an error: HTTP Error Code:  : 'Invalid version name. [The Version name contains invalid characters. (admin.Jan272026b)]' Message Code . Further details: '[]' However when I look at the versions, I see:versionName: ADMIN.Jan272026bversionGuid: {9466ACCA-2E0A-4D75-9789-CE40F1E941BA}

 I’m currently working on a project in relation to building a major road network which can be used for future traffic surveys.  I’ve hit a snag where I’m trying to find potential way of detecting branches within the carriageways so that we can set a condition that should the branch be longer than 500 metres, then we need to separate this branch as its own features.  What I’m struggling with is trying to detect the branching by applying unique identifiers (e.g. integer values) if branching occurs within a connected groups of features, something similar to the below: Essentially, I’ve built a two-way road network using the Ordnance Survey road network data and I’ve merged the road sections based on their connectivity (using the [NetworkTopologyCalculator] and [LineCombiner] transformers) and also depending on their ownership (i.e. locally owned vs centrally owned roads) and their road classification number (e.g. A303, A1(M) etc.).  Within each of these merged features we need to work out

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! 

I just updated to version 25.2 and my oracle reader is failing and throwing this warning (not an error):An error occurred while fetching from query `SELECT a.*** FROM *** a' : OCI_SUCCESS_WITH_INFO: ORA-24347: Warning of a NULL column in an aggregate functionWhich causes Translation FAILED with 0 error(s) and 1 warning(s) (0 feature(s) output).My colleague tried the same on version 25.1 and whilst he also gets the warning his translation does not stop and he gets all features to work with. (As did I before my update)Ignoring the fact that the view should be fixed, is there a way to continue the translation with all features? Troubleshoot option Ignoring failed readers simply skips the reader and thus returning zero features.Furthermore I did see a few changes regarding oracle in the changelogs but I could not pinpoint which one is referring to this problem.

Is it possible to switch the Versioning in an Enterprise Geodatabase (on SQL Server) from "traditional" to "Branch Versioning" without touching FME Workspaces containing Esri Geodatase Readers and Writers (GEODATABASE_SDE)? In a first attempt in the test environment, everything seems to be running like before, after we switched to Branch Versioning of our feature classes.  A quick look in the geodatabase tables seems to prove that the internal fields like GDB_ARCHIVE_OID, GDB_FROM_DATE, ... are filled correctly.  Can it really be that simple? Does FME support the switch to Branch Versioning while keeping the Workspaces untouched? Of course, this would be a dream, but this seems too good to be true.     

I am taking a polygon that is the floor of a building, I am then clipping out the exterior wall and the room polygons on it to get the square footage of the space between the walls. However, it is filling in polygons at random when writing to our SDE. When I write these polygons to a .gdb, that behavior doesn’t happen. I have tried to not simplify the geometry, used the donut extractor to only take the outershells, orientor to only choose right facing polygons, etc. Anything else I should try?Preview of the polygon in FME:Polygon in GDB:Polygon in SDE: 

This...may be complicated to explain. We are trying to create Feature Service webhooks in ArcGIS Enterprise. ESRI documentation indicates that this can either be accomplished with the admin Portal (which very few users have access to) or via the “administrative API”https://developers.arcgis.com/rest/enterprise-administration/server/create-webhook/The only way to access the administrative API is to acquire a session token (SSO, username/password, other authentication types are not accepted).In ArcGIS Enterprise, the generateToken endpoint is no longer used, the OAUTH2 “Token” endpoint has superseded it. There is a preliminary authorization step that must be completed before accessing the “Token” endpoint.https://developers.arcgis.com/rest/users-groups-and-items/authorize/https://developers.arcgis.com/rest/users-groups-and-items/token/Authentication in our environment is done via OAUTH2/SAML so when trying to access the “Authorize” endpoint via an HTTPCALLER, the response that I’m gettin

Hi!I have a workspace containing four Writers that write tables to a geodatabase. One of the writers is not working as expected. When i press “Run workspace” some of the attributes get null on almost all of the rows. It seems to filtered on one of the attributes (an attrribute called Name) since it is the same names that ends up null. The transformer in the step just before the writer looks as it should, so something goes wrong in the writer, not somewhere in the workspace. The strange thing is that when i press “Run to this” on the problematic writer, everything works as expected and there is no null values anymore. I don’t get any error messages. Using FME Workbench 2025.2Hope someone has any idea of what could be wrong, or if it is a bug?  

I have a workbench which takes a dem raster and clips it at various points, it converts the raster clips to the point cloud and extracts the highest value for each segment.  i then want to be able to use the highest point with the radiate line generator to show additional lines before being clipped and calculated.  I have tried a 2dforcer, aggregator and others to get the Radiate Line Generator to work, but it fails every time.. any idea how to get points from the workflow, and what have i missed..??If i try the Radiate Line Generator with a ‘normal’ point dataset then everything works fine and as expected..  

Hi,Into an Esri ArcGIS Portal Feature Service Writer sending data to ArcGIS Portal what is the difference between Publishing and Spatial.There is nothing about Spatial in the documentation.Thanks.

The failed feature type issueWe are reading in many featureclasses using GEODATABASE_SDE reader in workspace and recently noticed an issue in FME Form (24.1) where it only throws a warning“A table name ‘HeritageSites_Exclusion’ could not be found in the geodatabase as either a featureclass or table. This may be due because the current user does not have permissions to see HeritageSites_Exclusion”The rejected feature handling is set to TerminateThe workspace runs in success, although this missing table was joined upon and is necessary for the right outcome. I guess I’m posting here to see if others have/had this issue, where only a warning of a missing featuretype is given… we believe it should be an Error WorkaroundObviously, we can place NoFeatureTesters and connect a Terminator to the NoInput port. This is alot of work, so we looked into parameters of the GEODATABASE_SDE reader moreUnsure how the Reader parameter “Ignore Failed Readers” truly works. It seems designed very early on to

The Clipper can subset a raster by geospatial extents, while the RasterSubsetter can both subset and pad a raster by number of pixels, but is there a simple way to pad a raster to a given polygon/geospatial extent?My two ideas are to eitherUse the RasterSubsetter to pad the raster by a large amount of pixels and then the Clipper to bring it back to size.OrRasterize the polygon to the same resolution as the image with a background/NoData value and mosaic the two together.Neither seem particularly efficient. 

Is anybody familiar with setting up readers from SmartSheet in FME so that you can potentially make/send updates to the SmartSheet directly from FME?

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) 

Hi there!I get tons of these messages from some workspaces created with FME 2020 (in Norway) and now  migrated to FME 2024: The Startup Python Script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleErrorI have read the post http://fme.ly/PythonLocaleError carefully, but it does not give me anything. I have nothing such as import arcpy or locale.setlocale() in my Python-code. The example message above is particulary strange, I don’t even have a Python Startup Script. So something is absolutely confusing here.No Startup ScriptAnother example:PythonFactory script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing

Hello,I am creating PDF files using FME and am experiencing a serious performance issue (the process is very slow).I have a PDF template that I read and merge with my data so that each ID gets its own template. I use specific X,Y coordinates to write text at the correct positions in the PDF, and then I use the ID in the PDF writer to generate one PDF document per ID that includes both the data and the template.The output is correct and matches my expectations; however, exporting all records with the template takes a very long time.I was thinking to use  the PDF Page Transformer, but rebuilding the pages also takes a significant amount of time.Is there any way to improve performance and make my current solution faster without completely rebuilding the workflow? thanks in advance FME 2021

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?