Transformers

Currently I have few attributes that are saving row by row but raster images are saving one on another. Is there any way to save image into same rows like attributes?

I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew

With this Expression I get the max-value of the 5 first List-values.@max(@Value(FID{0}.FID),@Value(FID{1}.FID),@Value(FID{2}.FID),@Value(FID{3}.FID),@Value(FID{4}.FID)) But the features have different List-Numbers. Some of them 5, some of them more than 5. Is there a way to express not hard-coded? Where the Number of List-entries can be dynamic? My solution to get the maximum value was the Listsorter. But I wonder, if there is a way with the ExpressionEvaluator. An expression which is not hard-coded seems to be very powerfull.Thanks for help!

I am using a few check boxes at the Run window to let the user choose a few different things. I'd like different action to result from whether a tick box is checked or not. I can do that ok using a Tester and checking if the user Parameter is YES or NO, and the test works well, but this gets ignored by a FeatureMerger a bit later. The workbench somewhat carries on no matter what the test result is.  The end goal is to only create attributes if the user tick a box or not. Are there examples of that?   No features should go to the bookmark in yellow, but it does anyway despite failing the test. And the FeatureMerger returns empty values of course. I'd like to get rid of the Attribute with empty values before they get exported. What's the best way to do that? Let it merge then remove the attribute? if user-parameter is NO -> AttributeRemover on X I'd be a lot easier with Python, am i missing something obvious? I tried this but can't make it work: https://community.s

I have an FME process that updates one Oracle table from another via a ChanageDetector process. I notified the DBA that the table I am reading from is missing a field. The DBA created a able VIEW with the missing field and advised I use that to update the other table.  I don't see Oracle table VIEWS as an option in the Reader I am using. Can an Oracle table VIEW be used in a Reader? If so, how is that accomplished?Thanks in advance.

I have three datasets and there can be a possibility that the features that can be present in one dataset can also be another datasetThese type of features which shares same location should form one cluster.Similarly datasets that have same locations should be in one cluster and I need the count of clusters of all three datasets

I am working on a longterm project that will take csv files, turn the data into fme points and then use them to publish an agol web map. I have been trying to play around with the agol writer to publish the new feature layer. Whenever I use the writer to create a new feature layer, the data is lost, somewhere in the process and i get a blank layer with no data in it. Furthermore, when I try to insert data into these layers, nothing happens, the writer says it runs successfully but there will be no new data in the tables, they will remain blank. The final goal of this project as I said is to take csv data files containing point data and automate the process of making a web map with them. Is FME's writer unfeasible for this task? Do i need to accomplish this goal using Arcgis REST Api? The CSV datafiles typically contain the following: Latitude, Longitude, Object ID, Completion Status, Address, and a notes field. If I need to use python, how do I write my code so that it will use the

Hi all, I need clarification whether FME supports migration of Smallworld Electric Office data to ESRI Utility Network. Any lead in this aspect will be quite helpful. Please share if any portal is available as reference.

Hello,I'm having difficulty getting the results I want out of the Spatial Relator and AreaOnAreaOverlayer. Essentially, I'm trying to identify overlapping polygons within the same layer, where the overlap area is of a significant size, so that I can separate these out into separate layers in a fan out at the end of the process. I want to do this by creating a field and populating that with a value, where the first / bottom polygon remains in the original layer, but additional overlapping polygons are allocated an increasing number so they can be separated into a new layer - all the '0's, '1's and '2's together. I don't want to identify or attribute what are essentially topology errors (very slight overlaps), as these need to be reviewed and fixed manually, just what are considered 'legal' overlaps so they can be topologically cleaned separately. I have an (incredibly bulky and inefficient) solution, using both SpatialRelator and AreaOnAreaOve

Hello.  I would like to remove (replace with no text) everything what is after dash also with the dash. What I have: test - fmeWhat I want: testCheers, Oliwer

Hello all,I need to read glb-files and run a spatial transformation on it. Every glb shows one floor of a building with all its rooms. On the walls there are textures of photos so it looks like the view inside the room. The exterior walls show the same image as from the inner backside, because the building photos where only taken from inside, not from outside the building.FME can not read glb, so I tested some software to create different formats which FME can handle, like fbx and dae.When I look at the glb, fbx or dae in a 3D-Viewer, I can see the photo projections correctly. But in FME Inspector and after transforming the data to cesium 3D Tiles at exterior walls the inner room images are only shown outside. On the inner side there is the image missing.Is there a way to show the same images at the exterior walls and also at the inner side or change some settings so I can see the images only at the inner side and not outside?I am thankful for any help!Best regards, MiHue

I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.

Hi,I am trying to read data Oracle non spatial data from a View and create an output in Oracle Spatial.Although the process writes to the Oracle Spatial table and you can view the attribute data OK the data does not seem to be spatial and I can't see any data on a map. I have learned through passed experience that the Spatial Column must be changed from GEOM to SHAPENot sure if this is because i can't set the Eastings and Northings in the Reader to Types x_coordinate and y-coordinate?You can set in a CSV Reader but not Oracle? (if this is the issue)  Thanks

I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?

I have 4 lines and I constructed a polygon by using AreaBuilding. Now, I would like to clip the polygon with a 60 m offset from the northeast point. How can I do it? https://i.imgur.com/U59AcpG.png

Dear FME community, I have CityGML tiles which I converted into KML or KMZ files. They are in a certain folder structure. Now if I open single KML files they will only display in 2D with the inspector transformer. Is there a way to load all the files that belong to the KML structure? So that it displays in 3D? When I upload it in Google Earth it works just fine. At the end I would like to convert these KML or KMZ files into 3D CAD files like dwg or obj. Thank you very much for your help. With kind regardsChristian Lendl

Hi everyone,  I have a polyline shapefile that represents a transport route. I also have a point shapefile of markers along the route. I want to be able to split the polyline into segments between the points. I want to retain the route rather than use line builder to create segments between the points.  I have tried using the PointOnLineOverlayer transformer but I end up with significantly more line sections than I am expecting. For example I have a line with 27 markers along it. I am expecting to get 28 segments when I split the line at these points. Instead I am ending up with 61 as the line is split in locations where there is no point (highlighted blue part is on of the output lines). I think this may be a result of the aggregate geometry parameter. When I run the polyline through the aggregate filter it says the line is an aggregate. I see that the aggregate options in the PointOnLineOverlayer are deaggregate (which I think explains why I get more line segments than I was expectin

I have input points with multiple coordinate systems. I am trying to use esri reprojector on them, using a table for the input and output coordinate system and the geographic transformation.After MUCH testing, it appears to me that the geographic transformations are not being read. I hard-coded the identical value that is in the table and the features ended up where I wanted. When I set the value to get read from the table, they don't. I am pretty sure I've entered it correctly.Note: since I ran successfully with a hard-coded value, after switching to reading the table value it is working correctly. Logical explanation is that it is not reading the table. Input coord is read from table. Output coord sys is hard coded (wgs 1984), geographic transformation appears to be ignoring table values.

Hi there,I'm having problems with my workspace. It's quite big:reading an oracle data basetransforming and calculating datawriting to SpatiaLiteAnd all this on a virtual machine.I cannot provide the workspace and data here as they are sensitive, but I'll try to explain what I already did:The wohle workspace will throw an error. Sometimes because of memory space issues, sometimes unspecified (just 'Error during translation').I already set FME_TEMP to another disk.I did run it in debug mode: no hints on the abrupt termination.I disabled some parts of the workspace to get a focus + activated caching: while running part by part including writing to SpatiaLite, it didn't fail! But: I saw the temp-directory increasing up to 40GB.I ran the workspace in batch mode - failed. What else can I try? It seems to be a space issue (disk and/or memory). Does anyone else have experience on that (especially with a virtual machine)? Cheers,Maria

I have a line and a point dataset. The lines have measures, generated with the MeasureGenerator. Some lines are partly overlapping, so they share part of their route. The lines have a "ROUTENAME" and the points have the same attribute, indicating which line they are associated to. Now I want to derive the measure value of the points along the route, but only on the route they are associated to. How can I make the PointOnLineOverlayer and MeasureExtractor take into account the "ROUTENAME". Now some points get the wrong measure (of another route on the same location). Any ideas to help me out?

I have exported an AGOL featureclass as a JSON and GeoJSON featurecollection as I need to use the httpcaller to push the data to another feature layer in AGOL. I need to use the caller as I need to see the to/from objectID's for further record manipulation. However, I am really struggling with the format of the json to read from the file. Any pointers would be appreciated. thanks. Example exported JSON below{ "type" : "FeatureCollection", "crs" : {  "type" : "name",  "properties" : {   "name" : "EPSG:3857"  } }, "features" : [  {   "type" : "Feature",   "id" : 1887,   "geometry" : {    "type" : "Point",    "coordinates" : [     12897276.605700001,     -3756547.8676999994    ]   },   "properties" : {    "OBJECTID" : 1887,    "description" : "100 James St.\\nreplace pit lid and patch with cre

Hello Safe Software, The functionality to disable transformers in FME Workbench is a very useful functionality that I use quite often in the iterative stages of workspace development/authoring. But as of now when a transformer is disabled in a workspace in FME Workbench, FME features do not pass beyond the disabled transformer. Can Safe Software look at adding the ability in FME Workbench to let FME features pass through a disabled transformer. In other words, the transformer though still in the data flow but since made inactive (disabled) should simply let FME features to pass through without any manipulation it is actually expected to perform on the FME features entering it. Regards  SRG

i would like to add 6 extra character empty space at end of attribute value that include text . How could i achieve that ? FME 2018

I have a CSV file with Longtitude and Latitude fields (more than 10.000 records) and I want to convert these to point (shapefile). After that I want continue use a polygon to select which points intersect with it? I tried to use VertexCreator and SpatialFilter or PointOnAreaOverlayer but it didn't work like my expect. So who can help me to solve this problem. Thank you so much!

Hi everybody, I have a table which a column contain content as "province_district_ward_2020" and I want to split it into a word. Example: Before: "HoChiMinhcity_District1_ward1_2020" After: "HoChiMinhcity" / "District 1" / "Ward 1" / "2020"I tried use StringPadder or StringReplace but the result which It's not my expected result. I think there are wrongs in my process. Can you help me know how to work it? Thank you so much!