FME Form

Hi, I'm having an issue with a Microsoft Access Reader. I have a script that reads a query from Access. This query is a subquery of two other queries. Until now, the script has always worked, but now the query reader doesn't show anything.  

Morning All,  Has anyone else identified an issue with all SQL transformers when specifying the connection via either deployment parameter or database connection? When run on Form it operates correctly but when run via Flow (either scheduled or manually submitted) the following error is returned:  Error occurred while opening database reader with server type `MSSQL_ADO', server name `XXXXX', user name `', database name = `' : `Encryption Error: AES Decrypt finalization failed.' If the database connection is embedded into the transformers Flow is able to operate these transformers correctly, however this would then require each transformer to be reconfigured as we migrate between environments.  Thanks in advance, Paul.

Hi All,I have a folder of csv files with the naming convention like this : Insp1.csv, Obsv1.csv, Insp2.csv, Obsv2.csv etc etc.I have written a workbench to read in Insp1.csv and Obsv1.csv and derive the outputs i want. These csv files are pairs and both are needed to create the output. I have a folder of many InspX.csv and ObsvX.csv files that I want to process. I have set up a Directory and File Pathnames reader than I think I want to pass into a workspace runner that calls the workbench to process the files with parameters.  How to I get FME to iterate over my files and each time the runner is called iterate to the next pair of csv’s? ie first time is run use Insp1.csv and Obsv1.csv, the second time use Insp2.csv and Obsv2.cvs etc etcMany Thanks Goatboy

Hey everyone, I hope I am just missing a very obvious point here. I am trying to compare two SQL input data sourcesOne with these columnsAnd the other with these columns The customer and account number combination is going to be my primary key. I need to extract the email addresses of customers based on that combination. I have tried the feature merger which seemed to be the obvious solution, but I am not getting any matches?Any idea where I am going wrong? 

I was having a bit of a poke around with how Workbench calls the AI APIs and noticed that the method of sending the workspace was to first convert it to graphviz format. I had initially thought the fmw would’ve been passed and parsed instead,Converting to graphviz is a pretty cool step and could be used when producing reports or documentation on workspaces. I know people have asked for similar functionalities in the past re exporting the workspace as a graphic: Is that conversion something that the end user can tap into? I’m going to shamelessly tag ​@rylanatsafe ​@mark2atsafe and ​@NickAtSafe here, as while they might not be the people directly responsible for answering such a question, I feel like they might be able to point this question in the right direction!

I have found that the feature reader will not accept point data as the initiator. I have since found that in Version 15 a change was made: -Spatial operations will reject initiator features with point geometries to match native reader behaviour.Does anyone know why this was changed and if there is a way to force it to accept points without having to create a very small buffer to it and then recreate the point after the feature reader. 

Hi, taking my first steps in the FME REST API and webhooks, and struggling on passing coordinates. I published a simple workspace to FME server using the Geometry Pïcker as only parameter, the drawn polygon is noted in GeoJson, like:{"type":"Polygon","coordinates":[[[3.732869,51.016178],[3.733537,51.016688],[3.734896,51.015998],[3.734086,51.015473],[3.732869,51.016178]]]} I created a webhook from this workspace, the URL preview shows the special characters should be encoded, like:https://FMEserver/workspace.fmw?DrawnPolygon=%7B%22type%22%3A%22Polygon%22%2C%22coordinates%22%3A%5B%5B%5B3.732869%2C51.016178%5D%2C%5B3.733537%2C51.016688%5D%2C%5B3.734896%2C51.015998%5D%2C%5B3.734086%2C51.015473%5D%2C%5B3.732869%2C51.016178%5D%5D%5D%7D&opt_showresult=false&opt_servicemode=sync  but, when I GET-request through this URL, the workspace fails:55 2021-12-7 17:05:35 | A JSON syntax error was found at line 1, column 256 2021-12-7 17:05:35 | Unexpected character: 't'. One of the following ch

Good afternoon, I am extremely new to FME so apologies in advance if my question comes across as exceedingly simple or unnecessary. Anyways, I am attempting to convert a set of line features that originated in AutoCAD into a GIS formatted polygon layer. To start, I cleaned the layer as best as I could and performed snapping within QGIS. I then have tried using AreaBuilder in combination with other transformers such as LineCloser to obtain a set of polygons, but the output so far has been less than ideal. I have also experimented with Snapper and some other transformers such as LineExtender but those have introduced new errors that then lead to no output from AreaBuilder. Below I have attached an image of my workspace currently, as well as an image of the current output I am receiving. I will also attach a sample of the dataset I am working from! My conclusions are that LineCloser is causing the issue which leads to these slivers and polygons outside of the scope of the data, however I

I would like to use the AI assist feature in a programmatic way.  Is this possible?Currently it is available only as a GUI inside FME workbenchI would like to provide a prompt + workspace file, call an API, and then get a response based on the workspace context

Hi,I’m trying to put an URL in a table using the new DocumentPDFStyler and I can’t make it work.One of my issue is that the URL breaks because it doesn’t fit in the table box, also it doesn’t show up as an url. I tested many things to make it work: Image Link, add the pdf_url attribute (doesn’t work because this is the documentpdf writer),  put quotes around it.I’m trying to make this work without having to use the wkhtmltopdf 😅

Hello, Please see picture above, DateTimeNow is my value i am feeding into DateTime attribute, which matches the preview data format, but the output keeps getting rejected saying the errors above. I’m a bit stumped to as why this is not working. Any ideas?Thanks.

Hi,Situation - Oracle Writer will not work, so I need a workaround to overcome this. The tables in the workspace have many attribute fields, 2100 or thereabouts, and the Oracle writer falls over. 😕 Safe recommend upgrading to a newer Oracle, so the client will get that sorted eventually… but meanwhile I need to get the workbench working.The workbench prepares delta files to be written into the Oracle db. Once the data is ready for writing to the db I have used FeatureReader to read 13 Oracle tables into the workspace, then use a FeatureMerger with the existing workspace table to identify if the features already exist in the 13 db tables or not. If they are UsedSupplier they exist and are then designated to be an “Update”, if they are UnusedSupplier then they are new features and are sent as an “Insert”.As a further complication, we need to write to CSV files to overcome the issue with not being able to write to Oracle from FME. So we need a batch of csv files for Insert, and another f

Hello FME Community,I need to divide a line FC into 100 m segments. I can reach that with the IterativeSnippet transformer, but I have an issue with the leftovers; I don't want to divide the leftovers. In another way, I need to keep the leftover to be joined or merged with the last segment to avoid generating segments with 0. X values or other small values like 1 or 2 meters.Is there any possible way to reach this in FME? 

Hi All,I often encounter difficulties when attempting to select specific raster values using FME. I am currently working with a raster dataset that contains two bands, and I need to isolate the following values:Band 0 (GRAY8) = 3 Band 0 (GRAY8) = 4Could you please advise on the appropriate expression to use within the RasterExpressionEvaluator to achieve this selection?Thanks :)

Hi,I am trying to produce a list of all layers that are in Esri webmap. I have the private url of the webmap and I found this Python codefrom arcgis.gis import GISfrom arcgis.mapping import WebMapgis = GIS('home')# if running this from Notebook for ArcGIS in AGOL/Enterprise, replace this line with gis = GIS('home')wmItemId = "myid" #put the id of the webmap in herewmItem = gis.content.get(wmItemId)wm = WebMap(wmItem)for lyr in wm.layers:    print(lyr.title)    print(lyr.url)Could some please tell me how to use this code in FME?

Hello, I think my question has been asked before but I can't find anything on Google.Input Data : One table wothout geometry with : Id Id route measure One table with linestring geometry and :  Id Id route (the same) geometry I want to position my point data with the measure field along the line and generate a new Point Geometry

Hi, I’m struggling to tag a set of features with an ID, input data looks like the left case in this image:What I want is shown on the right. My input has a line of data with the ID, and it’s implied each record after that has that ID, until a record resets the ID for the subsequent features. Here’s a very similar example but differs from mine in that my ID is on a separate line: It seems like a Python caller might work, but I’m not very handy with Python & FME. Any suggestions welcome. Thanks in advance!

The feature reader does not allow you to make a clip on the initiator geometry. I need to read a fairly large raster (13GB). Input I get some small zone geometries to analyze. The idea was to create a BBOX on the geometry and use the feature "Spatial filter: intersects or bbox intersects" to load only the part of the raster needed for the analysis. Even configuring intersects or bbox on the feature reader, in output there is always and anyway all the raster. This problem is great because it slows me down considerably the server side script. If you add a raster reader instead you can check the "Clip on search envelope" flag and it works. But without FeatureReader i can't give my search envelope by the initiator. Could this be a missing-feature?Does anyone have a workaround? I use the FME Desktop version 2019.1

Using FME Flow with Esri ArcGIS Software – FME Support Center If you are using version 2025.1+, you must download the Esri ArcGIS Connector from the Hub and use the new readers and writers. Workspaces authored in previous versions will need to be upgraded. For steps to upgrade, please see Working with Esri ArcGIS Feature Services in FME.  Am I interpreting this statement correctly? There is effectively no backwards compatibility in 2025.1 for workspaces that connect e.g. to an ArcGIS portal?

Hello everyone,I have a question regarding a workflow/tool. I work in the railway sector and would like to automatically place overhead line masts on points and then rotate them in the direction of the tracks so that they stand perpendicular to the track axis. I have an FFS file of the 3D object, a point file, and a polyline that represents the track centerline. The placement of the 3D object works perfectly, but I'm having trouble rotating the object as desired.At the moment, I’m using the "NeighborFinder" tool to obtain the track alignment information, then the "CenterPointExtractor" tool, and finally the "3DRotator" tool to rotate the mast accordingly. I do manage to rotate the masts, but not in the correct direction so that they are perpendicular to the track axis.Does someone has an idea how I could proceed?Thanks in advance and best regards  

The AttributeValidator fails nulls when validating for various types.  Most of the time I would like it to pass nulls.The obvious work-around is using the NullAttributeMapper to map nulls to some acceptable value for the validation but:a) this is a pain because you have to do it for all attributes you want to checkb) you have to change these values back to null afterwards so as to not send spurious data to the writerAny more elegant way to do this?Perhaps a custom transformer to do the work-around and the AttributeValidator within?Or should this be an “Idea” for the AttributeValidator, i.e. Option: pass nulls?

I am trying to do a very basic read/write of an annotation feature class from one file geodatabase to another. In my case, I’m first running a PythonCaller transformer to remove any and all annotation feature classes in the target file geodatabase, then I use a FeatureReader to read the annotation feature class from the source file GDB, and then run a FeatureWriter to write the annotation FC to the target geodatabase with “Insert” and “Create if Needed” options selected for the table, which I assume is creating a new annotation feature class in the target FGDB.Regardless of minor tweaks I make to both the FeatureReader and FeatureWriter transformers, FME Flow keeps writing these as individual features instead of bulk features. There are ~450k annotation features in the feature class, so running this by writing individual features takes over an hour, which will not work for our scenario.Interestingly, the first time I ran this in an earlier workspace, FME Flow used the bulk feature sett

Hey,  I am trying to create a workspace with a HTTP Caller, that needs a Bearer token.  I use an earlier HTTP Caller to obtain the Bearer token with a login call. This is put into an attribute, which I then edit to add the phrase "bearer" infront of.  After which I want to use this attribute as a header in the next HTTP Caller to do the call I'm interested it.  This does not work, It gives me a error 401 Unauthorized, but if I copy and paste the bearer token into the header manually, it works.  Anyone any idea why this happens?   

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) before posting them to the "correct" MSSQL-Table (1). When I changed to a newer

Hi,I've been trying too use autocad_xref_path and autocad_xref_name to insert file (another dwg) into REALDWG writer feature type. It should be basic. But it's not working. No warnings, no errors.Did anyone succesfully managed to do that? Can you explain me what am I doing wrongRegards,Želimir