Creating and organizing workspaces. How to use Workbench.
Recently active
Hi everyone,After upgrading our FME Flow instance from 2025.2 to 2026.2, a workspace parameter with dynamic values stopped working in a Workspace App.When opening the app, FME Flow shows the following error when testing the dynamic parameters:Loading from WorkspaceKartenautomatisierungen/Kartenautomatisierung_ZUBA_PreScript_2.fmwError loading schemaUnable to generate dynamic parameters from source file.Error was:E:\appdata\fme\systemshare\resources\system\null\null\FeatureWriter\ZUBA.jsonPlease ensure the file exists and is readable. A few observations:The same setup worked without issues in FME Flow 2025.2. The workspace itself executes successfully. It loads the JSON after the workspace is done. The error only occurs while loading the dynamic workspace parameter. The path contains system\null\null\FeatureWriter\ZUBA.json, and the corresponding folders do not exist. I never configured FME to write schema files to that location.Has anyone seen a similar issue after upgrading to 2026.2
Quick question.Are there alternatives to using AttributeManager to manually sort attributes by name?Sort of an AttributeSorterByName or AttributeSortedReexposer transformers ?Cheers.
Hi all.I just created a new custom transformer, and need to apply it multiple times (10-20 times).It basically just has a name and three parameters, all of which can be deduced from a database query.So I thought it to be a good idea to create and paste the definitions from a query result (using some sql magic). Instead of copy/pasting the many transformers as I would normally, editing each by hand.So I experimented at bit first.I can copy a transformer from FME Form, and paste it right back. I can also paste the definition into a text editor, as the copied content is just text (FME file syntax).But when I just copy the complete transformer (without changes) back from the text editor (Ctrl-A,Ctrl-C), FME Form will not paste it into the workspace.I used Ditto clipboard to look for differencies, and I can barely find any. The two attached images shows the properties for the original and the text editor copy.original from FME Formtext editor copyThe only difference I can find are the sligh
If I have an MS SQL Writer that I have disabled for whatever reason, all the features in the workspace turn grey. Perfect, is a very good indication that it is disabled. However: if I import another table, that writer is added to the Main canvas and to the Navigator in full color!Which caused me quite a bit of head scratching this morning: why was nothing written to the database? It seems to me that this is a bug in FME Form (FME(R) 2026.1.2.0 (20260512 - Build 26124 - WIN64), but maybe I am overlooking/overthinking something…To reproduce: Add an MS SQL Server Writer, use Import from Dataset to select a table. Right-click on the Writer in the Navigator, and select Disable [writer_name]. Table on the canvas turns grey, as it should. From the menu select Build - Writers - Import Feature Types. Select another table, click OK. Now I see one grey table and one in full color…
Hi all.I’m experimenting with calling WFS services with custom filtering expressions, including spatial filtering.According to the filtering documentation, spatial filtering is possible with GML, but it doesn’t seem to work in FME ?The geometry column is present but has no value in the output from FeatureReader, and FeatureReader has its own spatial filtering parameter separate from the “normal” filtering parameter (using <Filter/>)Am I correct in assuming, that FME effectively prohibits any spatial filtering via the “normal” filtering parameter, and requires you to always use the special FeatureReader spatial filtering parameter ?And maybe this is neccesitated because FeatureReader removes the WFS geometry column values ?Thanks for any insights.
Hi.This may be a simple or a complex question, I’m not sure which.I’m attempting to use a dynamic expression, that I construct dynamically from values read from a file or table, and evaluate it on all relevant feature read from a database or file. Including AND/OR etc.How can this be achieved in Workbench ?I’ve tried to utilize ExpressionEvaluator with the expression @Value(@Value(expr)), but it doesn’t return any value in the “_result” variable.What am I doing wrong, and is it even feasable ?Are there better ways to achieve this ?Using 2025.2.4Cheers
I am looking at this Article for setting up Azure OAuth Connection for Data Bricks, the article is for Reader, but I assume the same set up will work for the Writer. We have an Azure app already set up for the FME SharePoint Reader and Connector, can the same Azure app work for both SharePoint and Data Bricks ? are there any best practices about using the same Azure app for both or making separate Azure Apps for each ? Any suggestions or cautions, things to watch out for, etc, appreciated https://support.safe.com/hc/en-us/articles/27147444106381-Setting-up-a-Databricks-Reader-Azure-OAuth-Connection
I just found that in the geodatase_sde writer, you can create domains for the field you’re creating. This is very exciting news! And the domain is indeed created in the SDE database. However, when I view the featureclass in arcpro, the domain for that field is not there. I still have to associate that domain to that field. Has anyone tried this? Is there a parameter i’m not seeing? I’ve checked all the parameters around the field, the feature type, the writer and didn’t see anything that could be it. The documentation didnt have any info except on how to create the domain. bug or feature?
I was using Service account Key File as a credential source for google cloud storage connector but it looks like its been removed as an option. anyone else seeing this?
I was able to do a cumulative count of duplicate values (where duplicate is “-1” only) using a Group By on a Counter transformer shown below. (Added note: I should have added this to remove ambiguity - SORRY. The output as shown below in the Preview is the desired output. I only care to know the number of consecutive sequential values when the value is “-1”. If the pattern changes and another series of duplicate “-1” appears, the count starts with “1” again. I don’t care if the pattern for duplicate values are greater than “0”, like “2420” on the Preview.) Since I have more than a dozen of these attributes, I’d like to use an AttributeCreator instead but I can’t seem to use the CurrentAttribute() to accumulate duplicate values.In addition, everytime a sequence of “-1”s begin (as shown in row 143 above), count starts at 1 again.Any suggestions?
I am clipping a raster by a polygon, but it sometimes seems to skip parts, I have the clipper set to Candidates on clipper boundary set to Output as Inside. I know this poly crosses 4 cells, so this is what I was thinking would come out of the clipper Inside port But instead I get this Any thoughts why it is skipping that one cell? This is a single band raster and all these cells have data
Hello, In FME Form, I am trying to generate a line from 3 parameters: lon/lat (WGS 84) length geographic orientation (from geographic north, in degrees)I have tried several ways to build this line (2DDirectionExtender, VertexCreator + Offsetter (tested polar coordinates or spherical coordinates), VertexCreator + Rotator)Always the same result, when I measure the angle from geographic north, there is a difference for instance, with my input:lon/lat : -4.49027778, 48.02000000 length : 0.002 orientation : 100.478°In both methods, FME gives me this result:When I calculate the bearing from start point to generated end point, it gives me the same result 105.411° (same with online bearing calculators using coords)Any idea on what could be wrong? Thank you
Hi There, I am trying to consume and Arcgis date field in Form but FME can seem to understand the datatype. Specifically, the Date Converter transformation just errors out (please see attached). I have tried every option from the drop down menu and have even tried using a String Convertor transformer and the Attribute Creator to (successfully) convert the field to a Datetime field in FME but the Date Converter can not read and I need to use this datatype for downstream use (I want to compare how new records have been added to the dataset by comparing this date field to the current time). Any help would be super appreciated. Thanks! Louie
HelloWe have a workspace that connects to Sharepoint using a WebConnection.It works in FME Form and on one of our two FME Flow instances, which is installed on a second server.However, it does not work on the other FME Flow instance, which is installed on a third server.The error message is as follows:Access token not found for connection ‘aaa@Sharepoint_bbb’Unable to obtain updated authorization for web connection ‘aaa@Sharepoint_bbb’; credentials may be invalidObviously, there’s something wrong with the access credentials, but why does it only fail on one of the FME Flow instances?The web connection was set up by someone who no longer works for us. Where can I get the access token for the connection?Thanks in advanceVera
I’d like to maintain my database documentation in an Excel spreadsheet like this:Attribute Name FME Data Type LandID int32 Acres real32 Name varchar(128) And then I’d like to import that into an AttributeCreator. When I try importing, the attribute names come through, but FME Form sets all the data types to varchar(200) instead of what I specified in the field ‘FME Data Type’ and imported in the import dialog.How can I fix this or set up my spreadsheet differently?
Hello all,I’m quite impressed by the descriptions AI assist can give for a workspace. Trivial things like input- and output-schema and even some description on the transformations on attribute-level.Now, I would like to ask these kinds of questions to a bunch of workspaces, and use the results in an automated way.Giving me access to the model behind AI assist could end up quite costly for Safe, so is there another way to get these answers?Kind regards,Martin
Hello,I seem to be outputting multiple folders when I run my app through data stream or data download.Tried connecting all connections to one feature writer but it seems to be limiting me to one excel file if I do that so I did multiple feature writers for each excel file that I want.Tested running my app through data download and data stream and it outputs multiple folders - one folder per feature writer.Was wondering if I am able to simply download all excel files right away without putting them into a folder or just output them all into one folder.Screenshot below.Feature writers under Microsoft excel format. Basically 2 sheet type. 1 is based on a value and other is count sheetNot much configuring except the name of the excel, sheet names, and drop/truncate both yesHere’s an example of what it outputs - 4 Folders(I suppose 1 folder for a specific feature writer)
Hi there, has anyone upgraded the previously community provided workspaces that bring additional dashboards to Flow?From REST v3ToREST v4Workspaces can be found from the article from V3 Monitoring FME Flow Job Activity using the REST API – FME Support Center which is a different article to Submitting a Job through the FME Flow REST API V3 – FME Support Center and ultimately the latest article Submitting a Job through the FME Flow REST API V4 – FME Support Center could do with have version 4 fo the statistics workspaces edited last in 2021
I am currently working with the new DocumentPDFStyler to create a individual feature reports. Instead of the table reading across the page, I am creating a vertical transposed table with the attribute exploder.Table input However this seems to have limits with the styling as both fields are in the ‘column value’ so any styling done, including conditional options, are performed on the entire table instead of just the second value column. Output PDFIs there a different way to do this or is it possible to have an other documentPDFStyler element for vertical tables?
I have mixed data that includes lines, polygons, curves and curved_polygons.I want all these features to go into my PostGIS databases, two tables :“my_lines” defined as geometry(multicurve) “my_surfaces” defined as geometry(multisurface)Here some remind about Postgis geometries : multicurve geometry type allows you to store polylines and curves in the same column multisurface geometry allows you to store polygons and curve polygons in the same columnHere is an blog post I wrote on the sibject : https://blog.arthurbazin.com/sig/bien-demarrer-avec-les-sig#types_de_geometriesFor reading, no problem at all for FME. For writing, I can specify the geometry type :If I have polygons, they are casted as multisurfaces and all is good.But when it comes to dynamic, how can I achieve to set this parameter dynamically ? I’ve try to use “from first feature” but curvedpolygons objects (even if I cast them to multi) are not mapped to multicurve ou multisurface and I can have polygons as first features
Hello Community,in FME 2024 I was able to find out whether I was running a workspace on FME Flow or locally by checking FME_SERVER_WEB_URL or FME_SERVER_HOST values. Both values would be empty unless the workspace was actually running on FME Flow. Fast forward to after upgrading FME to 2026, in FME Form, FME_SERVER_* parameter values are URL/host of the FME Flow FME Form is connected to. Knowing whether a workspace is ran locally is important e.g. if it calls a child workspace (using WorkspaceRunner vs. FMEFlowJobSubmitter). It is also very helpful during authoring/troubleshooting. How can I do this in 2026? Thank you in advance for any tips/ideas
I have this data that I want to be treated as immutable (read as strings) in the format CSV (but i suspect that this issue is true for other formats as well?) but FME keeps auto format it to a different format. I think this started with FME 2024 or possibly 2023. Since then I’ve somewhat changed methodology for new work spaces, but yesterday a revisited an old WS and got reminded of this source of frustration. I hope that someone can cure this case of “excel-autoformat-hell” with a solution or an explanation? I really don’t want my data changed automatically in any shape or form.Example.CSV-file states that attribute “Datum” has the value ‘2026-05-20’ FME (CSV) reader keeps format it to ‘20260520’. Even if i manually change the attribute to data type string or varchar FME still formats the date according to above.
Hello Forum, I have point dataset with 5600 points at an address level. Each point has a ‘score’ value of between 1 and 100. I need to create a hexagon grid. And then assign to each hexagon the score value of the point, or the average score values of the points, that fall into each hexagon. If only one point record falls into a hexagon, say with a score of 42, then that hexagon will inherit a score of 42. But if several points fall into a hexagon, say with scores of 13, 56 and 22, then assign the average value of 30.3 to the hexagon they fall into. I also need to define the size of the hexagons/hexagon grid. I’ve been looking into the H3HexagonIndexer (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/h3hexagonalindexer.htm) but can’t get the results I’m looking for / work it out. Any ideas would be welcome. Thanks,
I have configured all parameters on manage web services for Dropbox. But I am having to reauthenticate every time I run the workspace. What should I be checking? I also need to schedule it on Server. I am not being able to authorize it on Server as well. Any feedback is highly appreciated.
Ever since the merging of SQLServer spatial and SQL Server non-spatial Reader types, my SQLCreators and SQLExecutors generate a warning:Microsoft SQL Server Reader: Table `___FME_Custom_SQL_Statement___' does not include a spatial column. Geometry will not be read In Form this is easily ignored, but it really messes up my Jobs overview dashboard on Flow, because it results in quite a lot of listings with warnings that do not need checking. And I can’t seem to find a way to tell FME that yes, I know, there is no geometry coming through in this sql, don’t worry about it because I did not select it - on purpose (or because it does not exist).I really do not want to turn off all warnings generically, I am just searching for a way to stop this particular warning. Before the merge it was easy: just use the non-spatial type, and the warning would go away. But that is not an option anymore unfortunately...