Transformers

Dear FME community,I have a featureklass of lines. I want to find the start and end point of the lines. I used the Snipper transformers, setup as the screen shot below. '0' is the first vertex, '-1' is the ending vertex but the start and  end points which I created , don not lie along the line. I also used coordintateExtractor,, it gave me the same result. I couldn’t figure out what went wrong.I would appreciate any help to solve this problem.

Greetings,I’m writing FME workspace that should be able to scan a list of IP Addresses for modems. The result will have reachable:yes/No attribute to determine the IP address is reachable or not.First thing to think of is using python caller to invoke the ping tool of OS. I did it that way and it’s working. However, the client policy demands workflows that are only built-in. No custom coding, and I want to make sure that there is no built-in transformer that may do the task?Is there a built-in transformer that can check if a networked IP Address is reachable or not. Is there one that can be tweaked to do so ?Thank you-Moataz.

I have a complex workflow using multiple Workspaces. Each reads and/or writes temporal operational data to CSV’s.My question is, when do you use a Reader/Writer as opposed to a FeatureReader/FeatureWriter?I’ve settled on using FeatureReaders/FeatureWriters though I’m not sure if make much difference.I understand the Feature* transformers are geared towards mid-workflow use where you have input and output.Thanks in advance.

Hi, I use parallel (//) processing in other workspaces successfully but this is the first time with a Clipper. The tips offered in article: FME Parallel Processing: Tips and tricks for generating groups | Safe Software do not seem to apply, or at least I think they don’t. I am trying to clip an OBJ of  ~12720000 triangles with ~93K polygons of diiferent sizes. The OBJ has no attributes, just geometry. 1st try: link the same modcount (4 groups) to both Candidate and Clipper inputs of custom xformer containing only a Clipper.  The data passess through it without any clipping. The Clipper inside is set as “multiple clippers”; Clippers do not arrive first; Reject only parts, merge-clipper, and the rest is set with defaults.2nd try: cloning the OBJ as explained in article but it slow and eventually crashs as it runs out of memory.

I have designed a dynamic workspace to have a bulk transformation on all shape files within a nested folder structure. I have added the original folder location in the reader with checking tick mark for subfolder. Then I have used batch deployment and checked the 'recreate folder structure'. However, the destination files were not written in the similar folder structure as in the original structure.  See how the subfolders within original Asset folder (image 1) were written outside the destination asset folder (second image). Can anyone tell me what was the likely source of this?

When reviewing an old workspace in FME Form 2023.2, I noticed that if I opened a Feature Reader or Feature Writer that previously had an SDE connection file path referenced in the connection parameters that the parameter was now blank. If no changes are made, the workspace runs to completion as normal. No errors are thrown and no transformers are marked as “incomplete” in the navigator pane. This tells me that those pathways are stored somewhere. This does not appear to be an issue with other data types like csv, xls, or file geodatabases. These file types used in a feature reader all have their connection file parameter populated when opened in 2023.2. This does not appear to be an issue if a Reader or Writer is used rather than Feature Reader or Feature Writer transformers. A Reader or Writer configured to work in a previous version of FME using an SDE connection file path is populated when opened in 2023.2.

HelloI have a simple question, but I’ve found now answer.Is it possible to write a FBX file with transparency, transparent objects?Regards, Hartmut

Hello ,i have used network topology calculator then aggregator (group by network id ) .i have found that there are some unwanted connecting lines that has same network id .I want to check the reason ?i am wondering if there is a method to find the connecting points that occur to provide each line the same network id as before ?so I  can check them quickly .i am looking for a quick method to find unwanted lines that has the same network id .thanks for helpFme 2021

Hi, I have a geopackage with 5 million polygons, some of which are duplicated, but with geometry that isn't exactly the same. In the image below the dark red’s polygones means there duplicates.I trying with transfomer matcher  with this set It works but not all polygones duplicates are deleted. I got something like this I know that at some point some polygons won't be able to be deleted because the geometry is too different.Maybe in can set the tolerance in 4 or more, but i thinkAny idea if it can be done?

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

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)  

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

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)W

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.