Transformers

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) 

I want to put the coordinate value in the obj file modeled on the 3D building in FME Desktop and print it out as a City gml file. I'm going to upload the printed file to the website of 'CESIUM ION'. I'm curious about how to put the exact coordinate value and print out City gml and upload it. I would really appreciate it if you could tell me the process sequentially. 😂

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

I am trying to create a workbench which will read in the data from a table in an ArcGIS Online feature service, where the feature service is determined by input User Parameters at each run of the workbench. The output will be an excel export of the data from the ArcGIS Online feature service table. I have hundreds of different feature services, identifiable by a unique alphanumerical code and feature service ID. The aim is for the user to input the alphanumerical code for the data they want to export when running the workbench (e.g DA019). This code will act as a look up to a table that contains the feature service ID for the required data. I have then attempted to reconstruct the syntax of the AGOL connection as seen in an ArcGIS Online Feature Service Reader.E.g [AGOL Group Name]/[Feature Service Name]([feature service ID]) I then have passed that as a field called fsid_search into a Feature Reader under the 'Feature Service:' constraint. I've included a screenshot of my

Hello everyone, I am new to FME and I would like to do automatically the task described in the photo, which is an "unmelt"s . I went and check the transformers "ColumnToRow" that did not work for me, and AttributeCreator that works but needs to add one by one every attribute "Thing1", "Thing2" ... Or maybe I missed something ?Thanks for your help !

I am taking a feature reader (ESRI geodatabase) and putting a feature class through an attribute manager. The feature reader shows the guid fields correctly as guid.However, the attribute manager shows them guid fields as buffer.This is happening for all guid field. I've tried "reset table" and import from dataset in the attribute manager. I've also tried recreating the attribute manager. How can I fix the attribute types to be accuate?

For example, I have a "Description" attribute, and I want to create a new attribute called "Categories". Features in the description attribute containing the word "gardening", for example, would go into the "Gardening" feature type of the new attribute.

Hello Experts..I need your Guidance and Help.. would like to transpose the information available in the FME template i have attached ..In attribute Keeper Transformer - I have 2 fields name JSON index and Data ..I want to JSON Index in Row as heading and Data is its corresponding Value.. I have attached workspace ..Also , I have tried to follow this Article " https://community.safe.com/s/question/0D5Dm000006Zdi5KAC/transpose-a-table"I want to transpose this and aggregate itThe results Comes in this way Kindly Support and Guide Thank You

The data that I have is like the following: I would like to substract the information within the brackets, so I get the following result: Can anyone help me how I can achieve this within my workbench?

I try to intersect a line with 3d coordinates and a polygon with 3d coordinates. How can i calculate the intersection point (the two screenshots may help)? Are there some properties that i have to use? Thank you for help!