FME Form

Interpreting an FME model can be challenging at times, so having a function that exports every transformer/tool used in the model and automatically providing an interpretation of their actions would be helpful. Is this possible in FME?

I was busy creating a Custom Transformer and wanted to link a Published Parameter to the Advanced Parameter 'Maximum number of iterations’.  However, the dropdown option shown below did not pop up. This screenshot is showing a workbench derived from this tutorial:Looping with Blocking Transformers – FME Support Center Any clues?

I have a table that I need to export to an Excel file. To this file I want to apply some styling. I’ve written a Python script that works well: it uses a FeatureWriter followed by a PythonCaller, and the result is an Excel file with the desired formatting, including filters, colors, and so on.Now I’d like to split this Excel output using a fanout expression, which generates 23 separate Excel files. Each of these files should then be processed by the PythonCaller. However, that’s where things go wrong — the process seems to get stuck. I’m using the _dataset variable from the Summary output port of the FeatureWriter as the location for the Excel files, which the PythonCaller should loop through.Is there something I might have overlooked?

I have tried using the online tool but not having any luck. Could anyone show me how to get this into FME? How does someone get this built as a coordiante system in FME

 Hi folks! As I was using AI tools like ChatGPT and Copilot to troubleshoot, I suddenly received information from the AI about the "Generate Workspace Documentation" function. Here's what I learned:-------------------------------------------------------------------------------------------------------------------------------Generate Workspace DocumentationThis feature allows you to automatically generate comprehensive documentation for your FME workspace. The output is typically an HTML file that provides detailed insights into your workspace structure, parameters, and transformations. It's incredibly useful for sharing with colleagues or for archiving your workflows. How to Use It: Usage in FME Workbench (GUI):Open the FME Workbench application. Load the workspace you want to document. From the Tools menu, select Generate Workspace Documentation. You can choose to output the documentation in an HTML format, which can be opened in any browser.Command Line Usage:This function is also ava

I am trying to get my few MS Excel as a reader and then write them to a new Excel all together however, I got this error that says Excel Writer: xlsx row limit of 1048576 exceeded for New. The first 1048576 features of New will be written to file. Ending translation ? Is there a way around to pass this ?

Hello everyoneFollowing this article I created (with the help of our IT folks) a OneDrive (Graph) web service with custom client and tenant ID values, and on using the Test feature I can successfully bring up the sign-in dialog, but my connection is repeatedly sent back for admin approval, even though I’m configured as an admin for the app, and the 365 admins approved my login.  On returning to the app I get this:A bit of web research leads me Microsoft’s troubleshooting topics, but I don’t know my way around.  Our 365 environment is pretty locked down, but IT say I should be good for the app.Has anyone been through this and has some tips?  Thanks.

I would like to fill the holes or patch the gaps that are not really holes (see image), but in the output I don’t get any attributes. Why is that, and what is the best method? I try Areaamalgamator but ii cannot retrieve the attributs in output…thank you 

Hi, I have the following csv sheet created with FMEThat is not exactly what I want. I would like to see the following format:The third column is empty, and for the last 4 columns only 1 row is needed. How can I achieve that? The values in the last 4 columns are purely inserted in the user interface at the start, not more than that.Below is the part of FME:The user parameters of the writer  are as follows:Any tips?

My company does SSL inspection/interception which is causing errors when trying to view background maps in FME Form.  I have seen ways to fix this for the FME Flow (Server) side, but is there any way to change any configurations for FME Form to handle this?  The CA certificate for our authority is in the Trusted Root Certification Authorities certificate store on machines so I’m not sure why it isn’t trusted if FME is using the machine’s certificate store for trust.  Below is an example of error seeing from FME Flow 2025.0.1 (but have seen on previous versions as well).Stadia Maps Reader: Failed to load 'https://tiles.stadiamaps.com/tiles/alidade_smooth/5/19/14.png'. Error: 'HTTPSConnectionPool(host='tiles.stadiamaps.com', port=443): Max retries exceeded with url: /tiles/alidade_smooth/5/19/14.png (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1018)')))'Python Exception <FMEExcepti

Hello everyone,I need to transform a 2D road graph into 3D. Each vertex of the lines should receive the correct Z value from a DTM.I found this solution, which works very well:  The problem with this workflow is that it is very slow. My region is very large: the graph has about 150,000 elements, and the vertex extractor generates more than 2,000,000 vertices, which slows down the script. Any suggestions?

I am currently working with the new DocumentPDFStyler to create a individual feature reports.  Instead of the table reading across the page, I am creating a vertical transposed table with the attribute exploder.Table input However this seems to have limits with the styling as both fields are in the ‘column value’ so any styling done, including conditional options, are performed on the entire table instead of just the second value column. Output PDFIs there a different way to do this or is it possible to have an other documentPDFStyler element for vertical tables? 

I have line segments (vertex only a beginning and end) and want to create polygons for each (including their attributes).  The line segments represent a span between utility structures in a right of way. The goal is create the polygon geometry per span and calculate the acreage in each. The Bufferer works great when the line segments are straight, but when a turn is introduced, I get slivers and overlaps as seen in this screenshot:Notice the overlaps and slivers where the line turns Bufferer Parameters:Bufferer parameters To visualize what I’m trying to create - here is a mock up of where I want the polygons split (red lines were drawn in by me and the green polygon is just a buffer of the dissolved line segments).  The centerline represents the spans.Red lines = where I want the polygons split Doesn't sound too crazy but it’s kicking by butt at the moment.  Any idea or suggestions?

Hi, Has anyone went through issue with the Value doesn't fall within the Domain” in a File Geodatabase ?Even though the description is already there   See screenshotI am currently dealing with it and it is a lot of work…Is there a workaround to fix the error ?The reason I am asking is because I have to go back to the Recreation.gov website and re-do again and reviw to ensure I choose the right one.I am using ArcGIS Pro 3.3.6 in a Citrix envirnoment 

I want to upload some files for a specific workbench using HTTP.I'm using Python for this with requests library, but I'm having difficulty getting it to work.My python code is as follows:    with open(file_path, 'rb') as file:        url = f"{fme_url}/fmedataupload/{script_location}"        data = {            'custom_file': {                'value': file.read(),                'options': {                    'contentType': 'application/octet-stream',                    'filename': file_name,                }            },            'opt_namespace': directory,            'opt_fullpath': True        }        token = get_token()        headers = {            'content-type': 'application/x-www-form-urlencoded',            'Authorization': f"fmetoken token={token}",        }        return requests.post(url, data=data, headers=headers, json=True)I do get a 200 OK response, so authorization is fine, but the file isn't uploaded.It even creates a directory at the right spot.The response is as

Hi folks,Trying my hand at a workflow that takes certain records from a GIS feature class and writes them into a Spreadsheet XLSX (2025 Work Plan). I’ve renamed the attributes from the GIS feature class schema to match the relevant fields in the 2025 Work Plan Spreadsheet with no issues. When I examine them, they look good in the table.The Spreadsheet has certain Excel-only fields that are not included in the GIS feature class. What I am finding is that while the information is being translated into the 2025 Work Plan Excel Sheet, it is also writing the remainder of the fields from the GIS feature class into columns in the 2025 Work Plan Excel Sheet that are Excel-only.This is despite trying to remove the excess fields in the Writer. And even mapping the fields directly to the corresponding fields in the Excel Writer. I had tried experimenting with the ‘Update’ parameter rather than Insert, but that caused errors.Are there any suggestions to ensure only the specified GIS fields are wri

Hi all,I hope all is well! I am very new to FME and data products.We use FME 2022.2 but we thought it will be time to upgrade to the latest version to benefit from the updates.I have installed 2025.1 and the first thing that I can see is the reader format has changed I would use “Microsoft SQL Server Spatial” in 2022 but in 2025 it is “Microsoft SQL Server (MSSQL)”I would assume they have aggregated both non-spatial and spatial into one reader format.I go to add the connection that we normally use - in this case it is called GisAzureView which is a hosted server for us. I would then need to select which tables I would like to read from but I get this error: 2025.1 Error when reading hosted SQL database“Failed to obtain any schemas from reader 'SQLSERVER' 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” - is the error that comes up - so it is failing to open the reader

Hi community!I’d like to know how to make the white background of this image transparent and change the black color of the geographic region to white. It’s important to keep the original resolution and export the file in Uint16 format.I’ve attached the image: could someone kindly apply this transformation and send me back the modified version?Thank you so much!

Hello, I am trying to extract html tags from an attribute, however the documentation is very unclear and need further guidance.Page: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/htmlextractor.htmStates: “In the HTMLExtractor, a query is constructed to find the div tag with the id “article” (CSS Selector = #article). The contents of that tag will be extracted (Tag Part/HTML Attribute = Value), and output to the new attribute articleText.”Where is the mapping document that maps FME CSS selector ‘ids’ to html tags?  I am trying to extract <br>, what should the CSS selector for this be?  Using “br” as the selector and then using a list exploder produces an attribute with empty fields.

Hello,I am currently learning how FME handles IFC HVAC structures and have been using some sample files from the RWTH-E3D DigitalHub repository (https://github.com/RWTH-E3D/DigitalHub) for my tests.While doing this, I'm having trouble getting FME to read all the features and their geometry correctly. The IFC file itself appears to be valid, as it displays correctly in an external IFC viewer like BimVision. (filename: DigitalHub_FM-HZG_v2.ifc)Here you can see the full HVAC system with pipes, tanks, pumps, etc.However, when I bring it into FME, I get incomplete results, and the behavior is different depending on the version I use.1. With FME(R) 2025.1.1.0 (Build 25615):The reader fails to read most features. The feature count for IfcPipeSegment, IfcTank, IfcPump, etc., is 0. The FME Inspector confirms that nothing is read.2. With FME(R) 2025.0.3.0 (Build 25241):This older version is partially successful:It correctly reads features like IfcPipeSegment and IfcTank with their geometry.Howev

I'd like to use non capturing groups in StringSearch. It is possible in the PCRE expression but seems not to work in FME :Example :On the string "This is a text string"(?:This is )(\\w)* should return only the string "a", but StringSearch returns the whole "This is a" in the "first_match", and only "a" in the subgroup when activated.First match should be the same as the first subset ?

We would like to migrate IOT sensors event data, which is exist in MySQL to Hono-Ditto system.Can you please help us with the process? Thank you.

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

Hi,I do have a question for anyone that experience about extracted information from a website . I have a geodatabase that I set it up as a field with Domains.The project I am working on is Campground for my Forest here we have many campgrounds.  I work on about 18 campground so far…My question is can I go to Recreation.gov site and select a campground using in FME ? For example, in the search box , type Colorado Campground and then it turns to new page and you will see the campground map that has all the Site number you can pick.So click on number three and then click View details...which will bring another page and it gives you all the information about that site number…That is what I plan to use this…I have done input all the information into my geodatabase  there. Will HTMLExtractor work for this type of thing ? Am I making myself clear  Thanks ! 

Hello all! I am using a CSV file as a configuration source, which contains a list of database connections and corresponding table names. This CSV connects to a Feature Reader, where:The database connection is set using a parameter (dbConnection) read from the CSV. The feature types are dynamically set using the table names from the CSV.The Feature Reader successfully reads data from all specified tables and outputs them through a generic port. I’ve exposed both the feature attributes and the fme_feature_type.Now, I need to join the database data with client data, but since all table outputs are merged through a single port, it's difficult to manage and distinguish between them.What I’m looking for is a way to automatically separate the data by fme_feature_type (i.e., table name) and route each to a different port or stream without manually updating filters or Testers every time a new table is added to the CSV. This is essential because users will be updating the configuration file with