Transformers

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.

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 

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

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  

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.

How can calculate width of polygon in case rivers or roads?I have a road data and I need to know how minimum width of each segment of roads. I tried with some steps such as below:- First: from road polygon I generate centerline by CenterLineReplacer Transformer- After that: I used Chopper Transformer to chopped the Centerline into segments with mode "by vertex". - Next: I rotate all vertex with 90 degree and I extend line with a length (my problem is here). With road data which have more branch, and each branch have width difference, some case the range between minimum and maximum is so big (e.g. minimum is 0.5 met but maximum is 200 m). So when set the length parameter it not right for all branch. - Next: I

@takashiHi all I'm splitting buffered road polygons into chunks using the BoundSplitter transformer and it works very well for straight polygons, but it does not serve my needs for polygons that have a higher degree of curvature/angularity.I need the split to be approx every 100 m and perpendicular (or close to perpendicular) to the road that is being buffered. When the road has a lot of curves this does not work. I am using "Oriented bounding box, longer side direction"Example of curvy polygon: BoundSplitter strip polygon oriented to buffer polygon.Curvy polygon after boundsplitter:Because of the difference in

Every week I have to update a File Geodatabase in AGOL using “Update Data”. What transformer would I use in FME Form to automatically update the data without me having to sign into AGOL and drag/drop the zipped file? My ultimate goal is to add this to an existing workbench and create an Automation in FME Flow where this is done automatically each week.