FME Form

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 past suggestions, but then I hit a wall (pun unintended) becacuse SpatialRelator and SpatialFilter don’t work for 3D Data (INVALID_GEOMETRY will be written). The only transformer that seems to

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” But when using DBeaver (with the same connection details and credentials), i can view the tables and data just fine.Fig. 03 - Dbeaver Database NavigatorI’ve shown this behavior to both the ArcGIS Pro vendor and our IT personnel, and they’re both stumped. What would be the probable problem here, and where should we start looking? See the following for ArcG

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?

I am having an issue writing metadata to an SDE geodatabase. I am reading features from a feature server and xml metadata from a URL.  When I write to SDE it gives the error:Error occurred using IXmlPropertySet2::setXml(). HRESULT = -2147215103.   File: D:\code\fme\foundation\formats\geodb2\geodbutilities.cpp   Line #: 3580 I set the attributes up like in the tutorials (setting geodb_metadata_string and geodb_type) and I am testing on a new feature dataset. Using FME 2023.2Any ideas?

Just recognized, after migration of a workspace from 2024.2 to 2025.0 a BulkAttributeRenamer shows strange results: The transformer is set to change attribute names to lowercase (mode rename) for a selected set of attributes. This works as expected. However the remaining attributes (not selected for any change) got almost completely removed. ‘Almost completely’ means from the >5000 records only 4 have the attribute after the transformer while all other records show the attributes as <missing>.@safe - although it’s easy to mitigate it might be worth to dig into it.note: in mode ‘keep original attributes’ results are as expected.Klaus 

Hi, we would like to test if it is possible to use IDS- files to validate propertySet in IFC- files.Any ideas?  

Hi, we are searching for a solution to create seamlines between aerial photos.So we have a lot of photos with different overlapping areas like this:footprints Is there a possibility to create seamlines between the images? So we wouldn´t like to do this manually. It should be approximately the center line of the overlapping areas. At the end we wanna cut out the origin arial images based on the seamlines. Does anyone have experience with this?  

Hi all,I work on a mapping project that requires all of our shapefiles to be quality checked at the end of production. I currently have an FME workbench that converts Esri geodatabases to shapefiles for the final check.However, I’m having an issue with one of my attributes. The attribute is being written out by the workbench as a ‘double’ (which I believe has a max width of 19). The quality check tool checks both the data type (needs to be real) and the specified width of each attribute (needs to be 19).When it is checked by the quality check tool I get an error message which states the expected length is 19 and has found a width of 15? It’s fine with it being a ‘double’ though?Any ideas?Will provide more information if needed.

Hi,I am trying to use the SpatialSorter in my workspace to sort data by location and define group size. However, as I’m currently using the FME Workbench 2024 version, the SpatialSorter is quite different and doesn’t provide a new attribute named “GroupID”, it’s also impossible to define a group size in the parameters.It is quite inconvenient because it’s not possible to use the Aggregator transformer on the GroupID attribute afterwards to group sorted spatial data.As far as I know, there is no unexposed attribute generated from SpatialSorter in the FME 2024 version. To compensate, I used the  NeighborhoodAggregator but I’m not satisfied by the results.I was wondering if anyone else encountered the same issue and found another solution ? Thank you for reading!

I have a workspace in FME 2021.2.6 where I produce a TIN from a DEM with the TINGenerator. In this transformer there is a parameter called Tolerance. I was playing with this tolerance to find the right amount of detail, that is still acceptable for my task and reduces the amount of triangles in the TIN. Now we’re about to switch to FME 2025 soon, so I thought there might be a performance win with the new Version, so I gave it a try. But I found out, that this transformer does not work the same way anymore and whether I put in 1 or 100 or 10000 in the tolerance, it does not really matter. The result looks way different and in my opinion is worse, than with the 2021 version. Can someone explain me, how I can produce kind of the same results as with the 2021.2.6 Version? How can I reduce the number of produced triangles and level of details within the TINGenerator if the tolerance does not has any effect on this?Thanks for your helpSimon Different tolerances in the TINGenerator in FME 202