FME Form

Hi,A colleague and I are working on a script for a client. In the script, we have a simple custom transformer that performs a loop to match some attributes in the correct order. Its basically just a feature merger with a loop: If I run the entire workspace the loops get stuck and keep iterating forever. However if we run the workspace with for example "run to this" far down the stream, it has no problem and the custom transformer finishes after a few seconds.Does anyone have a clue why this is happening and what we could do to prevent it?Best regards

Hello there, I am trying to execute some Python using the ArcPy module in a workbench base on this Tutorial, Using Arcpy for FME Feature Processing, but I am getting this error the following error:Geodatabase Error (-2147220970): Cannot acquire a schema lock because of an existing lock.Could not open File Geodatabase dataset `C:\Users\’USERNAME’\AppData\Local\Temp\wbrun_1740499345598_2444\fmetmp_24\1740665793794_2528_d\tor470\temp.gdb' for readingFailed to obtain any schemas from reader 'FILEGDB' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information It the issue seems to be the GeoDatabase is still “open” in memory, but my Google Fu has failed to come up with a fix

Hello FME Experts,I am working on processing a point cloud and need to create height-based sections to later filter the point cloud accordingly. Here is my goal:Extract the minimum and maximum height of the point cloud (already done). Create sections every 1m, starting from the minimum height up to the maximum height. For each section, create a buffer of ±0.5m (so each section spans 1m). Finally, filter the point cloud to extract the slices based on these buffers.My idea is to extract the Bounding box of the pointcloud, extrude it 0.5m lower, and then slice it starting from bottom every 1m until reaching zmax, and use them with Clipper.How can i slice this bounding box?I thought about creating a new attribut Number of slices = zmax - zmin and then use it as increment? or is there a simpler solution? Thank you for your help 

Hi,IT is storing our passwords in azure key vault and they are rotating on a structural basis.We don’t have FME Flow.There is an FME app registration in azure, so i have tenant id, client id and client secret that can be used for like blob storage and sharepoint.Is there a way to connect in FME to azure key vault?Also IT is talking about using managed identity, are there any examples on how this can be implemted to fetch passwords from key vault?

I am trying to write out to a DWG from multiple inputs and need the output file name to be a combination of variables i.e.  Extract_@Value(lot_number)_@Value(survey_type)@Value(survey_number)_@Trim($(_extractCoordinateSystem),EPSG:)_@DateTimeFormat(@DateTimeNow(), %Y%m%d).dwg The variable creates fine using a variable setter   But when I try to run the writer it fails. It appears it is trying to write the file multiple time and fails to overwrite    Any ideas on how I could set the variable file name better?

Hi All,I have recently upgraded from 2022 to 2024. Previously, when choosing to remove an attribute from within the AttributeManager transformer, the name of the attribute was removed from the ‘output Attribute’ column. This was very handy as it gave a good visual prompt for how the new dataset would appear. Example shown in the screenshot below:I now notice with the new version that the name is no longer removed and stays visible in the Output Attribute column. Example shown below:Does anyone know if this is this something that can be changed in a setting somewhere? I know this is only a small thing but it made a big difference to my day lol :D Thanks! 

Hi FME Community,I have a folder containing 100 CityJSON files, each with three main features: Building, BuildingPart, and Metadata.I need my files to be dynamically processed by transformers to create new attributes and then output the modified CityJSON files into a new folder while keeping the original filenames.Do you have any tips on how to achieve this?Best regards,ImanePS: I tried using the reader to specify the folder path, but it doesn’t seem to be working perfectly. 

i manage to set up ODBC with KeyPair but FME's JDBC connector with KeyPair is failing.     Google the issue and it points to this solution : https://stackoverflow.com/questions/70303334/secretkeyfactory-not-available-error-in-snowflake-jdbc  how do i actually implement it in FME JDBC connector? https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#privatekey-property-in-connection-propertiesConfiguring the JDBC Driver | Snowflake Documentation It mention about using BouncyCastle API . How do I actually enter this part of the code in FME JDBC connector?

I am trying to download from the Norweigan Surveys Inspire Atom feed using the latest version of the GeoRSS/RSS Feed [Reader]. Oddly the LinkURI does not get exposed by the reader. Looking at the XML source the links are present and are tagged <link></link> but for some reason they do not get interpreted correctly. Any ideas on how to solve this?Link to the feed: https://nedlasting.geonorge.no/geonorge/Tjenestefeed.xml  

I have the blue lines drawn identical to red line.with right and left angle of 90 deg as shown on left.How can replace the 90 degree angle  with small arc with specified radius lines(fillet).This group is wonderful and members are gratefully giving always such help. 

Hello FME community,I have two feature classes and I want to know which features have identical shapes. It's somewhat like a FeatureJoiner, but I want to join based on identical shapes.Thank you 

Hi All,I’m trying to create a 10m node line from a 2.5m node line. I have tried ‘Densifier’, ‘Line Combiner’ and also ‘Chopper’ but can’t get it to work,How can I reduce the number of vertices and to obtain a 10m node line?Thanks

Hi everyone,I'm using the AreaBuilder transformer in FME to create polygons from line features. However, I've noticed that some lines disappear after processing. It seems like the AreaBuilder ignores or removes them in certain cases.The lines are neither in the Area nor in Incomplete nor in Rejected.The lines that have disappeared are marked in yellow.after Areabuilder before AreabuilderWhat could be the reason for this? Are there any settings or common issues that might cause lines to disappear?Thanks in advance for your help!

I was tasked with determing raster statistics (e.g. flood height and DEM elevations) for a large number of building footprints.  I didn’t expect that the Clipper transformer would treat the following input Clipper polygons the same as outside Clipper polygons:With the “Determine Cell Location By: Centers” parameter, any clipper polygon that doesn’t intersect a raster cell center is treated as being outside, even though it intersects the raster.  That is the polygons labelled below as “bounds only” and “no point or bounds” are treated as being outside the raster. With the “Determine Cell Location By: Bounds” parameter, any clipper polygon that doesn’t intersect a raster cell boundary is treated as being outside, even though it intersects the raster.  In this situation the clipper polygon can have an area much greater than the raster cells.  That is the polygons labelled below as “point only” and “no point or bounds” are treated as being outside.A raster (green grid with red centers) bei

I want to identify if there is a way to identify all connected conductors of an electric device using FME. All the points (Electric Device) and lines (Electric Line) in the attached screenshot are actually all connected. This is actually connected in Smallworld and I want to establish the same connection in FME but in ESRI this is not graphical connected as depicted in the screenshot. I can trace connectivity form Electric Line to the device but not the other way around. I want to correctly merge Electric Line data with Electric Device records. More than one electric lines can be attached to one device and so far I have tried List Based Feature Merger, Feature Merger and Spatial Relator with Intersect Predicate. Buffer will also not work in this scenario as it may take into consideration some other nearby line. There are no associated or connected features in Electric Device which may link it to Electric line, hence List based feature merger is also failing.ESRI :SMALLWORLD:  

Hello, I am working creating a workbench that will take date for AGOL and from our sde database and join them together as a point feature for use in AGOL apps. All of a sudden, I get this error message:ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '405' and the message was: 'This SqlTransaction has completed; it is no longer usable.'. Details: 'Unable to apply edits. Please check your parameters.'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for detailsAn error has occurred. Check the logfile above for detailsWhen I look at the log file I do not seem to locate any information. No sure what I am doing wrong.Thanks in advance. Scott 

I am performing data validation of a excel source data.I have configured multiple validations in Attribute validator.Issue:FME validates the not null validation and all other validations given, but what I require is if any of the attribute is null, I don't want to do any other validations.How do I perform these in FME?

I’ve seen a few other posts discussing this or similar issues when it comes to writing data to tables in an Excel file, which is now affecting me on a current project. There is a similar problem in named ranges as well, although slightly less problematic. I went ahead and filed a support ticket but in the meantime, decided to post here in case someone knows of a solution.Every time data is written to tables and/or named ranges and a template file is used, the resulting file contains errors that Excel tries to fix upon opening the resulting file. If tables are involved and cells are referenced elsewhere, links to the first table end up broken as you can see below:Here is the resulting error upon opening the Excel file: Data seems to be written as expected, but having to click through an error when opening the Excel file, plus the potential of losing links to table data, is not a good thing. An example workspace template is attached so you can play around and test on your end (in version

I use Fme Form 2024.2.2. If I remember correctly, I used to convert multiple files in one process with an earlier versjon of Fme Form.I have attached a file showing how I structured the fmw for to separate files and for multiple files.I need to convert more than 100 files from Quadri format used in Norway to the GDB format.When I convert two files separately, everything is OK.The sise of gdb files are: Rp2 5,90 MbKdp3 2,62 MBBut when I convert to files in one process something is going wrong. The size of files are:Rp2 – 5,90 MBKdp3 – 154 kBI have tried different combinations of the order of files and numbers of files.It seems to me the first file is always Ok, but it fails from the second one onward.I appreciate all kind of helpEla 

HelloHere’s my challenge:I have two datasets that I need to compare after several transformations.- Dataset 1: This contains georeferenced points with distances associated with a linear reference system (LRS).- Dataset 2: This has no geometry, but contains distances from the same LRS.My aim is to associate each value km_start in dataset 2 with the closest value _measures in dataset 1, even if they don't match exactly (I’d like to be able to assigne a tolerance, for ex. max difference of 0.01m). Thanks to this matching, I will be able to assign a geometry to the data in the second set. Below are a few screenshots to illustrate my question: Dataset1 with georeferenced points, _measures are distances in the LRSDataset2 with non geometry features I want to get the closest match from Dataset1 We're talking about fairly important datasets but it shouldn't be too much of a problem if the process takes time.Thank you in advance for your help and ideas.

I have a a workflow of moving several tables from one database to another one. I needed to make a change and wanted to test the workflow writing to my localhost instead of production database. So i changed the postgis writer from “Truncate existing” to “Create if needed” targeting my local test environemnt. Still i get an error complaining that the tables does not exist?.. It does not matter if I hardcode the Table Qualifier or not. Or if i remove it all together. I have tried to not running the wb in cached mode etc..Tried running the WB in both 2023 version which it was created in and in 2024 version. “POSTGIS Writer: Table 'rplan.PblMidlByggAnleggOmråde' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format Parameters”And yes the schema “rplan” does exisit in my localhost database.I have no explanation to why FME would struggle with this?

Is it possible to get the owner information using the ArcGISOnlineConnector? if not, is there something else I can use? I used the List Action and was able to get a list of the services/maps, but because there are the same item in two different AGOs in this group, I am unable to get the right one unless I know the owner. Thanks

Good day , I have these 4 lines. Each line is an aggregation of two different lines (blue and yellow). I want to split these 4 lines into 2 lines each where they intersect with a given point (red dot). I used the intersector and the point on line overlayer. But in both cases I get 3 lines as a result instead of 2. These two transformers split the lines at point intersection as well as desaggregating the blue and yellow line part. This is not what I want. I only want to 2 lines (split at point intersection) as a result of the transformation. How can I achieve it ? I can not split lines at point intersection before I combine the lines. It’s a complex workbench.

Hi FME world,I have received a series of NetCDF files (representing rain radar) and I have no information on the projection for them, other than they are supposed to be in New Zealand and maybe Lambert Conformal? I can represent in an app like Panoply (image below) but when I try to project in FME, NZTM or LL84 is incorrect. I have tried creating a custom coordinate system but this is no use either. I’ve included a view of the Feature Information with the exposed list as per this conversation NetCDF - no CRS desposited | Community.Would love some direction if anyone has any thoughts?! Thanks!   

I suspect this might be an ESRI thing rather than an FME thing, but is it expected behaviour that if a feature is written to a table which has a non-nullable long field that field gets populated as zero if an attribute is missing? No error, or warning?