FME Form

I’ve been struggling with the File Geodatabase Open API FeatureWriter in FME. When I create a new file geodatabase from scratch, everything runs successfully. However, when I switch the FeatureWriter to Drop and Create, I encounter random failures with the error:Geodatabase Error (-2147467259): General function failureHere’s my setup:The workbench consists of a series of Oracle SQLExecutors that read each table, followed by a FeatureWriter to convert the data into feature classes in the file geodatabase. I originally used a dynamic workspace, but after seeing this error (and reading advice to limit the number of features processed dynamically), I changed the design so each table is processed in series. The failures occur at different FeatureWriters each time, so it’s not tied to a specific table. I tried using Trunca

I have images taken by a camera mounted on a vehicle, with GPS (4326) coordinates recorded every millisecond. I also have a road reference dataset in a shapefile (epsg :2154) and I need to match my millisecond-spaced images (and their GPS coordinates) to this road reference. There will obviously be some discrepancies between the GPS measurements and the reference dataset, but how can I best align the GPS data with the road reference? What is the best method to do this?If you’d like, I can also help you rephrase it more formally or technically.Thank you

My scope currently is to produce an excel output using FME ensuring the template is being leveraged to populate the values in this columns. Some of these columns have formulas which have been coded in FME as AK.formula if the column AK has formula. However when I convert the FME produced Excel to XML and investigated this, the formula seems to be converting “ into &quot. However I get to know about this only when I checked XML since Excel exactly imprints the formula as coded in FME. What is the best way to resolve this issue?

Hi, The workbench to convert the File geodatabase to CAD was working until the FME/ArcGIS upgrade. The workbench is now not writing many line features  with the following warning The following feature is not valid because its entity type of 'fme_no_map' and its geometry type of 'IFMELine' do not match. The geometry failed to be converted to match the type, so the feature will be skipped.  Warning : Attribute(string; UTF-8)           : `autocad_entity' has value `fme_no_map' FME version : FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64) How can this be fixed? ThanksSresree

I have a raster broken up into a grid of raster cells using RasterTiler.  I want to rotate each cell X degrees (not the whole raster) in place.  I do *not* want to rotate around the upper left corner.  I need the cell to rotate and remain in the exact location.As I understand it, my process is using the following transformers:RasterCellOriginSetter: Set to 0.5,0.5 (the center) Rotator: Set Rotation Angle to X. RasterRotationApplier: Interpolation Type = Bilinear.When I do this, the cells are rotated around the upper-left corner rather than the centroid.Do I have the correct transformers & settings for this application?

Hi,I have 79 single-band rasters, each a step in a time series, with Int8 values that reprepresent a risk class. I want to get the max value for each cell and use a RasterMosaicker to achieve that. Then I use a RasterToPolygonCoercer to convert to polygons for further analysis. My problem is that converting the raster from the RasterMosaicker is extremely slow and performance demanding compared to converting the individual raster I have before the mosaicker (the timesteps are converted in a matter of seconds whereas the mosaicked raster takes in the range of an hour or more). This is an example of my workspace:Why is it so much slower to convert the mosaicked raster? As far as I can see they have the same properties and dimensions. It does have more data but not by much and still most of the cells are nodata. Is there a faster w

I need to take hundreds of thousands of connected 3D faces in DWG files and write them to separate IFC files, where each IFC file contains a single surface made up of the multiple 3D faces in each DWG.I have a working solution to accomplish this without merging the surfaces but it is very resource heavy and creates large IFC files, about 10x as large as the DWGs. Using SurfaceModeller accomplishes what I want, however the resulting TINsurface is extrapolated along the entire circumference of the combined features which creates geometry that doesn’t exist in my source data. How can I merge the surfaces without changing them?My workspace: 

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’

On FME Flow we added a Network Based Resource. In FME Flow, I can see that the system path of this Network Based Resource is characterized with a parameter, e.g. '$(My_Network_Based_Resource)'. I had some trouble on using that parameter in a workspace with FME Form Workbench. FME Form is not aware that this parameter exists, and upon using it in e.g. a path reader.Is there any way that you can expose additional FME Flow parameters to FME Form Workbench? As a workaround I was able to use a ParameterFetcher, and then feeding in the attribute value of the Network Based Resource into the FeatureReader, but that seems not ideal. Also, the ParameterFetcher does show a Red Cogwheel, because it is not aware of the parameter. Another alternative is probably to create an additional 'FileURL' type of parameter, and set the (default) value for that parameter to '$(My_Network_Based_Resource)'. However, also here it seems th

I have a process in FME and I want to send an email with the Emailer transformer at the end. I've already written in the email body the data I want to appear in the email, but the problem is that I want to send it in plain text format and not in HTML. The Emailer transformer always wraps my text in HTML, even though I already changed it to FME's format; it seems that every time I exit the transformer to run the process, it doesn't save the text settings in the transformer. Does anyone know how to change this?

Hi everyone,I have a geometry problem in FME and I’m not sure about the best workflow.In the image below, the red point belongs to a feature that is connected to a black point (the black point is the reference).What I need to do is: Take the line highlighted in green. Starting from the black point, find a position 10 cm along the line. Move (or recreate) the red point exactly at that location — meaning: the new point must lie on the line, and must be 10 cm away from the black point. I know the relationship between the red point and the black point from an ID attribute, but my problem is:How do I calculate this “point on line at 10 cm distance” inside FME?  

Hello Forum, I have two polygon datasets read into a FME Form workspace: Dataset 1: Super Output Area (SOAs): This is where the entire authority area is divided into 165 SOAs. No part of our authority area is not covered by a SOA. Dataset 2: Air Quality Focus Areas (AQFAs): These are specific areas for a particular purpose. Only selected parts of the authority area are covered by an AQFA.  Datasets 1 and 2 are entirely different and do not share boundaries or nest etc. If that happens anywhere it is entirely coincidental. I need to know what percentage of each SOA intersects (overlaps) with an AQFA area. Some SOAs are going to be fully outside an AQFA. Some SOAs will be partially within an AQFA. Some SOAs will be fully within an AQFA. I want to know what percentage of each SOAs is within an AQFA. The results would be added as a new attribute to the SOA dataset as a p

Ever since the merging of SQLServer spatial and SQL Server non-spatial Reader types, my SQLCreators and SQLExecutors generate a warning:Microsoft SQL Server Reader: Table `___FME_Custom_SQL_Statement___' does not include a spatial column. Geometry will not be read In Form this is easily ignored, but it really messes up my Jobs overview dashboard on Flow, because it results in quite a lot of listings with warnings that do not need checking. And I can’t seem to find a way to tell FME that yes, I know, there is no geometry coming through in this sql, don’t worry about it because I did not select it - on purpose (or because it does not exist).I really do not want to turn off all warnings generically, I am just searching for a way to stop this particular warning. Before the merge it was easy: just use the non-spatial type, and the warning would go away. But that is not an option anymore unfortunately...  

EDIT - Solved, see comment below regarding using the term “Bearer”.Hi,I am delving into the world of Flow Hosted. I am undertaking a Proof of Concept to discover the pros and cons. Concept: I’ve bult a Flow app (note: Flow, not Flow Hosted) to drop a random file into an Azure BLOb storage. I then have a workbench to monitor the BLOb, and when a new file is detected I want to start my currently “paused” Flow Hosted Instance to fire-up and inspect the newly arrived data and report back to say it has found it!It seems that my best approach is to use HTTPCaller in my workbench to use the PUT method and the details copied across from here: FME Flow Hosted API (I can launch the instance from the API page so I know it works using PUT/instances/{instance_id}/action/start) but I am str

With the new spatial definition option in the FeatureWriter, it appears that Attribute Definition cannot be reverted to Automatic after first setting the Spatial Definition? In my case the format is set to PostGIS. Is this expected behavior? Am currently running FME Form 2025.1.1.0, Build 25623.

Hi Folks,For reading and writing ArcGIS Online feature services we are transitioning to the newer Esri ArcGIS Feature Service format in FME Flow 2024.2 from the soon to be deprecated Esri ArcGIS Online (AGOL) Feature Service (at least according to this article)My problem is that now the reader seems to read dates as Epoch time in milliseconds! Obviously this can be worked around but it is quite painful to fix up the many workspaces we have which used the older reader and read dates as YYYYMMDD etc. especially when writing back to AGOL where the dates have to be back in  YYYYMMDD.Any thoughts?  

I have a field with city names and state names in this format:Oklahoma City OKOakland CADallas TXForth Worth TXAugusta ME  I want to do the following:Extract the City name into one field and the state abbreviation into another field. The only consistent pattern in the data is the state abbreviation always comes after the last space in the string. I think I need to create a RegEx expression to do be able to do this. Can someone help me with how do this? 

Hi, has anyone encountered this issue with 2025.1? Or am I doing something wrong? 

As of today we get a message trying to login to Autodesk with the FME web connector.I think we use the settings provided by the Autodesk integration:Client ID: 9YJwNVyykGTllW87Y45yDUGLRvvOmVhMClient Secret: dont knowRedirect URI: https://127.0.0.1:443Auth Url: https://developer.api.autodesk.com/authentication/v2/authorize?response_type=code&scope=data:read data:writeRetrieve Token: https://developer.api.autodesk.com/authentication/v2/tokenRequest format: code=[CODE]&redirect_uri=[REDIRECT_URI]&grant_type=authorization_codeRefresh token: 

Dear community, I have implemented a workflow with FME and ArcGIS Enterprise, in which an automation is triggered in FME via a referenced feature service with a webhook. Based on the entries in the ArcGIS Field Maps App, an e-mail is then to be sent via FME.This is set up accordingly according to the following documentation: https://support.safe.com/hc/en-us/articles/25407414850061-Integrating-ArcGIS-Enterprise-Feature-Service-Webhooks-With-FME The connection from the application in ArcGIS Enterprise to FME is also set up accordingly: https://support.safe.com/hc/en-us/articles/254077

We currently use the FME App but this requires our users to authenticate in FME Form and then upload this webconnection to FME Flow. And these users are logged out after a period of time.What are other company solutions for Flow connections to Autodesk? Didn't we look at the right documentation?

Hi all,Got a strange situation with the SharePointOnlineConnector (both in FME Form 2024 & 2025.2).I want to upload a file towards a certain sharepointsite. In the GUI I can select my site: ‘https://mysharepoint.com/teams/teamA, my library and my Path.  If I want to make my site dynamic, so File A needs to to go site from TeamA and File B needs to go to site from TeamBI’m not able to do this. User Parameter does not work. Making the url like this: https://mysharepoint.com/teams/@teamValue does not work → Even for the File for TeamB it still refers to the site from TeamA (or whatever team I selected to create the workspace).Even using the setup of getting the <HostURL>,<siteID>,<webId>  provided from attributes:

Has anyone in the UK who is using the Ordnance Survey Maps API managed to get them added into FME for use as a background map.  I have tried and get nothing to display….Any advice welcome...

Hi There,I am using a Text-FeatureReader to process .csv for input into a geocoder.  The problem is that these user-created csv contains Line Breaks and the addresses candidates cannot be read into the geocoder or even the Text-FeatureReader (please see attached grapic)...  I have a StringReplacer ready to fix the issue downstream but the problem is that the TextReader can not read and pass along the Line Break data (it goes missing) and I do not see any settings within the Text-FeatureReader itself to handle the string replacement.  --FYI I am using a Text-FeatureReader instead of a CSV-Reader because the data schema is always unknown.  Any help would be super appreciated.  Thank you!.

I use several XMLXQueryExtractors in my workspace, each with queries similar to the example below. Sometimes a query returns no results, which causes the transformer to generate a warning. This leads to a lot of unnecessary log entries and clutters the log.I’ve tried checking whether the query returns a result before processing it, but the check still sometimes evaluates to “no result.”Does anyone know how to prevent these warnings? Could it be related to the fact that return only uses fme:set-attribute and therefore doesn’t actually return a value?Query:declare namespace gml = "http://www.opengis.net/gml/3.2";declare namespace aixm= "http://www.aixm.aero/schema/5.1";let $id := fme:get-attribute("arc_id")for $arc in ( //gml:Curve[@gml:id = $id]/gml:segments/gml:ArcByCenterPoint, //aixm:Curve[@gml:id = $id]/gml:segments/gml:ArcByCenterPoint)return ( fme:se