Transformers

Hello!We have a new software package that imports KMZ/KML to another KMZ/KML format, and cannot take the standard google earth created KMZ. This is causing us issues, as 99% of the kmls we get to import are in the standard XML Format. What is the best approach I can take or transformer to use in order to convert the different KML formats? I attached two examples. One we received from someone to import, and the template that the vendor needs to import.

I've got a very big feature class which contains more than 12,000,000 polygons and I need to use TopologyBuilder and other transformers to do some processing, but it took too much time for TopologyBuilder to process the dataset. So I came up an idea that I split the dataset into several some small feature classes which contain less polygons. Now I only need to run my workspace repeatly through WorkSpaceRunner, but WorkSpaceRunner seems can not process feature classes in the GDB one by one, I have to export feature classes in to separate GDBs to get it work, but exporting processing also took a lot of time and made my folder very complex. So is there any way to iterate through GDB? I'd appreciate any @suggestion, thank you!

My dataset is a shapefile with footprints and elevation.

I am in the process of converting DGNs to SVGs for use as symbols in ArcGIS Pro. I am able to filter out the Text in the DGNs and assign a stock Windows Font. However the text reference is not being passed to ArcGISPro and the the text component of the symbol is lost. I am looking for a transformer or a set of transformers that will allow me to take the text in the DGN and convert it to a graphic, that DOES NOT reference a Windows stock .ttf file.  I have looked at the TextStroker but the outputs are inconsistent and messy looking as compared to the original DGN text, and I am also having trouble finding a way to fill in the TextStroker output.  To clarify, the ETL that I currently have successfully displays the text in the output SVG in a Web Browser. The only location that does not see the .ttf reference is ArcGIS Pro (the final, required, destination).

Hi I have a video in mp4 format, this video i need to convert to jpeg or jpg or any other imagery format with geotagged, please help us how to create video to imagery in fme

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!Thanks

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).  Would anyone have a solution?

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!