FME Form

Using Form/Workbench 2022.2, connecting to MSSQL 15 with 10.9 SDE over the top. I'm not an SQL expert, and this statement was a combination of my knowledge, ChatGPT and colleagues knowledgeSELECT    p.*,    -- Calculate the rate of nitrogen (N) application over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.NutrientN / p.AppliedAreaInHa) OVER () AS  total_n_rate,     -- Calculate the total fertilizer rate over the entire spread.    -- Convert the area to hectares, then multiply by the rate to get the total weight.    -- Finally, divide by the applied area to obtain the average rate.    SUM(p.Shape.STArea()  / 10000 * p.RateKgPerHa / p.AppliedAreaInHa) OVER () AS total_fert_rateFROM    [Agtech].[MASTER].[ProofOfPlacementSwath_evw] pWHERE    p.[SwathMergeID] = '@Value(swathmerge)';This runs fine in SSMS with no errors and re

We have a workbench that reads a CSV file on a network path that has multiple spaces . This works fine on the FME Form workbench but when published to FME Flow the spaces are reduced (there are three spaces in the path and Flow shows only 1)

I am sending JSON data to a Text File Writer. The Text File Writer has its MIME type set to "application/json", yet the response Content-Type remains "text/plain". Is there a way to force this to "application/json"? (Note: Using a JSON writer does set the content type to application/json, but it formats the response as a JSON array, which is not suitable for my calling application.) Second, the application that will be using this Data Streaming service sometimes requires specific HTTP status codes to be returned. Is there a way to force the HTTP status code e.g. to 400?

I'm dealing with an error while reading data from an Intergraph GeoMedia SQL Server Warehouse using FME build 23332, although this was also an issue in FME2019. The error does not give much info (see attached log file). We may get the error 3 times in a row with the same parameters, and then on the 4th run with no change it will process fine. Sometimes the error will not present at all.  This is also happening on multiple machines accessing the same network location. The error always occurs after the entry "Successfully closed GeoMedia SQL Server Warehouse reader" We are suspecting a network issue, but do not know where to begin checking.

Hi, fellow FMEers! I a problem that I cannot solve. I want to present 3D data along a line with breakpoints. In my script I want the line to be presented as a straight line (a profile).  It is important that the length of the line parts are correct but it doesn't matter where the resulting parts start.  The data input line is drawn from start to end but can begin and end anywhere (from west to east, north to south and so forth...).  Any hints or suggestions? 

Hey. Hey. Could anyone advise how to write files to multiple datasets according to the number of sets defined by the number of flight tracks? The output dataset should contain the name of the ler route and some other attributes that are not relevant at the moment, however I need the number of datasets to match the number of flight routes ( ar_name attribute ). Currently I can only create one output dataset see attachment "current_dataset_routes_update_test". The attachment contains four flight paths in one dataset, namely Z410, L132, M725 and L602. The required output I would need is 4 x dataset Z410, L132, M725 and L602 see separate attachments with required_dataset + flight route name. I am also attaching a printscreen to give an idea of how to create the actual output dataset. The number of flight paths and the resulting dataset can of course vary, the process must be automated. Thank you very much. M. 

HelloI took CityGML LOD2 RoofSurfaces (~1700) and textured them with an Orthofoto. If I write this to a 3D PDF or glTF it takes 1min and produces output of 50Mb in PDF and 15Mb in glTFIf I write the same data to an ESRI File GeoDB it takes 5h+ and produces a File GeoDB with ~6Gb size .What is going on here ? Do I need to specially treat the surfaces before writing them to the File GeoDB ?

Hello everyone,I'd like to outline the main concept of my work. I am working with two point clouds, one representing a road and the other obstacles. Initially, my goal is to determine the minimum distance between these two point clouds. To achieve this, I rasterize both point clouds and calculate the difference (A-B). I then identify the point with the minimum height (Xh, Yh) and its corresponding difference height (H). After that, I rotate the two point clouds, merge them, and rasterize the combined set. The result is like represented in the first picture. However, I aim to enhance this representation by adding an arrow to signify the distance H, as shown in the second picture.  My idea (maybe not the best) is identifying the neighboring pair in the two point clouds close to the extracted point with the minimum height (Xh, Yh). I intend to draw a line connecting this pair, label it with H, and either rasterize it with the point cloud or incorporate it in the end somehow. For now i

All our processes that were inserting NVARCHAR(MAX) values into SQL Server databases have stopped working correctly (FME inserts NULL values into NVARCHAR(MAX))after the latest FME upgrade (2022).  We have found a temporary solution using the Microsoft SQL Server Non-Spatial (JDBC) format instead of Microsoft SQL Server Non-Spatial but it requires to modify a lot of workspaces manually. Does anyone know if this is a bug and if it will be fixed? Thank you! 

I have created a process that simulates the horizontal wellbore creation processes for a client. However, I am stumped on, what seems to be a rather "newbie" process of flipping 180 degrees a select set of features. Let me illustrate further:  In the example below the user selects a township to create the horizontal wellbores. The workbench tiles the township into 6 sections by default. They next pick a direction (ie East/West or North/South.) Next they choose a starting location for the Surface Hole (N, S, E, or W.) Lastly they choose how many wells to place in each section.  The result is this of a North/South orientation with the surface hole in the south and 6 horizontal wellbores placed in the sections. So far, no issues this is version 1 where they all go in the same direction.    However, the client also wants the option of creating a "pad well" style drilling progam. In this case alternating rows would be flipped or reversed. Normally I am able to figure thi

I have drill hole id's with overlapping minimum and maximum depth values. I'd like to split the overlaps. However this implies the addition of a new row with new minum depth and maximum depth values. I've unsucessfully tried building lines to get the intersections and overlaps. I've added an excel sheet with sample data and (I think) a clearer explanation of what I'm trying to achieve.

I have a workbench I'm updating from 2021.2 to 2022.1. It reads in features and then following the general flow from this article (https://community.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin) does the change detection and then updates the portal service. In 2022.1 I'm running into an error though where when it starts writing the updates I get" ArcGIS Portal Feature Service Writer: Could not find a layer/table matching feature type 'ParcelTest_DBO_DelTest'". I've used the GUI to select the item from the portal, the only difference I can see is the '_' instead of the '.' in the service name. I can't change this though. In 2021.2 the writer has the '.' in the name. I can click on the url of the ArcGIS Portal Feature Service Writer: Requesting metadata for Feature Service at 'https://xxx.xxx.xxx/server/rest/services/ParcelTest_DBO_DelTest/FeatureServer' message and it opens the rest endpoint  

With GET /repositories/< repository >/items/< item >you can get information about items in a repository, in my case I am retrieving a workspace. In the response there's one tag named 'history', but this is not the comment you enter when committing a workspace.  Sub-type: Workspaceworkspace {...history (string, optional),... } Can I find this history I am looking for through the API? Or at least a timestamp of when the workspace was committed?

I've got two identical line/point features, each of them has a list of all attributes created by Aggregator. I want to compare these two list, some elements are same and some are not and number of elements may not be same. Matcher or ChangeDetector can do comparing part but can not out which elements are different. Is there a way to compare two lists and output different elements? Or can I just compare attributes of two features without creating lists?

I don't have experience in Bentley or AutoCAD. We aren't an engineering company, so we won't be using much of the 3D capabilities. I think for most jobs, we use CAD to generate reports, and plats, mostly 2D drawing. So, I would like to ask for some guru advice. 1) What do you like and not like about each software when it comes to integration with FME. 2) If you have to pick one, what would you choose and why? Thank you!

HelloAs a FME Rookie ive a questionI have three polygons less than 1km square0.4 , 0.5 , 0.2 km² I would like to know if there is a transformer to adapt every polygons to a 1km² box each ? , i only know Bufferer but is it possible to have the same surface in three different geometries ? Thanks in advance !

Hi everyone,  I have a some workspaces in workbench 2020.02, where I have used Creator and the filecopy writer to create new empty folders at the start of the translation. However, this no longer works in workbench 2023.1. Is this function no longer supported with filecopy?  Thanks! 🙂   

Hi @mark2atsafe​, I've read your interesting post (dated 2023-11-15) on LinkedIn about surface model in FME. Could you please share the workspace in this post? Thank you! 

If anyone is using Asana, please help me. I have the portfolio, projects, and users table in my FME workspace. I am trying to figure out a way to be able to use the project GID to be able to get their tasks but there's a problem with the tasks table. The task api has an endpoint to ONE projects. I am envisioning where I can pick different projects and be able to look at their tasks.  Does anyone have any idea? I was thinking about looping but I'm having a hard time understanding how I would loop if the task's api can only GET one project.

I routinely create buffers, and when I do I get thousands of tiny gaps which I need to fill, but only gaps upto a specific size. I can and do this currently very easily in MapInfo. I can quickly identify and then merge or fill these gaps with the rest of the buffer to make it look contiguous. As this is a repeated task on my part I want to do this with FME.I am thinking that I use the AreaGapandOverlapCleaner, however the tolerance to my knowledge is a distance setting, not an area setting, which I find odd as this is an "Area"Gap cleaner. My specific area size is quite small, just 0.005 sqmi.This is what it looks like in MapInfo. The yellow is my buffer and the red areas are the gaps of 0.005 sqmi or smaller that will be filled in. How to is set the tollerance to clean gaps of this specific size and smaller? Thanks in advance 

Hi,I wonder if it's possible to download all the tiles from a WMS web server. I would like to cache them as a Geopackage Tiles for exemple or XYZ Tile layers.  Do you know if this is possible ? Thanks,Arnaud

Here is what we want to do, review our annotation layers (from an ESRI SDE) to see if there are annotations that overlap or touch. When the annotations are brought into Form, they are represented as points. In the Data Inspector the text is displayed the same way as they display in ArcMap. Is there a way to convert the FME text into a polygon? Then we can check if there are polygons that touch (which there are many :D) Thank you for your help :) We are using FME Form 2022.2

 I have a unique requirement that I'm racking my brain trying to find a solution. I have a set of irregular shaped polygons, and I would like to draw a line between all unique pair of vertices. In the crude example below, the black line represents the input polygon and the yellow represents the desired result. Ultimately, after building the lines, I want to query out the longest line for additional processing.

When I migrating a workspace from FME 2019 to FME 2023, the FMEServerJobSubmitter in FME 2019 version returns _status feature attribute which helps me debug if the job is suceeded or failed. However, when I opened it in FME 2023, there is NO _status attribute returned after the workspace runs. FME 2019: FME 2023:How can I get the _status attribute back in FME 2023? or is there any other way to get an attribute value similar to _status to info the user if the run is succeeded or failed? Thanks for the help!

Hello everyone..I have Laz data and I want to bring the base completely to Z = 0 without disturbing the 3D position.How can I do that?