Transformers

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 

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 :(

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 

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 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.

Hi everyone,I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours.When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error:413 Client Error: Request Entity Too LargeOccasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists.I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations.Any insights or recommendations would be greatly appreciated!Thanks in advance.

   how can i turn this in FME????  login and get cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -c cookies.txt https://<host>/Webcontrols/xmlsql login with cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -b cookies.txt  https://<host>/Webcontrols/j_security_check echo "Get data from iprotect"query results to get data:curl -k -X POST -d @$base_dir/sql/acceskey.xml -b cookies.txt https://<host>/Webcontrols/xmlsql  --output acceskey_iprotect.xmlin the acceskey.xml is an xml format query select * from <table>output gives the data in xml format 

Hi. I’ve built a data cleaning workspace that performs a number of different tests, creating or retaining different attributes for each. I’ve created an ‘error type’ attribute to fan out by, have added schema scanners and have followed the gist of this. However, I cannot seem to get the writer to respect the varying schemas for each tab. Set up like this:   Pointers appreciated. Many thanks

Hello, I have seen similar threads but i cannot seem to get what i need to work. New to FME and I have a .img file with 1440 bands. Trying to rename the bands to dates as each band is a dataset a month apart. I have an excel spreadsheet with the original band names and the new names i want but after a lot of trying have not been successful.  Please could I have some help with this.  thank you 

Hi all,I hope to get a few hints in the following issue.Issue - Unable to reproject the dataset into GDA2020 zone 56Dataset URL - The dataset is displayed in the form of WFSDataset Coordinate system - LL-GDA94Dataset EPSG - 4293I have used different transformers to place the dataset in the right location with no success.I think the issue lies in using the right transformers so any hints would be greatly appreciated.Thank you very much in advance,Sebastian.  

I have a workbench that creates output for bentley Microstation. While trying to debug an issue of cells not appearing in the output, I found the VertexCreator deleting an attribute igds_type (microstation format attribute) in the processed features. Pictured is a basic configuration for reproducing the conditions.The version used is 2022.2. I have a simple workaround, but it did take a while to figure out what was going on.I wouldn’t have expected this transformer to touch the attributes at all. Is there a reason for this and does it affect any other attributes? 

Hello,I have GML file with polygons. Polygons are defined by coordinates inside LinearRing attribute. There are some other attributes, one of which is an ID of a polygon.I want to transform that GML to DXF format (only polygons and IDs (as texts) which have to be placed inside the polygons) and I have managed to do so, but I have a problem with some funny shaped polygons for which ID falls outside the polygon.What do I have to do to make sure those texts (IDs) in DXF are put inside corresponding polygons?Thanks in advance for any suggestions.Best regards! 

I'm looking for support with Navisworks (AutoDesk) BIM data (.nwd .nwf .nwc). I need to extract the full 6D information from the model and output it to other formats but also update the 6D information back to the model. Navisworks imports IFC but does not seem to export it. DWF, which can be written with Navisworks, does not hold the 6D information.Any help would be appreciated.

Hi ​@safe I attended the webinar yesterday and wanted to dive a little bit deeper in the AI Agents/transformers. Unfortunately you shared only the video and the slides to the webinar yesterday. Is it possible to get the workbenches and data as well?That would be a great help for a (AI-) beginner like me. Thanks in advance.Tom

In a file geodatabase, I have created over 400 feature classes. To each feature class, attributes will be added. Therefore I have created a workbench in which several tables are joined. An intermediate result is a table which contains a field called ‘Attribuut’. This column contains the names of all the target attributes, each row one attribute. This intermediate table also contains a field (‘Gegevenstype’) which describes how the future attribute is defined (field type). A simple ‘Attribute creator’ transformer does not do the job. I have read and tried several possible solutions on the FME-forum, but unfortunately without result. To understand how the process works, a tester is added to create a table for one specific feature class. When the process functions properly, a loop will be added to perform the job for all objecttypes.Can anyone help???

I am creating an AGOL to KML converter. I want all labels to be off when viewing in google earth, but I can not find how to disable point feature labels. These points are represented by icons. I have set the opacity to 0 using the KMLStyler and the setting for “Create Labels on Lines” is set to No (which successfully disables line labels), but the labels for point features still appear. There also appears to be no option to remove labels in the KMLPropertySetter.

Hi All,I wanted to dissolve (or merge) little slivers with the biggest adjacent polygon to harmonise my data, an example below where you can see the little slivers (selected): How can I achieve this with FME?Thanks :)

Hi,I have a workspace transforming data to write it in INSPIRE GML format (theme Hydrography). Earlier this year, some of the INSPIRE application schemas (XSDs) where upgraded to a new version Include changes from 2024.1 schema release · Issue #1027 · INSPIRE-MIF/helpdesk-validator, including the hy-p one that I’m using here (v4.0 to v5.0).Therefore I changed my INSPIRE GML writer to point to the new XSD URI and adapted the xsi:schemaLocation parameter consequently. However, when indicating the v5.0 the output GML is not written correctly: there are remnants of the v4.0 in it.First in the imports, see xmlns:hy-p4 and xmlns:hy4:<gml:FeatureCollection xmlns:omor="http://inspire.ec.europa.eu/schemas/omor/3.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sr="http://inspire.ec.europa.eu/schemas/sr/4.0" xmlns:base="http://inspire.ec.europa.eu/schemas/base/4.0" xmlns:gts="http://www.isotc211.org/2005/gts" xmlns:hy-n="http://inspire.ec.europa.eu/schemas/hy-n/4.0" xmlns:omop="

Hi all - fairly new to FME here.I am trying to do a calculation using the ExpressionEvaluator to calculate tree protection zone (TPZ) estimate, and round to 2 decimal places. The formula I’m using is @round(@Value(average_dbh_value) * 0.12, 2) I also need to incorporate min and max values into the output. Min is 2 and Max is 15. This is where I’m getting stuck. Would someone be able to provide a suggestion on how I can possibly achieve this? ThanksLeanne

Its not working with the latest FME flow. Metadata in agol is nt updated.It use to work previously.The meta data is is being read from the arcsde reader from oracle database.

I have a large number of spatial tables, each potentially having dozens of date fields. I need to check the dates in each of these fields to check they are greater than a certain data (01/01/1900?). These tables are being taken from Oracle and uploaded to AGOL. If there are any dodgy dates, it appears to break AGOL and no spatial data appears for the whole dataset!Is there a way to automatically select fields with a type of date or date time and check validate each row for each date field is above that date? That way I could investigate and correct before the data is transferred. There doesnt seem to be any kind of filter for attribute type.Once I have done this, I will need to do something similar with varchar fields as AGOL doesnt like certain characters.Many thanks