FME Form

Hi!I’m using FME Workbench 2022.I’m trying to insert some data in a table in PostgreSQL. The table has a composite key, like this: (id, feed_id, env_id). The table, obviously, has the constraint: CONSTRAINT agency_pkey PRIMARY KEY (id, feed_id, env_id).In FME, I’m reading from a GTFS file, doing some transformations, and then, trying to write into the DB with a FeatureWriter using PostgreSQL as Format. I have all the configurations right. I checked it so many times, and before posting this question, I talked to some experienced mates.The problem I have is, in runtime, the FeatureWriter is not adding the attribute called “id” to the insert, so the database is sending the error “null value in column id violates not null constraint”. It happens with and without bulk mode.Now I’ll provide some images for visual context and information.Flux:

I'm trying to reproject a DWG file from AGD 1966 ISG 56 (EPSG:102077) to GDA2020 Zone 56 (EPSG:7856). I'm using the original DWG as a template to preserve layers, colours, line styles, etc.I've set up a workbench to handle the reprojection and all the data looks good and in the correct location when viewed at the final step in the inspector:However, when I open the output DWG, most of the data is correctly reprojected (matching what I see in the Inspector) but some features remain in the original coordinate system, thus showing up in Antarctica:

I have been trying to find a good use for the ‘ai assist’ function. I don’t think it has ever succeeded in providing a useful answer. Have any of you had any luck?Or do you also copy paste to a real ai?In this example I needed a SQL Query edited, but my request was invalid for no reason. When I post in any other LLM I get a thorough response and description of this and that.My overall questions is probably, why is the FME implementation so poor? Is this spelling the early signs of the end for FME? 

Hi Everyone,I’m new to FME. Currently, I use FME to convert IFC4 LOD 300 to CityGML 2.0 LOD 4. It happened that a long railing can make the size of one CityGML feature exceed 1 GB, and it’s challenging to import it into 3DCityDB. I have to divide the railing into pieces so that each CityGML feature won’t exceed 200 MB. As shown, the railing has 1270 parts of MultiSurface. I’m thinking of splitting it into 1270 CityGML objects.First, I tried the “Deaggregator” transformer. But when it is written to CityGML with other feature types, the divided geometry cannot be viewed. The file size is small, so I believe the divided geometry wasn’t written into the CityGML file. However, if I only convert the divided geometry into the CityGML file. The file size is 1.4GB, and it can be viewed in FME Data Inspector. Here is the screen capture of

I try to create tables where schema definition is from SQL Server into PostGIS. Schema onlyFor this i have a simple workflow. But for the life of me i do not understand why my tables are not created despite FME report everything went well?String replacer is just changing the name of fme_freature_type_name to remove the standard “dbo.” table qualifyier from SQL Server.   Writer setup Log                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-rplanforslag_alternativ_forslag.RpAngittHensynGrense                         1rplanforslag_alternativ_forsl

Anyone having this issue ? Even if everything is fine with the parameters in the transformer, I see the red arrows. When I zoom in / out everything is ok. Kind of annoying. I’m using 2025.1.3.  

I feel like everytime I try the PythonCaller I really struggle with the scripting and usually switch to a start up script to avoid it. Can anyone help me figure out why I don’t have any outputs when I run this in my PythonCaller.  import fmeimport fmeobjectsimport reclass FeatureProcessor:    def __init__(self):        pass    def input(self, feature):        """        Processes a feature to extract and set address components.        Args:            feature (fmeobjects.FMEFeature): The feature containing the address attribute.        """        # Retrieve the address attribute from the feature        address = feature.getAttribute('ADDRESS')        # If the address is missing, set all related attributes to empty strings        if not address:            for attr in ['Suite', 'AddressNumber', 'StreetName', 'StreetType', 'Direction', 'Street']:

Hello FME Community, Salesforce recently announced the retirement of their SOAP API login().  Are there plans to replace the current Salesforce readers and writers or update them to support Salesforce’s OAuth 2.0 Flow?  Currently the readers and writers use /services/Soap/u/51.0 which will be retired in the Summer 27 release.  I’ve used these a good bit in production workspaces, so need to start mapping out some transition plans.  For retrieving data, the SalesforceConnector will work, but it’s nice to be able to write and update data with a drop in transformer rather than setting up HTTP

Would be great to be about to output Dynamic blocks to AutoCAD, things likeVisible states and Flip setting would be great, Distances for stretch, rotation and Alignment parameters might be a bit harder to achieve.

Hello,is there any version of FMEFORM 2025 that will allow me to select a coordinate system in the reader from outside the short list without automatically closing the entire application? I checked 2025.1.1 and 2025.1.3. or is there any tip to do this? I tried different scenarios and always when i am trying to open More coordinate systems the application closed by itself.Regards Artur Gustowski  

Hi,I created a parameter in my custom transformer of the following form:PARAMETER_NAME: LRF_FILEPARAMETER_TYPE: OPTIONAL FILE_OR_ATTR LRF(*.lrf)|*.lrfPARAMETER_PROMPT: Label Rule File:PARAMETER_DEFAULT: $(FME_MF_DIR)No matter what value I enter for the Parameter_Default, the file box on the transformer GUI always initially shows up empty in Form. Can someone suggest what I’m doing wrong?Thanks,Martin

Hello,I have a configuration table that my FME workspace reads to update a GIS database. This table includes ArcSDE database connection information. The workspace dynamically reads each database connection one at a time and passes it to the Feature Reader. Because it's dynamic, all features are routed through the generic port.Currently, I use an AttributeExposer to make feature attributes available for processing. However, this requires manual updates whenever database schemas change, which is problematic since the workspace runs on a schedule.Is there a way to automatically expose attributes at runtime, based on the schema of the next database being read, so I can eliminate the need for manually updating the AttributeExposer? Thank you, 

My current FME Server setup includes a CORE/2 Engines set up on one machine with another Engine-Only Host running remotely on another machine. Recently, I noticed jobs on the remote machine queuing up and never processing. Restarting the FME Server Engines Windows service temporarily fixed the problem. But only for a few hours. I don't see any errors in logs. But I've just switched to debug level logging for more info and hope to capture some. What I do notice is that in FME Server web console, under licensing & engines, the remote engine just won't show up. Once I restart the service, I see it under both the Engines tab and the Deployment Status tab, until it disappears again. Unlikely this is service account related (as other similar post/solutions suggest) since I can restart service and then it runs for a bit. I did make a change regarding domain controller/Active Directory recently but rolled that back and it didn't

Hi all, My colleague and I are preparing to do the Form and Flow certification exams. We use our work laptop to start Talview. The laptop only has FME Form 2024 (scripted). We would like to remote desktop onto our azure virtual machine to access Form 2025 for the exam.  This machine is also set up for publishing to Flow.Will Talview allow access to a remote machine for the exam? Thanks,Annette

I am trying to read in non-spatial data from Microsoft SQL Server. I need to read in three Tables and three derived Views. I have set up a connection using the Microsoft SQL Server Spatial (JDBC) format, and I have the connection to the main folder in the database working fine. In the Parameters > Constraints, I am only offered the option of ‘Tables’, and this does allow me to read in the three tables in the database perfectly. However I cannot find a way to access the Views which are in a different folder in SQL. Is Reader limited to just reading Tables? The FME documentation says “The Microsoft SQL Server Spatial (JDBC) reader and writer modules provide FME with access to spatial and attribute data held in Microsoft SQL Server database tables.” - with ‘tables'; being specifically mentioned, rather than all folders within a database.Is there another way of reading in Views? Or do I need to go back to the database creator and get him to do so

Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:

Hi,I am new to FME.My question is simple and easy.I have a field that has multiple lines, FME is not able to read it.FME Version: 2025.1.1.0Data set has 5500 records, of those 300 gets rejected as it has multiple lines.I am trying to create lines.  Sample:LINESTRING (-122.47510883224778 37.72569214605437, -122.47549442640992 37.72569240767212, -122.47591818521782 37.72543361304484, -122.47615044826871 37.725435814791524, -122.47635018879221 37.72551472908074, -122.4768917047572 37.72596114891507, -122.47722446641976 37.72606220923341, -122.47809062309513 37.726088801447176, -122.47840706343166 37.72604796879034, -122.4788330330602 37.72589235538119, -122.47914970916452 37.72593694003075, -122.47935639456331 37.72605991382738, -122.47998774607001 37.72692786951861, -122.4801298766873 37.727219718364864, -122.4800482518362 37.72746956663917, -122.47983883659106 37.72763905162748, -122.47914598242949 37.72796883327165, -122.47

We recently migrated to FME 2025.1.2 / ArcGIS Pro 3.5.3Now I need to update some records in a point featureclass in SDE so I created a new workspace with a Creator, a FeatureReader, an AttributeCreator and a FeatureWriter.Reading the data from SDE works as expected. But when I try to write the data, I get the following errors:2025-10-22 13:12:21|   2.0|  0.0|ERROR |Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support2025-10-22 13:12:21|   2.0|  0.0|ERROR |GEODATABASE_SDE writer: An error has occurred. Check the logfile above for detailsNot writing anything dynamic. Just point to the correct featureclass and go.I think I’m now pretty much out of options, because I upgraded my ArcGIS Pro.The only way to get it to work again is to remove ArcGIS Pro 3.5 and install a version which does work with an older version. I came from 2021.2.6 so I know that works, but I would pr

I have a Geopackage, 458.761 polygons. Using a FeatureWriter, type Geopackage, I tried to store this. Unfortunately I get this error and could not found any logic behind this one:OGCGEOPACKAGE writer: Feature type 'Road' has geometry type 'geopackage_multipolygon' and cannot accept the current feature with a geometry of type 'geopackage_multisurface'.  Skipping feature FME 2025.1.2.0

Hi All,I’ve got what should be a simple issue but I’ve not been able to find and answer for my exact query.I’d like to take a feature class, containing photo attachments, stored in a file geodatabase and write it to another file geodatabase. Essentially copying the data from one file gdb to another.I’ve seen lots of posts about reading and writing as separate processes. In both instances the photo’s are imported and attached or extracted from the data.Is it possible to essentially copy a feature class with attachments between file geodatabases, without having to extract the photo attachments and then reattach them?Thanks for your time.

Hello, the workspace is close to “Creating CityGML Solitary Vegetation Object | Community” but without the issues. I would like to randomly rotate the instances along the Z axis. Dimensions are set as in the first matrix shown below. When I use the last row to rotate, as shown in the second matrix below, the rotation is ignored and dimensions change. I tried the rotators, and the 3D affiner after defining the matrix to no good results. It seems that CityGML only looks at the transformation matrix.  Any advise or workaround to force instance’s rotation is appreciated. I have a random rotation value stored in an attribute brought as an attribute of the location point. +++++ Matrix withOUT rotation +++++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.0

Hello everyoneI am currently using FME Workbench 2025.0 (FME(R) 2025.0.3.0 (20250602 - Build 25241 - WIN64)) in combination with ArcGIS Pro 3.5. When attempting to add a File Geodatabase to my workspace, I encounter the following error:"Unable to perform any licensing-related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator → Workspace Parameters → Translation. This 64-bit version of FME requires ArcGIS Desktop with 64-bit Background Geoprocessing, ArcGIS Pro, or ArcGIS Enterprise. Refer to this article: http://fme.ly/qua for more details."Additionally, the following message appears:"Failed to obtain any schemas from reader 'GEODATABASE_FILE' from 1 dataset. This may be due to invalid datasets or format accessibility issues related to licensing, dependencies, or module loading. See the log file for

Hello,I’m using FME 2024.2 to read ORD DGN files stored in ProjectWise.The DGN files have a local coordinate system (LCC) defined in ORD, but when I read them into FME, the detected GCS appears incorrect — particularly the ORG_LAT value. Because of that, when I try to set the coordinate system and reproject to State Plane, the transformation doesn’t work properly.Has anyone encountered this issue before?Does the GCS definition in ORD need to follow a specific format or standard to be recognized correctly by FME?Any insight or suggestions would be greatly appreciated!GCS shown for features in FME

Hi Long time user, havent posted as not been hands on in a long time but here goesWe are looking to add new extensions into GPX files Something like: <trk>    <extensions>      <htrk:HemaTrack>        <htrk:difficulty>          very_difficult        </htrk:difficulty>      </htrk:HemaTrack>    </extensions>  </trk> We have an XSD definition for the namespace as well <?xml version="1.0" encoding="UTF-8"?><xsd:schema targetNamespace="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" elementFormDefault="qualified" xmlns="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" xmlns:xsd="http://www.w3.org/2001/XMLSchema">        <xsd:annotation><xsd:documentation>    This schema defines the Hema Maps extensions to be used with the GPX 1.1 schema

I am looking for guidance on how to create this interactive map..  We have FME and ArcGIS…  From time to time, we are given maps and we have to change the counties based on new staff.  Most of the time the counties are adjacent.  Other times not.  We have a shapefile of the counties. I am looking for a solution where we can select the counties in the shape file/FME and output the selection for the update query.I believe I have all the pieces Just not sure how to attach the transformers together… or what the logic is to create this… TIA (Thank you in advance)