Transformers

Hi,Does FME Server support LDAPS?the closets KB article I found is:https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Import_CA_Certificate_for_AD_SSL_Connections.htm but unfortunately introducing a certificate doesn't seem to be working.Anybody have any experience with FME Server + LDAPS and would like to share his/her experience?@david_r @mark2atsafe @jlutherthomasThanks,Itay 

I would like to generate 3D object from 2D Shapefile.The 2D Shapefile is Long/Lat coordinate system and has height value of Floor and Roof with meter unit.Is it possible to 3D feature using 3DForcer and Extruder.Could you tell me the procedure for it? I could generate 3D model from 2D Shapfile if the horizontal unit of coordinate system is m.

The server we are using is on-prem 2019.4. I am trying to publish a dataset using safe fme. I have read through the rest api tableau documentation, but I am still having trouble translating that so that the http caller reflects tableau's rest api guidance (https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm). Some help cross walking the two would be helpful. Thanks, Greg.

I'm a pretty new to FME so apologies if my question is a bit basic. There are 2 polygonal shapefiles, one that gets modified daily on a server and another we have in a sde. I'd like the first one to replace the one I have but only where changes have been made to existing polygons, while simultanously puting any new polygons created in a separate shapefile to add in manually for quality control. I'm not quite sure which transformer(s) to use. Any help would be appreciated, thanks!

Hi,I have a database with FIRST_NAME, NAME and BIRTH_DATE.I have to find all the potentially duplicate people.If I find two features with FIRST_NAME and NAME written the same way or looks similar, I have to compare the features between each other to check if they have the same BIRTH_DATE. If they do, it's the same person, if they don't it's two different people.In this example, John Lennon and Jon Lenon are written almost the same way and they have the same BIRTH_DATE. We can consider it's the same person.But John Lennon (1950-01-01) is not the same John Lennon (1985-01-01). IDFIRST_NAMENAMEBIRTH_DATE1JohnLennon1950-01-012JonLenon1950-01-013JohnLennon1985-01-014RingoStar1945-01-015RingoloStar1945-01-016RingoStar2000-01-017GeorgeHarrisson2000-01-01 Would you have an idea how to do this kind of comparison? I tried the FuzzyDuplicateRemover but it doesn't give very good results and it doesn't store into a list the duplicated features potentially found (so I can&#39

I have a section of workflow that generates a dataset, each row I will want to POST to an API. I then have another section that requests an auth token via HTTPCaller and creates a dataset with a single row and single value containing the auth token. How do I now get the Auth token to set it as a header value in the HTTPCaller when POSTing each row from the dataset?    

The Excel function takes the inputs NORM.DIST(x, mean, standard deviation) where x is the value that you want to calculate the cumulative normal distribution for. I intend to use 0 for the mean and 1 for the standard deviation (i.e. the standard normal distribution). I've looked through the StatisticsCalculator as well as the Math Functions in the ExpressionEvaluator but I don't see anything like it in those transformers. This is related to this post where they are attempting to do the inverse: https://community.safe.com/s/question/0D54Q000080hEk3SAE/is-there-a-function-to-calculate-inverse-normal-cumulative-distribution?t=1599138666050 In that post the solution was to use PythonCaller and I am planning to follow that solution but wanted to see if I could use a standard FME transformer to complete this calculation instead.

I don't actually need a solution, but I'm just curious if there's a way to convert a number from a float to a decimal or vice versa in FME without resorting to python. So for example reading some data as a decimal, which is then stored elsewhere as a float and you want to do some change detection and consider56.358400000000003 to equal 56.3584and963.299000000000092 to equal 963.299and56.358499999999999 to equal 56.3585  

Dear all,I am learning how to export my data to GML. My file has many buildings (including roofs and walls), I separated the roofs and walls for each building using FME.Now, I want to make a CityGML file from this data using FME.It was pretty good when I used the gml_id (in Building class) based on the building's name. The roofs and walls (with gml_parent_id was set as the name of the building) had attached to the correct building (Figure1).But when I inserted and validated this CityGML file into the 3D CityDB software, these were some errors (Figure 2).I tried to ignore gml_id in the Building class (do not change gml_parent_id of the roofs and walls), checking this CityGML file (in the 3D CityDB software) was OK. Unfortunately, the roofs and walls were not attached to the correct buildings (Figure 3).What did I miss and what should I do to solve it?Does anyone have a solution to my problems? I am very grateful if anyone can respond (this took me several days). I am a beginner with

I'm having some difficulties with an translation of an Excel file that contains a some sort of layered structure and needs to be transformed to a sort of folder/path attribute structure in Excel. The input is as followed:The first problem I encounter is the use of indentation in Excel, it looks like FME does nog recognize this kind of setting/formatting. This issue makes it a lot harder to transform the layered structure of attribute "Naam" to a path structure with an "folder" and "name" attribute. As shown below: I already have a solution separating the steps and merging them back when the structure is OK. I can do this by splitting the steps using the Sampler with a Group By number with sample rate (N) 1 and sample type first N with no randomization. All steps will be in the NotSampled area and can be merges back later based on the number getting the structure from the Sampled part of the flow.  So is there a way to use the indention or anther wa

Hello, as the title already implies, I'm trying to merge XML formatted text ("insert") into a similarly ISO19115-1 formatted root template ("template"- see attachments) in a XML Templater feature. The insert (see attachment) is put together in a String concatenator feature from a set of values extracted from a database in a previous stage of the workflow and stored in an attribute named "SCIENTIST_INFORMATION". AFAIK I have two options to achieve what I want:  *Option 1 - plain 'fme:get-attribute()' *:If I use a simple {fme:get-attribute("SCIENTIST_INFORMATION")} the templater replaces XML special chars with their respective protected counterpart (e.g. < with <), rendering the text insert into something I do not intend. Note that I cannot reverse these transformation with a string replacer after the templater, as this also replaces non-XML specific special characters making the resulting XML files invalid.  *Option 2 - &#

I'm trying to convert various features of an IFC file to OBJ files. I'm able to do the entire transformation up to the point where I save the OBJ files, but it seems that the coordinates are in a projected CRS, evident from the very large X and Y coordinates. I have tried using a CommonLocalReprojector transformer (with a FeatureHolder just before it to make sure the transformation is done relative to the entire feature set):But the models appear stretched when I view them in Blender. Quite drastically. You can see that the doors are much taller than they should be, based on their width to height ratio:The only geographic information I really have from this file is RefLongitude and RefLatitude. But like I said, the coordinates themselves appear as large X and Y values, at least after being read from FME Does anyone have any idea on how I can fix this?

Hi folks I'm searching informations for importation of donuts (archipelago) inside GDB format. Up to now, all my donuts are ejected when I try to integrate them. I can do the import in GDB open API or GDB with ESRI licence.

Dear community,I am running a conversion from dwg to ifc. the necessary information is placed on a layer which is named differently in each file. I can't find a way to process this automatically, since everytime the workspace-runner brings in a new dwg-file, the attributes are stored on a differenty named layer. Is there a possibilty to read in dwg-files with a filter looking for specification within a layername?Thanks a lot for any hint on this matter.

We are using FME 2017.1 to transfer facilities from one company to another going from a SW 5.2.3 database to a SW 5.1.2 database.  I can connect to the SW 5.1.2 Gas_transmission dataset from the SW 5.2.3 session. When setting up my Workspace, I have multiple geometries being exported like gt_line_loop (beg_location, end,location, route_satellite and route_aerial). Iff I have 11 records that I am exporting from SW 5.2.3, I will have 4 sets in the reader (11 per geometry). If I just run a straight tranlastion, I end up 44 gt_line_loop records being inserted into the SW 5.1.2 database. I only want 11 records to be imported/inserted. I did an AttributeCreator and created sworld_geometry{0}.sworld_name for beg_location. I set up another AttributeCreator sworld_geometry{1}.sworld_name for end_location. I crete and Aggregator and do it on ID and Merge Attributes. I run translation and it appears to work fine. I get 11 records with beg_location and end_location populated. I

Hi, you lovely fellow FME-people! I have a question that I have tried in this forum before but I really didn't get help so now I'm trying it again. I use FME to create earth samples speedy and elegantly in an output DWG-file using the DWGStyler. I point out a cylinder block in a template file and then use it in the output REALDWG (after inputting x,y and z and length to each individual sample). The challenge is that I also want to use FME to add tilt and rotation to the block in the output file. Is this possible? Or do you have other suggestions. It is important for me that the geometry can hold attributes and that the output file size is kept to an absolute minimum.

Whenever I try to write data in Irish National Grid TM65 (EPSG:29902) to Esri formats, FME writes Irish National Grid TM75 (EPSG: 29903) instead. The only time FME writes the desired coordinate system is if my source data is from an Esri format that is already in TM65.How can I get FME to write the desired coordinate system?

Hi all, I am working with a dataset that has been generalised and contains ALOT of spikes so I am trying to clean them up. Spike Remover- easy, its a great transformer. However there are spikes I want to keep and those I don't so I have been running a lot of tests on the parameters to get the optimum balance . When you set the parameters you can choose your max angle and length and if the criteria is met then spike is removed. The output shows the spike line segment values 1 & 2 for both sides. It seems to me that if one of the Spike lengths meet that max value criteria then the spike is removed. What I want is to have the option of when both spike lengths meet a criteria then spike is eliminated. This way I have much greater control over what is being removed and allows me to better keep the integrity of the dataset . Am I missing something that I cant do this easily? My Fix--I have put in some rules that basically takes the spike remover outputs for spike_length and tests tha

I have a polygon on which I run a CenterLineReplacer (medial axis). I would like to calculate the longest path spanned by the center lines. How is this possible within FME (preferable within FME 2016) ?

I am currently looking for a way to query a list to either return all the values that contain the value found in an attribute or return the list index for these values.  I have currently managed to return the list index for the first value in the list to meet this query using a ListSearcher but can't seem to figure out how to return all values. 

Documentation mention 'Syntax Highlighting' as an option in the advanced text editor.Is it possible to set the highlighting scheme to a given language (SQL) from a stringConcatenator transformer? 

Hi all, I have a 3D mesh in a DWG file (3D surface of a pavement) and want to convert its footprint to a single polygon in an Esri file gdb polygon feature class (for use in 2D GIS). Can ignore all attribute information. Tried following this post but without luck (I think I need more detailed instructions re settings for each transformer). Anyone here able to help me? Thank you!https://community.safe.com/s/question/0D54Q000080hgjISAQ/turning-a-mesh-into-a-polygon

I've tried using the raster selector but it always fails (probably because I do not know how to correctly introduce the parameters)I am attaching a print screen of the Raster Calculator from QGIS with the "Expression" I used to filter my raster image. Thanks

Hi, We are collecting data with Esris Survey 123 and I would like to export the data within the shapefile (table) to specific cells within a excel template. With our gathered data we would like to make excel reports where different data ends up in different single cells within the worksheet. Anyone who has a simple smart solution for this?