Transformers

I am processing complex linear features from a V7 DGN file.  Many of these complex linear geometries have several elements (segments) that contain multiple vertices with the same coordinates.  Sometimes there is only one segment in the geometry, which essentially makes the geometry a point, but there are some geometries with the multiple segments where the segment with only one distinct coordinate should just be removed and the geometry would be valid.  What I've tried so far is to use two GeometryValidator transformers.  The first one is set to remove Duplicate Consecutive Points and repair the geometry.  The second is set to check for "Contains Null Geometry Parts" and "Degenerate or Corrupt Geometries" and to NOT repair the geometry.  The problem with this approach is that while is captures those linear features that resolve to just one distinct coordinate as FAILED, it also flags those features that would be valid if the segment with the single distinct coor

I am trying to merge two tables with no common key. How can I do this? 1 is from a select returning the database name (dbname) and server name (srvname). For example:BlueSpark, WINSQLPRD001 2 is from a function and returns database role information. Example:sa, sysadminNTSERVICE\\SQLWriter, sysadminNTSERVICE\\Winmgmt, sysadminNTSERVICE\\MSSQL$INST1, sysadmin I want to take the two items from 1 and add them to each row from 2 such as:BlueSpark, WINSQLPRD001, sa, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\SQLWriter, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\Winmgmt, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\MSSQL$INST1, sysadmin I've tried using various transformers and all require a common key. So I tried converting the results of 1 into attributes and using that to populate the columns of the output, but it creates separate rows with the results of 1 and 2 - they are not merged such as:BlueSpark, WINSQLPRD001,,,,,sa, sysadmin,,NTSERVICE\\SQLWriter, sysadmin,,NTSERVICE\\Winmgmt

Hi everyone! I need to convert some coordinates from geographic to geocentric, X any Y are in SWEREF99 which can be easily converted, but Z is in RH2000 which is used in Sweden and other Scandinavian countries. I am trying to use CsmapReprojector and for vertical handling I used Orthometric height -> Geocentric or ellipsoid height. But then some "geoid height grid" file is needed! I downloaded grid files for FME desktop but nothing for Sweden id available! what shall be done now??

I have a table of non-spatial features. Each row has a non-primary key that it shares with 39 other rows. Each row contains a unique attribute type. For example: Row 1= "10 County"; Row 2 = "10 State"; Row 3 = "10 District" .... Row 41 = "20 County", Row 42 = "20 State" .... etc. How can I pull all the "10" attributes "20" attributes into single rows, each containing the 40 attributes?

Hello,I've just installed FME on several workstations successfully, however, on one machine, I am unable to run FME from the command line. It just says FME is not recognized and an internal or external command... It seems part of the installation maybe did not complete correctly. How can I get windows to recognize FME as a program from the command line? Thanks!

Hi everyone,I wonder if there is any way to force the SurfaceFootprintReplacer to not ignore holes in polygons?I have 3D cityGML data and want to get only the footprint, using the SurfaceFootprintReplacer the result is image Nr.2, all holes are gone and merged to one polygon. There is a custom converter called "GroundSurfaceExtractor" (I found somewhere in the web), what does it correct but this one takes around 10 times longer to calculate. Any hints?(btw: the cityGML does not include "ground_surface" elements to query for, I tried this one...)Thanks a lot!Building Polygon in 2D:SurfaceFootprintReplacer Result:

Hi, I would like to extract data from a web page coded. I already get the password. The url is :https://www.portail-nextgen-telecom.tdf.fr. I need to read the url , find the data : Document Contractuel. Read it. If there is a value , get it. i tried with htlm extractor but the response is a script. I need a value. yes or no the Document contractuel is here. Anyone can help me ?

Hello guys;I got some 3D Scan laser scan data as an e57 format and as soon as I open each setup I see that it contains point-cloud data and 6 raster imageries. This is great as I can combine all the point cloud and generate 360 panoramas for each set up I'm having hard time to extract coordinates from center of the 360 and build a single raster from each set up. No idea why I'm just able to preview just on of the raster and all the remain looks like contains same metada. My guess is that I'm missing something.Any one with experience extracting 360 panos from and e57 (Coordinates of center of the pano and a single raster?)  Thanks 

I use the AIXM 5.1 Reader with the default settings to read all AirspaceTimeSlice. Some of them are missing geometry. For example, I have a feature which uses xlink:href  to reference the geometry of a CTR. The CTR in itself has an UNION and consists of two CTR's which are also referenced with xlink:href. How can I get FME to get this geometry. It somehow doesn't seem to follow up on the xlink:href. I use FME Desktop 2019.2.3.1

I am trying to read in multiple files from a folder at once which contain a specific text string in the title and not any files that don't contain that string. I want it to be dynamic, such that if the files in the folder change, the reader will update as I want to put this at the start of a workflow which will put all the features from each individual source file into a single file and perform some transformations with that data. I have managed to figure out making a reader that looks at a folder and all its sub folders, but it reads in all the files in the folder, some of which I don't need/want. Is there a way I can apply a search filter to the reader so it only brings in files that have certain terms in the title?

I am hoping to produce a group of points along polylines of various lengths. I’ve been trying to mimic the GeneratePointsAlongLines() method from arcpy and ArcGIS Pro which will simply build out points from the start of a polyline at a designated interval (regardless of line segment vertices). I’ve investigated Densifier, but this transformer incorporates vertices and produces points that do not conform to the designated interval. I’ve contemplated utilizing Snipper, but this seems challenging given that many of the line segments I expect to incorporate may vary in lengths for different inputs.I’d appreciate any insight that can be offered.

Hi,i would like to define a list in the "PythonCaller" Transformer using incomming feature attributes. In addition, the list should be group by an attribute and sould output the same as the "ListBuilder" below. ListBuilder with incomming attribuit group by "Vorschrift" (=attribute) Definition in PythonCaller. how should the python code looks like for define a list using incomming attributes? desired output (=output of the ListBuilder above)    

I have and ESRI Geodatabase line feature containing a mixture of arcs and normal lines. I tried extracting the arcs using GeometryFilter but this doesn't work because although FME recognises that the segment is an arc, the geometry type is "line".How can I filter these arcs?

I have several hundred TIFFs that I want to load in to a File Geodatabase (FGDB) raster mosaic. ArcGIS allows you to load one image, then mosaic additional images into the same raster. I'm trying to do this with FME.So far, I have tried the following:1) RasterMosaicker, but that seems to create the mosaic in memory or temp before writing one huge raster to the FGDB.2) Read several TIFFs (e.g. select 2 TIFFs or specify *.tif in the Reader) and send to the same FGDB raster dataset (i.e. no fanout on the Writer) with Drop Table set to "No" for obvious reasons. This loads the first image then fails on the second with "ERROR |Failed to write raster data tile when writing to raster dataset 'TIFF2'. The error number from ArcObjects is: '-2147467259'".3) Using the Path Reader to get the TIFF names, then sending these 1 at a time to a second Workspace using the WorkspaceRunner (Wait for Job to Complete = Yes). The second Workspace loads the TIFF into

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

Hey everybody,I'm currently trying to transform LAS file into Cesium 3D Tiles with FME Workbench. Las file is provided by an Agisoft Metashape project with EPSG:3945 coordinates. I would like to transform this points cloud into Cesium 3D Tiles with EPSG:4326 coordinates.I can't use Cesium ion for my project. Unfortunately, I obtain this strange result. First screenshot is the original file and the second one transformed file.Has anyone run into the same problem ? Can someone help me to handle it ?Have a nice day !

Guys,  I'm lokking for a way to select all distinct values of all the attributes in a table.  For exemple :  City / Color   ------------------- New-York / red New-York / blue Berlin / yellow Chisinau / red Chisiau / blue  and the answer would be "New-York Belin Chisinau"  and "red blue yellow"... That could be writen in an excel file or txt...  It's more or less the same action than an advanced filter in excel...   Does anyone know how to do that ?  thank's in advance   

Hello,I have a API request working in postman, but cant get it to work via FME. If I could see the request headers/body, etc I would be able to debug the issue by comparing the working request vs the fme request.Does anyone have any ideas how I can see this?Thanks

I would like to be notified if there is any wrong attribute value in a non-spatial table which is read from SQL database by comparing with an spatial attribute table. In other way, I want to detect change if the attribute of a particular entry/row is different from each other. I have intentionally changed attribute values for two entries so that these two are picked. Both tables have few common fields but the schemas of the tables are not same. I have tried with changeDetector, Matcher and DuplicateFilter but not getting the actual outcome. Any help will be very appreciated.  In the attached image, 1 is the non-spatial table and 2 is the spatial attribute table. I have used attribute manager so that the attribute names in interest in both tables are same.  

Bonjour, Je souhaiterais ajouter dans le nom de mes fichiers de sortie le jour et l'heure du traitement. Soit : PO1_ADR_20200107_1021.csv CE1_ADR_20200107_1021.csv Adresses_ADR_20200107_1021.txt .....J'ai commencé en utilisant le transformer AttributeCreator placé en début de traitement avec en valeur de sortie : "@DateTimeFormat(@DateTimeNow(),%Y%m%d)_@DateTimeFormat(@DateTimeNow(),%H%M)" afin de ressortir l'information de la date/heure du traitement au format YYYYMMDD_HHMM. J'utilise ensuite ce champs dans le nom de mes fichiers en sortie.Le problème c'est que j'ai rajouté des traitements qui ont ralenti mon workbench du coup je n'ai pas toujours la même heure de sortie (les minutes changent). J'ai donc essayé de créer un Paramètre publié avec cette formule afin qu'elle ne soit lancée qu'une fois et utilisée pour toutes mes couches en sortie. En terme de paramètrage j'ai l'impression que la formule e

Hi I am chasing my tail and this is taking far too long to resolve. I have tried what seems like everything and I can't figure out how to remove gaps between polygons. I have tried snapper and it does nothing. I'm at a loss what to do.. Hoping someone has a simple resolution as this shouldn't be hard but I can't seem to find a solution.

Hello everyone,I am a beginner when it comes to FME and loops. I have the following task: I have an attribute column with a value. (e.g. Person 1, age 18Person 2, age 35Person 3, age 41Person 4 , age 45The age column should now be increased by one value x times per specified loop run. The number of loop runs should be controlled using user parameters and variables.I am using FME 2022. Can anyone help me? I have found examples with loops, but as a beginner I don't understand them.Thank you very much for your support. I look forward to your reply.A.B.

Hello guys,I have a files in a Esri geodatabase with the county of New York and an other files with "the constraint" its an huge group off small polygon (8 millions) who represent a mix between the slope + forest +swamp, what ever.  I would like to clip the county by the constraint and get the outside flow, it will form at the end the polygon of the county with some holes where was the constraints. So i use the clipper with this two files i think as many of you know it take long time and at the end fme say that i didn't have enough place (i had 20 gb free).  After that i try to create different workbench with 1 million feature to run in each workspace (workspace 1 = 0 to 1 million , workspace 2 = 1 to 2 million, workspace 3 = 2 to 3 million, etc), but im not sur its work to so.  So well my question is for you what is the best way ?

Text attributes can have a character encoding in FME, as we all know. The encoding that is used is shown in the Data Inspector, for instance: I would like to fetch that "iso-8895-1", "utf-8" or "windows-1252" value. My guess is that the answer is no but the question is: is it possible to extract the encoding somehow? I know that the FME Objects Python API allows me to detect if the attribute is an encoded string (FMEFeature.getAttributeType() ==> FME_ATTR_ENCODED_STRING), but it doesn't tell me what the encoding is. It seems to be stored as a (hidden) attribute property though, otherwise the Data Inspector could not show it.Depending on the answer(s) I will get here, I'm thinking of posting an idea for an EncodingExtractor transformer.

Hi Guys, another question....i want to do that for myself but i didnt find out which transformer i should use. I want to create arcs (thick line) where to lines come together (thin lines ) by radius params which are in a excel sheet..   Thanks