FME Form

Hello fellow FME-ers,I am working on making an xml from an Oracle database (with metadata). I am using the FME template for this in the XML Writer. Using the list builder I have generated two lists. One with the keywords and one with the attribute values. See below as an example (List_Trefwoorden and List_Attribuutinformatie):How do I make sure these lists (standard FME template for xml) are saved in my XML writer? Greetings, Wim 

Hi All,I have written a workspace that downloads features (and attachments) from an AGOL Feature Service, and everything was working fine until about 2 weeks ago. Then it suddenly, and for no reason that I can see, stopped working. The error message is as below:2024-07-12 09:38:47|   5.7|  2.1|ERROR |ArcGIS Online Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='www.arcgis.com', port=443): Max retries exceeded with url: /sharing/rest/portals/self?f=json&token=3NKHt6i2urmWtqOuugvr9Xotftc2MEsOx2iLqu8k_LPVAUrx4ptneDwWq5gGHyWsx9gLJB14s-YhL9BcQ6A71ysFhsv00tTqKaTLWA9OxAioggyddpHKGcxUfwKFMnzU-m7-SshOGN98nlYOd2uB9-LSYOpHZbnxGUhNJ_3nnRQntaumsDD__7bZqpHVciIFHkLU-of9RGgQ17FdVaDRxF6HcXcbq9Sm4XmdkzD7LqM-h_2jGsOM8HOeFBSI6iINhlNJE65A50NL1eFOJ-gGgg.. (Caused by ConnectTimeoutError(<urllib3.connection.HTTPSConnection object at 0x0000000

I have a pretty simple problem but I cound not find any solution. I tried feature joiner and added counter so that I have a field in common for bot tables but still didnt work. Attribute manager does like “what I get” which is not really what I want. Any Idea ?   

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": "Roun

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

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

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

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

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?  

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