Authoring

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? 

We would like to migrate IOT sensors event data, which is exist in MySQL to Hono-Ditto system.Can you please help us with the process? Thank you.

Hello all! I am using a CSV file as a configuration source, which contains a list of database connections and corresponding table names. This CSV connects to a Feature Reader, where:The database connection is set using a parameter (dbConnection) read from the CSV. The feature types are dynamically set using the table names from the CSV.The Feature Reader successfully reads data from all specified tables and outputs them through a generic port. I’ve exposed both the feature attributes and the fme_feature_type.Now, I need to join the database data with client data, but since all table outputs are merged through a single port, it's difficult to manage and distinguish between them.What I’m looking for is a way to automatically separate the data by fme_feature_type (i.e., table name) and route each to a different port or stream without manually updating filters or Testers every time a new table is added to the CSV. This is essential because users will be updating the configuration file with

HiSomething strange. I just wanted to write shapefiles with a fanout based on a field in the attributes, and that no longer works.  No errors, it creates the folders in the specified location but does not fill them.  It selects one and ignores the rest. I don't understand. I've used it a million times and never had any problems.  Has anyone else noticed this? Is it the version or is it me?

Hello Forum, I have read in 45 tif files into a single FeatureReader via Select Multiple Folders/Files> Add Files. But when I click three dots next to Feature Types to Read, in order to ensure that all 45 files are listed separately, I can only see one listed. And that doesn't appear to be a input file, but instead it just states ‘TIFF’... What I am doing wrong here? I use this function quite often and it usually lists all selected input files, but on this occasion it is not. How do I get Select Feature Types To Read to list all the selected input files?  Thanks,

Hi.Is it possible to execute dynamic SQL in the InlineQuerier ?I tried something like: SELECT * FROM Merged WHERE @Value(“sql_where”)but it doesn’t seem to work.Are there not substitution done in the “SQL Query” window in InlineQuerier ?Yes, I know it has to be SQLite syntax, and it is.Cheers.

Hi all.Is it possible to expose all attributes with a specific prefix with a transformer ?E.g. x_kjhkjhgk, x_iuyiuytiuyt and x_nmbvmnbvmnbvcAll attributes are read by FeatureReaders and renamed with a BulkAttributeRenamer.Or most I delve into doing some Python magic using the schema features and fmeobjects ??Cheers.

Hi.After installing the latest beta, all my 2024 and 2025 workbenches have lost all access to our shared server and database connections.How can I restore the access without compromising everything. Will a regenerate work ?The access still works in versions 2020 and 2022.Cheers.

I am looking at implementing something like this: https://support.safe.com/hc/en-us/articles/25407459193613-HTML-Page-with-Link-to-Download-Excel-File-FME-Flow-AppBut I don’t want to create a webhook for public access for the data streaming link, I want this restricted to the same role/group that has access to the server app - is that possible?

In addition to the defaults “name” and “type”, I would like to add a third, custom member named “data_owner” at the start of a GeoJSON file I am creating using the GeoJSON Writer (see example below). Is there an easy way to do this - I can’t find anything in the writer parameters - or do I need to use the JSONTemplater or another transformer? (FME 2023.2.0.0){    "name": "gis_assets",    "type": "FeatureCollection",    "data_owner": "CompanyName",    "features": [      {        "type": "Feature",        "geometry": {          "type": "Point",       etc.

I am attempting to find the file sizes for each Feature Class within a FGDB, both within a Feature Dataset and at the root of the FGDB.  All research yields that the file size is not available via the PythonCaller and we are trying to isolate the FC filesize output via:PythonCaller > getFeatureClassSizeimport os def getFeatureClassSize(feature):    fc_path = feature.getAttribute("FC_path")    total_size = 0     # Common file extensions in a File Geodatabase    valid_extensions = {'.gdbtable', '.gdbtablx', '.atx', '.spx', '.freelist', '.gbx', '.cat', '.gdbindexes'}     if os.path.exists(fc_path):        if os.path.isfile(fc_path):            ext = os.path.splitext(fc_path)[1].lower()            if ext in valid_extensions:                total_size = os.path.getsize(fc_path)        else:            for dirpath, dirnames, filenames in os.walk(fc_path):                for f in filenames:                    ext = os.path.splitext(f)[1].lower()                    if ext in valid_extension

Hi,Getting an error while publishing the workbench.Publish failed - FME Server encountered an error and reported the following message. The resource name must not contain any of the following characters: \ / : * ? " < > | & = ' + % #Regards, Dheeraj

So I’m configuring a service (an automation) which is triggered by an webhook. The automation will process data and then send the requester an email when the job is done.I want to add a little more feedback to the process for the end user. This is in part to reduce the amount or possible duplicate submissions - As I see it I have a couple of options:Send an email when the request comes in confirming that the request is being processed. Most likely this will be enough. (The user will already get a confirmation form the webapp where they submitted the request)Send an email after a certain amount of time (e.g., 15 mins) in case their job is taking a while or they are stuck in a queue.  Try to detect duplicate submissions and send an email to the user that their duplicate request was cancelled.As I see it option 1 is the only one which doesn’t require an extra free engine to run another job. Am I missing something?Are there clever way to do either 2 or 3 without an additional engine? 

Hi,I’m having a issue making a TIN properly in FME. Basically FME is interpolating points/vertexes that don’t actually exist in the original data. What I want to do is make a TIN that considers only the vertexes of the features I give to it (point/lines and breaklines). I do not want FME to make up data that does not exist.Does anyone know a way that I can do this?For example in this example this is one break line. It should only have two TIN vertices (the ends). No triangles should be created from any interpolated points However, when I look at the TIN for the same spot it has created 6 vertices I am using FME workbench/form 2023. I’ve been trying different settings for the SurfaceModeller and the TIN generator

NullAttributeMapper, AttributeCreator or otherWhat do people use to set default values for attributes?In the case that I have is a json document - in the case values are missing I need to set a default value. Ideally I’d use an NullAttributeMapper, however, there are upwards of 10 values I need to set and I don’t want to use 10 of these. The other option I see is an AttributeCreator/Manager with conditional values which is what I would normally do.  

Hi,I recently moved to FME Form 2025.0.3 from FME Workbench 2021.1.2.The install is on a central windows machine. Some workbenches run as other users. ArcMap and ArcPro (3.4) are also installed on this machine.All our workbenches involve ESRI enterprise geodatabase readers or writers, so require an ESRI licence to run.Users of FME all have named user licences for ArcPro, they are able to launch Pro and obtain a licence on the central machine.When I use FME Form there is no issue accessing the ESRI licence and using the readers/writer. However when testing with other users, who have the same type of named user ESRI licence, FME reports the error: “Worker 6428 > Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this art

New to FME, have a client using FME and want to read and traverse through a MicroStation DGN file on a number of client machines. What’s the best way to achieve this?Does a license allow me to distribute a DLL for use on their clients?Is there a batch interface I can use?Steve @ Hexagon 

Hello,FME workbench has a strong tendency to take longer and longer to perform editing tasks (NOT translation) the bigger the workspace gets.Disclaimer: My workspace contains over 2100 transformers and I am aware that editing transformer links upstream will cause FME to recalculate downstream. However, my frustration is due to the fact that even minor modifications to very small independent workflows in the workspace seem to trigger the same recalculation as the workbench becomes unresponsive for 5-15 seconds every time I do something. This even happens when i move a transformer without altering any workspace logic. It even happens when I move an unconnected transformer! Extremely debilitating to productivity.Is this a known issue / any optimization planned?Using FME Workbench on Windows x64 2016.1. Confirmed on multiple PCs.

Referring to this (closed) post: https://community.safe.com/ideas/httpcaller-to-specify-client-certificates-31782​@LizAtSafe mentioned that the feature is released. I can find it nowhere in the documentation. Could someone point me to the right direction on how to authenticate at an API,using a certificate?

Hi I am using the schema scanner to extract the schema of data in both the original and revised datasets by comparing with a change detector.  This is working fine and i can get everything into a single table from the insert output, however i want to be able to show delete and updated as separate tables within the email.Any ideas of the best way to do this?  

I’m taking the opportunity to plug an idea I posted a while ago: I really want the ability to embed linked custom transformers via the command line / automatically. I have a bunch of projects which are just custom transformers - these custom transformers are often part of projects which I deliver to customers. It’s much easier for me to deliver a single workspace with the transformer embedded in the workplace rather than have them deal with linked custom transformers.But in my development I want to be able to reference/use the latest version of the transformer, this is especially true it the transformer is used in a tonne of different workspaces. I have an automated build process which will package up the workspace(s) along with documentation. But what I’m unable to do is to embed these transformers into the workspace - if I want to do that then I need to do it manually and it’s a pain. 

I have a workspace and I want to turn it into a CutsomTransformer - as part of that process I want to rename a bunch of attributes to include a prefix (e.g., from a JSONFlattener) - This is mostly for readability.For example I have several attributes which are coming from a JSONFlattner - in the original I never added a prefix, however, now I want to prefix with something like “layer.” - so something like “extent” would become “layer.extent”. The issues is that when I add that prefix in then all the downstream transformers which use the properties break. Obviously going through and changing them would have taken me less time than writing this question but it’s certainly not the first time I’ve had this kind of issue.In similar situations in the past I’ve been lazy and have simply renamed the new attribute to the old value. There are quite a few situations where I think having this kind of functionality would do a lot to improve workspaces readability with little effort on the authors p

Edition: Data Interoperability, Fixed OEM LicenseVersion: FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64)OS Locale Name: en_USOS Encoding: windows-1252Process Encoding: UTF-8FME API version: 4.0 20240722Home Folder: C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\Operating System: Microsoft Windows 11 64-bit (Build 26100)For clarity, I am working with FME Workbench provided by Esri in both the Data Interoperability extension for Pro - and Server.  The server situation is worse at this point, so to start, I am just going to address the problems that I am seeing on my laptop.I am calling a number of different API endpoints with an HTTPCaller, manipulating the data, and then pushing (updating) the data in an ArcGIS Online (AGOL) Feature Service.  When I was building this workflow, I was successful in writing changes to the Feature Service.  I can step through transformers, check the cached data and then click on the ‘Run To This” to run the cached data from the previous tr

I’ve been a big of a hater of the Parameter Editor window for a while - I’ve always had it disabled in favor for more canvas space, plus I just like bigger windows to work with in general.Today though, while working in the PythonCaller, I really wanted to look at my log file - I always had to keep closing the editor to scroll though the log. Then I remembered about the Parameter Editor window and it made things waaay easier. I’m not sure I’ll keep it like this but for now I’m really liking it. 

Hello everyone,I am having difficulty adding data to an existing DGN file.I have a CSV containing X, Y, Z and a Matricule.I want to add this data into a DGN that already contains points and predefined layers (levels).I just want to complete the DGN with my CSV data, putting the new elements into the correct layers.I find DGN handling in FME much harder compared to working with simple shapefile layers.I have managed to roughly merge my points, but the values do not go into the correct layers and they don’t take the original DGN styling.For example, I want the Z value from my CSV to go into the layer “CALC_PTTOPO_ALT”On paper I thought this would be simple, but I can’t find the solution.Can you help me, or tell me if there is an easier way?In the long run, I would just like to update my DGN regularly when I have new points.Thanks in advance,