Transformers

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 Chainages Speed 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" #! OVERRIDE="-SCHEMA_3_DATASET" #! DATASET="mno.shp" #! /> I am adding values of Project Name, Outline SHP ,Parcel SHP #1 and Attribute Name #1. Remain

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.2 Warning 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 definition Workspace 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/login In Body as form-data or x-www-form-urlencoded username:user@test.com password:Test123 And 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.

I have a schema JSON file that I want to use to validate various JSON files. What transformers can I use to perform this functionality? JSON Validator only validates syntax and not schema so what's the alternative for this? I have added pictures of the sample JSON schema and also the JSON file that needs to be validated against that schema.

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 SQLCreators First one, Begin DBMS_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? Thanks sresree

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.

I'm using the TopologyBuilder with default settings to create linkage in an ESRI sourced water network - mainly because there's no node-to-node connectivity like there is in Oracle. Generally its working well but has thrown up an anomaly. The transformer has created the edges of a line which should be two adjoining mains at the left and right edge, but instead the left edge is showing as joining to itself. In the picture the highlighted main should be showing with a left edge of edgid 83360 and the right edge of edge_id 83331. Instead the left edge is 83391 - which is itself: Any ideas why this is happening? I have used a snapper and GeometryValidator and there appears to be no issues with the geometry. Do I need to add a tolerance into the TopologyBuilder? Many thanks in advance!