A space to discuss FME Form
Recently active
I've found not documentation around any name formatting limitations for Attributes for the Hyper file Writer. When I work in Tableau Prep, I have no issues writing a file with a field name like "Budget$" to a hyper file. I've found in FME that when writing to an Excel file, it also takes such a name, but when using the Hyper writer, it drops the "$" and replaces it with underscore "_". Why is it doing this? Is this a mistake in creating the code for the Writer or is it a Necessity and if it is a necessity, shouldn't this be documented?
Hello there,The coordinate system Irish National Grid TM65 (EPSG 29902 previously 29900) is not depreciated. It is also not the same CRS as TM75, there are mathematical differences which can effect the coordinate locations. They are both Irish National Grid. The southern Irish Ordnance Survey has moved to using Irish Traverse Mercator (EPSG 2157) but the Northern Ireland state mapping agency is still serving basemapping in TM65. There has been previous posts on this issue but the suggested fix has not worked. I followed the instructions in this post but I could not select EPSG 29902/29903.The only way we can get the translations to work in a workbench is by not setting the CRS on the Reader or the Writer. If we set try to set the CRS in the Reader or try to apply a projection using the ESRIReprojector it won't work.
Is this a bug? I am trying to list and download several files (some have dependencies-- references-- and some don't) and noticed that I cant download files that have an associated reference file.Any thoughts or suggestions?Thanks
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,There may be a bug (or least a less user-friendly transformer) in Form 2026.1.2Choosing specifically the Esri ArcGIS Feature Service as the Format, the Dataset parameter is by default disabled: I’m unable to determine what the “related parameter” is that is *disabled.I can setup my feature types by importing the schema of my intended target data, but saving all the changes in the transformer puts it in an error state.If you visit the navigator window you can see where the “Dataset” parameter is in error.The only way I’ve found so far to get around this issue is to go into the Manage User Parameters setting and create a new user parameter for Dataset which needs to be the feature id of the online feature, inclusive of the parentheses around the id number. This is definitely adding more configuration steps to the Feature Writer than before as the Dataset used to be configurable directly inside the transformer and you didn’t have to remember to copy the feature id from Esri.Any
Hello, I have a question regarding the DGN Reader/Writer about reading and writing external reference files.I am using the DGN Reader that contains a reference to another DGN file. In that referenced file there is a rectangle (an igds_shape element). In the DGN Reader parameters I enable the options "Read Elements From Reference Files" and "Keep Elements That Represent Reference Files".My goal is to move that rectangle to a different location and save it into a DGN file in such a way that:the rectangle appears at the new (correct) position - this part is not a problem; I already have a workbench for moving the geometry but it still keeps the link to the original referenced DGN file, and the referenced DGN file itself remains unchanged.In other words, I want to move the geometry in the main DGN while keeping the external reference link attached to it, so that any future changes in the referenced file (e.g., adding an image inside that rectangle) automatically appear in the main DGN at t
I encountered an error when writing data to a geodatabase because the file path contains a dot (period), even though this naming convention is completely valid. Everything worked fine in previous versions, but it fails in FME 2026.1. For example, I want to write to a Geodatabase named 'Geo.A1.2552.gdb'.Is this a known bug?
I would like to copy an existing file geodatabase and rename it to a different location. I have been reading up on the FILECOPY but can’t make sense of what I’ve seen. Any help is greatly appreciated.
Hello, I am currently working on adding data (a source file in Geopackage format containing point and polygon tables) to our Oracle enterprise database. I am using a dynamic workspace to process the data and an external table (CSV file) to define the required schema in the FeatureWriter. When writing the data to the database, three additional attributes (not defined in my schema) were recorded. They are called “rotation”, “textstring” and “height”. After some research, I realised that these are likely linked to the following FME attributes: fme_rotation, fme_text_string and fme_text_size and that this is related to the “fme_point” geometry. I have tried several ways to remove these attributes but have not succeeded (exposing the attributes and removing them before the writer, telling the writer not to write them in ‘attribute to remove’, writing the tables containing polygons and those containing points separately in different writers.Do you have any ideas to guide me in this task, or
https://support.safe.com/hc/en-us/articles/25407427123597-Reading-and-Writing-SharePoint-Lists-with-FMEGuidance states: “1. Add the SharePoint List ReaderAdd the SharePoint List Reader to your Canvas, in the Dataset parameter enter the domain of your SharePoint site (for example, https://safesoftware.sharepoint.com). Click Parameters. Select your desired Authentication Method. In this tutorial we are using the Microsoft SharePoint Online (Template) Web Service configured to Safe Software’s SharePoint. You can choose either Basic, Web Connection, NTLM, and Kerberos. “However, I get error message when selecting The Microsoft SharePoint Online (Template) option; doesn’t this need to be configured in a certain way..?
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
Hi everyone,I just started using FME and am already getting stuck. In my workspace, I import an excel sheet that contains a list of column names in one of it's cells. The list is in the following format: [“Column1”,“Column2,”Column3”].I also import a larger dataframe from a .csv file that contains a lot of columns, more than there are in the list of column names.Now I’d like to have a transformer completely remove all the columns in the larger dataframe that aren’t also in the list of names. I’ve already worked with AttributeKeepers and AttributeMappers, yet these can’t seem to receive a dynamic input.If anyone has an idea on how to solve this problem (Preferably using solely transformers and without PythonCallers) I'd love to know!
Hey there,I tried to pass on the wfs url as well as the feature types to read both as an attribute value in order to get fetched via a FeatureReader-transformer. Although the output contains the geometry, it contains a lot of unexposed features. So far so good.My question is if there is a simple way to generically expose these attributes and assign it to the geometry again? I do not want to manually expose them in the aftermath.Many thanks!
Hello everyone,I want to create hosted feature view layers on arcgis enterprise with REST API, httpcaller in FME. Although a new hosted view item is successfully created, the resulting view layer always remains empty (no layers inside it), and all attempts to attach the source layer fail.Below is a clear explanation of what i am doing, what works, and where the process fails. 1. EnvironmentArcGIS Enterprise 11.5 Hosted feature layer (source) Attempting to create hosted feature layer views programmatically The account performing the request is now: Owner of the hosted feature layer Administrator 2. What worksI successfully create a hosted feature layer view item using:content/users/<owner>/createServicewith parameters including:isView=truesourceItemId=<item_id_of_hosted_feature_layer>The REST response confirms:"success": true,"isView": trueA new view item appears in the Enterprise Content page.However:The created view contains zero layers, every time.Even though the source
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 everyone,While reviewing one of our workspaces, I noticed that one of my developers used the SystemCaller to launch a Python script as an external process instead of using the PythonCaller transformer. The workspace runs fine today, but I'm worried about unforeseen consequences down the road, and I'd like to hear from people who have run both approaches in production.I'm wondering about maintainability (the scripts live outside of FME), Error handling and logging and versioning.If you've dealt with this situation, I'd really appreciate hearing how it played out.
I have 400 rasters i would like to convert to a single combined pointcloud for more efficient processing. Each raster has a specific piece of information about the hydrology of the subsoil (horizontal resistance, top of geologic layer, bottom of geologic layer, top of aquifer, bottom of aquifer, etc). To preserve the meaning of the individual values i would like to keep the name and type of the source raster as component values. This is where my problem/challenge lies. I can rename the original rater bands to a meaningful name, but because each raster only has a single band, the band value is by default used as the z-value. If I set the attributes to keep as component to an attribute containing the layer name, these are not kept on the pointcloud. I think this is because they contain string values and components in a pointcloud usually only contain numeric values , but then why can i configure it as being a string datatype? The rasters are 2800 x 3250 Pixels with each pixel 100 x 100 m
Hello everyone,I have an FME script that processes various data. Upon output, everything goes to a feature service. So far, so good; I have no problems during processing.My issue is very simple to solve, I think, but I can't find the solution.I'm working with agricultural data. For example, when using my script, I might request to use data labeled "18/19/11". Everything works fine, and everything displays perfectly.The problem arises when I only want to work with data labeled "18". The script works perfectly again, and the data is correct up to the last transformer before the writer. However, the data in the writer isn't replaced by the new dataset, and I still get the "18/19/11" data when I only want "11"!What type should I choose in "Feature operation" (insert/update/upsert/etc.) and in "feature type handling"?Do I need to integrate a transformerbefore the writer that will update the datar, or is this problem solved solely within the writer? I'm a bit lost and frustrated...Thank you
I notice that when writing GIS to CAD, in this case a KMZ to DGN using FME, that the output often tends to have mismatched units and the scaling is often much smaller in the output. I know that a seed file is ideal but I often find that this doesn’t always solve the problem in FME. Is there any way to make sure that the units are not mismatched when going from GIS to CAD?
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?
Hi :)I’m trying to add the vector map from basemap.de as my background map for exports in FME 2026.2. However, I cannot make it work. I used the following link and MVT as my feature reader.I get an error regarding a missing API key. Has anyone ever used basemap.de as their background map and can tell me if there’s a simpler way to add it (and also be able to crop the data to my AOI before reading all of it, which covers the entire country), or if I need to somehow request an API code to use this map?Here’s the link (which I am also not sure if it’s the correct one):https://sgx.geodatenzentrum.de/gdz_basemapde_vektor/tiles/v2/bm_web_de_3857/bm_web_de_3857.jsonThanks!
Using FME Form 2025.1.3.2 (20251029 - Build 25646 - WIN64), when using MDB_ADO database connections, either in a Reader, Writer, or a FeatureReader, FME crashes at the end of it’s process. The log screen saysTranslation was SUCCESSFULFME Session Duration: 2.7 seconds. (CPU: 1.3s user, 0.4s system)END - ProcessID: 9984, peak process memory usage: 89716 kB, current process memory usage: 88552 kBso the translation is actually finished it seems, but the underlying fme.exe process crashes and never returns. So the UI never changes the red square Stop Translation button into the green triangle Run Traslation, and the Data Explorer is not started. In the Task Manager a Crashpad.exe can be seen, along with an FME Objects Worker.This only happens if there is an MDB_ADO connection in use. Other workspaces using all sorts of Readers/Writers run fine without any issues. It seems to have started about a week ago, before that this worked fine.Does anybody have any idea if there have been any Windows
In earlier versions of FME desktop/form i was able to filter log messages from options → translation → log settings. I know i can disable them in traslation log but we used those settings to control if server/flow logged warning messages. We have process that creates massive amounts of unnecessary warning messages that generates gigabytes of logs. Log message filter option doesn’t seem to be available anymore? Is it moved some other place?FME 2024FME 2022
Hello, I’m updating a number of workspaces from FME 2021 to FME 2026, and some of them have a dynamic writer outputting to a file geodatabase. As part of the update, we had to change the format of the writers away from File Geodb Open API due to it becoming deprecated. We’re trying to use the OpenFile Geodb format, but we’re running into a problem regarding the geometry of the resulting features. Before, our dynamic writers would output features with 2D geometry such as Polygon. However, with the new format, it’s only outputting features with 3D geometry such as Polygon ZM. This doesn’t occur with our static writers, those output 2D geometry just fine, and it doesn’t occur if we use a different format such as File Geodb. It’s only with a dynamic writer with the OpenFile Geodb format that this issue occurs. I’ve tried adding a 2DForcer and MeasureRemover transformer to the workspace just before the writer, but the features are still being written as Polygon ZM. I can’t manually set the