Transformers

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),"/\

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 attach

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:' con

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!

Hi, I need to validate if the TFW file content corresponds to the associated TIF file.Therefore, I'm reading the TIF properties (with RasterPropertyExtractor) and I'm reconstructing the 6 TFW-paramaters, to compare them with the content of the TFW file.But... the problem is that the Reader reads the TIF file with the parameters coming form the TFW file. Hence, if the TFW is wrong, then the TIF properties extracted with RasterPropertyExtractor are also wrong.Is there a way to force FME to ignore the TFW file when reading a TIF ?Thank you for your help.

I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.

I'd like to divide my 3D polylines by 3.28084 (feet to meters) - I think I'm close with 3D Forcer, using Arithmetic Editor but it's not quite working... @ZValue()/3.28084

Is it possible to write an AutoCAD Map 3D dwg with an attached FDO connection?I have a library of predefined .layer files containing the connection prepared.

I need a polygon or closed polyline of the extents of this data; using max and min (x,y) gives a bounding box which means further down my pipeline, data is being written to areas that should take "No Data". How can I grab extents from the point cloud to use it as a breakline? Pictured; point cloud, and point cloud overlaid raster output, showing data written outside the point cloud extents

Hi, We have tables of values with colors in Excel that we would want to integrate in a mxd.I though to export them automatically in jpeg files. It would be easier after to integrate images in mxd.How could I do that with FME? Thanks !

i want to merge multiple pdfs in order sequence and in one booklet how i can do please help me

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)

Hello,I am creating a josn using the json Templater. In my setting i have a subtemplate that must to be an "object" and contain a lot off nested attributes that are "list".In the situation where only 1 attribute is populated, the final result is good (Topology1record.jpg screenshot) but when I have more attributes populated the result is an array and not an object (Topology2records.jpg screenshot). I also attached the templater to show what I did.My final result should be: {  "type" : "FeatureCollection",  "features" : [     {         "id" : "rfs:7BBE13D625241D58",        "properties" : {            "topologyCharacteristics" : {                  "isPaved" : [                    {                       "range" : {                          "endO