FME Form

I used PointToPoint overlay to find out which two points are a repeat in two datasets. How can I still grab two columns of information from dataset 1 into dataset 2 if they are overlap? the two datasets do not have FKs, is there a way to join them spatially and then have the tables join instead of union? ---Thanks---

Hi all. I am reading in an Excel sheet where DateTimeUTC is formatted like this as text, but I need to convert this into a proper datetime for UTC… thoughts? DateTimeConverter is out, or perhaps I’ve not formatted it correctly.   Otherwise, I can use attribute splitter to get the date, but the time part is tricky… not sure what to use to get that formatted properly

I have finally started using FME Workbench (Form) 2024 a bit more consistently now that I built a new instance of FME Server (Flow Hosted) 2024.1.1.1. I like the updated look, but am missing a few things and noticing some inconsistencies in how the transformers render on the canvas:The newer look is more modern and although it’s just “ok” for me (looks like a card and less “fussy” than the previous transformer look), I like it. I miss the cog-wheel to access settings with a single click at the top-right of each transformer. Now you have to highlight the transformer and then you can click to access the settings. Doubling the mouse clicks isn’t a great enhancement. Would love to see this make a come-back, maybe as a minimalist “dot” or something... I can double click to get to the settings, but still not thrilled about it. It is forcing me to use the Parameter Editor window more now, docked to the right of the screen. Still getting used to it in an effort to reduce the clicking but with

Hi,How can get the green dot on the blue polygons.I have created the polygon centroid using center of polygon and with neighbor finder I get the green dot on red line. What I need the green dot on blue polygon and the small segment connecting the red line to blue polygons.I tried lion on area but I cat extract the  segment marked in black.Any help is appreciated

Hi, I’m an FME newbie. I have an ArcGIS sde (SQL) feature class of rooms with about 15000 rows across several hundred buildings. I need to write a list of rooms, by floor to directories for each floor in Google Sheets. I’m not sure how to go about generating each list. I’ve messed around with list builder some, but I’m stuck. I could do this in Python, but I’d like to take advantage of the FME Google Sheets writer. 

Hi all. I’m trying to generate UIDs for helping out with site inspection reports for structures. The structures are comprised of “Components” and each “Component” is comprised of “Sub-Components”. Each “Sub-Component” has a inspection lists (“Lists”) that are checkboxes that need to occur for each “Sub-Component”. Each checkbox is a coded item (“Code”) that must be inspected. There are multiple “Codes” for each of the “Lists”.The UID format that is desired is this:“Site ID”. “Component ID” . “Sub-Component ID” . “Code”The problem I am running into is that the data have been provided in Excel. There is a “SiteVisits” Tab, and a “Lists” tab. The SiteVisits tab has 350+ records, with columns containing Site IDs, Component IDs and Sub-Component IDs, and a column on the “Lists” required for each Site.SiteVisits Tab, with 350+ recordsThe “Lists” Tab contains a descriptor of each checkbox and the associated “Code”. What I am trying to do is concatenate the easy parts of the UID (“Site ID”. “C

Hi,It seems that the SpatialFilter does not always work as expected when the Filters First option is enabled. I have taken several steps to fix the incoming data (such as using the GeometryValidator and applying reprojections), but the SpatialFilter only works consistently when the Multiple Filters option is enabled.Below, I have included an image of my workbench, where—after multiple test attempts—only the top SpatialFilter suddenly works as expected.Is this a bug?I am comparing .dwg files with a feature class in a geodatabase (area)I work with the DataInteroperability extention by ESRI, in a workbench created outside of ArcGIS PRO,FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)  

Hi,I would like to use a simple function in the SchemaMapper for Attribute value for a new attribute. In an AttributeCreator I would use @Value(Lat)#@Value(Lng). This concatenates two values seperated by a #. I can't get it to work in a SchemaMapper. I tried @EvaluateExpression(@Value(Lat)#@Value(Lng)), but the SchemaMapper interprets this as a string and not a function. How can I make this work?Btw, I use FME 2023.2.5.Thank you, Arno

Hi,Is it possible to choose a line “connector” between a polygon and text object using MapnikRasterizer?Similar to attached image where the black text and lines are desired layouts. It would be good if an auto placement could be used for no overlapping of text, lines and polygons.   

Hello,I am generating an orthophoto from a point cloud using the ImageRasterizer transformer, with intensity as the input for pixel values. However, the only available option is grayscale, and I would like to apply a high-contrast color scale (e.g., green to red) instead of grayscale.Is there a way to change the intensity palette before rasterizing the point cloud, so the resulting raster already has the desired colors?Alternatively, can I modify the color palette during or after rasterizing to achieve a similar effect?Attached is an example of the desired output, where intensity is mapped to a high-contrast color scale.Thanks in advance for any suggestions!High contrast with colorsGreyscaleOrthophoto in greyscale 

I disconnected my external monitor to work on my laptop (not external monitor) from a different location. When I open up my FME Form workspaces, the transformer parameters font and icon sizes are really, really, tiny.  I saw the way to fix it was in FME Form go to Tool - FME Options - Appearance - Advanced Option and check “Enable automatic scaling for High DPI Monitors”. I have enabled this, closed FME Form, and re-opened it. I have unchecked it and did same. Nothing seems to make a difference. Is there another way? I am using FME Form 2021.2.0.1.   

HI, I have a problem to solve where I need to extract the coordinate system within the header information of the ECW image (not the sidecar files).  Our internal systems only work when the ECW header has “EPSG:7855” as the coordinate system, and I need to identify images that sometimes possess “GDA2020” & “Zone 55” information (as shown below).  The software “ECW Header Editor” can distinguish between the two, but FME seems to use the two values interchangeably, so my workbench can’t identify potentially problematic images.  The FME output for both “EPSG:7855” and the below entries are always “MGA2020-55_FME”.  Is there any way for FME to identify the below values hidden inside an ECW header? 

Hi,I am not able to use the ESRI GDB reader, as I am not able to open a layer from my database.So I created a reader reading a layer from GDB and then later this layer was removed from GDB, now I am not able to use the GDB reader at all, even if I open a new workbench and press the three dots button in the parameters of the reader, used to select the “Tables” , it gives me a message “Failed to retrieve feature types” “Layer not found”, but the layer mentioned in the error message is the old layer which is already removed from the GDB. And i didnt even got a chance to select a layer. What to do? Please do help.

Hello, I am currently running into issues when reading a gml file.I have two files, build exactly the same way.It reads perfectly well the coordinate system from one file, but not from the other.File 1File 2It seams to me that the the connection is not beeing read perfectly.cables is a table “CableElectrique” whereas “my” is the geometry I am sorry, I cannot provide more than snippets :(

hello,3dtiles writer support front and back texture? How can I achieve it？

Hi,I have a point dataset of vehicle locations being turned into lines using the LineBuilder and self-intersections are being created. While I can write successfully to the MSSQL SDE using the SDE writer, I’d prefer to use the SQLSpatial writer (due to speed and licencing). SQLSpatial fails due to what looks like the self-intersections.  GeometryValidator can’t seem to fix the issues, with the repair failing.The source points are the last hour of locations so they’re continuous being added and removed per vehicle.I thought this would a common situation for FME users to be in.  Processing tracking data.Also, would it make more sense to add the line segments on to the end of the line rather than rebuild the line?  I’m not sure how to go about that in FME.Thanks 

Hello!  I am currently Generating TIN surfaces from a pointcloud and exporting as a FBX.  I am having some issues with bad looking edges, aswell as vertexnormals looking like split normals everywhere (hard edges, see image below)As you can see from the images here, the triangulation is very rough. is there anyway to average those normals to get a more smooth experience? Think smoothing groups, from 3D studio max or something similar. i dont want to actually change the geometry, just the visuals. This was generated from a 4x4km pointcloud with a TIN generator surface tolerance at 0.5 (just to speed up the process).   Best Regards. Oskar Wallin

Hello:This is probably a simple use case to many of you, but I only have basic experience with FME Form and Flow.One of our programs has the ability to generate standard excel spreadsheets which contain reservation data (Date, Name of Room, Description of Room activity, Organizer contact info) GOAL: We would like FME to take that excel spreadsheet and post that data as a table on an html webpage.However, before that html webpage is generated, we would like the user to visit an FME Flow App (? I think) that will allow them to select from a dropdown list of rooms culled from a column in the excel spreadsheet. Once selected and submitted, the app would only show the list of active reservations Things to note:This excel spreadsheet data is updated once a day and will only show the current day’s data and will need to be uploaded to FME Flow each day. It’s being stored on a network location.I’ve managed to create a FME Desktop app that uses Excel Reader > HTMLReportGenerator > HTML Wri

I have a JSON-schema. A part of it looks like this:     "dct_license_sm": {      "type": "array",      "items": {        "type": "string"      }    } I feed data into a featurewriter pointed at the schema-file. The corresponding data from the input looks like this:dct_license_sm (string: UTF-8): https://creativecommons.org/licenses/by/4.0/So - a string, but in the schema it is declared that this is to be an array with string-items. Then I would expect the output to be like:  "dct_license_sm": [    "https://creativecommons.org/licenses/by/4.0/"  ],Obviously declared as an array containing a single string. But my results in FME via the FeatureWriter comes out like this:"dct_license_sm" : "https://creativecommons.org/licenses/by/4.0/",In the FeatureWriter I can't change the datatype.What would be a good way around this?   

Hi ,I am ussing a sqlexecutor for update or insert data in tables. But how do i get the rows updates, inserted ??so i use this in a Emailer ??  

I am outputting many rows to an excel table, some of my columns are numeric, I am hoping to add a total row at the bottom of my table, to sum these columns. I have found the Statistics Calculator, but I have no idea how to apply it (if at all possible). Any thoughts?

Hi All,I have read a few posts on the community already but can’t understand why the area calculated using Area Calculator is different to the SHAPE_Area in the Feature Class after exported to a GDB.An example below:Any ideas why does this happen?Thanks :)

Hello,I have a csv-file with the position of trees and additional information like the height of the trees. Further I have a sketchup model of a tree which I want to place at the position of each tree and scale it using the height of the trees.I can manage all steps from the different files, but not the scaling of the trees. If I use the example from https://hub.safe.com/publishers/con-terra-lab/templates/citygml-create-solitaryvegetationobject-with-implicit-representation and export the workbench to CityGML, the scale of each tree is right. If I want to export my data to Cesium tiles, the scaling is missing.Where can I set the scaling of the tree models for a proper output to Cesium?Thanks in advance and best regards,Andreas

I have a multitude of ring buffers and polygons for which I need to figure out what polygon intersects with what buffer. The task should be easy, but I am stuck here.All data come from the same feature dataset in a file geodatabase (so the spatial reference system is by default the same), however, to be absolutely sure I projected all data before they get into the SpatialFilter to the same EPSG.The settings for the SpatialFilter can be seen hereand to show that there are certainly intersecting areas and buffers that contain candidates I add the graphics view of the ‘Passed’ port and from the ‘Reprojected’ port of the Tester and the Reprojector.The candidates are in red…I did try an AreaOnAreaOverlayer, and that one finds overlaps but the request of merging the attribute data is unsuccessful. Meaning all the attributes are in the attribute table, but values from the buffers are not merged to the intersecting polygons, or the other way around. The list I create to check for what buffers

I was trying to compute the distance between a TINSurface and some horizontal polygons (which have a z value, but they are horizontal). I have been trying multiple things to try and get the distance between this two objects. I am kind of surprised that there is not a given transformer to compute the distance or the intersection between 2 given 3d polygons. Maybe a TINSurface is a little complex, but the triangles that compose them should not be complicated.I am a programmer and I think I can program a solution to this problem in a PythonCaller transformer, but I am really surprised there is not a simple answer for this.So if someone knows the answer to this I would appreciate it. If not I think I’ll be forced to program it myself.