FME Form

Hi, I have a set of hundreds of shapefiles and another set of hundreds of rasters. I don't want to use ESRIReprojector transformer individually for each reader and writer. What's the most efficient way for batch transforming their CRS in FME?

I have gps points that indicate the speed of a car, I want to sum them around 50 meters averages them. which transformer offers and how it would be worth usingThanks in advance

I'm trying to extract a tin surface from 3D solid mesh in an FBX file.Ideally we would extract the top and bottom as separate surfaces.Any Ideas?If it isn't possible to filter the top/bottom triangles to create a surface, is there a workflow to create a raster grid sampling the highest/smallest Z at each point?

I am building a vehicle location tracking dataset where I want to keep a history of vehicle locations for future analysis. I am using the ChangeDetector to compare the values in two tables based on a field called [device]. I want to compare the [device] in table 1 with the most recent [device] in table 2 and if there has been a change, 'insert' those values from table 1 into table 2. So where [device] is in table 2 multiple times, I want to compare only the most recent record of the [device] details. When running the ChangeDetector, i have noticed that everything in the Deleted output seems to be the older duplicates. This moves me to my question. Does ChangeDetector just look for the first match for the value and move the others to the Deleted port? Does ChangeDetector use the timestamp field that I have to automatically detect the most recent? Can't seem to find any documentation on this?

Hi guys, I'm trying to set up an html-based application that allows assignment of attributive information. The html page comes out of a Serverapp and is presented to the user by a Data Streaming service. Currently I only manage to create a static page tha visualizes the "as is" situation. Is there a way to turn this page into an interactive mode, that re-establishes communication with FME Server on user request (button click etc.)? Does FME provide technology to fetch user input from text fields, context menues or any other gui object present on the page straight out of the browser?  Looking foward to your answers!

When using the MariaDB/MySQL in either Update or Delete mode, how to you specify the key to match the record? Is it using the fme_where format parameter because there doesn't appear to be mention in the Writer docs. Does it support fme_db_operation also?

Is it possible to add transparency styling to DWG output via FME? There doesn't seem to be an option in the DWG styler. If there is an appropriate field in the autocad format attributes i can overwrite this value but I can't see anything relating to transparency.

How to convert the json to attributes so i can use it later in the workspace part of json : {    "content": [        {                "id": "89732" ,.................................... i have used jsonflattener but i found that i got missing data . Thanks in advance FME 2020.2

Is there a possibility to extract only the walls and the roof out of the dae-file ... I do not need steps and all the small stuff..... thx

Hello, I try to create resource inside my Ckan session with the CkanConnector and it doesn't work ><All is good with the dataset creation but when i try this for the resource creationwith url is an attribute with url like https://entrepot.metropolegrenoble.fr/opendata/200040715-MET/ESPNAT_PAT_ARBORE_TOUS/json/PATRIMOINE_ARBORE_EPSG4326.jsonand for dataset the id of the dataset i've got this :HTTP 400: "Requ\\u00eate incorrecte - Erreur JSON : Error decoding JSON data. Error: JSONDecodeError('Expecting value: line 1 column 1 (char 0)',) JSON data extracted from the request: 'url=https://entrepot.metropolegrenoble.fr/opendata/200040715-MET/ESPNAT_PAT_ARBORE_TOUS/json/PATRIMOINE_ARBORE_EPSG4326.json&package_id=3c510f3f-0da9-4ae6-9450-30803f9e6c9a&name=PATRIMOINE_ARBORE_EPSG4326.json&mimetype=application/json'" Any ideas ? Best regards 

I get data via API in a JSON format. The values from "Points" need to be stored in seperate attributes. I managed to do so with JSON Fragmenter (json["points"][*]). With list indexer I can then store each index (0 & 1) to an attribute. But I can not transform then this attribute with DateTimeConverter.  In the log I saw, that the list structure still exists in my dataset. I also found this information in the Feature Information (see screenshot).  How can I actually transform the list into a proper attribute?  JSON Structure: {  ...  "name" : "xy",  "modified" : "2022-02-16T10:16:53.066Z",  "points" : [   [ 1642633200000, 123.99 ], String replacer Output vs. Feature Information:

Hello everybody, For the sake of the question, my computer is a MacBook Pro (13-inch, Mid 2012) equipped with a 2.5Ghz Dual-Core Intel Core i5 processor, 8Gb 1600 Mhz DDR3 of memory and a 1Tb SSD. I am authoring a workspace from NONE to CITYGML.It uses some HTTPCaller transformers to get datasets from a WFS, based on locational user attributes (lat long of the center point and cardinal offsets for the model extents)It models LoD2 trees, LoD2 buildings and LoD1 relief in compliance with the GML 2.0 schema, including appearance and X3D materials.It finally writes all features in a CityModel, which is composed of several feature types on FME (CityModel, Building, Building Parts, etc...) The workspace runs without any errors when feature caching is enabled, and it delivers all features validated according to the CityGML schema. Examples:Center point -23.593186, -46.669269, offset 50m to all cardinal directions.Same center point, offset 100m to all cardinal directions. The problem rises whe

Hi all, I am designing an automated proces to transform a File Geodatabase into a GML that is validated by an XSD. The validation fails, because the gml_id is part of the geometry trait of the feature, where this shouldn't be the case. When temporarily turning the validate output parameter off, the result looks like this: The red line in the picture above indicates the gml_id I'm talking about. For the XSD validation to work, the gml_id in the geometry needs to be removed. When checking the attributes of the point feature, I see that the gml_id clearly is a geometry trait of this feature. See the picture below: With this information, I made the assumption that with a GeometryPropertyRemover, this gml_id could easily be removed, leaving me with only the coordinate system, the dimensions and the actual geometry. I used a GeometryPropertyRemover with the following settings. Note that my client uses FME 2018: After running the workspace, the FME Data Inspector shows that the gml_id

Newbi question, if i have a table where i want to splitt a collumn into two how woud I do that. Existing formatColumn a , Column B, Column CIndex,0,02022-01,100,2452022-02,101, 1452022-03, 90, 200North,0,02022-02,23, 1232022-03,35,250South,0,02022-01,87,100 Now I need to isolate the column a and the heading values, Index, North, South and make a new column Column a , Column B, Column C, New ColumnIndex,0,0,index2022-01,100,245, index2022-02,101, 145, index2022-03, 90, 200, indexNorth,0,0, north2022-02,23, 123, north2022-03,35,250, NorthSouth,0,0, South2022-01,87,100, South The source can be an excel or a db table. Target is a db tableHow do I do that?

I have a workflow in which i convert .dgn and .dwg files to postgis, in this process I spatially join the text to areas, as I need them for attributes. My problem is the text alignment for the dwg files is baseline_left.Even though my colleague centered these. Is there any workaround, or possibility to get the placement to center?I've tried using an offsetter, but the areas are very different in size, so the offset is not uniform distributed between the points.  The .dgn files does not have this problem.  EDIT: The problem is that: the placement of the points are not what my colleague sees in her program, there they are centered. But they are not centered in the areas when I open the file in FME.  Thanks in advanceJonathan

I am trying to use the BIM360 Docs Connector transformer and it is throwing an error related to a Python library. The error is "No module named 'fmepy_autodesk_bim360docs'". I had originally setup a custom Python interpreter environment using Anaconda so I originally thought it might be that. However, I changed the environment back in FME to Python 3.X (I tried 3.6, 3.7, and 3.8) but no luck. I did check the FME python install location for this file with no luck. Has anyone seen this before?

The SurfaceModeller transformer seems to not pass through the fme_basename attribute. I want to pass the name of the file through to the writer at the end of the chain. Is there another way I can do this without using the fme_basename attr?

What is the capability of FME server and what can do more?

Hi everyone, I have a question about my thesis.I have a point layer witch including data about the traffic(speed, cars number ect..). And I have a road layer. I don’t know how to connect the the point layer to the line as the closest segment of the line get the datas from the closest pont…I have gps points that indicate the speed of a car, I want to sum them around 50 meters averages them. which transformer offers and how it would be worth usingThanks in advance

Hi, I think I found a super obscure bug in StringSearcher. In my workspace I want to use Regex queries based on different conditions, e.g. if a string matches RegEx A use RegEx B in StringSearcher. This logic does work in general but for one specific query I get the Error:  "Expression Evaluation Failure: 'This FME edition does not recognize the `' function." Oddly the query works fine when I test it in the RegEx Editor. It also works if I don't use a condition or if I use a different query inside the condition. Is this a bug or am I missing something? Attached an example workspace that illustrates the issue. Thank you for your help! 

Hi everyone, is there a way to parse input in text user parameter before running a Serverapp? Let's say I only want to accept letters (A-Z,a-z) as input in text parameter and notify the user immediately if any number (0-9) is used.  I'm cerain that this check can be done at workspace excecution, but that would already be to late as all the given values for user parameters can't be kept and must be re-entered at a necessary rerun. Thanks for your answers!

I think I've used QGIS to its limits and as far as I know ArcGIS don't have any tool different that might be of help for me. Since I've heard about it a a lot yet never used it, I thought FME might have more options to do what I need. If I can do what I've got in my mind I am going to purchase the required license. Basically I've got a very large and complex polygon road network and my main target is to divide those polygons into smaller polygons with almost equal lengths. Also divide them vertically with a centreline if the width of the polygon is above a certain length. But complexity makes things really difficult. In two separate questions, more details on this issue are available on gis stackexchange. https://gis.stackexchange.com/questions/423160/how-to-subdivide-road-polygons-into-equal-distance-polygons-while-also-verticall https://gis.stackexchange.com/questions/423773/subdividing-very-complex-and-big-road-polygon-data-into-almost-equal-sized-piece

Hello, I have a fairly complex flow with lots of SQLexecutors.Recently I had to use also Oracle spatial Writers. The SQL Executor has useful output ports that pass the feature. This allows for example to handle successful or failed writes. The Writer has none of those, seems more like an dead-end. Is it possible to catch an error on feature write somehow?  Thanks in advance

I have a set of labelpoints that I want to flip to make it readable from a viewpoint from the side in 3D. Is there a transformer that does the trick? Thanks