FME Form

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   

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 conn

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.

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 :

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 result

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 LRS

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 “r

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?

How do i read LAZ raster files from Azure Cloud? 

i use  pyrhon create FMETriangleStrip, how i add normal list  for FMETriangleStrip? thanks

I have a workspace where the user should be able to export a DEM grid in several different fileformats (a user parameter for the output filetype). Then I have a FeatureWriter for the output. It works well if I want to output a raster DEM (e.g. a GeoTIFF), but if I want to output the data as a DWG with a point grid, I get several thousands of Features exported.Of course, I could make a workspace with a lot of different filetype Writers instead, but a single Feature Writer would be nicer.  Is there a way to consolidate all the thousands of DWG points into one DWG? I dont really want a DEM consisting of one multipoint either.

Hello folks,I want to split data from below data as shown. I want the output format in CSV as this - where the target quantity is Quantity / No. of days in months.The problem I am getting here is I am not able to split the data of month into number of dats because as I need the date as 01-Jan-25 for all the days in the monthHow can iterate these values. Kindly help!