FME Form

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" 

HelloHow could FME detect unwanted spike and unwanted zigzag and fix it without changing geometry of lines ?I have used spike remover and zigzag remover but sometimes it catches data that has no relevant with spikes ,what is best angle for transformers?How to keep the original geometry without changing it ,after fix the problem with zigzag or spike remover ?what is the best method to detect dangle lines and fix it ?thanks in advance fme 2021

Hello all,I want to understand the difference between two MapInfo WritersI am running FME Desktop version FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)The Writers are;MapInfo TAB (MITAB)Precisely MapInfo TAB (MAPINFO) Is one Writer better than the other?

Hello, I am creating a JSON file using several fme attributes. I want to include an if condition. If the typ =’HC’, I want to have an additional attribute (the name) added to the JSON. is it possible? The way the if condition is written here is not correct but it gives you an idea what I would like to do.{"Device": {"Type": fme:get-attribute("TYP"),"latitude": xs:decimal(fme:get-attribute("LAT")),"longitude": xs:decimal(fme:get-attribute("LON")),if fme:get-attribute("TYP") eq "HC"    then "Name": fme:get-attribute("NM")}}

You are trying to parse the IFC file into Obj and metadata through your company's FME Desktop.​I don't know why, but there is a problem that materials are not added to some objs. Please help in this regard.​The attached file is the workbench file used at this time.​​Regards,Bongsup Kim​​

Is there a setting to disable the translation log window from automatically popping up when running a workspace? I’ve disabled all logging and hidden the window, but it pops up as soon as I run. I’m trying to record the execution of the workspace for a presentation, and the window keeps getting in the way.

Hello, I am attempting to copy data from an ESRI FileGDB to a Feature Class in a SQL DB but no data appears to be copying.I have attached an example of a record from the log.  I have pasted “etc etc.” into it to shorten it as it is very long otherwise.I also get this error-Microsoft SQL Server Spatial Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'Hopefully this helps you troubleshoot my issueThankyou in advance

Hello, I have many points in txt file in PtNum,Y,X,Z,Description etc.And i have Alignements Geometry in a (Civil3D DWG OR LandXML) I want to put Stationning / Offset value on each point.Thx alot!!Running FME 2023.1.1 

Hi,  I have some questions about how to make a CityGML more efficient. Context: I have about 1.8m pipelines and cables. I want to visualise these as 3D cylinder/pipes (not actual ‘FMEPipeGeometry’), regardless of the ‘is it necesary to do this’. All features also have attributes like diameter and such. I want to write this to CityDB and CityGML. This results in huge filesize (somwhere like 15gb or 20gb). What I did: My thought process was it would be more efficient to use relative geoetries (a circle) that I extrude/scale/offset/etc to the proper location using the transformation matrix. Of course I cut the original geometry into pairs of 2 vertices. I wanted to reaggregate this to 1 feature once I had the relative geometry up and working. This all worked just fine until I discovered that in CityGML schema the cardinality is 0-1 on features with relative geometry. This means I cannot gather all separate bits

Good day,Is there anyone here tried converting Civil3d Pipes and Structure into ESRI Geodatabase Multipatch in ArcGIS Pro?My issue is the original attribute from Civil3d doesn’t copy in the converted Multipatch - when I convert using ‘CAD To Geodatabase’Can FME translate Civil3d Pipe/Structure Property to change the incorrect Multipatch attributes?Please see image below: