Transformers

I have a bunch of records with a GroupID attribute on them. Some GroupIDs will only have a single record/geometry, while others will have multiple records/geometries. When I use the Aggregator, it aggregates ALL the records, even the ones that only have a single geometry part.How do I either aggregate only the truly multipart aggregates or deaggregate only the single part aggregates?

I am trying to export to a geojson file (to upload to Mapbox). Unfortunately, 5 out of my 736 features have a type of GeometryCollection. The remainder of the features are MultiPolygon and Polygon. Mapbox is unable to work with the GeometryCollection. I tried using a GeometryCoercer with the Geometry Type set to fme_multi, but all of the features go through the Untouched port. I also tried running the 5 through a GeometryRefiner. This converts 2 of the 5 to MultiPolygon, but I can't seem to get the remaining 3. I have been trying to figure out how to use the GeometryPartExtractor, but I can't seem to get the syntax correct (this is all quite new to me). I'm also wondering if my lack of understanding of the Geometry XQuery syntax is the reason I can't get the GeometryCoercer to work. If anyone has any experience with this, I would greatly appreciate the advice. Thank you.

Hello, I have a single line, and also a set of 16 points that lie along that line.  I need to split the line into 16 different segments that start/end at these points. I found PointOnLineOverlayer that does this, and even mentions being able to apply attributes to the segments.  Its working perfectly to split the line up into segments, the problem I'm having is that those segments don't seem to be taking their attributes from the points that split them, but instead are taking them from the original line, and so the attributes for each segment are identical. How can I apply an attribute from the points to each corresponding segment of the line?

Hi FME'ers,I am using the HTTP caller to download multiple CSV files to a folder. I'd like to zip the folder and output the zip folder path as a single features to a automation writer. Can this be done? The automate writer would then trigger a second workbench to read all the CSV files and process them. I don't want to automation writer to trigger this workbench per file. Thanks, David

Hello i have Columnname A and B.I read the Excelfile with a FeatureReader. Get Columns A and B.Now i close FME. Rename Columname A to C in the Excelfile.Open FME. Read the Excelfile. Get Columns A and B instead of C and B.Why does FME cant see my renamed Column C and still sees Column A wich doesnt exist anymore?

I'm trying to reproject layers that were built in CAD. The first 6 figures of the coordinates match up to british national grid 6 figure grid ref. BUT there are 9 figures in the grid reference almost like it used BNG in millimetres instead of metres. I'm sure it is a simple quick convert/reproject but I'm a bit stumped...?

Hi All, I am stuck trying to figure this out. I am having trouble seeing feature classes inside FeatureDatasets using the FeatureReader. My Feature Types to Read is fme_feature_type_name and I am exposing fme_feature_type and geodb_metadata_string. All seems to work for feature classes but FCs in FeatureDatasets are skipped in Generic. They come across in the Initiator though. See screen cap below. I must be missing something simple. Any thoughts?

I'm fairly new to FME Desktop. I have a FeatureWriter with three inputs. I'm creating an Excel file with three sheets. It works great except many of the column widths are much wider than the content. I have to open each sheet, select all columns and Auto Fit Column Width. Today I realized that if the data type is text(255) then the column width will be 255. If the data type is text(150) then the column width will be 150. My data source is an ArcGIS feature layer created from Survey123. The default length for a text field is 255 so, I have many columns that with a width of 255 in Excel. This doesn't seem like a great way to determine width. I'd rather go with the Excel default column width. In the User Attributes tab of the FeatureWriter parameters, I see that I can set the column width. I believe that I can use zero to auto fit the column width. The problem is that I have about 30 columns and 3 sheets so, I'd have to type '0' close to hundred times. Is there

i have seen numerous posts about this but i cant get a good working solution. i have a user parameter that i want to limit a second user parameter based on the selection of the first. so far i can get a filter on the first parameter but how do you link the second parameter to the first in order to present the user with only the attributes that match the first parameter?

Hi, How could I assign a value to a polygon based on the value of most of the overlapping points? Thanks in advance. 

I just would like to convert xml files to json keeping the structure. I give you an example of my problem : My xml files look like that : <Organisme id="pmi-25047-01" codeInsee="25047" dateMiseAJour="2019-04-19" pivotLocal="pmi">  <Nom>Centre de protection maternelle et infantile (PMI) - Baume-les-Dames</Nom>  <EditeurSource>La Direction de l'information légale et administrative (Premier ministre)</EditeurSource>  <Adresse type="géopostale">  <Ligne>2 rue des Frères-Grenier</Ligne>  <CodePostal>25110</CodePostal>  <NomCommune>Baume-les-Dames</NomCommune>  <Localisation>  <Latitude>47.3492012024</Latitude>  <Longitude>6.36126995087</Longitude>  <Précision>8</Précision>  </Localisation>  <Accessibilité type="ACC">rampe d'accès</Accessi

Hi,is it possible to use the LineOnAreaOverlayer transformer to test all lines in an area against all areas step by step. That means i have 10000 areas and all should be testest one by one against the 15000 lines in the line port. As a result I need a list which shows me what lines are in every single area. And yes, the same line will be in more than one area. Maybe i colud use a second workspace and use the workspacerunner to bring the data in, but i hope there will be a smarter solution for that. 

Create polygon from point

Hello Dears,Im new to FME. I would like to convert SHP to TopoJSON. Is there any special transformers to use for this process or any customization required.I tried with simple attribute manager but the converted data is just a line. could you please help anyone SC attached  

In QGIS there is a useful tool that generates Random points on lines. It snaps the points to the lines whilst keeping an even spacing between all points. It also has a setting of points per line.Any ideas on how to achieve the same result in FME? Description of the function in QGIS:This algorithm creates a point layer, with points placed randomly on the lines of the Input line layer. The default behaviour is that the generated point features inherit the attributes of the line feature on which they were was generated.Parameters / options:For each feature in the Input line layer, the algorithm attempts to add the specified Number of points for each feature to the output layer.A Minimum distance between points and a Global minimum distance between points can be specified. A point will not be added if there is an already generated point within this (Euclidean) distance from the generated location. With Minimum distance between points, only points on the same line feature are considered, wh

 I have some problems using data made from FME. The workflow is basically from excel statistics data combined with feature joiner with shape polygon and after that through attribute manager to shape writer. I'm doing calculations based on both data sources attribute information in attribute manager (arithmetic editor) which I guess changes the data to text with point separator. When I try to do thematic maps in other GIS applications the data cannot be read even though it is there and looks good on the surface and contains both calculated data and polygons. I suspect the reason is that attribute manager changes the information to text after calculations. Even if I manually change the data type to double in shape writer this doesn't help. Any tips? Also possible reason is the use of point separator (most often I use comma). I haven't updated all the transformers lately. (The error I'm getting from ArcGIS when I try to do maps from data is that layer doesn't contain

My input is contour lines, I want to convert to raster. How can I do this? I was thinking contour->vector->raster, but i am not sure how to convert contour to vector. Any help would be appreciated

Dear All, I have GML with various types features like building, stream, road etc. In building feature member there are sub types like representation_point, roof_outline , roof_surface. My task is to extract only representation_point from building feature member. Kindly advice which transformer I have to use or steps to achieve the task. I tried xmlflattener but ended up with failure.

Hi There,I've got a question that seems to appear a fair bit within the forum but I have so far been unable to find a methodology that works for my case.I'm attempting to identify water mains within a water distribution network that have accidentally been duplicated, incorrectly split and not removed, or more generally are errors that went unnoticed. What I think it boils down to is isolating where lines overlap exactly (Scenario B of attach image), where mains have been split and a segment wasn't retired/removed when (Scenario A), or where a segment was completely replaced the old segment wasn't removed or retired (Scenario C). *Orange segments below are the erroroneous segments I'm attempting to isolate.From the forum posts I've read here there's a lot of talk of using the LineOnLineOverlayer which I have tried using. However, I'm don't want to report on valid intersects where mains are connected to each other. I've have some difficulty trying

I can't create the exact footprint through RasterExtentsCoercer, even i have set the Extents Type as 'Data Extents'. The transformer only allow me to generate a rectangle that covers the entire extents.My aerial imagery is in RGBA, possible the alpha band caused this issue. Is there a way to create the exact footprint?PS: i have attached a sample image.Thanks and Regards,Jian

Hello everyone, So I would like to generate a HTML report by using "HTML Report Generator".For the final product, I would like to generate the report with the "current time" on the HTML page. This is what I write in the text editor:   KE Indoor run on @DateTimeFormat(@DateTimeNow(local),ISO) The output is:   KE Indoor run on 2022-01-18T16:58:52.1754106+08:00 However, this is what I want for the result:   KE Indoor run on 2022-01-18 16:58:52 May I ask how can I fix the problem? Thank you in advance.

Hello,  I have an issue with generalising contours inside a tiling system. All contours need to match at tile edges, hence a surface tolerance of 0 is required. When this happens, vertices are added in what seems to be every 0.1m. Therefore i need to generalise.  The standard generalizer causes overlaps between different elevations, so the only option is sherbendgeneraliser but it takes an age with the amount of vertices. I have tried adding a generaliser with 0.1 tolerance before the sherbend generaliser but this also causes overlaps. I want vertices roughly every 5m or so in the output. Question:How do i fix these generalised overlaps?is there a quicker way to speed up sherbendgeneraliser?

I consider to replace my Http callers by the Asynch Http caller.  I am curious whether other users have experience with this Asynch HTTP Caller. This is related to this idea which is worked out in a transformer.  Because the test suite states 'failed', I doubt whether I can use this transformer safely. Anyone experience with this transformer?  

I need to truncate the existing table and append data. I have two tables one from versioned sde and the second table is in FGDB. I need to delete rows from the table in sde and append data from FGDB. I have to do field mapping after appending data from FGDB. I am not sure what would be the workaround to accomplish this task. Please suggest any workaround.

Hi, I am having problems with converting a TIN surface to a raster with height information. The input data is a LandXML which contains a surface of type IFMECompositeSurface. Right now I feed the surface into the RasterDEM generator with the following settings: The coordinate system is EPSG:28992 so the surface tolerance is set to 1cm, however the results are quite jagged:To give you a sense of scale, the image above is for an area of around 1300 meters wide so the the jagged points seen above are sometimes a 100 meters wide. To check my results I decided to convert the result to a pointcloud so I could take a look and compare it with the original surface in the 3D view in FME Inspector. In the image below you can see that the pointcloud that was created from the raster actually dives beneath the original surface:Does anybody have an idea what could cause these problems? I a doubting whether the RasterDEMGenerator is the right transformer for this job. I already have a workaround whe