FME Form

Hello.So I have created a workflow on Form where I:Read in a specific sheet from a specific excel file stored on my C Make some changes in the digits of that sheet Enter those changes to a feature writer where I update the sheet in question on my C That then triggers a feature reader that reads in the excel document that I just updated with the feature writer on my C The excel read in the feature reader has then done all the calculations based on the newly entered criteria. Process this onwardsThe purpose of this workflow is that the excel in question is a complex calculation module that has multiple intertwined sheets, so by doing this I just open up Form, fill out some published parameters (the digit changes) and then export an excel with calculation results. All without ever needing to open excel.My problem is that now I want to put this process on Flow with the following setup:Read in a specific sheet from a specific excel file stored in the resource folder on Flow Make some change

Hello, I’m starting my journey with Webhooking and of course I am already running into problems. So I have Enterprise 11.3 and Flow 2024.1 and no hosting enabled on Enterprise.So my workflow is fairly simple, I have created the following Webhook on our server: For the following service:Which then calls the very simple automatation on our Flow where any creation, updating or deleting in the dataset in the FeatureService (remember this service is referenced and not hosted) should kick of a single workspace and thats the end.However doing anything in that FeatureService, be it creating, updating or deleting does not kick of my automation. I have checked if Flow and Enterprise are speaking well together and it seems to be so as when I originally create the Webhook then the same automation kicks off with great results (its not a organisational webhook), just not when I then start to do stuff in the dataset itself. I have also made sure that the dataset in the FeatureService that originates

In this installation window, the folders look like in Windows 95 ! :D 

This issue seems to appear again in FME 2025.1! 

I'm trying to update (or rather replace) rows with new features and write them to geopackage. The problem is geopackage primary key is "id" that is generated when writing geopackages and I'm reading features from postgres where that same id doesn't exists and another id (let's call it ChangeID) is used as a primary key. ChangeID does exist in the geopackages and postgres table but geopackages primary key must be "id".  Unfortunately I have no control over why the id's is implemented like this. Also I know i could read those geopackages in to fme to get the "id"s but the problem is the dataset is hundreds of geopackages resulting in 100 millions of rows so the whole workflow is designed no to do that because that would result to weeks of runtime. I have a workflow to get rows that need to be replaced but fail to write them into geopackages because i can't use ChangeID to replace the rows because of different primary key. I know there

We have multiple workspaces that write to ArcGIS Online with multipart geometries. The old ARCGISONLINEFEATURES writer works and correctly writes the geometries. The new (2025) Esri ArcGIS Feature Service Writer returns an error rejecting the features and the following warning:ArcGISFeatureServiceWriter: INSERT error for a feature in Project Stats by State. The error code from the server was '1000' and the message was 'Adding/updating geometries that result in SQL GeometryCollections is currently not supported (SQL Server performance).' Using a Deaggregator seems to fix this in most cases. However, we want to retain the multipart geometries. In other cases, I see a similar warning and the following error after using a Deaggregator:ArcGISFeatureServiceWriter: INSERT error for a feature in Terracon Offices Closest Areas. The error code from the server was '1000' and the message was 'Data is Null. This method or property cannot be called on Null values.' I’ve tried a NullAttributeMapper a

I'm having a set of polygons and for every polygon a raster with height values. I'm combining them in the TIN generator to create TIN's for every polygon. Now I see a big difference in behaviour of the TIN generator, depending on the amount of polygons I'm sending to it. For example: when I use one single polygon as input, as a result I get a TIN with 234 triangles.If I use 459 polygons as input and proces them individually by using Group processing, the result of the same polygon is a TIN with 3602 triangles. Can anyone explain why this is happening and how to prevent it?

I am creating some PNGs from my analysis and until recently the MapnikRasterizer has been creating transparency according to the opacity setting for my polygons.I did not touch the MapnikRasterizer, but the results do not show any transparency anymore.Below a screenshot of the settings I made and the opacity setting is the same for all polygons, yet there is no transparency to see in the resulting PMGs. Is there anything where you see something problematic, that might prohibit transperancy?

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.

Wie lässt sich aus einer Spalte der Strassenname, Hausnummer und Zusatzinfo in eigene Spaltenextrahieren? Ackerstr. 9 - 4733 - Adlerbrücke Tunnel B 7 - 9814 - Adolf-Röder-Gasse o. Hausnr. - 8104 - Adolf-Vorwerk-Str. / Hohenzollernstr. - 9251 - Agnes-Miegel-Str. 6 - 9630 - Agnes-Miegel-Str.14 Miet - 5680 - Agnes-Miegel-Str.33/37 Miet - 5498 - Agnes-Miegel-Str.20/26 Miet - 5498 - Ahrstr.90 - 7943 - Ahrstr.35 - 7543 - Musterstraße 123a - 4102 -  

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,I am using the AutoCAD Reader to extract external references from DWG files. When I get to the same file in the directory in results in an “Error running translation” error. However, if I run the Reader against the individual file, it works fine. I have removed the file from the directory and it then errors later on a different file. I believe this could be a memory issue? How can I resolve?I am only running the Reader and no other Transformers.Any help would be appreciated.Thanks.

Hi, I have some 3D fencing data in IFC format and I want to work out the height of the objects. I been  x,y,z co-ordinates and the ‘Bounds Extractor’. However, due to the data being long linear features and thus the underlying height of the ground negatively affecting the height. I get strange results (as fencing goes up and down underlying elevations).I think the only method is to take cross sections of the fencing and work out the distance (height) between the highest and lowest z value from the cross section. However, this seems difficult to do. Any ideas? ta

Just upgraded from 2022 to the latest version for Flow and Form. Whenever I publish a workbench the publication works then shortly after the log gets the message “The web connection 'FME Account' could not be loaded”We don’t have a Web connection “FME Account “ and the task has completed anyway. Any ideas where this is coming from?  

Hello everyoneIn 2025.1 FME Form I can use the Civil 3d reader, to read extended data from a dwg file just fine. Within the reader I just have to make sure the option for  “Civil 3D and CAD entities” is on and leave the other settings as default.The challenge comes on writing extended data. I can write ‘object data’ just fine but I cannot figure out how to write ‘extended data’. The picture below shows where I want to be able to write data to within the Civil 3D interface, from FME. Any insights would be valuable.Thank you

I got this error when trying to add attachments to AGO: The ArcGIS REST API returned an error: HTTP Error Code: 413 : '' Message Code . Further details: 'The page was not displayed because the request entity is too large.'Esri community has a solution to edit the header, but there’s no option to edit header on transformer? 

There are situations when I want a variable or parameter to determine whether a certain process is run or not. I could add the variable as an attribute to each feature and then test for the value of the variable. But that way the variable controls the process for each feature, when I already know that I don't want put any of the features through the process. And it feels like creating an unneccesary amount of extra data (even though temporarily), which I have to remove later on.I've come across this before, and now I have a case where I want to run part of my workspace once a week and another part every day. (An alternative is to distribute the processes across separate workspaces, of course.)What I'm thinking of is functionality like the feature reader has: it only reads features when triggered by an initiator. But I can't think of a way to do this with other transformers.Does anyone know of a way to achieve this in FME Workbench / Form?

Hello everyone, I have colleagues who were wondering whether there would be git integration available with fme workbench.I understand now at the moment there is no integration directly in fme workbench with git. However it's possible to manually check in .fmw scripts in git I heard, but I think it would be an useful functionality if you dan do that directly from fme workbench. I was wondering whether something like that would be available in the future.

Hi, I’ve seen this touched on in other posts, but I wanted to ask directly: has anyone had success getting data into a Microsoft Fabric Lakehouse, and what are the best authentication methods?I think there are potentially options using the Azure Blob Storage connector to push CSV files in, and possibly using the Fabric API as well. Before I go down the governance route and request SAS tokens or API keys, I’d like to hear about others’ experiences to make sure what I’m asking for is actually going to work.I have a few data rescue use cases where I need to scrape large volumes of documents, structure the outputs using FME, and then write the data to a Lakehouse so the business can use it for reporting.I’ve managed to get data out of Lakehouses using the SQL endpoint with a SQL Database Reader, since it has Entra ID authentication integrated.Any insights apperciated.  im using FME 2024

FME Form Version: FME(R) 2024.2.0.0 (20241102 - Build 24783 - WIN64FME Flow:  2024.2.1 Build 24801 - win64 I have created a bunch of User parameter type: Groups Box in a skript. Within those Group box are a bunch of parameter type: yes/no. These parameters are used in an FME Flow APP. However. They’re not working as I want them to work. When a Group box is unchecked in the FME Flow APP then I want all the layers inside the group box to get unchecked.However in FME APP, it doesnt do that. Please see picture below attached to this question. All the layers inside the Group Box (byggnadsdelar) are still checked. What am I doing wrong?Please see my konfiguration for the group box parameter and the yes/no parameters inside Group Box. 

Is there a method to import CAD graphic elements, line, Arcs, etc. with the geometric attributes readable by Arc map such as Radius of arcs, bearings of lines.  When I import CAD graphics, I get polylines, but they do not really have readable geometry like Line Length, Arc Radius, Line Bearing etc.  I would like to import CAD graphics like road centerline geometry and have the geometric data in a Table like format, similar to the old COGO formats.

Good day, I have this table in green. I want to regroup row 2 to 5 so the result should like row 11. Here is how row 2 to row 5 are connected:Row 2 to Row 3: row 2 end_crct_id = row 3 crct_id, Row 3 to Row 4: row 3 crct_id = row 4 begin_crct_id, Row 4 to Row 5: row 4 end_crct_id = row 5 crct_id.I have several of these cases, this only an example. The number of rows to combine varies every time.

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?

Hello team!What is the recommended strategy to secure secrets in FME Form and python scrypts. Thanks in advance.have a great rest of your day. 

I have used a PythonCaller to flatten a xml dataset and have many handfulls of attributes that need to be exposed. Cutting and pasting into the AttributeExposer does not feel appealing. Surely there must be an easier way to do this? After all the features already have these attributes, only they are set to be Unexposed. It should be just a hide-unhide setting that is needed?