Authoring

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.

Hello Everyone, I wonder if folks might be able to help with troubleshooting ideas for a Scripted Selection that I am trying to put together. I am trying to dynamically read a SharePoint List using a web connection. When the sharepoint is read users get to choose from the list of records. I can get his working in Form but when published to Flow I do not get a dropdown[v] or list selector [...]. Am I missing a trigger or something? Thanks a bunch for reading.  

Hello,Newbie to FME here, trying to create a simple script to move multiple pdf files all located in one folder to multiple folders which match the name of the folder. Tried using File Copy Writer but had no luck.

Hi all,I am using the Overwrite Existing Geodatabase/Template Geodatabase functionality:This creates a new copy of my gdb with a “_yyyymmdd” suffix. However, if my users run this multiple times a day, they have to delete the output of the previous run.I would prefer there to be a “_yyyymmdd_N” suffix, with N being incremented for every time the workspace has finished running that day.What is the sleekest way to implement this? I now have built something with a Path FeatureReader and a combination of Testers and StringConcatenators to filter out and manipulate the different filenames with either no suffix, a date suffix or a date+N suffix. Then FeatureJoiners to join the different path features into one:It works but its bulky and it feels overengineered.Any inputs? Kind regards,Joep

Has anyone had any issues with the speed at which the list of transformers appears when you start typing? For example, if I start typing Creator it can take 20 seconds or more for the list to appear for me to select the transformer from. All of the transformers are the same.

I have provided a consultant with the URL to one of my geocoder services. In order for them to access it, I need to issue a token. The token is issued in the Portal, which means it is valid for a maximum of two weeks. Currently, I have to issue a token every two weeks, a manual process. I would like FME to issue a token and then email it to the recipient. I know how to do the email part, but is it possible for FME to contact the Portal and issue a token?My ultimate goal would be to add this workbench to an Automation and have the token automatically issued every two weeks.

Good morning, I want to read the points the created the curve in DWG civil 3D fileso the reader will draw the  curve with the same accuracy.