Transformers

I have error messages when trying to run python script. I installed fme.exe python -m pip install pywin32 before import win32com.client but encountered a lot of error messages. Please see script attached. Please help. Thank you.

Does FME support reading Geosoft Geodatabse with the extension .gdb? If yes, which reader can be used?

For some reason when I run inlinequerier on FME server 2022 I get the following error. 64 2025-3-31 16:49:13 | InlineQuerier (InlineQueryFactory): The clause 'USE_FMEOBJECTS Yes' within 'FACTORY_DEF {*} InlineQueryFactory FACTORY_NAME { InlineQuerier } USE_FMEOBJECTS Yes TABLE_DEF Swap_Data Title<comma>text<comma>Hyperlink<comma>text<comma>Region<comma>text<comma>Status<comma>text<comma>Event_ID<comma>integer<comma>Usid<comma>text<comma>Market<comma>text<comma>SubMarket<comma>text<comma>ClosedOut<comma>text<comma>ErcNode<comma>text<comma>SSD<comma>text<comma>SSV_Ready_Date<comma>text<comma>Q_5640T_Date<comma>text<comma>FA<comma>integer<comma>County<comma>text<comma>SSV_Rejection_Note<comma>text<comma>sharepoint_item_id<comma>integer QUERY_DEF Swap_Data SQL_ENCODED Select<space>&lt

I would like to create clusters of line data (geometry) for sampling, the geometry would be connected within each cluster. So far I’ve thought of:Create a bounding polygon > split it into X polygons using Tiler or some other transformer > SpatialFilter. This would be the easiest I guess, but this would create dead ends at the geometry around the polygon boundary. Ideally, I would like a closed/self-contained ‘route’ but not really necessary. SpatialSorter > group every X rows. But I realize this doesn’t give a nice closed-off route either and you would have to manually see how many rows to pick to create a nicer cluster so probably better off with the first option.Any better ideas? Additionally, it would also be good to be able to define a criteria for sampling like having X km of main roads and Y km of small roads in each cluster but I suppose that can come afterwards by calculating the counts per cluster and choosing clusters to hit the quota.

I’m using FME Workbench 2023.1.  I have a workspace where I am trying to use a FeatureReader with a Spatial Filter for a constraint to limit the number of Parcels I bring in from the Parcels layer by running them spatially against the Corporate Boundary layer.  I’m new to FeatureReaders and I’m not sure what I am missing to get this to work as intended.  I have my Corporate Boundary layer connected to the Initiator Port on the FeatureReader.  The settings for the FeatureReader point to the ESRI REST Service URL of the Parcels layer.  And no matter what Spatial Filter selection I use: Initiator OGC - Contains Result, Initiator OGC - Intersects Result, Initiator OGC - Within Result...I only get 1 output to the Schema and 1 output to the Initiator port.  See the image below.  Can someone please explain what I might be doing wrong or missing when trying to use the FeatureReader? FeatureReader_Parcels Parameters view with FME Workspace in the background. 

Hi all,I’m attempting to create a python script to encrypt a file for transfer to a bank.We need to be using PGP encryption, and as I understand the only way to encrypt using FME is by way of python.Having only recently joined the organisation, I was not here when the installation of the latest Form and Flow was undertaken, (otherwise I would have advised that the Flow installation 2022.1.1, should at least match the Form version 2023.2). But that’s only part of the problem I believe.First, I would like to attempt to figure out if the libraries are available from a Form workspace running on my desktop.When I check the INTERPRETER settings in the Options menu, it appears I cannot change or make reference to any alternative path.So far I have had very little luck, and would like to know if anyone hasa simple python script that can run in a workspace PythonCaller/PythonCreator that will provide a test (so far the script produces an error any way I attempt to write to the log). I must admi

Hi All, I've replicated a print call to a public mapping application using HTTPCaller. I've done this to try to capture some metrics on intermittent print errors we are seeing.However, complicating this, the response body results URL (from which the pdf would be retrievable) is formatted slightly differently between the  HTTPCaller and the browser Dev Tools response. For example:In the browser I see: "url": "https://utility.arcgisonline.com/arcgis/rest/directories/arcgisoutput/Utilities/PrintingTools_GPServer/x_____xW6zDASkYrE9-8aNcJmscBA..x_____x_ags_e458af6a-0932-11f0-acf5-0e5ef779a06f.pdf"However in the HTTPCaller response I get: "url": "https://utility.arcgisonline.com/arcgis/rest/directories/arcgisoutput/Utilities/PrintingTools_GPServer/_ags_10f9db8b-0934-11f0-84d5-0afff93c372b.pdf"What would be the explanation for this difference?Thank you!

Hello FME Community,I am working with a Utility Network Model (UNM) in ArcGIS Pro and need to perform a subnetwork trace using FME. Since FME does not have a dedicated transformer for UNM traces, I am exploring options using the Python Caller or Python Creator to execute this operation.What I Need Help With: Python Script Guidance: How can I use the arcpy module (or another approach) within FME's Python Caller/Creator to perform a subnetwork trace. Are there any specific UNM functions or ArcPy methods that work best for this? Input/Output Handling in FME: i need to pass subnetwork name  from FME to Python? How can I return the traced features back into the FME workflow?  Environment: FME 2021.x ArcGIS Pro 3.x Python 3.x

I am working on feature and attribute extraction from an AutoCAD Architectural file, namely the extraction of room polygons and their attributes from AEC blocks that represent rooms. I have tried the Civil 3D reader and the reader actually sees the layer with the room AEC blocks and it shows me the available attributes correctly, alas the reader does not return any features. There are no errors, only a lot of warnings about attribute renaming because of scpecial characters.Has anyone ever succeeded in reading AEC block features and attributes? If so, how did you do it?

I'm trying to create a re-usable template that uses a dynamic reader to allow it to read a table from a database, the 'connection', 'feature types to read' and 'where clause' attributes would be defined before the reader but this approach seems to be causing me problems. The process so far looks like this... The FeatureReader looks like this...If I define the connection, table and where parameters within the feature reader everything works fine, the reader recognises the schema and creates an appropriate output port. Using the above approach and defining the same parameters as attributes doesn't create a output port (which I understand as how can it create a port for a feature type it hasn't read yet), next stop was the generic port but I can't seem to get anything useable out of this. I've read numerous articles on here about using a feature merger to merge the schema and the generic ports but this doesn't seem to give me anything useab

Hi All,I’m working on a workbench to help my team to convert E57 point cloud data into SLPK and publish these into a 3D Scene in Portal for GIS. Initially I was converting the E57 into LAS files and then use ArcPro to convert the LAS files into SLPK and upload them into Portal.Before doing any publishing on Portal I wanted to do a simple test on my machine to makesure the E57 point cloud export fine to my machine,I have read the slpk can be created in FME by using ‘Esri Indexed 3D Scene Layer (I3S)’ but, for some reason, I can’t get it to work. Below a screenshot of basic workflow that read the E57 and tries to export to slpk….but it doesn’t export anything? there’s no slpk at all, see below:  Any ideas if I’m missing something?Cheers

I am getting the following error in a FME Form Workspace:Starting translation...ERROR : INCLUDE -- failed to evaluate TCL expression ` if { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { puts "MACRO REAL_MODE ORIGINAL"; puts "MACRO REAL_RATE [expr <Unused> * ( -1 ? -1 : -1 ) ]"; } ' -- missing operand at _@_in expression "_@_<Unused> * ( -1 ? -1 :..." (parsing expression "<Unused> * ( -1 ? -1 :...") invoked from withinexpr <Unused> * ( -1 ? -1 : -1 ) invoked from withinif { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { ...Program TerminatingTranslation FAILED.In a general context , what does this error mean?  What are examples of issues that can trigger it and what FME form workspace design approach

I have a collection of geopackage files, several of which have different feature attribute schemas (attribute names, numbers of attributes). I have read the schemas using a FeatureReader, and created a list for each FME_Feature_Type_Name. (I’ve built a concatenated text string here just for visibility):  Where I am getting stuck is in using this in a subsequent FeatureReader to define the attributes to expose for each file. I’m using fme_feature_type_name in the read location to grab one file at a time.  But am struggling to use the Schema list or concatenated attribute to drive the attribute exposure. I can get all attributes exposed via AttributeExposer, but then I have to use a TestFilter and an AttributeManager to remove the attributes that don’t apply to particular files (because ‘expose all’ picks up all attributes from all files). Is there any way this will work?  

I need to get data from my Bing subscription into the MapnikRasterizer. At least that how I think it should be done.It works of course in the preview because I made the Bing maps available through the options. But as I see it for the MapnikRasterizer I will have to provide the background as an image and I am struggeling to get the Bing data into my workflow. background settings in MapnikRasterizerHow can I get the Bing data into the MapnikRasterizer?

For normal Reader feature types, to update for schema or attribute changes you simply go to Readers > Update Feature Types. I can't find the same functionality using a FeatureReader. Is there a way to do that? The only workaround I've found is to drop the FeatureReader and re-add it.

Hi, why does the attribute pivoter no longer work? I have already read several questions about this.  There is an alternative somewhere with the aggregator, but that doesn't work very well for me either.  Isn't there an easier way or a reason why the pivoter doesn't work?

Hello all,I have some point (electricity poles) and line (overhead conductors) features which I need to connect up for our utility network model. I am trying to insert a vertex on the line at the nearest point to the pole. I have a neighbor finder and vertex creator, but neither are actually adding a vertex to the line (the neighbor finder has insert vertex on base feature set to yes). Is there something I am missing or another way to go about this?thanks. 

Hello,In FeatureWriter, User Attributes,I want to use a User Parameter as the name of my primary key.User Parameter (in french: Primary key name)Feature Writer (not working) 

[Edit] I solved this by fiddling about. Se solutions at the bottom. Will leave post as is, incase it can be of help to someone else.Visual Preview and Data Inspector are behaving very erratically on my computer in Form 2025.0. Bordering on making the software unusable.Some of my issues:One specific to a workspace Today Form refuses to show the results from inspectors inside Custom Transformers, it will only show those in Main. This worked fine yesterday. Only difference is a computer restart.This issue prevails if I open the workspace in 2024.2. I created a new empty workspace and got the previews working from within Custom Tranformers.The issue below goes for all workspaces. Form is behaving like a raging toddler when I try to turn on Enable Feature Chaching. I try to get it to work with me by clicking the setting over and over and over again, but it just resets and does noting each time I press run. Then suddenly it complies without me understanding how that happened.There is simply

Hey, I’ve been trying to get FME (Feature Manipulation Engine) by Safe Software to use Python libraries from QGIS (like qgis.core) so I can mix their cool features in my temp.fmw workspace. The idea is to use QGIS’s Python (version 3.9) inside FME by setting it up with PowerShell commands. But it’s not working, and here’s why, explained like I’m talking to a 5-year-old and then a bit more grown-up:The Toy Box Story (Simple Version)Imagine Python is a kid who needs toy helpers to do jobs—like QGIS toys (for maps) and FME toys (for data tricks). These toys are called DLLs (little helper files). I want Python to borrow toys from both QGIS’s toy box and FME’s toy box at the same time.Step 1: I told Python, “Look in QGIS’s box (C:\Program Files\QGIS 3.32.0\apps\Python39) and FME’s box (C:\Program Files\FME\python)!” That’s like setting PYTHONHOME and PYTHONPATH.Step 2: Python found some QGIS toys (like qgis.core), but then it yelled, “Where’s my Qt5Core.dll toy? I can’t play!” It’s like a t

In my workbench I am taking points, buffering them, and using those buffered areas to clip small portions of a raster mosaic.  After clipping I then run a raster calculator on each of those points  to find the sum, mean, min, max range, etc and create an excel file with all the values calculated and collected. My workbench runs successfully, however in several of my datapoints I get empty rows with no stats being calculated.  When I check the area in ArcGIS Pro there aren’t any null values in those areas and it runs without any issue.  I have tried using RasterBandCoercer to change any null values to 0, rasterbandnodataremover, and nullattribute mapper to help deal with these issues but none of them give me results that I can actually use without skewing the data and giving me invalid results. Does anyone have any suggestions or ideas on how I can fix this issue? Currently running FME(R) 2024.0.1.0 Thanks! 

Dear FME Users,In our organization, we frequently work with Esri Geodatabases, and we often use FeatureWriters to write data to these databases. This process has always worked smoothly for us until we updated our FME Form to version 2024.2. Since the update, we've encountered an issue where the geometry of a feature class is no longer auto-detected when adding a connection to a .sde file (we always embed these connections) and then adding a feature class from the dataset. Previously, this functionality worked perfectly, and we appreciated not having to manually set the geometry.Could this issue be related to the version of FME Form, the transformer itself, or are we possibly missing a setting in the FeatureWriter setup?ExampleInterestingly, when we select a table without geometry, it is auto-detected as a 'geodb_table'. However, for some reason, geometries are not being detected.Any help would be appreciated!

Given the height, length and width of an underground vault, I'd like to create a 3D box of the vault. I'd also like to create a flattened box out of the same dimensions.I've started out with a creator, cloner and a 2dBox replacer then a 3D extruder for the box. I'm a bit lost with the flattening of the box in a 2d plane. Any suggestions on how to get the bottom corners of boxes 1,2,3, & 4 align with the corners of box 5?The bigger challenge is how to project this so I can draw this in a DWG file later in my translation. I have a lat/long as the center of each vault and I could probably start at zed value of 0 initially.me dimensions.

Upgrading 2023 workspace to 2024.2.  When upgrading or adding a new LenghtToPointCalculator transformer and referencing existing attributes for the X/Y coordinates, FME adds 2 rejected ports to the transformer.  If you then run the workspace you get the error:Cannot have multiple factories with the same name.  Multiple factories were assigned the name 'LengthToPointCalculator_<Rejected>'  Any suggestions on how to get only 1 rejected port?Thanks.

Hi everyone, I've just uploaded my very first custom transformer to the FME hub which I'm very excited about. However when downloading the transformer it doesn't show my name next to the community publisher. Any idea how to show my name there?A lot of time went in this transformer so a little bit of credits would be nice :)