FME Form

Hi,I tried to find letter after period and capitalize it using StringReplacer but it did not work. Is it possible to accomplish such a thing with the StringReplacer? For example: Condition: good. ensure continuous maintenance. The result should be like this: Condition: good. Ensure continuous maintenance. Text to Replace: (^[a]|\. [a-z])Replacement txt: .\U$1 also \U\1 won’t work. ThanksLeida

While waiting for the Italian coordinate systems to be included in the base library, I would like to share the customised coordinate system to define the following reference systems:Datum “Rete Dinaminca Nazionale 2008” RDN2008 (LL) EPSG:6706 RDN2008 / Italy zone (N-E) EPSG:6875 RDN2008 / Italy zone (E-N) EPSG:7794 RDN2008 / UTM Zone 32N EPSG:7791 RDN2008 / UTM Zone 33N EPSG:7792 RDN2008 / UTM Zone 34N EPSG:7793Here is the definition to be copied into the fileC:\Program Files\FME\Reproject\MyCoordSysDefs.fme ##################### RDN2008 #####################DATUM_DEF RDN2008                                             \   DESC_NM    "Rete Dinamica Nazionale 2008 (ETRF 2000)"  \   SOURCE     "PROJ4"                                         \   ELLIPSOID  GRS1980 \   USE 7PARAMETER    DELTA_X 0

Hi! I am currently stuck on this: There is a FME model that is functioning in the FME tool.The input field for tree symbology is a user public parameter, it’s linked to the attribute to filter in attributefilter.When I try to import the FME tools to ArcGIS Pro, I found that no matter what I input to the user parameters, they can’t be passed to the FME model, which causing the attribute filter to export <Missing> values: (I think that’s because the filter is not reading the attribute name correctly, which is the user parameter I defined)  

FME(R) 2021.1.0.0 (20210630 - Build 21607 - WIN64) I run 3 readers all with sql statements, the output writes to Oracle in 1 table. Ik never had problems (fme 2020) but with version 2021 I get an error : 2021-07-27 11:33:03| 142.5| 0.0|FATAL |An error occurred. Here is the information that FME was able to find on the error2021-07-27 11:33:03| 142.5| 0.0|FATAL |bad variant access If I run them individually there is no problem. When I run 2 of them at the same time thies error occurs. Why? How to prevent? 

Hi,I am a very basic Flow/Server user, but handy enough at Form/Desktop. My company recently upgraded from 2022 to 2023. I have noticed after the change a few of my workspaces no longer have their description appearing online and I can’t work out why this wouldn’t.For example, in the workspace description I would usually put a basic description or some instructions. I then publish it to Flow, and it used to be that the description would be in the online interface. Does anyone know what’s going on and how I can make this reappear?It used to appear here:The workspace does have a description:  

Hi all,i have following problemi join a gdb (with included domains) with an excel sheet…...if i don’t resolve the domains the feature class is written but no geometryif i resolve the domains i have geometries right but no domains anymore Can somebody help me? Thx Franco

Hello everyone,Is it possible to extrude a surface through its normal instead of the vertical?Thank you:) 

Hi!Does anyone know what this means? I have been struggeling with it for the past week, and for the first time it actually goes trough a couple of 1000 features, but it stops again at like 2000. also, it doenst really give me the reason why it failed. if it is the 928… Code, i did some research on it, but could find it.I am not sure what i am doing wrong, i dit it quite much in the past, but maybe it has changed with the newer versions. This is what i am trying to do:ArcGIS Online Reader. Add data, like weather and difficulty ArcGIS Online writer, update the existing layer.If someone could help me, that woul

Hello,I have a workbench, which when published to FME Server - is not updating the data, rather - I am getting the cached data.  Is there any way that when I publish the workbench to FME server- can I use the option of “Rerun Entire Workspace” rather than “Run Workspace”. Please find the below snapshot of the options in workbench :    Also, want to mention that - when I did ran the workbench in FME Desktop - it updates the data only when I use the option “Rerun Entire Workspace”, but when I use the option “Run Workspace” - I am seeing the cached data. Please let me know If I am missing anything.

Hello togetherI have a network with lines and points and i want to join the lines on specific points.In the picture you can see the network. Now i want to combine/aggregate the lines between the big green points. In the end i want to have 3 lines: C4 → A1, B5 → A1 and A1 → A2 I tried a couple of transfomers: Intersector, TopologyBuilder, SpatialRelator, NeighborFinder etc, but couldnt find a solution. Does someone have an idea? Thanks!

Hi all,i’m building an FME desktop workspace for eventual use with a server automation. we’re taking some emails, parsing them for some specific data, reading text files with additional information, and then putting it all together to be sent out via an API for a software called Desk Alerts.Where i am running into issues is - the text files are UTF-8 encoded and contain line feeds and tabs that the API isn’t happy with.so for instance i might have a message that looks like: now you can see i’ve got 4 tabs and almost 20 line feeds.this text is actually the combined result of several files and the content is variable so for readability’s sake maintaining the line feeds (and preferably the tabs) is paramount.When sending to the API, i get the following error response: {"status"

Hello Experts, I have two Layers PD and AA. I want to align the PD layer to AA layer. Any help would be highly appreciated. Thanks in advance

Hey FME Community!I'm working on a project where I need to write logfile "ERROR" messages to a database attribute table. Specifically, I want to capture the time of writing data whenever an error occurs, and then collect that error information into the database attribute table.I'm wondering if anyone has experience or suggestions on how best to achieve this within FME. Are there any transformers or workflows you've used successfully for similar tasks? Any insights or advice would be greatly appreciated!Looking forward to hearing from you all and learning from your expertise!

i have some cells contains Aaaa||ccc||ddd||bb||fffi would like to reverse them in case condition happens to get fff|||bb||||ddd||ccc||AaaaFME 2021Thanks in advance 

Hi All,I’m working on a workflow that requires filtering some values based on a Lookup table. I’ve initially thought using FeatureJoiner to join and filter the values but doesn’t give me the desired results as the 1:M relationship doesn’t work. I have thought about the FeatureMerger to apply the 1:M relationship but can’t get it to work.Below a few screenshots of the tables:Table A- Example of the table to join (by TexString)Table B - LookUp table (by TextString - Column B)Only the highlighted cells will be used to join  Below is the part of the workflow to filter the value in the Table A but the

Hi everyone!I’ll try to explain what we need...Nowadays, we have a download system based on Geoserver. When someone wants to download some data in KML format from the viewer, the data contain the same style you are displaying. So, you can open this KML in Google Earht and you can display it with the same symbology. Now, we want to change this download system and we want to do it using FME. But, when we download a KML, we have lost the symbology, beacuse we get data from database, not from Geoserver. Nevertheless, Geoserver contains SLD files from each layer. KMLStyler transformer can assign an static symbology, but this isn't what we want.The question is, is there any way to assign dynamicly, the SLD to KML, in order to display with the right symbology? That is, can we read he content of SLD and assign the colours to KML?

I am making my first workspace that uses a reader for a hosted feature layer from Portal. I notice that I am able to use the Esri ArcGIS Server Feature Service Reader/Writer as well as the Esri ArcGIS Portal Feature Service Reader/Writer to achieve this. My question is what is the difference? As the end result was the same for both.The Esri ArcGIS Server Feature Service Reader/Writer seemed far simpler to use as all I needed was the user and password plus the feature layer URL while for the Esri ArcGIS Portal Feature Service Reader/Writer I had to enter the host, user, password and feature service which was the folder location of the feature layer plus the feature service ID on the end in brackets in order to get it to work. I am using FME 2018.0 as well if that makes a difference. 

Hi All, I want to update geometry  column (esri SDE) from postgresql writer. What I need to do ? esri keeps the point value  like. 2D000000010000000100040001000000110000000101000090D1D3C2A00380A6E4AFBA0880A8D6B90700000000 I can reading from the postgresql as  sde.asText / asBinary    but I can not write 

This may end up as an Idea, but wanted to ask the community first: I have been trying to find some way to generate pdfs of floor plans that will contain annotation objects at specific coordinates, labeling things in the floor plan where the annotation can then be edited/appended.  Also, I want to ‘embed’ a GUID in each annotation that can be used to link back to other systems.    Use Case:Taking a pdf of floor plans onto a construction site, making comments on the provided annotations that can later be loaded into a Revit model by leveraging the GUIDs that came from Revit objects.  The pdf could be generated directly from a Revit model, or coordinate and GUID data could be extracted separately and added as a layer. You can imagine most buildings contain hundreds if not thousands of components that need to be maintained and tracked.   This is a universal problem for building owners and maintenance personnel.    As far as I can tell, there is n

Hello , I need to trace all paths that I have ,start and end point of each path is available I would like to find the points and lines between start of path and end of path in different paths ?First point is start find the next point on the same path and the second point find the third point till end of path ,ordering points and also ordering lines between them .i would like to have excel file that include First row Start point (a) - next point (b)- lines (line id 1)Second row From b point - next point C - lines (line id 2 )and so on till end point (blue point )fllow direction from start point to end point as picture  

Hello, I have a folder containing multiple shapefiles, for example,  (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after every iteration, so i can't get a configuration of the loop. I appreciate any assistance or proposition you can provide. Thank you.This is my wokspace and the custom transformer , using a loop. 

Hi,I am using:FME2021.1 32-bitArcSDE Geodb writer, truncating the SQL Server table in 10.x geodatabaseVersioned Edit Session to feature class that is registered as versionedFME log claims success and that all writes were saved. No errors, warnings or anything indicating an issue in the log at all. The problem:Only even 1000 are written. For example, 9454 features result in that FME log displays all written successfully, but only 9000 features exist in the geodatabase. If i use cloner and increase the feature count to even 10 000 all features are saved. Any suggestions? 

I am running a workbench that uses dates as parameters. If I run the command in a windows cmd window without admin privilege's, the date parameters are not passed into the workbench. When I run the cmd window with admin privilege's it work as expected.  I am fairly new to FME and I am not sure what I am missing. Any insights are appreciated.  string passed to the cmd window:"C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\fme.exe" \\myserver\myworkbench.fmw --SourceDataset" --SourceDataset" --SourceDataset" --DestDataset_CSV2" \\myserver\myfolder\mycsv" --odbc2_where_clause "(reptd >= '2024-2-1 00:00:00' AND reptd < '2024-3-1 00:00:00 00:00:00')"  --FME_LAUNCH_VIEWER_APP" YES"