Transformers

I have been using Topologybuilder to merge attributes from overlying features. This worked fine as long as empty cells where set to NULL. Now for some unknown reason this does not work any longer. Example of two overlying features:Feature 1: attributeA = NULLFeature 2: attributeA = 'valuesomething'The output used to be one feature with the value 'valuesomething', but now I get the value NULL in stead. Has the way the Topologybuilder works been changed? Does anyone have a workaround?

I am trying to set-up a very simple converter that takes one dwg with defined layer names and output to a new dwg that matches the layer names that we want then to be called. Unfortunately all feature_types in the output end up the same feature type.  

In a workspace, I retrieve by spatial relation (AreaOnAreaOverlayer followed by a Sampler, SpatialRelator after InsidePointReplacer, ...) an attribute value in a table and a shape that have nothing to do with the table and the source shape. So I create a second workspace in which I retrieve the previous attribute value in the table and the original shape by a Joiner.  How can I do this in one workspace?

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

Hello, I use the transformer Bufferer in a workbench.I don't understand the result pour some features for which I have an ellipse in result (fme_geometry = fme_point, fme_type = fme_ellipse). I join a very simple fmw (2022.2) with 2 polygons. What parameters should I take to always have features with fme_type=fme_area et fme_geometry=fme_polygon ?  Mélanie

Hi,Im having trouble getting some XML editing working.Im extracting some elements with XML fragmenter, this generates an XML_ID attribute for each fragment.Im then filtering for just the fragments I want then wrapping them in another element.Im then attempting to reinsert the fragments into the XML and I thought I could use the XML_ID attribute to insert each into the position it came from.Im using //DynamicValue[fme:get-attribute("xml_id")] to try to put them back inIts basically the structure below but can be more complex<Item><AssOpp><DynamicValue><\\DynamicValue><DynamicValue><\\DynamicValue><DynamicValue><\\DynamicValue></AssOpp><Item>I was hoping the XML_ID would place only the filtered edited ones into the correct spot but I seem to be replacing every dynamic value.The new fragments are like below and the ids look like 'id-DynamicValue1.2.3'<BuiltInFn><StaticValue><\\StaticValue><D

Hi,This is a bit hard to explain so I hope this drawing shows what I want.  I am trying to create a gml spesification where different geometry segments in a polygon feature is split into curvemembers only containing one geometry type. Basically when you have a boundary of line segments and arc segments, the gml will wrap a curvmember around every geometry type segment. as illustrated.I am using a GMLFeatureComposer so I have the ability to update each gml feature before writing it out with a text file writer. Should I use xmlupdator, or is it possible to do anything with the native geometry structure of IFMEPOLYGON to contain multiple IFMEPATH segments?

What is the syntax for same and common attribute name for two datasets (parent and child tables) in Tester? If i give same field name for both Left and same values, iam getting merged all data. But i need only matched records. $(SourceDataset_CSV).@Value(#EMPNo)?? How can i access the same attribute name when we have many datasets?

Hi.I'm generally use the workspace repository to assign job queue when scheduling job executions, although I have a couple of special queues to enable high importance jobs to run sooner.But jobs that are not scheduled by the FME server itself, instead being initiated via the REST interface, all seem to end up using the Default queue.I've looking into the API example, and it doesn't seem to include a queue name request parameter. And there's no way to create a queue designated for REST initiated jobs.Is it possible to control the execution queue with REST initiated jobs ?Using 2020.2.5

Dear FME community,I have a shapefile with lines that are partially parallel. We want to create a map for 1:50.000 and there the parallel lines are too close together to distinguish them :-) Is there an easy way in FME to separate the lines, i.e. to make more space between them?I think the Offsetter makes offsets for all the lines, but I only need to change the parallel one's. And each parallel line in opposite direction.Kind regards and many thanksThomas

Hi All XML Format as follows: <?xml version="1.0" encoding="UTF-8"?> <Flows><SCN> <SystemCodeNumber>N11111J</SystemCodeNumber> <FlowType>Scoot</FlowType> <ShortDescription/> <Northing>0.00</Northing> <Easting>0.00</Easting> <Flows> <Flow Date="2015-05-03 05:08:35">1.0</Flow> <Flow Date="2015-05-03 05:13:35">4.0</Flow> etc. I am accessing an XML file as a single merged feature type as i would like an output as follows: SystemCodeNumber,Northing,Easting,Speed,Flow,Date N11111J,0.00,0.00,,1.0,2015-05-03 05:08:35 N11111J,0.00,0.00,,4.0,2015-05-03 05:13:35 N11111J,0.00,0.00,,1.0,2015-05-03 05:18:35 N11111J,0.00,0.00,,0.0,2015-05-03 05:23:35 as so on. I am getting the elements i want: and flattening the elements: not the output is fine, im getting what i require out: I have my SystemCodeNumber, Easting and Northing ou

Hello,Is there a way in FME to detect lines having the beginning or the end vertice like shown in following images.Thank you

Hello, I am using the sqlexecutor and I am populating the attributes to expose from sql query. It correctly displays them but there is a (ok) button missing to add them successfully. When I close the window (x), they won't be added.

I have point features in an Oracle SDO_GEOMETRY column.  Currently the rotation of the points are 0. How can I rotate the points given the angle of rotation?

Hi Community!I'm working with two sets of polylines, but not all of them match perfectly.I'd like to identify, using FME, the polylines that do not align (Non-Overlapping).Is it correct to use the SpatialFilter transformer for this type of comparison?If so, how should it be properly configured?I've attached the data I'm working with:the red polylines (RtesType1.shp), which do not match, are located in the area highlighted by the black circle.The polylines I'm comparing them with are the ones in cyan (RC.shp).Thanks in advance for your help! 😊 

Hello,  I have five feature classes: wPump, wControlValve, wMainLine, wUtilityArea, wServiceArea. The wPumps, wControlValves, wMainLines and wUtilityAreas all reside w/in various wServiceAreas. I am attempting to create an excel file that has one row for each wServiceArea, with the Service Area Name being the first column. Each successive column would provide the following information for each wServiceArea:  1) number of wPumps in each wServiceArea 2) number of wControlValves in each wServiceArea 3) length in feet of wMainLine in each wServiceArea 4) square footage of wUtilityArea in each wServiceArea  So far, I’ve only been able to successfully get one of these bits of information into the excel file using the SpatialRelator & StatisticsCalculator transformers.   When I attempt to add a second item, the excel file that gets generated now contains 2 rows for each ServiceArea.   What’s the best method for getting the excel file to have just one row for each ServiceArea and have the

Hi guysim trying to craete a workbench to backup my agol group content into local shapefiles. ideally i want to use _name (feature service name) as folder names so web layers (using fme_feature_type as dynamic shapefile name) goes into each folders by their service name.  however, for some reason the fanout option couldnt work. Also tried to create attribtue with the output file path then use it as destination esri shapefile folder on the writter - this solution doesnt work neither. wondering if anyone know a good practice for this? Thanks!

I need to export all source and destination values from an attributeValueMapper transformer. How can I do that?

Hello all, I need some help performing a spatial operation. What I haveA set of coordinates (sample enclosed) What I wantRemove / dissolve coordinate pairs if the are within 2 km radius of each other so that only coordinate pairs remain that have no overlap. What I've triedA Bufferer transformer with a radius of 2km connected to a PointOnAreaOverlayer.The result is a bunch of overlaps but I don't know how to further process these.  Cheers,Eduard

Hello,I have vector 3D (vx, vy, vz) from some triangle.How I can transform/project vector 3D to vector 2D?

Hi,The KAFKAConnector works fine und provides me features with a filename "key"and the file itself "value". In my case "value" holds a zip-file with Shape-Layers. How can I access the features in the zip-Files? The content of "value" starts e.g.:"504B0304140008080800117242540000000000000000000000000C00000036313231396E67722E646266A4BD49AEB5C9921C5622454D04021A68016F2EBC83E89B2121160942608352092047DA8776A389D629B3F81AF76391F578322A1F2A2BF2FEFFBDD74F34DE9A9BFFCBFFE75FFC8B7FF53FFEDDDFFDBFFFC3FFF777DB3FFFCBDFFDDDBFF987BFFF37F77FFD3BFEEB7FFD57DF7FE5BFFCFD3FFC87FFF8F7FFF8F7FFF04FFCF9BFFF87FFEB3FFDDBFF7B2DFF13FFF53.... I think, I have to write this somehow to the filesystem. Maybe using the FeatureWriter Format: DATAFILE And then use the FeatureReader. Any Ideas? regardsHerfried

Hi,  I want to use a Dynamic ORACLE SPATIAL writer in UPDATE MODE. But when i try to update a row through this, two extra attributes 'ORIENTATION' and 'TEXTSTRING' appends in the query so that when i run the workbench oracle throws an 'invalid identifier' exception and the process stops.  Can anyone tell me how to use a writer dynamically to update a row in oracle spatial  database. Thanks in advance.

Hello, I have a feature class from an geodatabase that contains larger and smaller features that overlap one another. I sort these features to have the larger features come before the smaller features. The attributes of the feature class are: Id and date The goal is to union the smaller and larger overlapping features, but only keep the attributes of the larger overlapping features. Since there is one feature class the overlapping areas share the same attribute names.  Therefore, I use the AreaOnAreaOverlayer transformer, with accumulation mode set to Use Attributes From One Feature.  However, I am unsure of the behavior of Use Attributes From One Feature accumulation mode. Which attributes are copied over to the resultant feature when the overlapping features are unioned? The document mentions the following for the Use Attributes From One Feature accumulation mode: "Takes all attributes from one representative feature" How does the AreaOnAreaOverlayer determine which of the

Hi,I created a geodatabase from SQL database. I have to create a workbench that the user will be able to edit the SQL database and apply the changes to the geodatabase by using the workbench. I am trying to detect the differences between SQL table and the related feature class which have the same data, but UpdateDetector, ChangeDetector, or Matcher do not give the correct answer. I also change the lenient geometry matching and treat blank value as different from missing attribute. No difference. What is wrong?

Hello, I have a query please. The attached table is a snapshot (fictional names etc used) of an Excel dataset of 10000 records, where employees of a company are each given a Card to access the office building, and this dataset logs their details each time they have entered the building, by swiping their card at the entrance door, in the past week.In the ideal world, every employee should have a unique "Employee Number" and also a unique "Card Number." So in this example, John Smith should have an "Employee Number" of 100, and a "Card Number" of 1. However, we can see that he also has a "Card Number" of 2 on two occasions he has entered the building, for whatever reason.Also, we can see that for Sarah Brown, her "Card Number" should indeed be 5, but for some reason, she has two "Employee Numbers" (400 and 500) when in fact she should just have one "Employee Number" of 400.What is the best way, using FME, tha