FME Form

Hi everyone,We recently switched to the new version (2024) of FME. I ceated a new fmw-file to convert gml to dgn. But when opening the dgn, I noticed that every level that uses an attribute value has the colour ‘white’ instead of the intended colour.Is this a bug? Can somebody help me how to solve this?Thanks in advance. 

I am testing the OGCAPI of the Norwegian Mapping Authority (https://ogcapitest.kartverket.no/rest/services/havnedata/collections). It provides five different coordinate reference systems. http://www.opengis.net/def/crs/OGC/1.3/CRS84http://www.opengis.net/def/crs/EPSG/0/5973http://www.opengis.net/def/crs/EPSG/0/25833

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 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 Documentat

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.

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:

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. 

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 spl

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)

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 Writ

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):

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 ?

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

I can't remove the "issue." fields. I tried deleting them with Attribute Manager and AttributeRemove without success. Could someone tell me how to do this deletion?

Hi everyone, I'm working on an FME workflow that needs to process multiple Shapefiles. The challenge is that these files come with different schemas (different attributes, attribute names, etc.). I’ve noticed that transformers like DuplicateFilter, AttributeExposer, DatetimeConverter, SchemaMapper... don’t handle these schema changes dynamically. That means every time a new Shapefile with a different schema is added, I have to manually update these transformers to accommodate the changes. Is there a way to make this process more dynamic, so the workflow can adapt automatically to different input schemas without manual intervention each time? Any tips or suggestions would be greatly appreciated! Thanks in advance!