Transformers

The data conversion from the oracle database to dgn works fine. I see in Microstation that the coordinates are identical with the counterparts in the Oracle database. However, Microstation doesn't seem to know that it has a coordinate system. It says <coordinate system not set>.  In processes 'downstream' requires that the dgn files have a coordinate system for further usage. This is now a manual step, that we want to avoid. Is someone familiair with this and knows how we can setup FME to write the coordinate information? 

Trying cell value based colors in Excel. ExcelStyler is simple and straight forward. Still I am missing some fundamental principle is missing. Attached workbench has very easy example to demonstrate how I mange to create non-formatted excel file.

HiI have two datasets, one water distribution area in polygons, and a point layer with the count of people inside each household per adress. i want to count up the sum of people in total for an each area. The count of people is in the point layer. i have tried the pointoverareaoverlayer but i only get the count of points inside an area, not the count from people inside the area

Hi,I have a smart solid model of a building made in Bentley. I would like to drop solid and take the top view drawing out. Solid dissolver is not working. Any help is greatly appreciated

Hello thereI was wondering if it's possible to write to geodatabase relationship classes where the source is not a geodatabase, so you don't have the "OBJECTID" to set as the "geodb_oid". I'm reading in some CAD data and am inserting records into 1 feature class and 1 table in a defined File Geodatabase that already has the relationship class setup (non-attributed), and want those 2 objects related. All the examples I've seen of writing to geodatabase relationship classes seem to have a Geodatabase-type source with already-defined OBJECTID values as attributes. I may have missed some documentation, or have done some tests incorrectly, but is it possible to somehow create the "geodb_oid" at runtime or would this have to be a 2 step process (i.e. 1) write data to feature class and table and 2) write relationships)?I know this is a bit vague but hopefully there's enough information that someone knows the answer!Than

I installed FME server 2021.2.2 and I have a problem in the gestion of the coordinates system NTF.Lambert-2E-ClarkIGN. It seems that FME server doesn't recognized this coordinates system and thinks it's NTF.Lambert-2C-ClarkIGN. We tested with FME desktop 2021.2.2 and FME server 2021.2.3 and the coordinates system is recognized. Do you know if there is a problem with FME server 2021.2.2 and the coordinates system NTF.Lambert-2E-ClarkIGN ?

Hi, i have a attribute field that contains value more than 8 charecter.I want to limit it to 8.

I am having issues setting an attribute within a python caller. I am reading in a list of strings, mutating the components in the list, then trying to overwrite the same list. Currently, the results of the output are the same as the input.Below is an example of how I am doing it.x = feature.getAttribute(list{}.item)for i in len(x):     <mutate items in list>feature.setAttribute("list{}.item", x)Can anyone let me know why this is not working, and how I can fix this? Thank you.

How do I create a WGS84 coordinate system whose units are milliarcseconds (1/1000th of arc second) in MyCoordSysDefs.fme? Not exactly sure what I really need... This is my guess.UNIT_DEF MILLI_SEC               \\    UNIT_TYPE ANGLE           \\   UNIT_ABBREVIATION DEG_MILLI_SEC      \\      UNIT_FACTOR 0.00000000484813681109535  COORDINATE_SYSTEM_DEF WGS84-MilliSec\\  DESC_NM "WGS84 milli (1/1000) arcsecond " \\  GROUP "WORLD"                  \\  PROJ LL                     \\  UNIT MILLI_SEC                   \\  DT_NAME WGS84 Should  UNIT_FACTOR be 0.00000027777777777777777  for conversion to meter & UNIT_TYPE be LENGTH? Thx,Mark  

I define the parameters of the TUREF_TM36 system, which is the national coordinate system of Turkey, and create an FME file. Then I throw the file I created into the documents/coordinate file. then I define it with tools/patch via workbenc but it doesn't read my file. what do you think i should do

Hello, I'm still juggling with FME. I have this very large raster (30 Go) and I need to clip with over 2000 different shapefile extents. Right now, I have been trying to use a Feature Reader and set up a spatial filter to read only what intersects the selected shapefile. Unfortunately, the whole raster is always completely returned. I have also tried creating a parent workspace only reading the main raster and creating a child workspace that would clip the raster according to the selected shapefile. The problem is that the raster is then read EVERYTIME in the child workspace (which amounts to about 72 hrs of unnecessary processing). I have read somewhere that you can publish extent parameter and use it in a normal reader to apply a search by envelop and than clip. However, I can't seem to understand how to "call" the parameters in the reader as there are no way to input parameter (see picture below).  

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

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

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