Authoring

FME tells me that there was 1 feature written to the database, but it is not true. In my opinion that’s a bug because the statement is objectively wrong.In this case the translation failed because of an error. No features were written to the database. No table was created. I guess FME counts the schema feature, although it is NOT written to the database.Here’s a part of the log and the workspace is attached.POSTGRES Writer: Fanout for feature type 'SQLCreator' failed to find feature type template 'schema_from_query'POSTGRES writer: An error has occurred. Check the logfile above for detailsSuccessfully closed POSTGRES database writer=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `POSTGRES' writer using keyword `POSTGRES_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-SQLC

Is it possible to change the keyboard shortcuts in FME Form?There are some important shortcut that rely on function-keys. With the rise of compact keyboards I am not the only one who has done away with that row.

POSTGRES Writer: Fanout for feature type 'SQLCreator' failed to find feature type template 'schema_from_query'POSTGRES writer: An error has occurred. Check the logfile above for detailsI tried to create a workspace using a dynamic writer (see attachment) but I get the error above. The writer uses following parameters:Table Name: `@Value(fme_feature_type)` The `fme_feature_type` attribute contains the value `SQLCreator` on my features because I use an SQLCreator to read the features.   Schema Sources: `Schema From Schema Feature` I’m using the schema feature from the SQLCreator.   Schema Definition Name: `schema_from_query` I think the schema definition name refers to the attribute called `fme_feature_type_name` on the schema feature. This attribute contains the value `schema_from_query` when using the schema feature from the SQLCreator. I have also tried to leave the Schema Definition Name field empty in the settings of the dynamic writer’s feature type. In this case it defaults to `De

Is there any option how to set multiple condition for visibility of user parameter? I need some parameters to be available for two choices of another parameter. I could define another connection parameter but i have to use it in same readers and writers of workspace.- is there a chance for some workaround?I can’t merge these two choices, because there another flow for each one of these two.I know thers new feature in FME 2025, but we recently upgraded to last major 2024 version. Probably we’ll be waiting for another release of 2025.

I’m working on an analysis to determine the correct calculation for elevation gain and loss along a line representing a real-world route (such as a trekking, marathon, or MTB course). I’m using FME and have two source vector datasets: a GPX file that already contains Z values for each vertex and a PostGIS line to which I need to assign elevations from a DTM (Draper). Is there a standard workflow for this type of calculation?

Hello, I have a SharePoint List that I am already using. Can FME be used to update this list? What Transformer(s) would I use? At this stage, I am looking for general information to help me get started, so anything you can provide would be excellent. 

Hi, I have one table that have attributes called months of the year, that begin in OUT_24, NOV_24...until SET_25.My workspace will run month by month by workspace runner. In my workspace sometimes the value is filled in OUT_24, in the next execution NOV_24...until the end. How my table can be updated if OUT_24 have a values only for example? I would like to ignore attributes with missing values. I try this code in SQLExecutor:  UPDATE ARCGIS.BTA_SAT_NDVI_pl SET MAR_25 = @Value(MAR_03) WHERE COD = @Value(COD) AND NEW_ID = @Value(NEW_ID); But don’t work for me...because I need to change SQL after SET to attribute with value. Thank´s

我在PyCharm中导入fmeobjects模块时，提示：ImportError： DLL load failed while importing fmeobjects： 找不到指定的模块。PyCharm项目设置中我已将python解释器的路径添加了，但是我发现出现以上问题的根源在于FME 2024.2.1安装目录下的“fmeobjects”文件夹下没有对应python版本的fmeobjects.pyd文件，这是什么原因造成的？又该如何解决呢？

Hi,I am working with FME Desktop, and at a certain point, my features have a "Month" field with values such as 10, which refers to October, 11 meaning November, and so on for all months of the year. The table that will receive this value has columns ranging from OCTOBER to SEPTEMBER. How can I make FME understand that if the column has a "Month" value of 10, the "Average" field should be renamed to OCTOBER, ensuring that the values from the recently renamed OCTOBER field are recorded in the table, which also has a column named OCTOBER? Thank´s

I’m am using WorkspaceReader to document my workspaces. Is there a way determine what annotations are linked to what transformers?

Hi There,I was wondering if anybody knows of a way to completely or partially suppress the logging in a workspace? (even if it is a hacky method)I am aware of the settings in the options menu but unfortunatly they just don’t do the job necessary.Cheers,Itay

Hello, I am exporting addresses from an Enterprise GDB into an Excel spreadsheet. I have created the Excel Writer, and it successfully writes the data to the spreadsheet. But when I open the spreadsheet, the column widths are crazy wide, and the names are not bold or centered. Is there a way to control the column widths and column names (make them bold and centered)? The screenshot below shows the Excel Writer (“Template”) and the parameters I have set.  

I have a spreadsheet with Address, Street Name, City, and Zip Code fields with 500 addresses. I need to create mailing labels for each address in this format: Occupant1234 Main StCity A, 54433 The output would be a Word/Text doc with the list of labels. What Transformer(s) would be used to create these?

Hello, parameter newbie here apologies... but could anyone provide a link or information on how to configure parameters dynamically from a csv so that users can identify the Address column they want to use for the geocoder in the app-- as users will typically bring their own csv schema to the app for geocoding.  Thanks for any help here!!

I’ve been dabbling in the latest release of FME Form 2024 for a little while now and I’m just not getting the benefits of the new look, specifically the removal of colour from most icons.I could go into personal reasons why colour helps myself with attention to detail, concentration and focus but I’m just wondering if it’s possible to get a classic look while utilising any new functionality.

Hi, I’m getting thrown this error by my feature writer when trying to write to a dwg. I have not changed my workspace and used it a hundred times with no issue, except this one case. I am getting this error:AutoCAD Writer: An error occurred for dataset '.\QHPRW_Tiles11,12_QA.dwg', in function AutoCAD2004Writer::writeBlockHeader. Exception thrown: 'Invalid Symbol Table name' (Invalid Symbol Table name) I have no symbols/cells/block to write. I am using a template file to set the right colours and display. I am able to write the file if I remove the comma from the name. However, I have another file the works fine that has a comma in it. So that can’t be the real issue. Does anyone have any ideas? I am using FME 2023.2.1 Thanks 

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension.In 2021.2 both .tab and .TAB files are readA MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab filesIs this expected behaviour?

Hi,IT is storing our passwords in azure key vault and they are rotating on a structural basis.We don’t have FME Flow.There is an FME app registration in azure, so i have tenant id, client id and client secret that can be used for like blob storage and sharepoint.Is there a way to connect in FME to azure key vault?Also IT is talking about using managed identity, are there any examples on how this can be implemted to fetch passwords from key vault?

I want to identify if there is a way to identify all connected conductors of an electric device using FME. All the points (Electric Device) and lines (Electric Line) in the attached screenshot are actually all connected. This is actually connected in Smallworld and I want to establish the same connection in FME but in ESRI this is not graphical connected as depicted in the screenshot. I can trace connectivity form Electric Line to the device but not the other way around. I want to correctly merge Electric Line data with Electric Device records. More than one electric lines can be attached to one device and so far I have tried List Based Feature Merger, Feature Merger and Spatial Relator with Intersect Predicate. Buffer will also not work in this scenario as it may take into consideration some other nearby line. There are no associated or connected features in Electric Device which may link it to Electric line, hence List based feature merger is also failing.ESRI :SMALLWORLD:  

I disconnected my external monitor to work on my laptop (not external monitor) from a different location. When I open up my FME Form workspaces, the transformer parameters font and icon sizes are really, really, tiny.  I saw the way to fix it was in FME Form go to Tool - FME Options - Appearance - Advanced Option and check “Enable automatic scaling for High DPI Monitors”. I have enabled this, closed FME Form, and re-opened it. I have unchecked it and did same. Nothing seems to make a difference. Is there another way? I am using FME Form 2021.2.0.1.   

Hello:This is probably a simple use case to many of you, but I only have basic experience with FME Form and Flow.One of our programs has the ability to generate standard excel spreadsheets which contain reservation data (Date, Name of Room, Description of Room activity, Organizer contact info) GOAL: We would like FME to take that excel spreadsheet and post that data as a table on an html webpage.However, before that html webpage is generated, we would like the user to visit an FME Flow App (? I think) that will allow them to select from a dropdown list of rooms culled from a column in the excel spreadsheet. Once selected and submitted, the app would only show the list of active reservations Things to note:This excel spreadsheet data is updated once a day and will only show the current day’s data and will need to be uploaded to FME Flow each day. It’s being stored on a network location.I’ve managed to create a FME Desktop app that uses Excel Reader > HTMLReportGenerator > HTML Wri

Hello all! I am stuck and unable to create a formula in FME. It involves an Excel formula that I can't seem to replicate in FME. I know there's likely a simple way to achieve this. I need to subtract values. Here is a screenshot for reference: I would greatly appreciate any help!  

Using an Esri FGDB Reader (an Esri FGDB FeatureReader) in a Workbench, I would like to apply a where clause using the last_updated field.  I believe that because this is a date/time field that it is causing me troubles as I am able to run tests on other fields.   What is the correct syntax to enter a where clause on a date/time field from a FGDB?  

Hello, I use a custom transformation in the ArcGIS platform.  It is a two step projection which uses the Ontario NAD83 grid file to project to NAD83 CSRS and then the second step is projecting from NAD83 CSRS to WGS84 geographic (LL).  The two tranformations are:ON_NAD83_NAD83CSRS_CustomTranf, (custom transformation set up in ESRI)NAD_1983_CSRS_To_WGS_1984_2 (chosen ESRI transformation).This two step process was recommended by ESRI Canada to import data into their ArcGIS Online format.  I have seen various articles for parts of this process in the FME Community but I guess I am looking for a stepwise list (e.g. obtain grid shift file from authority, create custom transformation in ESRI, etc.) to get the pieces of the puzzle in the right location to use in an FME workflow.Thanks

Hi everyone,I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours.When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error:413 Client Error: Request Entity Too LargeOccasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists.I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations.Any insights or recommendations would be greatly appreciated!Thanks in advance.