Transformers

I have a workspace that has two SQL Executors connecting to an Oracle database (the same database connection). In between there is processing that happens. It appears that FME is keeping the oracle connection open from the first SQL Executor for the entire duration of the processing, and using the same connection when it runs the 2nd SQL Executor. This is causing a network timeout error to occur. To prevent this I have tried unchecking the Persistent Connection option in the 2 SQL Executors, but still get the same behaviour.  As a test, I have logged the oracle session ID from the first SQL Executor to the log file, and in the 2nd SQL Executor I have logged the session ID and session duration. Both session IDs are the same and the session duration is the entire running time of the workbench. See attached screenshot for workbench, the decelerator is to simulate processing time.  So to summarize, the Persistent Connection check box doesn't do any

I'm creating DEM rasters (1m cell size) from Lidar using RasterDEMGenerator. Then Hillshades from the DEM rasters using RasterHillshader.I'm getting hillshades that look like stacked contour layers.I believe the hillshades "should" be smooth surfaces (especially Lidar surfaces) so I'm not sure what I'm doing wrong.I've attached my model and sample output.

Hello, i have an e57 file with size over 100g. It contains 50 pointclouds and 300 raster. So i wan to reduce the point cloud size .I've 2 questions​ I'm not sure if my workflow for this is correct. Cloud someone give me advice？In transformer "Writer" exits much options, i'm not sure the one i've choosed enough to export and save the minified file Thanks in advance​

I can set up a zip file extractor with a user parameter but how do I then connect it to the reader to have it extract the shapefile from the zip file?

Hello,  I am a basic user of FME and have created a workbench merging many tables. I need to add a further table, but before I use the FeatureMerger I need to specifiy a WHERE clause on the reader. I have tried doing thison the reader with no joy. I have also tried with the FeatureReader and no joy. I cannot find any help documentation in the reader to help me with syntax. Is there a simple transformer I can use?  I need a very simple clause to pass only certain attributes from one of the fields into the next transformer.  Can someone assist please? Harriet

in the data inspector , and it looks like its just those two columns in the screenshot. is m new to fme and I could just be missing something many thanks in advance

Hi there guys (and girls), I've been trying to combine several 3D-geometries (arcs, polygons, lines) into 1 big polygon.  What I have now are seperate parts (a window, a floor, a wall and so on), but what I actually want is a clean building that is only clickable as a whole.  I already managed to combine the different geometries into a geometry collection with the Aggregator Transformer, but I was not able to write this geometry to the destination file (OBJ).  Does anyone have any idea how I could solve this problem? I am looking forward to hear from someone else from this planet soon,Claire

i have adobe geospatial pdf and it has lots of points that connects together with different lines ,i would like to extract the lines coordinates and also the length and extract also line number for each line . FME 2020.2 Thanks in advance

I want to write out a bunch of MapInfo tables, placing multiple tables into multiple folders. My folder structure is about ten folders named after Districts. The District name is a value in one of the columns. How do I tell FME Desktop to fanout to a different folder based upon the value of the District name?

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