FME Form

Hi,Trying to use a clipper for 3d intersections but some 3d solids getting rejected i think due to geometry errors in 3d solids. I have ran the 3d solids through geometry validator but does not fix the geometry errors. Geometry errors include - Non-Planar Surfaces, Incorrect Solid Orientation, Invalid Solid Boundaries. Any other ideas to fix? Thanks

nvm

Hi FMEers, I’m trying to create a basic map using the HtmlReportGenerator. I’ve added 2 polygon hosted feature layers from our ArcGIS Enterprise Portal, that are comma separated in that URL field. They are shared with groups that I am a member of so I have access to view them.When I send it through to an html writer, the output map is blank. I wasn’t sure if that was because it is offline so I also published to FME Flow but it’s still blank:  I also tried with a layer shared to public from our portal with the same results.Is there something I’m missing from the docs?

Hi guys,how can i handle to read in Excel sheets (with other column names from time to time) and have the possibility to choose from a schema (xls) the right attribute names for the workflow…..Parameters on the reader?I’ve tried the Attributemanager and import a excel file...but the names from the excel sheet are only added to the default output attribute names a dropdown list on the Output Attribute name would be great……..any help to handle it or a link to another articleGreetz and thanksFranco

Hi,I would like to convert an image symbol from Esri CIM JSON to AutoCAD DWG format. The JSON file looks like this: {  "type": "CIMPointSymbol",  "symbolLayers": [    {      "type": "CIMCharacterMarker",      "enable": true,      "anchorPoint": {        "x": 0,        "y": 0,        "z": 0      },      "anchorPointUnits": "Relative",      "dominantSizeAxis3D": "Y",      "offsetX": -3.3333333333333335,      "size": 5.555555555555556,      "billboardMode3D": "FaceNearPlane",      "characterIndex": 85,      "fontFamilyName": "Tahoma",      "fontStyleName": "Regular",      "fontType": "TTOpenType",      "scaleX": 1,      "symbol": {        "type": "CIMPolygonSymbol",        "symbolLayers": [          {            "type": "CIMSolidStroke",            "enable": true,            "capStyle": "Round",            "joinStyle": "Round",            "lineStyle3D": "Strip",            "miterLimit": 4,            "width": 0,            "height3D": 1,            "anchor3D": "Center"::],  "haloSize": 1,

Hi guys,This week I created a nice model A with runs smoothly combined with a main script B which includes a workspacerunner triggering workspace A. Is there a way I can track whether all the scripts started by the Workspace Runner are ready?In my case 21 features entered the WorkspaceRunner, starting model A, which leads to creation of 18 Excel files which is perfect. I would like to create a log somehow that 21 workspaces were started and 21 workspaces were completed resulting in 18 Excel files in this case.Workspace B now states that the WorkspaceRunner is finished, however, on the background workspace(s) A is still running for some time. 

I have the following table, very simple:DATE_START ID 19921101 0502010000013950 19950209 0502010000013950 20031231 0502010000013950 20040115 0502010000013950 20040120 0502010000013950 20110704 0502010000013950 20200211 0502010000013950 20251005 0502010000013950  I want to make te following result: DATE_START DATE_END ID 19921101 19950209 0502010000013950 19950209 20031231 0502010000013950 20031231 20040115 0502010000013950 20040115 20040120 0502010000013950 20040120 20110704 0502010000013950 20110704 20200211 0502010000013950 20200211 20251005 0502010000013950 20251005 null 0502010000013950  Date_end is next value of date_start to create a cycles like this. This what i did:    I get to following result:U see the problem is with the last date_end, he is using for that feature the first date_start. I dont now how. Anyone a solution?

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.