Authoring

In Form (2024.1) the FME Flow connection is overwritten when creating a new database connection.This behavior is in our Citrix environment. Why is this happening and what can I do about it? Doesn't have a clue at the moment.  

Hello Forum,I am experiencing an unexpected problem with what should be a simple point in polygon search process in FME Form. I have a Creator connecting to…FeatureReader -  reading in a point dataset of 16255 recordsFeatureReader - reading in a polygon dataset, which covers a smaller area of what the points do  The two FeatureReaders feed into a PointOnAreaOverlayer. But when I run the workspace 16255 point records are found. The number should be far smaller. Thanks. 

Hi,I have points created by vertex creator but my points don’t have coordinate system. I need create by points square buffers with 25 kilometers. I’m using coordinate system setter to define WGS84, after use bufferer but the error below is showed. Bufferer can’t understand my coordinate system but without the coordinate system isn´t possible to generate the buffer. Thank´s

Since updating our FME Form host computer with the latest version of VMWare Tools, FME Desktop, FME Data Inspector, and all other FME Form GUI software does not run.We briefly get a spinner and then nothing. The problem was noted on FME version 2021 but is a problem with all version of FME Form up to the latest version FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64).It is still possible to run Workspaces in batch mode.The issue seems to be with OpenGL as indicted in the log, below.I would be interested if others have the same issue and, if so, how the issue can be resolved.Here is a snip from the log file:VMWare Tools v12.5.0.24276846Faulting Module = vm3dgl64.dllWorking Version = 3.5.3.2Faulting Version = 3.6.0.0 Event Log:Faulting application name: fmeworkbench.exe, version: 2021.7.41.21614, time stamp: 0x60f7b7a5Faulting module name: vm3dgl64.dll, version: 3.6.0.0, time stamp: 0x66a16726Exception code: 0xc0000005Fault offset: 0x0000000000e3696dFaulting process id: 0x1becFaulting

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