Authoring

I am in the process of moving my FME Desktop 2021 workspaces into FME Form 2025. I know I can open the FME 2021 workspaces in FME Form 2025. As I get farther along in this process, is there anything I need to be aware of? example, is it best to just rebuild my FME 2021 workspaces in FME Form 2025 instead of just opening and saving the FME 2021 workspaces in FME Form 2025?I have run a few FME 2021 workspaces in FME Form 2025 with no issues. But wanted to reach out to the FME community to see what their experience has been in bringing in older FME workspaces into new versions of FME.

My workbench tries to read features from ArcGIS Online feature services, write them to a different database and, if successful, delete them from their ArcGIS Online feature service. I’ trying to use as few feature writers as possible, so I use attributes to descern feature services and their layers. Most feature services contain only one layer, but the name of the layer can be different from the name of the feature service.I can get the name of the layer from the format attribute “fme_feature_type” and use that for the “Layer Name” in the Feature Writer parameters: But in the “Writer” group (button: “Parameters...”) I also want to use an attribute for the parameter “Selected Feature Service”. 

Is there a way of Auto switching Parameter between Form vs Flow?ie Local while working on FME From (C:\FME_SHAREDRESOURCE_DATA) vs FME Flow($FME_SHARERESOURCE_DATA)Workspace Locally with FME Form is add “C:\FME_SHAREDRESOURCE_DATA” to the FME Flow Parameters to test and work on the solution. When I upload the Workspace to FME Flow I always need to remember to remove the local value for everything to work.  I forgotten a couple of time and wondering if Deployment Parameters is the solution?  

Does anyone know if FME can be used to notify via email when one or more SSL certs are due to expire. I have a boatload of SSL certs whose expiration dates I keep track of using a spreadsheet. Just wondering if FME could make it easier? The OS I use is Windows Server 2022. 

I dug out one of my old FME 2014 workbenches. It has this PythonCaller defining a local CRS. It had worked beautifully for years.import pyfme#define custom CRSmyCSMan = pyfme.FMECoordSysManager()fmeParams = {}fmeParams['CS_NAME'] = "local_polyconic_cs"fmeParams['DESC_NM'] = "Dynamic CS"fmeParams['DT_NAME'] = "WGS84"fmeParams['PROJ'] = "PLYCN"fmeParams['UNIT'] = "FOOT"fmeParams['X_OFF'] = 0.0fmeParams['Y_OFF'] = 0.0fmeParams['MAP_SCL'] = 1.0fmeParams['SCL_RED'] = 0.9996fmeParams['SOURCE'] = "HESS"fmeParams['QUAD'] = 1fmeParams['ZERO_X'] = 0.0001fmeParams['ZERO_Y'] = 0.0001surf_lat = float(feature.getAttribute('surf_lat'))surf_long = float(feature.getAttribute('surf_long'))        fmeParams['PARM1'] = str(surf_long)fmeParams['ORG_LAT'] = str(surf_lat)myfmeCS = myCSMan.defineCoordSys(fmeParams, "myfmeCS") Now I am at FME 2024 where

Hi,has anyone had any success creating User Parameters for the SharePointOnlineConnector Site, Document Library and Path values?I’m using FME 2025.2.2 (latest version) and SharePointOnlineConnector version safe.microsoft-sharepoint  [1.13.1] (latest version)I would like to embed a SharePointOnlineConnector in a custom transformer but I don’t want to hard-code the Site, Document Library and Path values. However, when I create User Parameters to expose these as custom transformer parameters I am not able to actually select values for them. I have also tried creating User Parameters for these values as input parameters for a SharePointOnlineConnector in the main workspace but run into the same issue.This is how my SharePointOnlineConnector is configured (I have used all default values when creating the User Parameters):

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?

I have a SQL Server Database that has 156 tables. I need to extract the schema for each table and table names into a CSV. I know one way is to add all 156 tables to the workbench as separate Readers and then use FeatureReader (with Features to Read set to Schema Features). This could be a start, but it seems rather tedious.  Is there a better way? I want to write to a CSV that has the attributes in one column and the table names in another column.  Any thoughts on the best way to tackle this?

We’re currently in the process of looking to move to a newer version of FME Form (2025.2) but we’ve hit an issue where we can’t meet the required dependencies for adding a Smallworld reader regardless of having the correct files in the right locations. If we open an older workspace with the reader already added, it will still complain about missing dependencies but the workspace will execute correctly.If you select ‘Update Reader’ from the navigator you can add additional feature types etc and change parameters, but you can’t add a new reader due to the missing dependencies. I noted that there was a Fix in Build 25811, but when I tested in 2025.1 (before the fix), there are no issues adding a Smallworld reader. I understand that the Smallworld user group probably isn’t the largest but is anyone

Within the new ArcGIS Feature Service reader (part of the Esri ArcGIS Connector Package) if you choose a source type of Enterprise it’s not possible to connect to a feature service that is shared across an entire organisation and not in a group.This can be done if you use a Source Type of Standalone Server (but it’s not obvious).It would be nice to have and Item Source of Organisation which would allow connection without specifying a Group 

Hello, I have an Excel Spreadsheet that I need outputted in a specific format. I am only working with 175 records, so I could complete the customizations using Excel in a couple hours. But, I wanted to run this by the FME Community first. Here is a screenshot of the spreadsheet output format I need:Column names must be bold. Col A cells need to colored yellow. Col A cell values need to bold and red. Whenever there is an X in Col A then the entire row needs to be bold red The APN column needs to counted with the total shown in the row of the above screenshot.At this point I am not looking for specific instructions on how to set up a spreadsheet like this. If you can provide any that would be helpful. I know I would use the Excel Styler Transformer. Maybe the Aggregator

I am trying to read geometry of the leader lines from the Pro Annotation feature class.In the attributes which I see when loading it in the Data Inspector, I only see geodb_text_leader_line_anchor_point which contains correct coordinate but no geodb_text_leader_line. Does anyone knows if reading of the leader line from Pro Annotation is supported?I am using FME 2025.1.0.1.I tried changing reader parameters “Split Multi-Part Annotations” but it makes no difference in the way annotations are red.

I am taking a polygon that is the floor of a building, I am then clipping out the exterior wall and the room polygons on it to get the square footage of the space between the walls. However, it is filling in polygons at random when writing to our SDE. When I write these polygons to a .gdb, that behavior doesn’t happen. I have tried to not simplify the geometry, used the donut extractor to only take the outershells, orientor to only choose right facing polygons, etc. Anything else I should try?Preview of the polygon in FME:Polygon in GDB:Polygon in SDE:

This...may be complicated to explain. We are trying to create Feature Service webhooks in ArcGIS Enterprise. ESRI documentation indicates that this can either be accomplished with the admin Portal (which very few users have access to) or via the “administrative API”https://developers.arcgis.com/rest/enterprise-administration/server/create-webhook/The only way to access the administrative API is to acquire a session token (SSO, username/password, other authentication types are not accepted).In ArcGIS Enterprise, the generateToken endpoint is no longer used, the OAUTH2 “Token” endpoint has superseded it. There is a preliminary authorization step that must be completed before accessing the “Token” endpoint.

I have a workbench which takes a dem raster and clips it at various points, it converts the raster clips to the point cloud and extracts the highest value for each segment.  i then want to be able to use the highest point with the radiate line generator to show additional lines before being clipped and calculated.  I have tried a 2dforcer, aggregator and others to get the Radiate Line Generator to work, but it fails every time.. any idea how to get points from the workflow, and what have i missed..??If i try the Radiate Line Generator with a ‘normal’ point dataset then everything works fine and as expected..  

The Clipper can subset a raster by geospatial extents, while the RasterSubsetter can both subset and pad a raster by number of pixels, but is there a simple way to pad a raster to a given polygon/geospatial extent?My two ideas are to eitherUse the RasterSubsetter to pad the raster by a large amount of pixels and then the Clipper to bring it back to size.OrRasterize the polygon to the same resolution as the image with a background/NoData value and mosaic the two together.Neither seem particularly efficient. 

Hi, a client is using nb_NO (Norsk Bokmål) Locale on a Windows Server machine and the produced FFS filename is incorrect. They are using FME Form 2024.2.3.0.I have tested same om my machine Windows 11, FME Form 2025.1.1.0 - build 25615. I want to produce a filename “t2_æøå”.FFS (where æ, ø and å are Norwegian alphabet letters)using en_US Locale the produced file is t2_æøå.FFS using nb_NO Locale the produced filename is t2_æøå. FFSI repeated the test wiriting to Esri Shapefiles - and both Locale will give the result t2_æøå.shp. Seems like the FFS writer have an issue with Locale. Might be a known issue  but I was not able to find it. Thanks 

Hi there!I get tons of these messages from some workspaces created with FME 2020 (in Norway) and now  migrated to FME 2024: The Startup Python Script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleErrorI have read the post http://fme.ly/PythonLocaleError carefully, but it does not give me anything. I have nothing such as import arcpy or locale.setlocale() in my Python-code. The example message above is particulary strange, I don’

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

Before I file a bug report, I thought I would post here.  I used to be able to right-click in the Data Preview and get the ‘Zoom to Selected Feature’ for the CAD geometry.  The last few versions of FME have not had that available.  What gives?Please see the attached.Currently using the latest build:  FME(R) 2025.2.2.0 (20260106 - Build 25827 - WIN64)

Hi everyone I have been having some issues with the new ArcGIS feature service writer. When using this writer in combination with a change detector, it doesn't seem to update or insert any of my changed records and i have been getting weird behaviour all over the place. Let me preface this by saying that everything works as expected on the old portal feature service writer, it's when switching to the new feature service writer that weird things start to happen.  Under the advanced parameters I have enabled the following fields to adress the first problem I encountered (namely that the writer no longer seems to care that global id is a read only field and skips it for writing):  Af

I have a csv spreadsheet of arcgis server feaureservice urls with the featureclass, name attribute , and projection attribute. This list is long and has multiple servers and I want to pass this list into my workspace and have the FeatureReader transformer read the url and featureservice with a spatial filter for my area of interest (AOI) and then clip out the data I need inside the AOI and only keep the attribute name field in the result, run some additional analysis, then write out the clipped results to a GDB, then move to the next record url in the spreadsheet.. My plan is to reproject the AOI to each projection listed in the csv and then pass the AOI as the creator to the FeatureReader transformer to only read based on the spatial filter. This works great if I do separate feature readers for each URL but that makes for a gigantic workspace and isn’t very dynamic as the spreadsheet and AOI changes frequently. Is there a way to pass a csv list to the FeatureReader in this way and

I am encountering an error in FME Workbench when closing the GENERIC Reader. During execution, the translation fails with a transcoding error related to a binary string, and the program terminates unexpectedly. The error message indicates that FME is unable to transcode a binary string containing non-UTF characters (apparently related to a shapefile) into another encoding. As a result, the translation process stops with a “Translation FAILED” message. This issue occurs consistently and prevents successful completion of the workspace. Any guidance on how to handle encoding or binary data in this scenario would be appreciated. Menssage Log:NullAttributeMapperFactory (NullAttributeMapperFactory): Transcoding the binary string '1e\xA8\x83\x16\x00\xE8\xBB\xE9\x96\x1DfH\xC0 -\xB12\x1A9:\xC0\x00\x00\x00\x00\x00\x001\x01\x00\x00\x00\x09\x00\x00\x00shapefile' to another encoding can not be doneOGCGEOPACKAGE writer: Committing transaction of 1451 features to feature

We have a workbench that runs daily via windows task scheduler which reads data from an Oracle database and ArcGIS Online and then writes to SQL Server. The process has run for some time but the other day there were some issues with the output dataset. On viewing the log file, it appeared that only 2000 of aprximately 50,000 records were read from AGOL. However, there were no error messages to say that it han’t read the whole file. Is there an easy way to build something into the workbench to sent a notification email to check that the whole file has been read in to prevent this issue happening again? Thanks

Hello, thereI would like to prepend one dataset with other datasets and return other datasets as output. Please refer to the screenshot below, this should be done with only one workbench. Highly appreciate your thoughts.