Transformers

In my example below I have two different attributs: the asset and group, group A being highest priority then B and then C. I would like to keep only 1-A, 2-B , 3-C and 4-A. How do you filter the other ones out?Asset - Group1 - A1 - B1 - C2 - B2 - C3 - C4 - A4 - C

I am trying to extract the orientation / angle / direction of a 2 node line. I cant believe there isn't a transformer that simply extracts the orientation of a line but I cant find one. Anyone found one? I want to be able to compare the orientation between two lines which are close to each other to determine if they are in the same (or similar) orentiation. Thanks

  i have tried to use intersector and topolgoy builder to identify nodes that intersectedbut i am not sure how could i recognize only the node of starting branch because some node has 3 overlaps and one at the end has only two overlaps .it means only two lines intersected with eachother ,So it will be hard to recognize by overlaps because At some branches to red point ,the lines intersected to eachother ,so it will have also 2 overlaps. each line has his own id but from the vertex in front of Grey Arrow has 2 or 3 Lines till reach End point .the main line has many connected linesi have tried with neighbor finder but my main problem how could i recognize the the vertex in front of Grey Arrows .Is there way to use neighbor finder and add Tester to stop at Vertex in front of Gray ArrowFME 2018 Thanks for help in Advance    

Hi all!I am trying to style the headers of my excel list, based on their name.With the Excel Styler I figured out how to style several values, using conditional values.However, what I want is to style headers, not values. How can I define header of column to style? Is it possible?Thanks in advance!

I have a list which has two elements {make, model}. I can receive multiple make, model in in this list. So, I can get values like:{make = Toyota, model =camry},{make = Toyota, model =Prius} and so on.I need to use these values create a sql in the format - select * from cars where (make=toyota and model = camry) or (make = toyota and model - Prius); How do I achieve this in FME? I dont know the no. of values that I will get in the list. Please advise, I am very new to FME

This is how I it get, with different tabs. And below is how I want it.

I have a table that has x and y coordinates. I am trying to write to an sde point feature class and it is failing. The error message is that 'line' features can't be put into a point feature class. Each record has one x and one y value. The log says there are 2 coordinates (which is why it's trying to make a line), but I have no idea why its seeing 2 x values for any record.  I exported as lines and got the correct number of lines of 0 length. They actually are in the right place in GIS. Light on details, but if anyone has hit this snag and recovered, I'd love to hear about it. There is NOTHING weird about this table. Sensitive data so I can't provide details. Actually, it is only some records - an identifiable set - the other records will create points. I see nothing different about the records that fme wants to turn into lines. Thank you,Randy McGregor

"4;30;4;20;SW,SE",,, Here is my attribute string, I want everything between the quotes to be split at the ; and the rest to be split at the commas. (There are no values held there in this example.) Please help. m

Hello,I often use SQL creator and SQL executor to extract data of my dB.My select-queries always include the oracle geometry (stored in a SHAPE column).However, I noticed only in some cases the geometry is extracted in my workflow.I have, to this day, not been able to understand in which cases this works and in which it doesn't (I then add a feature merger to re-append the geometry to the features).Can someone explain this to me?Thank you

I am getting an invalid layer message when trying to open a raster in QGIS. This raster I have imported into Postgis using FME. I was using column=rast . I have set the coordinate system as the reader, but when importing the SRID is not being written.  Invalid Layer: Raster layer Provider is not valid (provider: postgresraster, URI: PG: dbname='xxxxx' host=xxxxx port=5432 user='myuser' password='mypassword' sslmode=disable mode=2 schema='myschema' column='rast' table='GEOTIFF' Any tips, how to fix this?

Hello everyone, I need your help with AnchoredSnapper, basically I have two vector layers:  - linear layer which is in the form of a road network. - point layer (Camera positions).  I would like to attach these camera points to the road network, what I have problems with is the areas where we have road intersections, I don't know how to configure it so that it snaps the points to the right segments, if you go to the image link, i tried to show you that the last point is attached to the correct segment, but in reality it is going to be snapped on the other segment which is closer to it. So if you have any answers, I'm interested, and thank you link image: https://zupimages.net/viewer.php?id=21/25/2nrm.png

Hı,I want to extract certain color codes from the photograph. I tried but I couldn't. I want to get the white areas in the sample image . how can I do it. Thank you

Hi, I am new to FME and have just started doing the intro to desktop training material. I am doing Exercise 1.1 where it asks me to run the process but I keep getting this message KML: Cannot open dataset `C:\\FMEData2019\\Data\\Boundaries\\LocalAreas.kml'KML: Error initializing reader and I don't know how to fix it? Can anyone please help? I would appreciate it .

The online custom coordinate system generator does not appear to be working anymore.  @daveatsafe​  - any ideas?

Hello everyone, this is my first time writing in the Forum, by the way I am coming to you for a little problem on FME. To get you up to speed, I have two layers:- Road network: consists of several numbered segments.- Point layer that represents the camera location. After the application of Anchored snapper in order to attach the camera positions on my road network, my goal is to assign to each entity of the attached point layer, the distance from the origin of the segment on which is attached of the road network, please find attached an image by which I have tried to present my problem, thank you in advance for your help. Link Image: https://www.zupimages.net/viewer.php?id=21/25/1sxs.png

Hi I’m finding when reading an Excel Worksheet containing only headers in Row 1 and no other data that I have one feature read with <missing> values for all columns.Surely if there are no rows there should be no features read?Process:New Excel Workbook containing one Worksheet and create the header in row 1 as follows:In cell A1 enter MyCol1 and use the right arrow to store that value in the cell and move to cell B1.Enter in cell B1 MyCol2 and use the left arrow to return to cell A1.This ensures that no other cells have been interacted with.Read this Workbook with an Excel reader and it returns one feature with missing values for MyCol1 and MyCol2.If you actually have data in row 2 you also get one feature read correctly.Thanks

Hi all,I'm trying to read from a Postgresql DB (postgis) applying a spatial filter using the SQLCreator transformer.Here's the sql statement set in the transformer:SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4326),7844), geom) This is the error I'm getting - it's logged as a warning but definitely what is failing the process:2021-06-23 13:07:41| 1.7| 0.0|WARN |Error executing SQL command ('declare "public_custom_query_crsr" cursor for SELECT capture_start, capture_end, metadata_url, status, project, geom FROM "public"."Metadata_Index" WHERE ST_Intersects(ST_Transform(ST_GeometryFromText('POINT(142.94 -37.28)',4283),7844), geom)'): 'ERROR: GetProj4StringSPI: Cannot find SRID (7844) in spatial_ref_sys'I've read through the docs available on the Safe websit

Hi there, I want to know if there is any method to read specific sheet only by using Excel Reader, e.g. I have multiple Readers in the same workspace to input various datasets, one is EXCEL, the other is IFC. If I want to read the sheet whose name is the same as my IFC Reader's source data name. Any method to achieve this? I guess fme_basename helps, but not sure how to achieve this. Thanks in advance.

The article on shutdown scripts states A shutdown script runs after all of the transformers, readers, writers, and the log file are closed in a successful translation. In the case of a failed translation, the script will still execute but may fail as only fme.status and fme.failureMessage are guaranteed to contain valid values.I have a FME Workspace that has a "Translation FAILED" message.  The last three lines of the Translation Log are:Program TerminatingTranslation FAILED.Warning: not all FMESessions that were created were destroyed before shutdown.  This may cause instabilityTesting that I have done indicate that the FME Python Shutdown Script is not being executed.  I assume this is because some FMESessions are still open.  As part of testing I have removed the import or use of any FME related python library from my Python Shutdown Script, and, have tested this script on other workspaces.   Is there anyway to force the FME Python Shutdown Script to run when the Translation has Fai

I have two tables that form a child parent relationship. The parent record has a primary key and some field data, and the child record has a foreign key and some field data. I am trying to append each child record's field data onto the end of each parent record. There can be anywhere between 1 and 99 child records for every parent record, and the field names from the child record should be repeating. I have attached some sample data to show what I am trying to achieve. The spreadsheet contains a parent table, a child table, and a final table showing the desired final format. Parent: Child: Final: It basically look something like this: Parent Table:Parent-Field 1 (Key) | Parent-Field 2 Child Table:Child-Field 1 (F-Key) | Child-Field 2 | Child-Field 3 Final Table:Parent-Field 1 (Key) | Parent-Field 2 | Child-Field 2 {0} | Child-Field 3 {0} | Child-Field 2 {n} | Child-Field 3 {n}  I have tried using aggregators, feature joiners, database joiners, aggregators, list builders, and splitt

I can nowhere find information for this error?Does someone know how I can fix this?--Stored 82 feature(s) to FME feature store file `C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.ffsupdating'Saving spatial index into file 'C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.fsi'Finished saving spatial index into file 'C:\\Users\\CENTRA~1\\AppData\\Local\\Temp\\wb-cache-03_Buffers_Bouwen-xPalBe\\Main_LineCombiner -1 152 fo 0 LINE 0 932eff0b162b454a4c8fc28137d419000e8ade26.fsi'Expression: edgeCurves_[edge].has_value()FME Session Duration: 2 minutes 17.7 seconds. (CPU: 114.9s user, 19.7s system)END - ProcessID: 8116, peak process memory usage: 299160 kB, current process memory usage: 105972 kBExpression: edgeCurves_[edge].has_value()Program TerminatingTransla

My request is to transform the x,y coordinates which are in CC49 of the attached file into UTM 31 N (epsg 32631) The attached project does not change the coordinates and duplicates 3 times the data for each phase. Could you help me ? Thank you

I have a DEM raster and also a vector layer containing 20+ polygons. I would like to calculate the highest points within each polygon and then create a point feature for each high point, but I'm not sure how to enable the workbench to cycle through all of the areas.  There's a similar post explaining a workflow to calculate the highest points in a single area, but I would like to apply this to several different areas. Here's a link to the original post for reference: https://community.safe.com/s/question/0D54Q000080hQhISAU/find-position-and-value-of-highest-elevation-on-a-dem-raster

We get multiple problems when rendering complex data with the MVT Tileset writer: Small polygons vanish on different zoom levelsLines are on some zoomlevels so simplified, they look like a subway plan (see screenshot)Some content does not get rendered at all on some tiles, but is visible on neighbouring tiles at the same zoomlevel (see screenshot) The data we render consists of 5 input layers. Polygons and points are mixed in the tileset, but homogenous for each layer. The input polyogons are very complex (lots of vertices per polygon). We produce a single tileset with the input data.  MVT Tileset writer parameters are default.  We als tried with simplification parameter "2" with the same results. It is not really clear what number to use with the simplification parameter, the documentation is not clear. Maybe someone can provide samples how to calculate the number to fill in? FME version is 2021.0.3 b21326. Viewer is QGIS 3.18.3. Viewing with maputnik shows the same results.

Hi Support, I am trying to export the Smallworld Electric Office 5.x data into ESRI File Geodatabase(FGdb). I wanted to export the Cable Segment, Cable & Cable Existing Phase records with the same join relationships to ESRI, while doing that I am not able to choose the Cable Existing Phase table(eo_cable_exi_phase) even though I have selected 'Expose Internal tables' option(please refer attached screenshot). How can I export the Cable Existing Phase table data from Smallworld. I have verified in the Community articles and couldn't find any. Can you please help.