Transformers

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!

I encountered a strange color overwrite behavior while writing to Bentley files. Namely, I am taking colors and styling by level from the seed files. These colors are specified in RGB. The resulting DGN file has colors in hex. Is there a property that sets this? Issue with the seed file? Attached is the workbench with the writer with the current properties as well as the resulting DGN file. Any pointers would be really appreciated!

I have some polygon features. Imagine one has area 100 units. Now I want a polygon having area 30 units to be split from this. Similarly I have many polygons and a list of areas. How do I split a polygon into two based on area?

I have a Survey123 form, that needs to be exported to a specific excel template file. The Survey123 form has 1 layer (parent record), and two related tables associated with that single record. The final format for the excel template would need to be 1 file per record, with two sheets (from the two related tables). Prior to exporting out to the template files, I would need to filter the data down by a site name For instance, a site (that I have filtered down to) may have 4 records taken on it, so I would need to create 4 separate excel files, based on a Plot ID field. Each on of these excel files would then have 2 sheets based on the related tables of the record. Open to suggestions and comments. Thank you!

I am working with conductor line segments and need to establish a parent child relationship between these lines. For example I would like to assign conductor "2" a parent value of "1" and a child value of "3". Has anyone accomplished this task or have an idea of how to go about this?

We have generated a chart by using the transformer "HTMLReportGenerator".As result we have something like this:Now we wanna color each data point inside the chart differently. Something like this: In fme I can only choose one color for the hole data atribute!Is it piossible to create different colors for one data attribute?  

I am facing challenge while transforming data from XML. The challenges are while reading an element it gives incorrect format.

Hi,  I have a requirement to refresh a materialised view in Oracle database, read the view and then write to a CSV file. Reading of the view should only happen after the view is refreshed. Tried using 2 SQLCreatorsFirst one,BeginDBMS_MVIEW.REFRESH(SCHEMA.MVIEW_NAME);End; Second One,Select * from SCHEMA.MVIEW_NAME; How to make sure that Materialised View will be read only after the view is refreshed? Thankssresree   

Hello Sir/ Madam, I have several transformers that I am not quite understand even I checked on the "help". I hope someone can give me a hand. May I ask what is the purpose of using transformer "Creator"? I often use "reader" to add the data. However, I saw other people use "Creator", may I ask why?What is transformer "GeomtryCoercer" does? It said to reset the geometry type, what does it mean?How about "Aggregator" and "Deaggregator"? does it mean to combine and separate data? Thank you.