FME Form

What I need to to do is to create one attribut in the table adress that says what polygon they are within. One adress can be witnin many polygons. This should lead to many duplicates but when I try to use pointonarea overlayer the point only gets the attribute from one of the polygons. I've tried to group by the polygons unique values but that did not work. I think this should be easy to solve but how to do it? To be clear the table "adress" should get one attribut that tells every polygon they are within. How to do it? Best regardsJesper

tested it with 3ds, shape and object.the CRS is 25833 GeometryValidator => passed through "Solid Orientation"FME 2020.1  

I have Table1 with the attributes "code start" and "code end".Table2 contains a code and geometry. Now I need the geometries conmbined from al codes that are between "code start" and "code end". Examples:Id 1 will get only the gemoetry of code 6371 ABid 3 will get the geometries of code 6371 AP and 6371 AR combinedId 5 will get the geometries combined of all codes between 6371 BA and 6371 BD 

I have come across this issue a cuple of times and I want to understand what is happening:I use newid() to insert uniqueidentifier for all new rows. The writer set to import table definition from datasource and thus includes the local_id attribute (defualt to newid()) My features to INSERT already have a local_ids from the source that i need to remove which I do my remove the attribute all together using the featureManager transformer. Despite of this FME produce an insert query with local_id is set to <null>. Do I really need to remove my local_id in the writer for it to be left alone to let the DB produce the id?I have other columns default to timestamp (Now()) and that is triggered as expected by the DB, so I am a bit confused to why the identifyer key is treated differently.

I have a workbench that generates features with about 20 attributes. Not every run will have the same source and so not every run will fill the 20 attributes in the feature writer. I have used the NullAttributeMapper just before the FeatureWriter to map null and empty attributes to missing, but it still outputs all the <missing> attributes. I have tried both Automatic and Dynamic, but same result. What's the best way to only output the attributes that aren't all 'missing'?    

I have a following problem: I want to group and build lines from points based on two different groupings. Firstly by category_id that indicates certain categories for the lines (number of categories varies from 1-7). Secondly by "line_number" that indicates consecutive measurements points (see first picture with four point lines). As a result (see second picture first line) or in another words I want lines where category change starts a new line within "line number"-group. Points have order_id so it is can build the lines in particular order. I've tried LineBuilder but can't figure out which aggregations/groupings I should do and in which order.   

Hi everyone, I have a question about my thesis.I have a point layer witch including data about the traffic(speed, cars number ect..). And I have a road layer. I don’t know how to connect the the point layer to the line as the closest segment of the line get the datas from the closest pont… Thanks in advance

I have a CSV file containing the four values of a bounding box. I would like to read the file into FME and populate the four search envelope values of an SDE reader in order to clip the data to the search envelope when reading the data. How do I populate those four values from the file?Thanks,Aaron

Hi,I am trying to do transformation using Snakegrid projector to OSGB.I have appropriate Snakegrid license as per FME desktop registration key. However, looks like I am facing issue with python compatibility.  I tried some workarounds as below:1.     Installation of FME desktop & Snakegrid projector with the help of expertise in the team2.     Installing FME desktop version (2021.2.1) with customizing python option3.     Setting up python interpreter in Translation (tried using all options given in drop down), But when I try to add Snakegrid projector it used popup with python incompatibility and changed to python 2.7 Error snapshot as below:Please can anyone help me with this issue?

We are producing Cesium 3d Tiles from .dgns, our problem first was that some elements seem to have the wrong surface normals, or so we think and our fix was to use the Orientator transformer, produce a Reversed version of all elements and then Merge these elements back together so we don't have duplicates. What occured afterwards is that some elements have weird shadings that change as you orbit the element, is there any fix to this? Is this still an issue with the surface normals? Or could it be that some inner color bleeds through because of the normals 'fix' we did? Thank you in advance!

Hello, I'm trying to convert .dwg to cesium 3D tiles, but exported 3D tiles seems to have only one-side surface. Any ideas how to export 3d tiles with front and back side? I tried lots of transformers. In FME it seems to have double-sided surface.  Many thanks

<ul class="textattributes"> <li><strong><span class="atr-name">code</span>:</strong> <span class="atr-value">01</span></li> <li><strong><span class="atr-name">teh_nm</span>:</strong> <span class="atr-value">Adhartal</span></li>  </ul>]]></description><georss:polygon>23.263113894134655 79.9657965013572 23.263116605734016 79.96581753147373 23.263121042554495 79.96583425568379 23.26312856542468 79.96585814323883 23.26313967034197 79.96589970121278 23.26315331921497 79.96597267824511</georss:polygon></item><item>

Hello, I am trying to create a polygon from different point clouds files. After the reader I use the "NumericRasterizer" and then the "RasterExtentsCoercer" but after the rasterization I receive 1 file as an output instead of 8 that was the input. Which means that they have been merged somehow and therefore I have one polygon. How can I keep the individual files and create an outline per file?

I want to convert 3Dsolids (dwg) to a shape. But the shape is to complex I just want the boundary of the multisurface. How can convert these multisurfaces to a boundary? Thanks

FME is aware of the file extension .nc, but appears to be unrelated to the file type I am using. Please see attached file sample (note the original file name is louves.NC)

Hello FME users, I am looking for a solution that is the equivalent to ArcGIS snap raster. My situation is that I have road netowrk, rivers and lakes (all in vector format) and I need to transform those into raster format. I already have a grid template (coming from a 10m resolution slope raster) and I want all my vector to raster outputs to fit with absolute precision. I have tried to use min/max coordinates but the resultat is not good enough (see images below for transformer parameters and resulting rasters.) I am sure this standard ArcGIS procedure MUST have an equivalent in FME(otherwise, PLEASE make sure to develop one!). Can anyone enlight me? Kind regards,Anne-Marie

I've built a python fastapi web application using the FME Server REST API and was wondering if I'm overlooking where the file extension filters are returned for any file parameters. While I see all of the other parameter information, I am not seeing the file extensions specified in the workspace for a parameter. It does not show this in the REST API call for /repositories/< repository >/items/< item >/parameters, so I was wondering if it is somewhere else or not available at all. Is this a limitation to the FME Server REST API perhaps? The reason for this is that my application is fully dynamic, so the FME workspace drives the creation of the form inputs.

(on FME 2020.2) Hi,  I have a workspace with an Oracle reader in which I want to filter the features to read with a WHERE clause on a column, let's say COLUMN_A. I created a Choice type published parameter named colA, which contains the possible values for this column.This way I can filter the features from my table when COLUMN_A contains the value selected in the Choice list. The WHERE clause is : "COLUMN_A" = '$(colA)'Quotes character are used to handle the values with spaces. Problem : the values can contains the quote character as well !What is expected for the database (Oracle) is that the simple quote in the value should be doubled. For exemple the colA value TES'T should be transformed to TES''T. I tried to find a way to replace the simple quotes with two quotes in the WHERE clause using SQL string functions, without succ

   Hi, Is the following possible?An FME workspace writes to a table. After the writers are ready I want that process to continue with other transformers and an other writer which must be writing last. I don't want to create 2 workspaces. 

I have an array of polygons representing a surface triangulation.Because of the source of the data, some faces are vertical which aren't supported in the TIN I'm trying to create.Any ideas on what would be the best way to overcome this? I'm sure its a common issue, be interested to see how others handle it.Maybe convert to lines, filter overlapping lines with different Z values and offset both a small amount?

I’m struggling with the TopologyBuilder transformer and, since I’m sure my use case is quite common, I hope someone might be able to help me. I want to extract the topological boundary polyline from polygons. In addition to the polyline geometry, I’d like to carry polygon attributes through to left and right-side attributes of each new polyline. For example, if my input polygons were countries of the world, I’d like my output polylines to be borders with each attributed with the country on each side. e.g. Left: France, Right: Germany. I’ve got the polylines geometry coming out of the TopologyBuilder perfectly, but not so lucky on the attributes. I get _left_face and _right_face attributes coming out, but these edge IDs don’t seem to mean anything. They don’t relate to any input attributes, nor are the polygon table row id. I’ve also tried “Generate List From Input Faces”, defined a list name, Selected Attributes, and my

FME Desktop 2022: What is the equivalent tool for ArcGIS “join field” in FME? I couldn’t figure out if there is a tool that’s equivalent tool for ArcGIS “join field” in FME. For example, in the screenshot below, I wanted to join the attribute table of the layer L1 with the table T1 to end up with having all the fields of table T1 in the layer L1           

I've found this documentation that mentions that comma should be surrounded with quotes when using in string functions. But the case now that I receive a file name (which contain comma) in a published parameter, then I want to replace part of the file path with some other string using "StringReplacer" function. I can't do this as the value retrieved in the published parameter has already the comma. Any Advise?

HelloI 'm trying to have the Fanout output directory stamped by date, I successfully did that except FME creates 2 folders of same content except one with the date stamp and the other without. Both directories are identical from inside, any advice?I'm using the parquet writer to export Revit elements properties to parquet files, here is my settings for output directory.The output comes as following:What I was expecting is the folder with date only???The same other folder "rst_basic_sample_project" with all its content is replicated in "2022-02-17"I only want "2022-02-17"

is there a way to convert mxd to cad? including all the symbology?