FME Form

(on FME 2020.2) Hi,  I have a workspace with an Oracle reader in which I want to filter the features to read with a WHERE clause on a column, let's say COLUMN_A. I created a Choice type published parameter named colA, which contains the possible values for this column.This way I can filter the features from my table when COLUMN_A contains the value selected in the Choice list. The WHERE clause is : "COLUMN_A" = '$(colA)'Quotes character are used to handle the values with spaces. Problem : the values can contains the quote character as well !What is expected for the database (Oracle) is that the simple quote in the value should be doubled. For exemple the colA value TES'T should be transformed to TES''T. I tried to find a way to replace the simple quotes with two quotes in the WHERE clause using SQL string functions, without success because it always require to have the doubled quote. The only workaround I found for the moment is to change the Choice parameter to a Choice with alias par

   Hi, Is the following possible?An FME workspace writes to a table. After the writers are ready I want that process to continue with other transformers and an other writer which must be writing last. I don't want to create 2 workspaces. 

I have an array of polygons representing a surface triangulation.Because of the source of the data, some faces are vertical which aren't supported in the TIN I'm trying to create.Any ideas on what would be the best way to overcome this? I'm sure its a common issue, be interested to see how others handle it.Maybe convert to lines, filter overlapping lines with different Z values and offset both a small amount?

I’m struggling with the TopologyBuilder transformer and, since I’m sure my use case is quite common, I hope someone might be able to help me. I want to extract the topological boundary polyline from polygons. In addition to the polyline geometry, I’d like to carry polygon attributes through to left and right-side attributes of each new polyline. For example, if my input polygons were countries of the world, I’d like my output polylines to be borders with each attributed with the country on each side. e.g. Left: France, Right: Germany. I’ve got the polylines geometry coming out of the TopologyBuilder perfectly, but not so lucky on the attributes. I get _left_face and _right_face attributes coming out, but these edge IDs don’t seem to mean anything. They don’t relate to any input attributes, nor are the polygon table row id. I’ve also tried “Generate List From Input Faces”, defined a list name, Selected Attributes, and my attribute field name. Sadly, none of these are populated on the ou

FME Desktop 2022: What is the equivalent tool for ArcGIS “join field” in FME? I couldn’t figure out if there is a tool that’s equivalent tool for ArcGIS “join field” in FME. For example, in the screenshot below, I wanted to join the attribute table of the layer L1 with the table T1 to end up with having all the fields of table T1 in the layer L1           

I've found this documentation that mentions that comma should be surrounded with quotes when using in string functions. But the case now that I receive a file name (which contain comma) in a published parameter, then I want to replace part of the file path with some other string using "StringReplacer" function. I can't do this as the value retrieved in the published parameter has already the comma. Any Advise?

HelloI 'm trying to have the Fanout output directory stamped by date, I successfully did that except FME creates 2 folders of same content except one with the date stamp and the other without. Both directories are identical from inside, any advice?I'm using the parquet writer to export Revit elements properties to parquet files, here is my settings for output directory.The output comes as following:What I was expecting is the folder with date only???The same other folder "rst_basic_sample_project" with all its content is replicated in "2022-02-17"I only want "2022-02-17"

is there a way to convert mxd to cad? including all the symbology?

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?