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

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?

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 -  

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?  

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.

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? 

Hi,I recently upgraded from 2025.1.1.0 b25615 to 2025.1.3.2 b25646 and noticed that whenever I open a .fmw file, a new folder, “.sentry-fme” is created in the same directory.When I started FME from my desktop shortcut, a “.sentry-fme” folder was created on my desktop once the program was up and running.Could we get this fixed? I’d rather not bloat my directories with temporary files if I can help it. I’ve since downgraded back to 2025.1.1.0.Thanks,

I’ve been experimenting in FME and reading some conflicting data on this but it seems like there isn’t a way to publish from FME to AGOL raster data without the image license for ArcGIS online. Either AGOL stores it as an image file or FME will store it as a BLOB. I’ve tried using the pythoncaller and httpcaller to no avail. Anyone know any other workaround / have experience here?

Hi FMEers.I have an interesting task and thought I’d come directly to the experts for advice! I want to pick a random position on Earth, but it has to be on land. How would you go about it?The obvious route is to simply pick a random coordinate, repeating the process if it doesn't fall within a land boundary. That seems inelegant. Alternatively, maybe I could use H3 hexes? Generate all level 15 hexes over land and pick one at random. That seems slow.I'm open to any suggestions. I want lat/long coordinates to about 7 decimal places, and I need it to run (on Flow) in around 1 or 2 seconds.Thanks for any suggestions.Mark

I have a list of client records with a start-date and an end-date. In some cases there are multiple lines for a client, identical except for start-date and end-date. I need to somehow either concatenate them into one client record which contains the minimum start-date and the maximum end-date from each of those client’s records, or create a new client record for each client with the minimum start-date and the maximum end-date. All other data can be discarded in the process.For example, I start with:JohnDoe, startdate: 1 Jan 2024, enddate: 1 August 2024JohnDoe, startdate: 3 Mar 2024, enddate: 31 August 2024JohnDoe, startdate: 3 Mar 2024, enddate: 15 Dec 2024DavidSmith, startdate: 1 Feb 2024, enddate: 15 Oct 2024DavidSmith, startdate: 3 Mar 2024, enddate: 18 Oct 2024 And I want to end up with:JohnDoe, startdate_min: 1 Jan 2024, enddate_max: 15 Dec 2024DavidSmith, startdate_min: 1 Feb 2024, enddate_max: 18 Oct 2024 I have managed to create a really intricate and clunky solution which kind

Good evening,I am wondering what the community thinks about this situation:FME Form 2024.1.3.0 (20240927 - Build 24627)Writing to Esri Enterprise Geodatabase (SDE) 10.9.1 - MS SQL Server 2022I have almost 700,000 records that need to be written out to our SDE into 1 feature class.Currently I have 1 Writer using the Esri Geodatabase (ArcSDE Geodb) format.The 1st attempt to write the data failed after 22 hours because I had a loc on the destination feature dataset.  doh!On the 2nd attempt to write the data to the SDE, the job has been running for 12 hours.  I cancelled the job, and below are snippets from the logfile highlighting how many records have been written, and how much time passed.  This shows a pattern that: as time progresses, the processing time is becoming exponentially longer.  I am thinking of breaking the data into 100,000 chunks, with the first chunk first truncating the table and then loading, and the sequential chunks appending to the table.Is this performance hit expe

I am trying to validate some properties of objects in DWG files, and some of the things I’d like to check require me to know what paper space viewport an object is visible through, but I have been unable to get the autocad_viewport_handle attribute to show up.I’ve tried a few combinations of reader parameters, including checking all boxes in the “Model and Paper Space Options” section, unchecking some options while leaving “Read Model Space Entities Through Viewports” checked, and tried reading multiple DWGs, but so far I have not had any luck. I am thinking this must be a “me” problem, but I’m kind of at a loss. Is there a certain set of parameter settings required to get autocad_viewport_handle to show up? I am setting the reader to expose the attribute, but so far, it is always missing. I’m using FME 2025.0.