Transformers

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.

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!

Hi. I try to create a HTML report (with Esri Leaflet) with point and polygone on the same map. It's possible ?

Hello everyone,For my colleague I would like to convert dgn (V8 and 3D) to a IFC file.I tried based on the following link that converts dwg to IFC. I tried to adjust the workbench from that link to make it work with Microstation (V8), however I am already stuck at the Creating the Space Geometry part. There are a lot of attributes for which I don't know what the Microstation equivalent is and I am not sure whether what I want is to currenlty possible to achieve in FME desktop 2022.For example I don't know the Microstation equivalent of these autocad attributes:Height LongName Nameautocad_entity_handleI was wondering if someone can send me in the right direction

I have a workbench that reads .dbf tabular data and .shp spatial data and writes both to a Fgdb. It works fine if I manually point to an existing gdb but when I try automate gdb creation by exposing the "fme_dataset" and use that for a location and filename, via fanout, it only writes the tabular data. I can get it to write the spatial data but it comes out in another gdb labeled "null."  I'm guessing that since the dbf and shp and not directly linked the writer doesn't see the "fme_dataset" based gdb as an option. I've even tried directly linking the table to the shp with an AttributeKeeper but its still creating a second "null" gdb instead of inserting the spatial data in the "fme_dataset" based gdb.

I am trying to visualize all speed bumps and elevation changes such that there is a height difference every 0.5m in the 3d model.What I have tried: Clip the raster using the clipper, followed by RasterStatisticsCalculator (tried maximum, mean, median) followed by Attribute manager to rename 'band0.max' to 'Height' followed by Feature Merger to join the shapefile to the GEOTIFF. Then followed by Extruder transformer using the 'Height' attribute.  I don't get the 3D roads in 0.5m resolution but rather long stretches of road surfaces. How can I change my workflow to get the elevated roads from the GEOTIFF in 0.5m resolution?  Thanks!

I'll be the first to admit this may be a dumb newbie question, but I'm struggling! I have an input field that contains a file path like the following:q:\\staging\\incoming\\1930s\\WI\\Sauk\\1937\\Sauk_WI_WU_11_908_19370707.tifI need to construct a URL to the file as referenced in a URL, and dump it into another field:https://server.com/1930s/WI/Sauk/1937/Sauk_WI_WU_11_908_19370707.tif My conceptual approach has been to use string processing to replace q:\\staging\\incoming with https://server.com, and then replace backslashes with forward slashes. Well, you can see where this is going... the slashes and backslashes are wreaking havoc. For example, I've tried various combinations to escape the \\, like:@ReplaceString(@Value(inputpath),"/\\","/")... but I either get no results, or a syntax notice. Am I even in the ballpark?? I'd love some suggestions on how to approach this issue.  

Hi Guys, I need to generate values between 1 and 2 ,it includes decimal values like 1.1,1.2... Can anyone help me on this? thanks and regards,Prashanth

@nielsgerrits​  I have a road shape file with numerous segments (links), all of which share the same road id. Now the user has provided me with csv data, claiming that this is the bad route from chainage 0.75 to chainage 5.1. In order to highlight the road, I must add another line geometry (a long line) on top of road features. The created line must overlay eactly on top of road. the created line begins at link 1 (0.75 chainage far)and extends to link 9 at a 5.1 chainage. How do I accomplish this with fme? I tried a lot of different things, but none worked. Actual line length and chainage length are two different metrics. We can take the proportionately dividing road length since chainage length is accurateWhat I mean is that if the real length of the line is 1.5 km and the start chainage and end chainage (attributes) difference is 1 km, then it becomes 100 m = 150 m in geom length. sample source shape file attachedand source shape ,desired output line, how it looks like( jpg files)