FME Form

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension.In 2021.2 both .tab and .TAB files are readA MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab filesIs this expected behaviour?

HiIn FME 2025.1, can multiple feature classes containing the same fields and needing to be updated with the same data be developed to use a single DatabaseUpdater converter?For example;A function can be added that allows feature classes or tables to be selected in the parameters, as in the reader. The additions can be seen as a list above the Match On list.

I’m trying to upload a raster to Mapbox, but no matter what I do, the output file always turns the nodata cells to black. I have tried fixing this using RasterBandNodataSetter and RasterPaletteResolver. If I look at the feature cached output from those transformers the nodata cells are still transparent. The issue arises when I use the MBTILES writer. No matter what, it writes nodata as black. I also tried removing the nodata (RasterBandNodataRemover), doesn’t work. I have tried outputting the data both as png, png8, and jpeg. Does anyone have any other suggestions? Thank you in advance!

Hi, I just upgraded FME Form and FME Flow from 2024.0 to 2024.2.3. One of my jobs failed using a FeatureReader with the Directory and File Pathnames due to the extension not being in all caps because the extension on the file it’s looking for is in all caps (.CSV). Originally the parameter was set to filename.csv and the FeatureReader would have no issues finding the file on 2024.0. Now the FeatureReader is not able to find the file in 2024.2.3. I changed the parameter to all caps .CSV in the featureReader and it finds the file with no issue. Anyone else noticing this with 2024.2.3? 

When using a FeatureReader transformer to read Snowflake spatial data, the following warning is posted into the log.Snowflake Spatial Reader: Skipping data in column '.GEOG' due to error (JDBC Type = VARCHAR, Vendor Type Name = GEOGRAPHY, Error: class java.lang.String cannot be cast to class [B (java.lang.String and [B are in module java.base of loader 'bootstrap'))The process does complete normally, but the geometry is not read automatically. Has anyone else encountered a problem like this? I’m using FME Form 2024.0.1.0, Build 24202.

Hi All,I have a survey asking participants to rank their favourite colours—Red, Blue, and Green—in numerical order (1, 2, 3).I want to use the results to create a workflow that counts how many times each colour has been picked based on the ranking.Here is some example data.Sample Data Unique_ID Colour Rank 1 Red 3 1 Blue 2 1 Green 1 2 Red 1 2 Blue 2 2 Green 3 3 Red 1 3 Blue 2 3 Green 3  What I am trying to achieve Colour  Rank_ 1_Count Rank_2_Count Rank _3_Count Red 2 0 1 Blue 0 3 0 Green 1 0 2

Hi, I have scanned a map and saved it as a raster image. I need to compress this PDF using FME. I have tried RasterMappers and RasterResampler, but both are making my map smaller without actually reducing the file size. Do you have any recommendations, please?

I have a feature reader that’s reading an Oracle non-spatial database. I have a workbench that writes all of the read tables to a file geodatabase. Some tables, I process twice; one where just the flat table is written, and another where the coordinate attributes in the table are used to create a point feature class written to the same file geodatabase. For some reason, only the flat tables are being written and none of the point feature classes are being created. Both work if I run them separately but not if I have two coming out of the same reader port. I’ve hidden the lines to write the flat tables to the feature writer.Is there a setting in the feature reader that I need to change to ensure it processes multiple outputs for each feature?  

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?