FME Form

Hi,Following the instructions: How to Connect to Microsoft Dataverse using FME Form – FME Support CenterI can successfully authenticate to Dynamics 365. However, when I create a Reader and attempt to List the available tables, I get HTTPError: 404.The error message suggests the URL is being incorrectly formed by including “/user_impersonation offline_access/”<domain> is redacted real address….Error URL:https://<domain>.crm6.dynamics.com/user_impersonation offline_access/api/data/v9.2/EntityDefinitions?$select=LogicalName,EntitySetName,DisplayName,PrimaryIdAttribute&$filter=IsValidForAdvancedFind+eq+trueExpected URL:https://<domain>.crm6.dynamics.com/api/data/v9.2/EntityDefinitions?$select=LogicalName,EntitySetName,DisplayName,PrimaryIdAttribute&$filter=IsValidForAdvancedFind+eq+trueAll assistance gratefully received….

Hello,I I am fairly inexperienced with some FME processes.My task at work is to extract text from DGN files and convert it to Annotation Feature classes in a GDB. I need to override the FontSize value that comes from DGN with a specific value in the GDB Annotation class, and all my attempts failed. Does anyone have suggestions on how to go about it? I am using FME 2024 and ArcPro 3.5. Thanks! 

I have a workbench with a RasterMosaicker that runs fine in 2021.2.6, but the same workbench throws an error in 2025.1 “Failed to mosaic the rasters”. Same error for version 2024.1.2.1.The error occurs only when setting the parameter “Overlapping Values” to “Composite Using Alpha Band”.Is there anything known causing issues regarding raster transformers in newer versions that might explain this?

Hello Forum, I have point dataset with 5600 points at an address level. Each point has a ‘score’ value of between 1 and 100. I need to create a hexagon grid. And then assign to each hexagon the score value of the point, or the average score values of the points, that fall into each hexagon. If only one point record falls into a hexagon, say with a score of 42, then that hexagon will inherit a score of 42. But if several points fall into a hexagon, say with scores of 13, 56 and 22, then assign the average value of 30.3 to the hexagon they fall into.  I also need to define the size of the hexagons/hexagon grid. I’ve been looking into the H3HexagonIndexer (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/h3hexagonalindexer.htm) but can’t get the results I’m looking for / work it out. Any ideas would be welcome. Thanks,

Can fme only run up to citygml 2.0?I don't know the part about uploading citygml 3.0. 

When a database is updated using SpatialRelator, FeatureTypeFilter, and DatabaseUpdater Transformers from feature classes inherited from two different readers, the _relationship attribute disappears when the FeatureTypeFilter Update button is used. All DatabaseUpdater transformers are in the "incomplete transformer" status. When examining the DatabaseUpdater transformers, the _relationship values are red. Copying and pasting the same value fixes this. To avoid this issue, you must manually edit the FeatureTypeFilter, which is time-consuming.  

Basemapping available to our org is limited. Several are dark or the level of colour obfuscates point geoms in particular. Can we have a basemapping transparency/colour intensity setting?

Hi,I was hoping to use the new IFC writer available in FME 2026.1 to update the IfcPresentationLayer attribute values from IFC to IFC.The idea was to disregard the current layers exported from Revit from others and define our own layer presentation for the models so we can turn certain layers on and off in our platform (Trimble Connect). I used the reader to load the IFC file (in 2x3 format), and it successfully retrieved all layer attributes into FME. However, I don’t seem to be able to write the updated layers.In fact, even without adding any transformers—just using the reader and writer from IFC to IFC—the layers are lost. So I’m wondering if anyone has had success using the latest FME reader and writer for rewrite the layersThanks!

We are working for a client that has a test domain and a production domain. Servers in test cannot reach servers on production and vice versa. There is currently an installation of ProjectWise (PW) installed in both domains, but the test version is a minimal installation that lacks WSG being setup and configured whereas the deployment on production has everything, currently.Our task is to setup a process that will use FME Flow to retrieve DGNs from PW and use them elsewhere. We currently have an FME Flow installation on the client’s test domain and are trying to approximate the workflow that we will have available to us in production. However, for the moment at least, it appears that WSG being installed is a core requirement for reaching PW with FME. We have other methods for users to place files where the test FME Flow server can reach them, but I would like to know if there is a workaround that can get us to our final goal prior to putting it in the production domain.Any help is appr

Hello,  it is possible to see a FME workspace CPU usage at the end of a job in the logging. However, when you activate a stream it will occupy an Engine and it will not give CPU usage in the logging. Is there a way to find or register the CPU usage of a stream that runs 24/7?

For a specific Writer (for example Precisely MapInfo Extended TAB)Is there a way to see a history of changes and improvements from version to version of FME Form?I have v2022.1 installed, and I am researching if the Writer has changed or improved in v2025.I am aware that a Transformer has a version number specific to that Transformer, but a Writer’s version number is locked to the version number of FME Flow, so it is hard to quickly determine if the Writer has changed between versions of FME Form.

Reading Living Atlas layers anonymously (no authentication) is done using the Standalone Server source type but the 3.21.2 package errors.  This is a publicly shared service you can try:https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/USA_Major_Cities_/FeatureServerSafe are aware of the issue, you can revert to 3.20.2 to avoid the issue.

Hello, I have a pointcloud scan of a underground tunnel. I would like to calculate its volume. Is this possible? I am guessing I first need to make a water tight mesh out of it. Kind regardsMathias

Hi,I’m looking for solutions to a problem that may not be solvable.I regularly need to refer to a spreadsheet from the NZ Electricity Authority (it’s open data).  At the moment I have to regularly download it from https://register.ea.govt.nz/ using the ‘Download’ button This downloads a dynamically time-stamped spreadsheet of the electricity industry participants and their relevant codes.I want to automate this with Form/Flow but this is a sticking point.  I’ve suggested to them that they expose this as a service for the industry, but the wheels move slowly if at all.Any idea on how to read, or more likely, automatically download this?  For the download I’m open to non-FME automations.Thanks

FME Form Excel writer warns of reserved characters, where none exist, in the names of my Named ranges and appends underscores to them. I am getting a lot of warnings similar the following:Excel Writer: Feature Type '/AH_4_3_Housed_Part_Time_Replacement' has been modified to '/AH_4_3_Housed_Part_Time_Replacement_' to avoid reserved characters for Named Ranges and Tables in Microsoft Excel This is unhelpful behaviour, can I avoid it?2025.2

I have configured all parameters on manage web services for Dropbox. But I am having to reauthenticate every time I run the workspace. What should I be checking? I also need to schedule it on Server. I am not being able to authorize it on Server as well. Any feedback is highly appreciated.  

About once or twice a year I have to dig out the SystemCaller, mostly just because I have to trigger a PowerShell command or script file. Without fail, I end up frustrated by the byzantine syntax (quotes galore) and limited way to capture output, finally succumbing to unnecessarily re-implementing the whole thing in Python.So my pick for the transformer that really needs some love and attention from the developers is the good-old SystemCaller :-)Do you also have a pet peeve Transformer that you think could be improved upon?

Below is a screenshot of my workspace that creates a new feature class (AttributeManager_6_Output). This feature class will be edited by end users in ArcGIS Pro. I need to bring that feature class back into the workspace and join it back to caputure those edits. My problem is that some of the attributes will be updated upstream as well. I need to capture those edits as well without overwriting the end user edits. How am I able to set the attribute conflict independently (some attributes from Left and some from Right) in the FeatureJoiner?  

Hello Community,I wonder if anyone has recent experience with Bentley POD Reader. This reader requires installed and licensed Bentley Pointools, which has been deprecated for several years by now and can not be purchased anymore. Is there another way to read POD files with FME? Can Pointools be replaced with something else to enable POD Reader?Thank you 

Ever since the merging of SQLServer spatial and SQL Server non-spatial Reader types, my SQLCreators and SQLExecutors generate a warning:Microsoft SQL Server Reader: Table `___FME_Custom_SQL_Statement___' does not include a spatial column. Geometry will not be read In Form this is easily ignored, but it really messes up my Jobs overview dashboard on Flow, because it results in quite a lot of listings with warnings that do not need checking. And I can’t seem to find a way to tell FME that yes, I know, there is no geometry coming through in this sql, don’t worry about it because I did not select it - on purpose (or because it does not exist).I really do not want to turn off all warnings generically, I am just searching for a way to stop this particular warning. Before the merge it was easy: just use the non-spatial type, and the warning would go away. But that is not an option anymore unfortunately...  

Hi all,I’m encountering an issue with the InlineQuerier transformer in FME Form 2024.2.1 (pre-production environment) that seems to differ from previous behavior.(FME Form 2024.1.3 in developement environment)🔧 Workspace Setup:The InlineQuerier has two input ports:tubes (can sometimes receive no features)parametre_generique (always receives data)I’m using this request :❗ Problem:When no data arrives at the tube input port, the transformer throws the following errors:InlineQuerier_2 (InlineQueryFactory): Generating output 'tubes_statuts_inactifs' using query 'SELECT * FROM "tubes"WHERE (    UPPER("statut_administratif") NOT IN (        SELECT TRIM(UPPER(value))        FROM "parametre_generique",             json_each(                 '["' || REPLACE("valeur_parametre_text", '|', '","') || '"]'             )        WHERE code_parametre = 'STATUT_ADMINISTRATIF_RETENU_TUBES'    )    OR    UPPER("statut_operationnel") NOT IN (        SELECT TRIM(UPPER(value))        FROM "parametre_generiq

We have over 300 FME dataflows using multiple Oracle databases.  We are trying to figure out how to list all the different tables and schemas used by all the dataflows together.

Hi Everyone,We are working on an integration between ArcGIS Utility Network and SAp using FME to connect with SAP via their Odata services and Integration Suite.We have successfully used Get calls from FME desktop to fetch a token and get information about an asset.When we switch using a POST call to create a new asset we get a response error of  “HTTP/1.1 403 Forbidden” and response body “CSRF token validation failed”The calls we are using have been successful from postman through integration suite.I have attached the workbench containing the current settings and the latest log file.Any insight i why this would work for GET calls and not for POST calls

Hello everyone,I looked at thread DGN writer RGB color | Community and I am dealing with the same problem.Ideally I would like to get the RGB color (true values) instead of the colorindex from the color table.I read in the above thread that true color should be available from FME Form 2023 on, but I still get the index number from the color table. Iam using FME Form 2024.2.1 by the way.I do the following thingI have a dgn styler configurated as follows in the Writer I use a seedfile with RGB values for the layers Output is    Am I doing somethign wrong or are true colors not yet available in FME 2024.2.1?

I want to convert OSM data downloaded in .osm.pbf format into OSM format, but I’m encountering the following issue:When converting from .osm.pbf to .osm in FME, the OSM XML data is incorrect: all polygons (areas) become lines, and many objects are missing. I tried using Osmium Docker for the conversion, and the OSM data remained intact.Is there a way to achieve the same result as Osmium within FME? Am I missing something?