FME Form

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: https://developer.api.autodesk.com/authentication/v2/tokenFormat: refresh_token=[REFRESH_TOKEN]&response_type=refresh_token&grant_type=refresh_token&scope= data:read data:write When using a custom app created in Autodesk Forge I am able to connect with these settings (only changing the client_id and client_secret. Also…Would there be any instructions about creating a server-to-server integration in Autodesk Construction Cloud?   

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: It still points towards the old setup and not a dynamic one. Am I missing a certain step? the used Authentication account has rights towards the sharepoint (setup via this guideline: How to Create a SharePointOnlineConnector Single Tenant Web Connection – F

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:set-attribute("startAngle", if ($arc) then string($arc/gml:startAngle) else ""), fme:set-attribute("endAngle", if ($arc) then strin

HI All,I have a bit of geometry challenge to create a rectangle (or square) polygon based on a cross geometry, some example below:Any ideas how to achieve this?Thanks :)

Hi folks,I had a question regarding creating an FME script that takes attributes from a system of record dataset into an existing record created in a feature class within an Enterprise Geodatabase.Workflow consists of the following:Two layers with the same information and attributes in different systems of record – one in an asset management system and feature class in an Enterprise Geodatabase.No integration exists between the two systems yet as there is a new replacement system being developed in a project, but in the intermediary, it has been decided that the business will be updating the asset in the asset management system, then updating the feature class attribute table in the Enterprise Geodatabase. Therefore, they will be maintaining two datasets in tandem until the pilot project for the replacement system is complete.The difference is that the layer in the asset management system only stores XY/Lat/Long values whereas the true layer in the feature class in the Enterprise Geoda

Hi,As Safe people do some fun projects with AI like https://hub.safe.com/publishers/safe-sandbox/templates/agentic-ai-spatial-schema-mapping-template-gemini, would it be possible to do one preparing one or multile schema mapping file(s) instead of mapping all data through AI? You could just send a sample to Gemini/OpenAI (you name it), with the associated schema and restructure the output into something accepted by SchemaMapper. This would be better for performance, safety and the planet 😊. Quite many transformers could be adapted to digest an input like schemamapper so that they can be configured by AI agents in a nicer way. Thanks! 

I trying to find out the differences (and uses) of the 4 version types available in the Esri Geodatabase (ArcSDE Geodb) reader/writer:Version from SDE connection Transactional version Historical marker specific date and timeI’m not clear on the differences between them especially version from SDE connection and Transactional version where the version can be specified. From my understanding the transactional version is where the sde version is specified and if not then the default is used?An explanation or pointing me in the right direction would be very much appreciated.

Hello FME CommunityI got issue when trying to connect to ArcGIS Portal from FME Form 2025.1. I get error “The web connection 'FME Account' could not be loaded”, but unlike in this discussion ()My workspace doesn’t finish normally and actualy is not able to read/write to the Portal Hosted feature layers. I use FeatureWriter and can see layers I want to read/write in the settings of the transformer.Is there any workaround for this? Or we should wait for 2025.2 like in above discussion suggested?I’ve upgraded from 2023.2 where everything works just fine.Thank you in advance.Regards. 

Using FME Form 2025.1.1.0, I have some 30.000 features that have an attribute containing a polygon in Well-Known Text form. For about 4000 of those, GeometryReplacer rejects them with the fme_rejection_code of ‘INVALID_PARAMETER_GEOMETRY_SOURCE.If I check the WKT, I can’t find any problems with it, and if I use https://wktmap.com/ (with an EPSG:28992) the handful of polygons I’ve checked show up just fine without any errors.Example of one that goes wrong but looks good to me (and wktmap):POLYGON ((78388.897 419890.033, 78421.563 419868.628, 78426.311 419875.727, 78429.69 419880.662, 78426.428 419884.195, 78422.297 419888.73, 78417.812 419891.98, 78413.315 419895.15, 78401.216 419903.072, 78397.477 419905.515, 78379.315 419917.4, 78377.366 419915.657, 78378.144 419913.401, 78379.163 419910.789, 78381.446 419908.255, 78384.409 419905.029, 78389.638 419899.094, 78392.82 419895.507, 78388.897 419890.033))As far as I can work out, it does seem to always be the same features (this is from th

I have a Excel in which some cells have STRIKEOUT text. I can find the cells where the whole cell text is STRIKEOUT by using the advise of the below post.Recognize "strikethrough" in cells | CommunityBut the cells which have STRIKEOUT text and normal text are not recognized. I need to exclude the STRIKEOUT text and work further with NON STIKEOUT text, even if both are in one cell. The first record I can find and exclude but the third record STRIKEOUT is not recognized. Is there a way I can only read NON STIKEOUT text if it is included with STIKEOUT text?The STIKEOUT text could also be part of a sentence like: abcdefghijek mno pgrs tuvwxyzwhere pqrs should be left out.

Hello, I have a polygon dataset and I am trying to find the polygons that are within 200m of another polygon. I am trying to do this using the NeighborFinder in candidate only mode with the “Number of Neighbors to Find” = 1 and “Max Distance” = unset and then using a tester to select the features where _distance is less than 200.  I am getting a lot of features out of the “unmatchedcanidate” port though. I would have though with number of features to find = 1 and an unset max distance all candidates would be matched and given a distance to their nearest neighbor? am I missing something?

In a workspace processing AutoCAD data, I have recently replaced a bunch of transformers with an InlineQuerier, and downstream of it is an AttributeFilter, filtering on the autocad_entity attribute. Because of this, I found that the InlineQuerier is dropping this attribute, regardless of whether it’s exposed when entering.I don’t need the attribute for my queries, so I had not originally added it to query columns, but after some testing, the only way I can get the attribute to persist on the features exiting is to include it in the query columns, specifically include it in my SELECT statement, and also not include fme_feature_content in the SELECT. With a simplified query:Works - autocad_entity is present on outputNot working - autocad_entity missing in outputI found this post  Geometry Replacer - missing attribute after output | Community where the replies note the GeometryReplacer will remove this attribute (among others) to avoid issues downstream - this makes sense, and I’ve found

Hi !I have an image in my documents folder and I need to add it into excel on a specific cell. I saw a training available, but it uses an image fetcher. image fetcher cant be used with a folder path.Looking for inspiration as I have hit several walls.Thoughts?Thanks, in advanced.   

I would like to look into using the integrated version control of FME Flow:https://docs.safe.com/fme/html/FME-Flow/WebUI/Manage-Workspaces.htm#WorkingSo I asked for a repository within our git environment with rights so FME could access and write the workflows like mentioned here:https://docs.safe.com/fme/html/FME-Flow/WebUI/Version-Control.htmBut our current policy disallows integrations with a wide scope and would like to use the fine-grained scope settings within github probably like mentioned here:https://github.blog/security/application-security/introducing-fine-grained-personal-access-tokens-for-github/Does FME also support fine-grained scope and if it doesn't would this be implemented in the near future?  

Hi,  Has anyone else noticed that when you use an attribute creator in your model, or renamer, or in your manager where you reuse an existing field, it works perfectly in your model but is not transferred when you write it to your shapefile? I always have to use a separate creator at the end This used to be no problem at all. I am now using 2025.2, but I had already noticed this in version 1.

Reading Utility Network Data in a FeatureReader with an SDE connection with resolve domains and resolve subtypes ticked.Domains can be applied different on each field dependent on subtype, but it looks like only those fields that are set to domains on the Unknown subtype are exposed on the reader. Subtypes that have domain fields applied to other fields, have these attributes resolved but they remain unexposed. Is this a known issue?

I followed the procedure for silent installation of FME Form 2023.2, but without succcess. Here is the command I write in the console, with Admin rights :fme-form-2023.2-b23764-win-x64.exe -d"C:\\FME\\installer" -s -sp"/qn /norestart" The fme-form Logfile which is created notes a successful installation in the end:Product: FME Form 2023.2 (Build 23764 - win64) -- Installation completed successfully. However, I cannot find the software installed... No shortcut and no program in the default C:\\Programs\\FME.Could you explain why the installation is not finished?

I am in the process of automating feature service creation and uploads to AGOL. We have built this process in FME 2023.2.2 and it works as intended. After updating to FME Form and Flow 2025.2, I am getting this error message (see below) when trying to create a fGDB by importing an XML schema created just upstream from the fGDB writer. I have updated my AcrPro to 3.6.0 and made sure that the Python Compatibility is set to ESRI ArcGIS Python 3.13. I have confirmed that the XML is valid by importing it into a working fGDB in ArcPro, and that it is finished being created before the attempt to create the fGDB. The ArcObjects error number points me towards the article linked below, which tells me I have a spatial reference issue, so I am not sure what the actual resolution could be. I am overwriting the spatial resolution in the XML to reflect the state plane coordinate system the potential project will be located in, which was never an issue with previous FME versions. Has anyone else come

so i have this polygon and i can see the min extents and max extents in the record information window. i know that i can get the coordinates and calculate the length and width of the polygons, but i’m interested to know if the min and max entents in the geometry portion of the Record Information can be obtained directly?  

We currently use the ArcGIS Data Interoperability extension for standardization and validation of alphanumeric and spatial data, processing datasets ranging from 1,000 to 10,000,000 records.We are aware that there is a difference in the number of transformers available compared to FME Form, but we would like to understand whether there are deeper technical differences that a beginner user should consider when deciding between continuing with ArcGIS Data Interoperability or investing in a full FME Form license.Specifically, we would like to know: 1. Performance with large data volumesAre there significant performance differences between the two solutions, especially when working with millions of records? 2. Structural limitations of ArcGIS Data InteroperabilityWe would like to understand whether there are important limitations regarding: automation and scheduling of routines, database integration, advanced geometry manipulation, building and debugging more robust workflows.  3. En

I am new to lists and xml in FME and having a bit of trouble. I am trying to use the XMLTemplater to populate an XML tag using a list value.My XML template looks like this: <prompt>{fme:get-attribute("prompt")}</prompt>            <output>{fme:get-attribute("output")}</output>            <data>            {            for $testcount in fme:get-list-attribute("itemlist{}")            return <item>{$testcount}</item>             }            </data> Test count is the output of a list element counter, and itemlist is a list attribute of the items. My output looks like this: <prompt>Material</prompt>            <output>Survey Attributes/Material</output>            <data>                        </data> There are no contents being created within the data tag.I am trying to get it to output like this: <prompt>Material</prompt>            <output>Survey Attributes/Material</output>