Transformers

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 here and 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 buf

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 Large Occasionally, 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.xml in 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 56 Dataset URL - The dataset is displayed in the form of WFS Dataset Coordinate system - LL-GDA94 Dataset EPSG - 4293 I 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? Thanks Leanne

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

Prior to Desktop Version 2022. I could read an AGOL service with attachments relatively fast. Now with 2022, it doesn't seem to work at all. I can view the source from the workbench ok, I can read the features in if I disable read attachments. But it doesn't seem to work with read attachments set to Yes any more. The log gets stuck at 'Updating Access Token for..." Updating the token doesn't help either. Has anyone else had this issue? Thanks

Hi, I have a GDB with different layers with 3D multipatch data. I want to analyze the layers between each others and find the nearest neighbor. Like a NeighborFinder in 3D mode. How can I do that? NeighborFinder only supports 2D mode. Thanks.

I want to use the StringReplacer to edit a couple of attributes, but their names are not known in advance. Can I save a list of attribute names in an attribute and tell the StringReplacer to work on these attributes?

Hello everyone,I am looking to linearize hedge polygons generated by AI. Since linearization is an iterative process, I need to cut the godzillas into smaller polygons to reduce computation time. I have already tried using the Chopper transformer to make cuts, but unfortunately, at the cut points, the linear features lose their continuity, as you can see in the screenshot below. The offsets are several meters, so I don’t think post-processing to reconnect the linear features afterward is a good solution—I might end up connecting the wrong ones. I am therefore looking to cut my polygons along lines perpendicular to the median axis of the polygons. Below, I have attached my current FME workflow. I believe what I’m missing is the creation of the perpendicular lines and the interval at which to create them. If you know the transformers missing and their links it would be amazing. If you have any other ideas, I’d love to hear them! Thank you all.