Creating and organizing workspaces. How to use Workbench.
Recently active
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...
Hello,I created an FME script in which I have 10 Readers and 10 Writers. I would like to run this script in a specific order. I don’t want FME to execute everything in parallel, but instead wait for Writer A to finish before reading Reader B… How is it possible to run things sequentially?Thank you for your help
Hi there,I have installed FME Flow 2026.1 in AWS has a High Availability WebUI/Core with distributed engines.The setup uses HTTPS on an internal url (corporate network)When I try to connect FME Form to Flow, I get the following error message Unable to retrieve public key from FlowUnable to establish secure communications with FlowDeployment parameter access failed (Connection Error) - Unable to connect to FME Flow. Has anybody seen this before? ThanksWhen I use the url in the browser on the same machine (tested on 2 different machines), i can log in using my admin user account
Hello;I'm stuck uninstalling FME Form 2026.1 (build 26103) and I no longer have the installation package. Is there a version for download?I have version 2026.1.1 (build 26121) but I get an error when uninstalling the old version.Thank you.
Hi,I have several rasters that are quite dark, I’d like to brighten them. I can do this automatically in another software, but this involves me setting up a script (I use mogrify).I’d like to do this in FME, but I have never been able to work it out. I have tried several things over the years. The best I’ve been able to do dynamically is make the image better, but then the colours go all strange. I want to keep them close to real like. Here is an example of a dark image.I don’t think the images have a consistent correction that should be applied, which is why I want it to treat each image individually.Any help would be great thanks
Hello, As announced in the following article https://support.safe.com/hc/en-us/articles/44279253166605-Nested-User-Parameter-Deprecation, Safe have deprecated nested user parameter starting with versions patching the recent security issue.First of all, the deprecation really took us by surprise, simply because it was written nowhere in the security advisory article the potential regression of applying the patch. We only noticed the new deprecation by checking the quaterly FME Knowledge. In my opinion, Safe should have better communication on new major deprecations like this one (as a matter of fact, our official FME Partner haven’t heard of this deprecation before us asking them).Moreover, I understand that due to the criticality of the issue, Safe had to patch it in a hurry, but FME Flow behaviour is less than ideal:Nested parameters being functionnal on FME Form but not Flow creates a major undocumented discrepancy between the two; Added to the fact that the error message is simply “
Hello,I try to do something very simple but I think I must be dumb. So I’m working with a ArcGIS Featureservices data which are agriculture data. In the RPG_2023, the attributes associated to “CODE_GROUP” will be only numbers like 11,16,18 so very simple.In the user parameter I try to add the “CHOICE” parameter because I want the script to ask me which kind of attribute I want to work with.I try to use the import wizard using the valuesBut then in this box is going endless ==>I don’t know if I do something wrong or it’s normal for the reading dataset to be so long.I don’t have a lot of different attributes (maybe 26 max different kind of “CODE_GROUP”). If someone could help me because I don’t understand what do I do wrong. Or if you have documentation about the subject I will be very happy to learn more about it.Thanks a lot and sorry for my english !!
Hello,I found more people who raised the same question, but it was 4 years ago, and I don’t know if it has been resolved and/or how.I am in the following situation: I need to read subtype domains from an ESRI enterprise geodatabase, and I would like to see the domain descriptions, not just the codes. I’ve tried using the new ‘feature service’ reader (enterprise configuration) and enabled domain resolution and exposing subtype_name, but I didn’t get the expected result.While reading the documentation, I saw that the .sde reader offers more options in the constraints, including “Resolve Subtypes.” Is it actually possible to obtain subtype descriptions this way?Am I missing something when using the feature service?Thanks :)