FME Form

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

Hi all,I have to create a workflow where we are retrieving public data, either through download or URL and running it through FME for data processing and publishing to our SDE.  The idea is then that this process should be fully automated by adding the FME script as a spatial ETL tool in ArcGIS Pro, and then publishing it as a web tool to an ArcGIS server with DI extension for server.  This way we can just schedule that tool to run on a monthly basis, where new data is downloaded and being published to our SDE without us having to do anything :-) My problem is this: How do I handle the data and data connections in my script? Can I set up some parameters ensuring that even though my script is now running as a web tool on a different server, it still has a data connection to my SDE? And can I ensure that access to my "downloaded" or URL data is still intact through the web tool on the server, for instance using some kind of scratch folder?  Should I set a FME_TEMP Environment v

Anyone run into this error before trying to write data to ArcGIS Online with the writer (applyEdits)? In this instance, this came from ArcGIS Data Interop running on ArcGIS Server.{"code":1000,"description":"The request limit has been reached. Contact esri support for assistance."}(Also cross posted on the esri community)

Hello,This is my first use of the Writer with Oracle, I only used SQLExecutor before.  The problem is, all features are stored correctly, but I cannot get the Writer to store the geometry - it just remains empty.  First I put the name of the table and have specified the spatial column like this:Secondly I basically enumerate all columns:It works, but no geometries are being stored in the "AREA" column. All features come with geometry, I see them cached in the Inspector.  Thanks for any suggestions!   

Hi! I'm validating the quality of the CityGML and CityJSON building datasets. I'm wondering what is the real difference between all self-intersection rules implemented in the FME's GeometryValidator. So shortly: Is the rule Self-Intersection in 2D same as the Self-Intersection under the OGC Valid and OGC Simple?  I think I understand the difference between Ring Self-Intersection, Surface Self-Intersect and Shells Intersect at least. Still, I would be grateful for proper definitions of all these errors. The document of GeometryValidator is a little bit unclear in the case of these "sub-errors". Thank you a lot!

Hello, i have a point cloud data file in e57 format and i plan to reduce it by transform PointCloudSimplifier. There is my workspace.And it appears that warning "The workspace may run slower because features are being recorded on all output ports". The data is very large, more than 100GB, so i wish it cloud be processed faster.​I'm not exactly sure what "recorded on all output ports" means, what should i do? Do i need to add a transform like AttributeManager between the Reader and PointCloudSimplifier or something else?Thank you in advance!