FME Form

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.5

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 tuvwxyz

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 output

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:h

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 co

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 import

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.

Hello everyone,I am a beginner when it comes to FME and loops. I have the following task: I have an attribute column with a value. (e.g. Person 1, age 18Person 2, age 35Person 3, age 41Person 4 , age 45The age column should now be increased by one value x times per specified loop run. The number of loop runs should be controlled using user parameters and variables.I am using FME 2022. Can anyone help me? I have found examples with loops, but as a beginner I don't understand them.Thank you very much for your support. I look forward to your reply.A.B.

When upgrading from one version of FME to the next, I can upgrade some upgradeable transformers, and I can also upgrade the readers and writers to the latest version. But what about the readers that are called by the FeatureReader (and writers by FeatureWriter)?We just upgraded from 2024.1 to 2025.1, and I upgraded the FeatureReader transformer reading a geodatabase. Does upgrading the transformer, upgrade the GDB reader functionality? Or does it automatically call the latest GDB reader? Or does it stick with the old?

I am trying to create a webservice to access Sharepoint. FME has been registered in Azure but when I try to set up the connection the conditional access policy blocks my connection.It looks like it has something to do with the way the http user client provides info to Azure. With the FME default http user agent you just get a blocking error, with the system default http user agent you get this: It looks like the http User agent does not provide the device ID (apparaat-id): Not available (niet beschikbaar). The conditional access policy demands a registrered device so it blocks this connection.I can make a Azure connection directly from Chrome or Edge in other apps. what is the way to a solution for this problem? 

Hello,I seem to be outputting multiple folders when I run my app through data stream or data download.Tried connecting all connections to one feature writer but it seems to be limiting me to one excel file if I do that so I did multiple feature writers for each excel file that I want.Tested running my app through data download and data stream and it outputs multiple folders - one folder per feature writer.Was wondering if I am able to simply download all excel files right away without putting them into a folder or just output them all into one folder.Screenshot below.Feature writers under Microsoft excel format. Basically 2 sheet type. 1 is based on a value and other is count sheet

I need to assign a z-value to 2d points snapped along a 3d line.My steps  anchoredsnapper to snap the 2d points to 3d lineChopper to extract the vertex of  3d line create vertex of 3d lineNeighborFinder to find the closed vetex (of 3d line) to my 2d points   but now the question is how can be sure that the nearest vertex belong to the lines where my points are snapped ?  In red a point without z value but if I increase the maximun distance of NeighborFinder the risk is to assign the wrong z value (I mean the z value of the other line) So at the end my goal is to assign the z value to the points starting from the line where these points are snapped  (sorry for bad explanation...) thx for support Francesco

As the question title states, I would like to use the SharePoint Online Connector to download files from SharePoint to my local computer's drive. I was able to set up the connector using a web service and it says "translation successful" when I run the SharePoint Online Connector on it's own but I'm not sure what readers and/or writers to add, or is there something wrong in the parameters? The files on SharePoint vary from .docx, .xlsx, and .pdf formats If someone has a basic template to show that would be great. Thanks!

I'm trying to write AGOL features and attachments coming from a feature service tied to a Survey123 survey into a SQL Server geodatabase. I've looked through most of the tutorials and questions about this, but in my use case I need to maintain Global ID's on both the features and the attachments. The feature GlobalID's are being used to name photos that get stored in S3, so I can't use the examples that use a counter to create a new relational ID. I have set the "Maintain Global ID's" parameter on the AGOL reader and have exposed the AGOL attachment attributes. The attachments have a Global ID and Parent Global ID, and I figured it would be simple enough to use both of those to create the relationship class in the GDB since that's what the AGOL service is doing. When I query the service, I can see a feature's Global ID and the attachment's Global ID and its Parent Global ID (the GID of the feature it's attached to).

EDIT - I have solved my own issue here! We had some network changes, and I needed the SAS from the top level of the storage account rather than the specific container. Problem solved. I’ve successfully connected to the Azure BLOb using 2025.1 Form using the AzureBlobStorage Connector:I can connect to the “Hosted” folder inside the container “shared-data”. I am connecting using SAS. However, I need to use Flow 2024.2 and so I need to open this same workbench in Form 2024.2…. and this is where the fun starts!The transformer is slightly different, when I try to configure the Container I don’t seem to have the option to add the “Shared-data”.

Hi everyone,I’m working with the JSONUpdater transformer in FME and need to add a key called layerDefinition to my JSON. The goal is to have:"layerDefinition": {}as an actual empty object, not:"layerDefinition": "{}" // stringor"layerDefinition": nullHere’s what I tried:Value Type = Plain Text, Value = {} → Result is "{}" (string). Value Type = JSON/XQuery, Value = {} → Result is null. Value Type = JSON/XQuery, Value = json:object() or map {} → The key doesn’t appear at all in the output.My JSON path is correct (json["operationalLayers"][0]), and the update type is Insert into Object.Question:Is there a way in FME to insert an empty JSON object using JSONUpdate

HiIs it possible to connect fme to a Microsoft Fabric Lakehouse? And read data?I use fme 2022.2 

A caseA column code contains both unique and identical values ​​(e.g., A, A, B, C, C, C, D, E, E).A second column names contains different names.I want to group a column, but the names associated with it need to be merged.How can I easily solve this in FME? Thanks in advanced!

I have a column containing values ​​(contains 1 or more sorted names) that are both unique and duplicate. Now I want to assign a unique number to each value. This means that the values ​​that are the same should also have the same unique number. How can I handle this within FME? Thanks in advance!

I am trying to connect to a SFTP using the FTP caller. I have followed the instructions in https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems and I can connect to the server using other methods (winscp, filezilla) so the new key is working. In the log (with debug enabled) I get the following:SystemCaller: Executing 'start "" "C:\Program Files\PuTTY\pageant.exe" --encrypted C:\PPK\PrivateKey.ppk'FTPCaller (FTPFactory): Using the 'SChannel' TLS library for HTTPS/FTPS connectionsFTPCaller (FTPFactory): FTP info:   Trying ??.??.??.??:22...FTPCaller (FTPFactory): FTP info: Connected to ??.??.??.??