FME Form

DescriptionI have a excel template file which I have in the excel reader dataset as a reader file. This file only has the name of the attributes and no features. I am trying to implement this job for the end user where every month they can upload the excel file with the same template structure, however different features month on month basis.  I want to set up my parameters in a way that based off the template populated, it reads the file every month when uploaded by the end user and also give an ability to the end user to mention the sheet name in the prompt. 

I have a new attribute named EXPORT_YEAR. I want the Attribute Value to automatically change to 2026 at 12:00AM Jan 1, 2026. Until then it will stay 2025. Is this possible? if yes, what expression do I use?   

Is it possible to save the frame of the data inspectors?I mean, I have this:Two layers overlappedIs it possible to save this image at certain zoom directly in FME from data inspector or the regular translation environment?

Hello FME Community, can someone help me configure the Geocoder transformer to use our County geolocator service?  I’m using a single-line address, with the locator on an ArcGIS Server.  The URL is https://gis3.montgomerycountymd.gov/arcgis/rest/services/geocode/Composite_Locator/GeocodeServer.  This is a public-facing locator service for Montgomery County, MD. I’ve tried:   Using the above URL   Using the locator as an AGOl item in the transformer, both fail.     Setting the URL with different paths to the operation or the base geocode folder.   Setting the transformer geocoding service parameter as ArcGIS Server or ArcGIS Online.  I can successfully use the geocoder transformer with the ArcGIS Global geocoder, but I prefer the County geocoder to ensure the addresses and inters

@safe I just recognized that the SpatialRelator in 2025 does not release my Requestor attributes as before (2024 and any older version I remember).I’m used to use the SpatialRelator with the setting ‘Generate List’ checked (incl. some selected attributes) and keeping the ‘Merge Attributes’ unchecked. As a result I see all my Requestor attributes and where applicable the list attributes according to the spatial relation I’m looking for.Now in 2025 the above setting ONLY releases the list attributes and all my Requestor attributes are removed. The only way to bring it back is to check the ‘Merge Attributes’ checkbox as well, which is not my intention.I guess it’s a bug since the Transformer page still states for ‘Output’: These are the Requestor features with the new attributes added. One list entry is made for each of the Suppliers that has at least one matching predicate. FME Form 2025.0 build 25208

Hi,I’m finding that the date shown for data updates on ArcGIS Online Hub is misleading and not showing the date that we are actually updating the data, has anyone used the Metadata Updater to update any of the dates in metadata?  I don’t see it listed in the dropdowns for the updater. Or should I be using the XMLUpdater?Thanks,Lorinda

Hi, Based on the sample table, I want to implement a logic. Same name, different policy # and same address - Goes to file 2 Same name, different address and different policy number - The first record goes to file 1 and rest of the records go to file 2.  All the manual should again go to the file 2.Policy Number New/ Renewal/ Manual Name Address To process Split  123 New John Chris 123 Oxford St Y File 1 110 New Mary Jane 45 Caron ave Y File 1 111 New Mary Jane 360 Caron ave N File 2 112

Hi, I have 50 SQL queries stored in a excel file.Column A: Name_SQL_QueryColumn B: SQL_QueryI am having a hard time find ways to execute the query and export to a CSV file with Name_SQL_Query. I set the csv writer to dynamic exposed. however, when i run the workspace i only repeated sql 6016 times (this is the number of rows I get when i execute the sql by itself). it seems like the first Query from the excel list is working when i sampled the first 1. However, I am getting the repeating of column A and B. How do i export the result straight from the SQLExecutor?  

Hello,Do you know why autocad_color parameter is allowed from 0 to 256 for Autodesk Autocad DWG/DWF writer but is strictely limited to 1-255 for Autodesk Autocad Map 3D Object Data writer ?It prevents to write entities with ByLayer (256) or ByBlock (0) Color parameter in addition with OD tables 

Hello everyone, I’ve been working with 3D Buildings recently and I’d like to add some info to the walls (e.g. indicating which wall has an entrance door). I could set up this information with the 2D Footprints by using the BoundingBoxReplacer and HorizontalAngleCalculator (I’d have used it with my 3D Buildings themselves, but it only works for 2D lines). But I can’t find the right way to add this information to my 3D walls.If I directly extrude the 2D walls instead of the 2D polygons, I lose the classification of Building_IDs that I want. If I reconvert the 2D walls into 2D polygons with an aggregator, all my info goes away and I’m back at the starting point. I tried converting the walls into points with snipping and then converting them into 3D Features with Offsetter and Bufferer such as other pas

Can you please let me know how I can switch and select the workflow based on the value of Attribute? For example I need to select and continue between continuing PythonCaller or PythonCaller_2 based on the value of operation IF ‘operation’ == ‘ADD’ THEN Continue with PythonCaller IF ‘operation’ == ‘REMOVE’ THEN Continue with PythonCaller_2 

To provide context, I’m trying to read tables from Amazon Redshift DBs, because our IT Dept does not allow direct connections to our Oracle Nonspatial DBs. We’re using Amazon Redshift as a “clone” of our Oracle data, refreshed daily.Problem is that when I access Amazon Redshift via FME Reader, tables in those schemas that are DDL-enabled are not visible to me (I can see the schemas just fine, but when trying to specify the specific tables, this below error appears).Fig. 01 - Tables not accessible in FME Amazon Redshift ReaderThe following image is when I click the “Show Log...” button.Fig. 02 - Logs from “Fetching Feature Types Error”

I am having trouble writing a few rasters to a raster fgdb. Most are fine but a generate errors of undefined. But previous definition seems fine. bit of a stumper. don’t think it’s a projection issue. Any thoughts? Error on write for 1 or 2 rastersPrevious step has all as fme_aggregate and fme_type as raster. 

We are using FME 2021 and planning to bump postgres version to 14.Are there known issues with that combination?I have tried to find a compatibility sheet for FME Desktop/Server and Postgres and/or other Software, but did not succeed.

Hi guys!I'm trying to understand how the STAC Asset reader works.In my case, I have a URL to an item, but when I try to access it, it complains that I don't have authentication. When I then check the "Use authentication" box, I only get options related to AWS, and not the service I created.I've used the URL to retrieve data via Radiant Earth Stac browser with my credentials and it works there.Has anyone used this reader to extract data from sources other than the default ones?

In the past I've received 2 file MRSID files, 1 RGB and 1 Color Infrared, this time got a 1 MRSID file with all 4 Bands. I can RasterSelector then RasterBandRemover and get the RGB, this takes a little longer as I need to pass it thru transformer. QuestionCan I read a MRSID and only select the RGB Bands and not read the Color Infrared (Apha) as if I don't need it why read it (would this speed up the Workspace processing)? 

I'm struggling to figure out a way for an initiating Feature to trigger 2 separate WorkspaceRunners simultaneously. In this case, Workspace 1 and Workspace 2 are completely independent of each other, and it doesn't matter to them if the other Workspace Fails or Succeeds. However, Workspace 3 DOES need to conditionally only run if Workspace 1 and Workspace 2 both succeed, and Workspace 1 and 2 must only report "Success" if they run with no errors. I hopefully set it up this way below only half expecting success, although it ended up that this still only ran the WorkspaceRunners in Sequence and didn't work, since WorkspaceRunner #2 waited until WorkspaceRunner #1 completed before pulling in the Initiator Feature. Note: Workspace 1 and 2 are completely different FMWs and completely different Parameter lists. 

Hi, wondering if anyone know how to limit the featurereader, I am trying to read only the first 10 rows from each table in postgres and it is still pulling back every row before passing on only 10. What am I doing wrong? Thank you in advance

Hello,In some cases, JSONFormatter writes a decimal point number with the full precision of floating point numbers.Example:Source{ "number" : 1.954, "string" : "1.954" }Formatted by JSONFormetter (FME 2021.2.2){  "number" : 1.9540000000000002,  "string" : "1.954"} I think this document is desired in many cases.{  "number" : 1.954,  "string" : "1.954"} Is there any way to prevent adding the excess decimal places?

I have many pdfs that are structured in exactly the same way.At a certain place I have to black out the text.My rough idea:- pdf-reader: define the search envelope so that only the text that has to be blacked out is read in- place black polygons at the position of the text- rewrite the pdf as a whole, with the polygons overlaying the textIs this feasible in FME ? 

I have a dozen TIFF files I need to convert to PDF. These are not georeferenced or related to GIS; they are just black-and-white images. They are intended to be hyperlinked so users can view them on a website. I understand how to use the TIFF Reader, but the PDF Writer confuses me. I see there are only two choices to write to PDF: Adobe 3D PDF and Adobe Geospatial PDF Writers. I have tried both and received same error. I am using FME Form 2021. What is the best way to convert TIFF files to PDF files? Or what parameters do I need to set if I use one of the PDF Writers I mentioned? Here is the error I receive when I use any of the two PDF Writers:ERROR |PDFWriter: Could not open output file for writing. Please verify that the file is not open in other applications or that the file is not read-onlyThe TIFF files are not open and are not read-only.

I wish to use the JPEG writer rather than the attribute file writer, because I want to add EXIF data to the image that doesn't exist in the original BLOB. I do not see a way to add this EXIF information when simply using an attribute File Writer.

I have two lines that are starting from the same point (blue point). I would like to calculate the geometry of the points where the lines start to run in parallel (approx. where the green points are). How can I do it in FME ?

Is it possible to force a custom transformer to process features one at a time when there are blocking transformers within the custom transformer?I run into this problem when I try to create a 3DGeneralizer and want to process lines individually.Example: A custom transformer splitt lines into vertices. The lines are also generalized. NeighborFinder is used to match vertices and generalized lines. I want the NeighborFinder to only process features (line and vertices) from a single line at a time. If Group By is used in NeighborFinder it will block features until all lines have entered the custom transformer.Thanks, Anders

I have a template.gdb that contains feature classes, and some attributes within these feature classes have default values. Like here for the attribute FLOWDIRECTION When writing features into these feature classes using the Feature Writer, I expect the default values to be applied to attributes where no value is provided. However, this is not happening. What could be the reason for this issue? How can I ensure that the default values from the geodatabase are correctly applied?