Transformers

Hello. I have a question about one solution. I have duplicate points with the same name, but with at least different geometry. I need to filter these duplicate points relative to this one coordinate. Passed will be the point with the same name that is closer to this coordinate. I am attaching the fmwt. Thank you very much.

Is there any way to extract only the exterior wall boundary along with its door, window, and other related elements? Please share some ideas I really appreciate your kind support.

Hi there! I have a point cloud representing a dense forest. I am trying to get the 3D convex hull of the point cloud (as a mesh). I have already tried PointCloudToPointCoercer (individual points) into HullAccumulator but the results are unexpected and do not contain the whole point cloud:  Using the Minimum Bounding Volume tool in ArcGIS Pro does the trick, but since the rest of my workflow is in FME, I would like to avoid this option. Is there an FME alternative to this tool? Here is the result produced by Minimum Bounding Volume in ArcGIS Pro:  Hope someone with knowledge of 3D models in FME can help. Thank you!

Hi guys,i have different excel files which i have to split in separate excel files (fanout with row C), name them as Row C input (PA9-BK.....) and keep the formatting...first two columns (the grey ones should stay in all files) and the rest (green colours and so on) should also keep in the new files. how is the plan for that? i have searched some articles but not found the right one.....sry cheers, thx and greetz FRanco

I have an issue trying to get a DGN file into Revit for placing rebar and steel detailing. I've tried the following:Import an IFC from designer - model breaks and has strange behavior.Convert DGN to a DWG file via FME and import to Revit - broken model no resembling original. Has anyone developed a workflow or know a good way to achieve a stable DGN to Revit workflow maintaining most of the original integrity without bugs etc.? Thank you!

Hi, guys, i'm new here. When i make a hatch in Autodesk CAD, and then translate it into GDB via FME, then i use FME exporting to .dwg file, when i zoom in to a very large scale, the new geometry's boundary line doesn't fit the original one, the area of the hatch also changed a little, but the line or arc don't change when i do the same. Can anybody tell me how to make it right? THANKS!!

I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools? As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures. To add one attribute I can use an InlineQuerier function:Select Cities.*, CityIndex.IndexValue as Index_at_20210630from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanksPhilip (6 month FME user)    

Hi everyone,I am trying to split a large table into multiple files and was playing around with the dataset fanout feature. My table has multiple header rows that contain explanations of each attribute that I wish to keep in each file created by the fanout but I cant seem to make it work.  An alternative that I can also see working is to add a static Sheet to each fanout-file which then contains these explanations. I wasnt able to make that work either though. Any help would be much appreciated.

Hi, we have some PoylgonZ geometries with multipe polygons per building. For each polygon we have different heights. Now we are creating building models in citygml with citygml_lod_name = lod1Solid. This is working already with this workflow:But now we have for each solid one building element. Then I thought on the transformer aggregate to aggregate the solids for each building (by gmlid).But then I have MultiSolids which I can´t write to CityGML (lod1Solid). How can I create only one Solid for each building?Or do I have to use lod1MultiSurface?

Hi, I am using the Email(Send) action within an Automation but am unable to get it to work. I am using: smtp.office365.com on port 587 and StartTLS encryption.The office365 email account has MFA enabled and so I am using an App password.I am able to use the same configuration within the FME Desktop Emailer transformer just fine - but the same parameters do not work within the FME Cloud automation.Error message is:"com.microsoft.aad.msal4j.MsalInteractionRequiredException: AADSTS50126: Error validating credentials due to invalid username or password"My FME Cloud instance is running "FME Server 2022.2.1 Build 22776 - linux-x64"I have also supplied an App Client ID by registering an App within am Azure AD as described in this article but it does not resolve this issue:https://community.safe.com/s/article/How-to-use-Microsoft-Modern-Authentication-with-FME#ForServerAny Ideas?Thanks

Task: Transpose speed sections along a section of road that is provided as 5m point layer, this is to be done for multiple roads with multiple speed sections. Road Layer : 5m Points with ChainagesSpeed Zone Layer : Sections of road with Chainage From and Chainage To When you have one road this task can be executed using TestFilter and manually entering the speed sections using Chainage From in creating the speed attribute. Question:Is there a transformer or a way that I can import the parameters from the Speed Zone Layer, without having to enter the filters manually? As I will need to do this task for multiple roads with multiple sections. Entering different testfilters manually is very time consuming and inefficient and tedious, hoping I can import in bulk?  Appreciate all the advice :) 

While running the FME script I am encountering the following error message :No SCHEMA dataset name was specified (couldn't find a value for `SCHEMA_2_DATASET' or `SCHEMA_DATASET') We have upgraded to new FME version 2021.2 from old fme version (2016). The script is running fine on the old fme version but having some issues in the new FME version.The script has multiple shape file parameters  The data set in the FME script code are in the following format :#! <DATASET#! NAME="SCHEMA_1"#! OVERRIDE="-SCHEMA_1_DATASET"#! DATASET="abc.shp"#! />#! <DATASET#! NAME="SHAPE_1"#! OVERRIDE="-SHAPE_1_DATASET"#! DATASET="def.shp"#! />#! <DATASET#! NAME="SCHEMA_2"#! OVERRIDE="-SCHEMA_2_DATASET"#! DATASET="ghi.shp"#! />#! <DATASET#! NAME="SHAPE_2"#! OVERRIDE="-SHAPE_2_DATASET"#! DATASET="jkl.shp"#! />#! <DATASET#! NAME="SCHEMA_3"#! OVE

Hi All, Hope you are well, I'm trying to upgrade an FME workbench made in FME 2020.2 to FME 2022.2 but keeps giving me a Python error while running,  I assume is something to do with Python 2 (FME 2020) and Python 3(2022) but can't figure out the workaround to update the workbench Would you be able please provide me with the steps to upgrade the workbench without re-creating it in 2022? Thanks in advance 🙂

Hi,I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

I am having no trouble reading the parcel polygon portal service, its just not bringing over the shape column, so I am unable to write the data to our SQL database.

Hello! When converting DWG/DGN v8 files to DGN v7, the coordinates in the v7 file are rounded, which causes the file to end up a few centimeters in the wrong place. I want the v7 file to have the same coordinates as the v8. How can i solve this?/ What is happening with the transformation that casuses this? The image is very zoomed in, but there is a difference.  Regards,Gustav

hello ,  how could I use feature reader to read Esri ArcGis geodatabase sde to get the content of tables . i have tried it but the output has no content of table .it shows me only the amount of table .could some one explain me ,how to get the content of tables by using feature reader ? and also show the output ports with name of each table ? i will be thankful if someone could show me the parameters that I should consider in Festure reader .FME 2021   

When using the schema mapper and connecting to a postgres table and choosing embedded connections there are no options to choose a parameter that holds the relevant value. For host, port, database and username, I'm able to type e.g. $(STAGING_DB) and create the link to my user parameter that way. However this doesn't work for the password field.Is there any trick to link the password parameter?  (FME 2021.2.0.0 Build 21784)

FME version 19.1.2Warning message: Cannot define schema for 'test' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration.Error message: XLSX Writer: No DEF line could be found for feature type 'test'. If you are using dynamic schemas, ensure that the fme_feature_type attribute exists on the incoming feature and corresponds to a valid feature type definitionWorkspace included below (I've tried 1 query now, but I'd like to add multiple using a conditional value for the sheet name)

Hello everyone! I'm trying to combine the components of two point clouds from their x,y,z coordinates but they never match 100% of the points... The help of the tool says that it may be necessary to round the coordinates but the transformer "pointcloudexpressionevaluator" does not have the "round" function... How could I round the coordinates of the x, y, z components to match and match? I would really appreciate any kind of help. 

I'm new to FME and want to create a workbench that translates 3D data to zero. I have IN (reader) -> CenterPointExtractor -> Affiner -> OUT (writer). Within Affiner have: 1, 0, @mult(@Value(_inside_x),(-1))0, 1, @mult(@Value(_inside_y),(-1)) I've tried a bunch of variants of this but am struggling to get the data to move to zero. Workbench attached. Thanks for the assistance.

Hi,In Postman:I have setup a POST request to https://xxx.com/loginIn Body as form-data or x-www-form-urlencodedusername:user@test.compassword:Test123And I get my response back OK In my httpcaller I am setup like this : But now I got a server error, just like my request is malformatted, as you see I even tried to put the form data into a specific attribute instead of passing directly inside the httpcaller. I got a feeling that fme httpcaller is having a problem with the "@" in the username, because in cURL I would put username in double quote to make it work just like : curl -X POST -F "username=user@test.com" -F "password=Test123" "https://xxx.com/login" What am I doing wrong there? 

Workbench is S-57 .000 files to File GDB. I only want to write Soundings that meet that meet the criteria SORIND where it's equal to US,US,graph,Chart * (for any chart number). Is this the correct transformer, syntax etc: 

I need to export the Data Model of our entire Geodatabase for an external consultant without the Data and it needs to vendor agnostic format (cant export an Esri XML Workspace for example). In the past I used a package call Geodatabase Diagrammer but it is no longer compatible with current releases of Esri let alone Pro. I was hoping to get some tips on how someone would be able to use FME to do this. I am hoping to be able to produce an XLS with a tab for each featureclass that lists the fields in one column, data type in another, field length, alias, perhaps domain. Any tips would be very appreciated!

I am trying to find a way to identify the date when the workspace was run in the resulting Bentley files. According to the end-users, that can be specified in the file description.  Is that the best practice? If yes, how could I add the description from the FME DGN V8 writer?  Any pointers would be greatly appreciated!