Transformers

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)  the FME model is input as spatial ETL tools in ArcGIS pro.Here comes the problem: I keep the same input REMARKS, however the input parameter is not passed to attributefilter correctly in ArcGIS Pro. (In FME tools it’s working fine) To solve this I have tried:set the FME user parameter type as ‘attribute name’ or ‘text’ → both of them are shown as string parameter when import to ArcGIS Pro as spatial ETL tool put the spatial ETL tool into ArcGIS P

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!

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 join doesn’t do 1:M. There’s 193 records highlighted in yellow in the LookUp but the FeatureJoiner only joins 189 from the 1,363 records from Table A….and I’m expecting more values after the join as for example N = North Lines and S = South Lines values appears multiple times in the Table A and need to keep all of them. That’s why I think the 1:M is the one to apply here? Any trick to make the

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 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")}}

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 

I have a datetime in the format YYYYmmddHHMMSS.SSS and want to convert it to any other format e.g. YYYYmmdd or DD-MM-YY or whatever. My super simple workspace is below. My FME version is Windows 2022.1.3.0 The DateTimeConverter version is 4 The result I get with every combination is INVALID_INPUT The Preview suggests everything is OK and what I expect: Any suggestions?

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_ROLE_ID)SELECT @Value(CA_ID), '@Value(BA_ID)', @Value(CONTRACT_ID), @Value(CA_ROLE)WHERE NOT EXISTS (SELECT 1 FROM CONTRACT_ASSOCIATE WHERE CONTRAC

I have IFC file with 3D Room and Excel Records with XYZ and i am trying to clip the XYZ coordinates that totally fall or touch the boundaries of 3D Room.  I would like to confirm is that,  i am following the right steps in Workbench ? I would like to ADD 10 cm buffer to 3D rooms, so that i don’t miss any XYZ records, so not sure what is equivalent value as there is UNIT in buffer :( Also i would like the EDGES to be SHARP after applying buffer not sure how to do  PS: Attached is FME Workbench for further reference, as its does work if anyone would like to refer as well. But open for any enhancement as well.      

Completely new to fme and trying to find my way.I have a GIS feature class titled wMeter.  I want to take fields from this feature class and load the data into an existing excel database (provided by others). I added the feature class as a reader and the existing excel database as a writer and field matched which fields from the wMeter feature class I want to go into which fields in the database. I used an AttributeKeeper transformer to remove the unneeded fields from the feature class and it seemed to work at first however each time I ran the form it would append the data in the database. I changed the Writer Mode to Update so now it appears that I am getting the data 2X in my results.

 Dear FME community.I got xml data with geographic location,  I tried to use coordinateExtractor but I could not get x and y coordinates and I could not also visualize the polygon using FME inspector. How do  Extract the X and y attribute? Any idea would be apricated and thank you in advance.  

Hi There,i have workspace and trim transformer - Post/processe/Radarsat2/20240313 for example, it should leave 20240313 name of the file, but it remove 2 at the begining, 0240313 remains as file name. How to keep that “2” at the beginning? 

I am attempting to get the value of a date field from a subset of data tables in an Enterprise geodatabase.  I have narrowed down the list of tables with the required attribute from the SDE_column_registry and I only want to query those data tables for the value of that date field.I have attached two screenshots showing the inner join and rejected output and part of the translation.log.  Perhaps I am formulating my query incorrectly. I am only concerned with getting the value of the date field from 133 data tables that have the attribute.Please help.SheilaCounty of Kern, CA

Hello,I have two polygon datasets: folios and townlands(see image below). For the most part, the folios(grey outline) are nested neatly within the townlands dataset(red outline) so the outer folio boundaries are shared with the townlands’ boundaries. I would like to extract the areas where these two datasets’ polygon boundaries cross...i.e. where they are not nested neatly. Most of these will be slivers.  SpatialRelator(and Tester) helps to extract the offending folios using the Spatial Predicates Test: "Requestor OGC-Overlaps Supplier" however the output is the entire folio polygons(not overlapping area) as SpatialRelator does not edit the input dataset. I am unsure as to what to do next, I would like to automate this process in FME Server if possible so having one workflow would be useful. 

I’m doing a project where I have to generate and compare multiple DTM TIN-models. In regards to this, I wonder: Is there a difference between TINGenerator and Surfacemodeller in regards to how the triangulation algorithms work?How does the triangulation algorithm(s) work, in more depth than that it is delaunay triangulation?​​​​​​​Are there any other transformers/methods to produce TINs in FME?

I would like to identify snapping errors of newly captured layers which is snapped to old layers only.I do not want to find any old layer's errors as it is not my scope of work.Please suggest the best transformer. RegardsArun

Hello all,When trying to write my data as a geopackage I get the following warnings (see attached).In the reader I have to specify what geometry type I want to use but I can only select one, which results in some features being excluded.I have read a thing about the dynamic writer but that one is giving me errors.Using the GeometryFilter the only type I get is ‘area’ so it doesn't seem to make a distinction between those.Is there a way to write these different geometry types in one Geopackage layer? I am using version 2020.0 

Hi,Have a workbench that I have been using for a while in previous version (2023).This is to convert data with attachments from ArcGIS online to a FGDB.I use a ListExploder for this, I don't get an error message but also no objects.When I use the workbench again in the old version, everything works fine again.The problem occurs when a space is used in the naming of the layer and/or feature class. Does anyone know about this problem? Any solution would be helpful. Gerard

Hello everyone,I am converting several SDE geod to respective CAD files. All CADs need to be written in the same folder (with suffix of the currentdate). I  created this folder in Python Caller. How can I now route CADs to this folder?

I'm converting an obj file to local coordinates, glb.Running one obj file in FME will take you to the desired local coordinates.But when I run thousands of obj files in FME, they don't move to local coordinates (0,0,0).I want to move thousands of obj files all to (0,0,0) at once.For reference, I activated move to local coordinate.