FME Form

I’ve got a weird problem where an Excel reader is reading an entire file correctly, except for one column where it is only getting part of the data. When I decode the XML of the Excel file (change extension to .zip and expand), I can look at sheet1.xml and I see the following data:<c s="12" t="inlineStr" r="AK10"> <is> <r> <rPr> <b val="0"></b> <i val="0"></i> <strike val="0"></strike> <u val="none"></u> <sz val="10"></sz> <color theme="1"></color> <rFont val="Courier New"></rFont> </rPr> <t xml:space="preserve"> </t> </r> <r> <rPr>

I’m using FME 2021.WAL is possible pour SQLite since 2010, Geopackage is based on SQLite. I didn’t find any way to activate WAL on a Geopackage FeatureWriter in order to avoid lock problems.How can I use WAL on Geopackage ? Is it available in later release ? 

I have a workspace that reads an excel spreadsheet that contains 20,000+ rows with file names and paths to DWG files which works 99.9% of the time.  The simplified process is as follows:Filter the list of files from the spreadsheet to remove certain filename patterns Read the dwg model space, but only keep lines that are on layers that starts with BND Test to see that they fit in a polygon using spatialfilter clean up attributers and write the results to shp fileFor some reason when it hits a certain file, the process stops when it hits an error (even it is set to continue on rejected feature and ignore failed readers is set to Yes.  I have attached a zip with the log file as well as a FFS file it create which contains a single line that doesn't appear to be anything unusual or unexpected.  My work-around for now is to skip the offending file by using the “features to read” settings on the reader.  Given that there ar

I have a workflow where I am creating a raster using SurfaceModeler. As documented, this transformer may output some NaN values when using PLANAR interpolation. I indeed have a few cells that come out with a NaN value.  I am not certain what transformer can change my NaN values to NoData values (or any other values)?  I read through this article: http://blog.safe.com/2013/11/fmeevangelist119/ and thought the NullAttributeMapper would be the answer, but it does not seem so.  

Hello, I am using FME Form 2025 and looking to write  shapefiles/ geodbs dynamically to an ArcSDE Geodb.My issue is that  where my source data has the data type VARCHAR2 it is written into Oracle as NVARCHAR2.According to our database manager our preference is VARCHAR2 due to: “VARCHAR stores each character using a single byte, NVARCHAR columns typically consume twice as much storage space as equivalent VARCHAR columns.”I have tried multiple options of resetting the data types and writing out either using automatic attribute definition or dynamic (using the readers schema), but in any case the final table stores NVARCHAR2.Is it possible to change the data type from within FME?Many Thanks!

Upgraded from FME Desktop 2022.2 to FME Desktop 2025.1 (Build 25609)In FME 2022.2, I had a FeatureReader reading to a FeatureService URL with no issues. Perfectly was able to read it and extract its spatial content and attributes. Upgraded to FME Desktop 2025.1 and it no longer works. Could this be like an internal firewall blocking access to this or is it the way FME 2025 handles SSL certificates? If so, how can I remedy this?Any insight is much appreciated.SAMPLE WorkbenchI have the latest package installed Error message: ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services.arcgis.com', port=443): Max retr

I want to change paths for readers in multiple FME workbench files and Ive been trying all day without success to do so without doing it manually. Does anyone know how to do this :) ?For example from \\192.168.221.35\ftp\hofn\Höfn-skolplagnir.shp to \\192.168.221.50\ftp\hofn\Höfn-skolplagnir.shpwith the only change being the ip path from ending at 35 to ending with 50 but for multible at once :)I already tried changing in Notepad as suggested here with all the paths but it doesnt work for some reason. Also consulted chatgpt for Powershell scripts of different variety...Thank you for reading :)

Hello everyone!So I’ve had a workflow run fine for the past 2+ years. It involves using HTTPCaller to send a GET request to our OpenText ContentServer repository and download a csv document as an attribute for further processing.It appears that at some point in late June, the service credentials we’d been using all along are no longer working in FME or something because we’ve been consistently getting a 401 error in the rejected features port of the HTTPCaller. We’re seeing this behaviour in both FME 2022.2 and 2024.2.The thing is, the same credentials will work fine when the URL request is done manually through the browser.The setup has originally been NTLM, with the service username and password passed from User Defined Parameters. When I check ContentServer’s authorization settings through the browser’s Developer Tools it still shows up as NTLM too, so that hasn’t changed.I’m hoping for any ideas or leads that I can look into. Is it possible tha

Hi all, how do I easiest update change the field type in a GDB?Esri Introduced the BigInteger, which is giving me a lot of issues. It dosn’t work in all applications, and I can’t even do a relate or join on it. I need to get it into a integer. For some reason the data we get delivered now on a weekly basis has all the number fields in BigInteger.I need it to find the BigInteger Fields, and change the type, without loosing data. The data also fits an normal integer.Any thoughts would be much appreciated. Thanks  

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

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%

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 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

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