Best Answers

Hi all, I am trying to modify a workbench and re-upload it to the server (2020.1 to 2020.1) and am getting back an error that: The following readers or writers are included in an enabled service, but are not present in the workspace: [SourceDataset_JSON] Request to xxx returned status code 422. This has only happened since we updated the server from 2020.0 to 2020.1. The workbench takes incoming JSON from a notification service using a topic and subscription and runs it through the workbench and dumps it into an Esri Portal FS. This error is odd because there is only one reader and one writer in the service. If anyone else has seen this problem please let me know. Thanks! -Adrian

Hi,When launching a workbench using mostly SQLExecutors, with long sql statements, I can only see the first few lines for those statements on the Log file, for each SQLExecutor, but not the full SQL statement. Is this something that cannot be modified?I’d like to have all SQL lines that have been through the process. log file workbench Thanks, Juanma

This article covers setting up FME Form & Flow Emailer transformers, but doesn't cover the System Email setup in FME Flow. https://support.safe.com/hc/en-us/articles/25407404506253-How-to-Connect-to-Microsoft-Exchange-Online-using-OAuth-2-0-Microsoft-Modern-Authentication That page has much fewer settings available than the transformers: The docs don’t mention how to use Client ID (UI notes this as Microsoft OAuth only) https://docs.safe.com/fme/html/FME-Flow/WebUI/System-Email.htm What are the steps needed to set up System Email with Microsoft OAuth?Do we need to register an SMTP Account & Password rather than use Client ID / Client Secret?

Hi all, I’d like to use FME to execute some count SQL functions on SQL server (SDE). I’m having trouble with the syntax of the SQL in FME and I’m not receiving any output from the SQL Executor. SQL I’m running: SELECT COUNT(*)from "SDE".SAMPLE;

HI All, I have prepared a workspace that allows the user to clip a LAS file and export it to LAS or DWG. I was thinking to use the GenericWriter to include the options for the user….but the transformer fails when trying to export as LAS. The reason for that is because I have included a PointCloudToPointCoercer right before the writer to make sure the points are written to DWG however the fme_point geometry isn’t allowed by the LAS format as requires point cloud geometry. Here is a visual screenshot of the workspace: I have included (for now) an additional LAS writer that skips the PointCloudToPointCoercer and writes the LAS file as point cloud geometry… How can I modify the User Parameters to allow the user to chose one writer (LAS) or the other (DWG)?

I need to output a list of paired values as a JSON File. I have a list called JSONList with two attributes JSONname and JSONvalue. I am using the JSONTemplater to organise the data. I have the root template set as { "publishedParameters": [ fme:process-features("SUB") ]} and the SUB Template as { "name": fme:get-list-attribute("JSONList{}.JSONname"), "value": fme:get-list-attribute("JSONList{}.JSONvalue")} but I am just getting the name and value as a single line each. How do I change the structure so each name and value pair are separated, similar to the below? { "publishedParameters": [ { "name": "_portalLayer", "value": "parks" }, { "name": "_portalOrganisation", "value": "SWR" } ]}

I am reading in a very poorly formatted JSON file which has hundreds of lines but I just want to extract some key attributes that will then be used to create a JSON file that can be passed to FME Flow to start a work bench using the extracted attributes. I am reading the JSON file in and running it through an attribute manager to get the attributes I need. If I then run through JSON writer I just get a list like this [ { "json_featuretype" : "JSONFeature", "Catalogue Key" : "Data Catalogue", "Layer Name" : "Testville Roads", "Data From" : "Import type from CSV file", "Data Access" : "Restricted", "Update User" : "Alex", "Description" : "Roads data for Testville COuncil", "Dataset Dimension" : "3D", "Data Update Frequency" : "As needed", "Geometry Type" : "Points", "Spatial Presentation Type" : "Vector", "Data Currency" : "2025-11-09", "Initial Publication Date" : "2025-04-15", "Contact" : "Fred Flintstone", "Data Classification" : "Business Impact Levels (BIL)", "Dataset Aggregator" :

Im trying to implement some dynamic selection based on an API call response. So far I can build a package for scripted selection according to Dynamic choices using Scripted Selection - FME Packages SDK Guide and debug in VS Code attaching to Workbench (Build a Hello World package - FME Packages SDK Guide).The problem is that debugging is bound to running the translation and that is already late for the script I need to debug. The selection scripts are run when filling in the transformer parameters. I need to add breakpoints and inspect the execution of selection script (ScriptedSelectionCallback) during the API calls and browsing the object structure. Is there some setup to make this possible?The final purpose is to get this into User parameter scripted selection in FME Flow. I understand it would work this way in scripted parameter selection as it is in the transformers.

I would like to automatically number an electrical network as shown in the diagram below.If the digitization direction of the features is correct, then I get the correct numbering. I used the NetworkTopologyCalculator and TopologyBuilder transformers to perform the automatic numbering.If the direction is reversed, then the numbering is incorrect.Is there a solution to this problem?Thanks in advance.

Any way to write to different zoom levels on the same MBTile? If I change the mbtiles_zoom_level and send 2 rasters to the writer - it still writes 2 different tiles, and not within a single MBTile and different layers/overview. Is this not possible?

Hello all, I’m interested in seeing if FME can connect to ArcGIS Server Manager. I’d like to see that status of services (Started not started, instances running..), log messages to review issues, and possibly view the statistics reports (graphs of activity, views, response times etc).. Is this possible?

Hi All, I have a question regarding the integration of FME Flow with the ArcGIS suite. I am currently developing a 3D viewer platform utilising ArcGIS technologies, such as the 3D viewer, to display LiDAR data in SLPK format. The platform operates smoothly; however, my client has requested the capability to download the data as LAS files based on an 'Area of Interest' (AOI) drawn by the user. I am considering embedding an FME Flow application within an ArcGIS Experience Builder that hosts both the 3D Viewer and the FME Flow application to facilitate the download of LAS files. Is this feasible? Any information or resources to assist in achieving this would be greatly appreciated. Additionally, is it possible to customise the FME Flow map to function as an ArcGIS Webmap (either 2D or 3D) to display the extent of the LiDAR data? My tests have only shown the default map with OpenStreetMap as the background, but I aim to provide users with the extent of the LiDAR data so they are aware of w

Hi there, I am trying to generate a survey123 report using FME. I have downloaded and added the custom Survey123ReportGeter transformer however I am using a portal connection instead of an AGOL connection: After this step i have the Tester that checks for the submit_response_body beginning with {"jobId" however the flow always fails here. I get an invalid token message in my submit_response_body: {"error":{"message":"498: Invalid token.","code":498},"success":false} I am not sure if the request URL needs to be different for portal? or if the token i am providing in my query string parameters is not being read in properly… Any help would be greatly appreciated. This is what my transformer looks like:

Hi. I am using neighborFinder to align the points to the closest line segment. Points are connected to the Base, and lines are Candidates. I have also merged candidate Attributes. I am trying to join the Line segment from NeigborFinder with the original line dataset to get the closest line, but I am getting point geometry. is there a way to retrieve the line segment from the neighborFinder output? Thanks!

I am using the OGC WFS Reader to try and connect to my site in the TreePlotter App (cloud based app by PlanIT Geo). I have the API Key and other parameters. When I run the Reader, I get these errors (from log file). Does anyone have an idea on what could be causing this? (I followed the instructions from their website: https://support.treeplotter.com/knowledge-base/wfs/) 2025-04-28 16:32:25| 0.8| 0.0|ERROR |<ows:ExceptionReport version="2.0.0=" xmlns:ows=" http://www.opengis.net/ows/1.1= " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance= " xmlns:planit="planit: https://pg-cloud.com/planit= " xmlns:wfs=" http://www.opengis.net/wfs/2.0= " xmlns:gml=" http://www.opengis.net/gml/3.2= " schemaLocation=" http://www.opengis.net/ows/1.1 http://schemas.opengis.net/ows/1.1.0/owsAll.xsd= "> <Exception exceptionCode="CODE WILL GO HERE=" locator="FeatureInPolygon">="> <ExceptionText> https://pg-cloud.com </ExceptionText> </Exception> </ows:ExceptionReport> 2025-04-28 16:32:25| 0.8| 0.0|ERROR

Our Flow instance has more web connections than it should. That’s the result of allowing new connections without peer review.Now, one of our team members is leaving and I’m concerned his workspaces will use connections that won’t transfer. (We use Entra)Is there a way to find all the connections used in various workspaces (scheduled and on-demand apps). I don’t see a view for that in the individual workspaces, or I’d step through them all. Other than downloading and opening each workspace (~100), or deleting the connections to see what happens, is there a way?

Hello all, Complete FME newbie here I need to transform the data compiled by a different department as an excel spreadsheet to look like this: From Initial structure To Final structure Basically the idea is to pair each of the projects with each of the areas in order to then join the final table to a different spatial table on the ‘AREA’ attribute, ideally without manual input into transformers. The project attribute will have new entries added to it, with corresponding counts, the areas will remain the same. Thank you.

I'm trying to join two Excel files that share a common column called "ID". File (A), which I consider the main file, has 7 columns. File (B) has 16 columns, but I only need one column from it, called "NON", to be added to file (A). I tried using the FeatureJoiner, but it didn’t work. I also used the AttributeKeeper to filter the data, but the result is always null. Note: The column titles in both Excel files are written in Arabic. is this could be the reason?

I have a list containing 93 different WFS URLs, my goal is to be able to read these in one workbench without clutter and for the workflow to handle changes in the URLs for example, a new WFS is released and gets added to the list, I want it to work without having to change or add more to the workbench. Im using FeatureReader to read the format OGC WFS (Web Feature Service) but it wont accept an attribute value as the Dataset, I mean I can put one in there put it does not know what to do with it. If I put the URL directly as the Dataset it knows exactly what to do and I can use the Feature Types to Read and select all an they end up as text separated by a space between each Feature Type. This theoretically means that I could just write a list of every Feature Type I need, use the Attribute Value as Dataset and get results. However, what I really need now is a way to get every Feature Type from the WFS List so that I can ad it in place of Feature Types to Read. Dataset = Attribute ValueF

Hello , I have four tables. Each table includes an attribute called result, which contains fields value string string number. (Hello Community 30 ) ,all tables share a common attribute id I would like to combine the output from all four tables into a single attribute called result String String String String String number String number String number. String no. I would like the first string from each table to always appear above and the second string and number written on the next line and All values should be combined into the same field. Thanks on advance

I am using SystemCaller to run a pyton script (uses conda env) that creates a bunch of files and I am trying to figure out how I can get FME to then read the folder location and serve that to the user as a .zip file. The folder location is an attribute that I use to pass to SystemCaller but I cant figure out how to pass this attribute value to say a FileCopy or even a FeatureReader. The output folder is a concatonated path $(FME_WORKSPACE_DIR) + _output that I made as a new attribute value (_output_folder). In the pic below, I tried to connect the Logger to FileCopy but that doesnt seem to do anything here is the FileCopy settings i am using. Am I doing this correctly or any other suggestions?

Hello , Is it possible to control the position of Upper left x and Upper left y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly? I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .

When I installed FME Server, it is asking me for the name of the server which I specified. But when I register the license and the engines are started, they are listed as localhost_ENGINE1. Is there a way to change it the server name? What if I wanted to specify the engines to run with the server name, how do I do that at install?

Hi all, I am querying an API to download a large number of tables (50+) as CSVs that will be written into a DB. I have automated the process of downloading the tables and dynamically writing them to the DB, but the default/source attributes the tables come with when downloaded are messy/poor quality. One attempt at this I’ve tried is to set up a mapping spreadsheet for each table with an example shown below. I have been able to use a SchemaMapper and dynamic CSV writer to write a single table with the updated attribute names, but I am wanting to do this dynamically using a WorkspaceRunner to automate updating the attribute names for all the tables, while also reading and writing records to the DB. Does anyone have any advice for this? The SchemaMapper is not able to take parameters/attributes to read the mapping spreadsheets so it does not seem like an option.

Hi, I have error while running the workbench from How to Expose Feature Attributes from KML Tags or HTML Tables – FME Support Center It failes at point Method 2: XML> 2. Fragment XML Any idea why it does not work. I have not changed any of the settings in that workbench