FME Form

In FME 2016 there were a possibility to set how geometries would be stored in the MSSQL writer. For instance, Arcs could be stroked with a setting within the writer when stored in the table, without using the Arcstroker-transformer.However, in recent version this isn´t possible any more. My problem:I have a set of polygons in a MSSQL-database table (let's call it table 1) that was written thru the 2016 MSSQL-writer. (The original data is stored in a different database (oracle) which i use to update and create new data)  I then use FME-server to write all the data (edited, new, untouched ) from Oracle to a different table i MSSQL (let's call it table 2) each night . The MSSQL database then comapers the areas of the original table (1) and the comparison table (2) which I'm writing data to each night. I do this check to see if I got any new, deleted or changed geometries (area comparison) be

Hello. I'm trying to host FME Server under AWS's Application Load Balancer (ALB). A SSL certification (which is provided by AWS) is attached to the ALB and ALB listens to 443 port.The EC2 insance runs FME web application on the standard HTTP port (80). Let's say the domain I host FME Server is mysite.com.When I open https://mysite.com , the browser redirects to http://mysite.com/fmeserver/ (port 80) instead of https://mysite.com/fmeserver/ . How can I configure FME Server web application to redirect to https ? EDIT:I'm using Ubuntu 20.04.F

Hello:)This is incredibly petty, but as someone who lives in a country where “Commonwealth English” is the standard for spelling (and not the Simplified English of North America), I wondered if there’s a switch in the UI somewhere so that menu items and transformers are spelled correctly (correctly for me). For example: the NeighbourFinder, which, as is pointed out in the docs, is an alias of the NeighborFinder. I’m waging my own campaign against the normalisation of N.Am. English in software across the English-speaking world. 

Hi all,Trying to set up workspaces in Form that read files directly from my ACC project using a web connection. However, my project isn’t appearing under my Hub? Appreciate this is vague but any suggestions would be great! Update - there seems to be two environments - one linked to autodesk EU and one linked to autodesk UK - not sure if this is impactful!  2nd update - one (UK) environment i can install the FME app on Autodesk but on the EU one i dont have this option - will the project not appear if the Autodesk FME app is not installed? Thanks  

If you’ve watched my FME Realize video, you probably noticed a sleek toolbox full of colourful buttons that launch different experiences like attribute popups, videos, inspection forms, and more.🎥 Haven’t seen it? Here’s the link — grab popcorn, it’s about 9 minutes long 🍿These buttons aren’t part of FME Realize by default — they’re generated entirely using an FME workspace. To make it easier for you to create the same kind of toolboxes in your own FME Realize projects, I’ve created a custom transformer called HTMLToolboxGenerator.W

I’m using the rasterdemgenerator and I can’t get the fme_basename passed it.   I have some lidar tiles and I want to make a DTM from them. I can do everything, but I cant get the DTM named like the input las file. It has either no name or it has the name of the transformer.  There is an old forum post where Takashi tell’s someone to expose the FME_feauture_type, fill it with the FME_basename, use a group by (using the FME_feauture_type) in the rasterdemgenerator and than use it as the raster file name.  It doesn’t work for me… Any other suggestions? I’m on FME 2025.0   

I would like to use Flow to send an email once a record is being added to a survey123-form in Arcgis Online. This email should contain the record fields and attachment (image file, 1 for every record). When using a webhook + workspace in Flow I am able to sent an email with the record fields using the emailer transformation.However, I am not sure how to send the attachment (without placing it on the server first). I am not sure what I should fill out in the 'source file' field in the Emailer transformer.I tried:inserting the attachment url first converting (with RasterExtractor) and then using the rasterblob.Both send the items to rejected.What should I fill out here?Or is this not possible without first downloading the image?

Hello Safers, I have a CAD file that has annotations inserted within it that should be one annotation but, for whatever reason, they were created as separate annotations: Above is an example of what I am struggling with. The text should simply read 10.88, but FME reads it as 1, and 0, decimal , 8, 8, and 0. What I would like to do is treat this as one annotation, and be able to round or eliminate extra numbers where needed (i.e. I only need two decimal precision, not three). Please note I already figured out the precision and rounding….I just need help with these multi-part annotations.How would I go about doing this in FME?Thanks!

Hello...I've created a HTML report using HTMLReportGenerator/HTML Writer and am trying to write this report to a pdf but have not been successful. I've tried connecting both a pdf FeatureWriter and a PDF Writer to the HTMLReportGenerator output and do get a pdf file created but it's blank. Thanks.

Hi All,I have tried to implement several suggestions from the community regarding date filtering; however, I have not been successful so far. I am trying to filter dates in a CSV file based on the "last login" within the past three months. The date format in the file is as follows:18/07/2025 09:16 08/07/2025 12:46 01/02/2024 10:07 16/01/2025 10:33I have converted those dates to %Y%m%d resulting ‘20230403’ then add an AttributeManager to change the ‘last_loging’ attribute to ‘date’ and finally used the following expression to filter the "last login" within the past three months:@Evaluate(@DateTimeFormat(@DateTimeSubtract(@DateTimeNow(), '3', 'months'), '%Y%m%d'))...but for some reason doesn’t work,Any guidance or support would be greatly appreciated.

When I create a Custom Transformer in FME, and (manually) create parameters within that custom transformer, it seems that I can't assign an attribute value for these parameters from outside of the custom transformer. So for example, I created 3 distinct parameters (text, number and (single) choide) inside of a custom transformer, all of them with the setting 'Disable Attribute Assignment' unchecked.then outside of the custom transformer I don't get an option to provide an attribute value for each of these parameters;Interestingly, if I expose attributes at the input port of the custom transformer, like so;

I’m trying to read a text file with settings in it then, use the settings in the WS. The settings are formatted on lines like name = value. There are lines with other stuff on them like comments that I just want to ignore. The WS that I have seems to work up to the AttributeSplitter. I think it splits right because it shows 30 features created but it doesn’t fully fill the list{}. I think the list{} should have 60 items but it only has 2. The AttributeCreator just creates one attribute for the list{2}. I’m a bit confused how this should be configured. Also, if there is a better way of doing this (reading settings) then, please let me know. I have attached my WS (zipped) and my txt settings file.AttributeCreator: only one attribute gets created ‘APP_EXIT’. 

Hi Guys, I have a strange error when i running an testfilter transformer.When I want to pass data through the test filter, then set it to "No" and all other must be filtered. The Test filer give an output as you could see on the pictures. Also i'm seeing chinese characters......is this a bug?Before testfilter.....   Same feature after testfilter...

I've run into this issue multiple times now, and it's quite serious. My SQL table writer was set to automatic and selected TINYINT as the datatype. However, one of the values I attempted to write was 5000, which exceeds the valid range for TINYINT. As a result, I expected 57 rows to be written, but only 51 actually made it into the database. Because the system only throws a warning (and buries it in a long list of logs), this kind of data loss can easily go unnoticed unless you're scanning through potentially hundreds of warnings. The warning I wish to flag or somehow cause the workbench to fail if it occurs:2025-07-17 14:15:40| 0.5| 0.0|WARN |Microsoft SQL Server Non-Spatial Writer: Failed to parse Unsigned TinyInt' from attribute value 5000' for column `How many kilolitres (kL) of liquid waste was generated?' Silent data loss is extremely dangerous in data pipelines. How can I flag

I’m working through a data cleaning process in a workspace. I have multiple files that are different from each other in schema and attributes, but are essentially all saying similar things. Hence the cleaning. I’m working in one workspace to make re-use of transformers a little easier, but when I’m using the FirenameParkExtractor transformer I need to identify a user parameter source for it to gather up a name to chop up. This is what that dropdown looks like: The names here do not align with how I’ve named the readers and associated files so I’m a little confused about how to make this situation easier to work with. I’d like to be able to rename the source datasets, but I’m not sure where I’d do that. Can you tell me? As an aside, is it a bad idea to process many things in one workspace? Should each

Hey!I was wondering what the best practices are when it comes to updating a sde table that has archiving enabled. I have a few tables in a sde database that I need to update regularly. These tables have archiving enbaled and the tables have between 100,000-900,000 records.I have noticed that when I want use “Truncate Existing” in my sde writer that it takes a long time (I’ve never actually had the patience to let it run to completion… I usually cancelled it after a few hours)If I use the “SQL To Run Before Write” to truncate the table before I write to it, all the “archived” data gets lost.If I use the arcpy function “Truncate Table” in a Python Caller right before I write the data to the table it works really well, it doesn’t take too much time and the archiving function is working as well. I guess one other option would be to detect all the changes and only update those rows but for different reasons this makes the workflow a

Not sure if it’s an issue as such, although I struggle to think of a scenario where you would want this functionality, and it might be obvious to some but just as an FYI If you send multipolygons into a Dissolver with Aggregate Handling set to Deaggregate and choose attributes to sum, the polygons will be deaggregated first, this means that each constituent part inherits the attributes of the original multipolygon feature and this will then be summed to leading to unexpected values. So from thisYou get this 

I’m working on a flood-affected buildings project in St. Pauli, Hamburg, using FME’s SpatialFilter transformer. I uploaded an image of my setup (see attached). Almost all buildings are being rejected, and I’m not sure why. My buildings are the "generic object," and the flooding areas are the clipped ones.  

Hello,I have two tables with the same field names. Both tables have 2 date fields, with a start date and a end date and other fields which has the same name in both files. The only thing is that the date segmenst (time between start and end) has a overlap.Example:TABLE 1:DATUM_INGANG DATUM_EINDE ID REPLACER 19921101 20040119 0502010000027183 OWNER 20040119 20160930

I am processing a large amount of simple data: Points with attributes. I want to filter the data by a specific set of attributes, some of which have wild cards. e.g., "T", "T BASE", "T BENT" should all pass through. For each run, a user will be specifying the valid attributes by putting them into a file (probably text), which will be read in at the start of the process. I mention using a list, but they could go into a table as well if that would work better.

I’ve recently faced the conundrum of how to ‘spell’ workspace - is it with a capital ‘W’ or is it a lower case ‘w’.🤔🤔I can see arguments for both sides. I think it’s pretty unanimous that Workbench is a capital ‘W’ as it is the name of the application, but what are your thoughts on ‘workspace’? For example: Ensure Workspace properties are filled out to provide context to users reviewing or supporting Workspaces. The Workspace description provides an overview of the purpose of the Workspace. The Workspace name provides additional context to the purpose of the Workspace.  OR 

Hi, i am copying files using the FeatureWriter with FileCopy and but some of them are missing but i dont get an attribute telling me which files are missing. All i get is this in the log:File Copy Writer: Skipped 401 features that contained invalid source datasetsBut what i would like is to route those with invalid source data set and have them write to an excel ark or similar so i know which files cant be found.But right now the features all come out of the same port with no distinction of wheter or not the copy was actually succesful. Which is not very useful for me. Any help is very much appriciated :)

I want to re-project an image file into CRS EPSG 20047 BCSG2020But that CRS is missing from my drop-down list.I am running FME Desktop FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64) Is CRS EPSG 20047 BCSG2020 available in a more current version? 

HiI am currently trying to create a web connection in FME desktop but it says the following: Unable to store connection. Please try againSQL Query INSERT INTO fme_nc_namedconnections (connectionname, username, servicename, connectiontype) VALUES (?, ?, ?, ?) failed. Error: attempt to write a readonly database This happens with any connection type I try with this particular windows user account. If I log in with a different account, I am able to save the connection, but I no longer use that account and need to run it through this one. Does anyone know how to resolve this please? Thanks