Transformers

I have a workbench that creates a table based on a number of joins that are on occasion, filtered on an attribute. Instead of manually entering the attribute values, I’d to read a list of attributes from, say, an Excel doc e.g. NSG001, NSO001, TES001 so I don’t have lots of duplicated transformers. How do I iterate through a list of values and plug them into FeatureJoiners without duplicating lots of stuff. 

Hi,I need using attribute value to create another attribute, but the @Value<attributeName> no work in attribute creator.Can you help me? Thank´s

 Hi everyone,I have a set of consecutive lines, and I need to detect when there is a digitization direction conflict between them. As shown in the image below, the green arrows represent the direction of my lines, but Line 2 is oriented differently compared to the others.Is there a way in FME to detect such conflicts? Ideally, I’d like to flag or filter out the lines that have a reversed direction compared to their neighbors.  

I’ve read a couple of posts on this, but I’m still not perfectly sure on how this works.I have over almost a year been working on and refining a flow. Since I keep getting new updates from the project, the flows has became large. It became into 3 flows, that could maybe have become 1, but I don’t think it would be that easy, at least I’m not up for that task. It consist of multiple feature readers and multiple feature writers. Each flow takes up some data from the other. For example something can have been made in a file Geodatabase or on ArcGIS Online, and the next flow would then use that content.So, I easily enough just want to run those 3 flows, by one click in workbench. I would expect just to create something like this. I just find it’s strange to connect it like that.Is it that easy?  

I have different IFC files which I want to read and transform.The geometries each contain a Transformation Matrix. From the FME Form Documentation I know they are not applied.How can I apply them?I tried to extract the parameters (with TransformationMatrixExtractor) and then used the 3DAffiner, but with no result.Ther must be a more convenient way, right?!

Hi all, I have a workspace that preps all input features by reprojecting them to GDA94/ Australian Albers and then calculates input area. When I run the same feature (as a shapefile, but different different coordinate systems) I get different Area values even though they’re both in the same Coordinate System.I ended up testing the features with an AreaOnAreaOverlayer and turns of there’s really tiny slivers across the boundary of the feature (I don’t know where these slivers are coming from?). I added both the shapefiles in ArcGIS Pro and followed the same process- reproject and calculate area and both area values are coming out as the same in Pro. I am unable to figure out why I’m getting this difference in areas in FME but not ArcGIS Pro. The difference is tiny but ends up changing the final stats.Screenshots attached. Any help would be greatly appreciated.  

How to convert polyhedralsurfaces(voxels) stored in database with addtional attributes stored in columns into cesium 3dtiles?Additionaly to export the data in a suitable format to view voxel and its attributes?

Hi Everyone, I’m kind of stuck with a problem with my Geopackage writer. For a client, I’m working on building a script that generates multiple Geopackage tables, each with its own name. Each Geopackage table writer uses a fanout to automatically provide the writer with the needed file name. The writer also uses a Geopackage with styling embedded in the database, with 0 features, as a template file. This template is provided by an engineer from the team, which should automatically style the Geopackage based on the attributes it has. The problem occurs when I have both fanout and template file enabled. This causes the Geopackage to only write certain features. I can’t find any logic behind why it writes some features and not others. The template file and the Geopackage writer are 1-to-1 copies of each other, and I get no errors/warnings regarding feature issues. For example, one table, which consists of 470 features, will write 233 features, and 237 features end up somewhere in space. :

  Im fairly new to FME, I have a programming background, and I was hoping to bring those skill here, but i can see is not fully the same. So I apologize before hand 😂 I have a custom transformer that does a API calls and loops until it finds “last-batch” set to true from the Header area. For Reference Here is the custom transformer:The first call uses uses the InitialHTTPCaller, which uses the the request url and access token from the main workbench. Here is a screen cap: The _response_header list will have the variables I need to determine if the its the last-batch = true and the next batch url. The JSONFragmenter, is exposing the values for _response_header{5}.value,_response_header{6}.value.I have a tester that checks if _response_header(5) is true to go the pass else it will fail and will go to Output and call upon the Loop to the NextPage.  When the NextHTTPCaller gets called it will be using the User Parameter named NextUrl of which im setting it with the @Value(_response_header

Hi,Does anyone know of a method where I can readily identify which transformers are affected (ie need an update / fixed / superseded!) when updating from one version to another?Whilst I know there is documentation with each release, is there an easy way to compile a list that could be read into a workbench?I am also aware that each transformer has a version number.I want to create a method for identifying which workbenches are going to break before updating the software!I am hoping someone has already thought of this and the solution is already built… Any help much appreciated.Stu

Hi Im using the AGOL feature service writer to write to our AGOL account but it is not working correctly. The workbench reports that it has been successful with the correct number of features. However, when you open the item in AGOL, there are features missing. The last one I tried had 80k reported to have written but only 4k in AGOL!If I use write a fgdb locally and then the ‘ArcGIS Online Connector’ transformer to upload the file and another to publish it, it works fine. However, I cant work out how I could use this to do updates to the hosted feature service when the data changes (Ive got this sorted with the writer)Im using FME 2023.2 (dont really want to upgrade until 2025.1 is out as its a proper pain to upgrade server) but if there is an issue with the older version of this transformer I will.Does anyone know why the writer is not working but the connector is? This data is business critical so I need to ensure that it is correct.Thanks

Hi,First off, excuse my ignorance in this question - im a beginner. Please let me know if any additional details would be helpful.I am using the HTTPCaller transformer to run a print POST from an AGOL app (Experience Builder).I’m able to successfully run the HTTPCaller and pull the response_body containing the output pdf URL. Id like to now run another transformer to download that pdf locally. Any suggestions on the next transformer to achieve this? An example of the URL: https://utility.arcgisonline.com/arcgis/rest/directories/arcgisoutput/Utilities/PrintingTools_GPServer/_ags_mapfile_name_hear.pdfMuch thanks!

Hi,I need to find the average distance of 25 nearest neighbours in a point layer. I have tried with Neighborfinder set to 25 number of neighbours to find and generate a list, then a ListExploder to expose the list, but I don't know how to group the 25 neighbours to calculate the average distance of these 25 neighbours to the base point Im gettin this of ListExploder: idRecord it’s the ID of points.Any ideas for grouping the 25 neighbours to calculate the average distance?Thanks you all.

Hi guys!I'm trying to export a list of the completed jobs using the FME Rest API, but I can't seem to get it done. What I want is basically a list of all the completed jobs, including the start time, end time, job id, engine, workspace name etc. For this, I'm using FME Form, a creator connected to a http-caller. Used the following Request URL: /fmerest/v3/jobs/completed?status=SUCCESS/fmerest/v3/jobs/completedAnd a few others.I got two headers, one with the token and one with the content type.The errors are being returned:{"message":"null for uri….}Does anyone know a solution for this?

I'm trying to use RasterClipOverlay to extract an area on GeoTIFF defined by a polygon.  FME is currently giving me the incorrect area.  The Workspace: The workspace has a polygon coming from a POSTGIS layer which is filtered. It also has an GeoTIFF  both of which are inputs to the RasterClipOverlay.  The results are output to a GEOTIFF.  As a test I have also added a simple output image that does not come from the RasterClipOverlay. Both the polygon and image are in the same projection EPSG:3395.The original image (displayed in QGIS):   The polygon (in QGIS):The results: Displayed in QGIS with Open Street Map behind and the polygon overlaid.​​​​As you see from the results, the area of the map is not correctly extracted.  The polygon is supposed to cut out the sea, however, it also cuts the map boundaries and part of the land. The shape of the cut is correct however the map is “shrunk” hence the area of the map is incorrect. This is just one example, I have various other maps I’m worki

Im wanting to see the http it’s generating so i can understand where its going wrong. Is there a way to see this - without it being submitted? Or even if it’s being submitted? Im sure im missing something. JKW

I am using FME Form 2024.0 to read an excel file for processing.  The reader is not determining the correct max length of multiple text fields in the XLSX file.I have set the max rows to scan to a value larger than the total row but short of manually setting these values I cannot get the reader to detect the correct field length.The FME Help for the MS Excel Reader states to leave this setting blank to scan all rows but the transformer will not except a blank value.I also tried to use the FeatureReader rather than a standard Excel Reader with the same results.  I want this to be dynamic as the data being read is variable.  Any suggestions or workarounds?

Hi,How can create a published reader parameter for gdb feature classes?The gdb conation Point, line Polygon feature 

Apparently this feature was finally introduced 5 months ago, yay. I’ve been waiting for this for 5 years.I’ve just tested it today, with a PKCS#12 certificate, and unfortunately it doesn’t work.We’ve sofar been using our own C# service provider for this, and the certificate is used here on a daily basis with success. And I’ve verified the private key password.Has anyone tried this feature (with PKCS#12) yet with success ?Using 2024.2.3 (build 24825).Cheers.

Reading laz from Local / Network drive throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it.Any ideas why this happens?

I need to use FeatureMerger or FeatureJoiner based on two varchar(200) attributes.Visually those values do match. No white spaces trailing anywhere, the strings are the same, yet neither FeatureMerger nor FeatureJoiner are able to combine the data. settings for FeatureJoinerAs an example from the the Feature Information pane right attribute to join onleft attribute to join onThe join/merge is supposed to happen within a custom transformer, but I also tried it in the main workflow, where I received the same results. FeatureMerger is in version 21, andFeatureJoiner is in version 1001. Any suggestion on how I can identify the culprit and get these features to join/merge?

Hi All,I have been trying to put a workflow together to linear referencing a few event tables in GIS. I usually do the task in ArcGIS but this time I want to automate the process as much I can.I have been checking a few of the LRS FME tutorials online but can’t get it to work. The aim is to linear referencing speeds along a railway route (line) using an event table that relates the lines and speeds.The input of my workflow as follows:Event table (xls) that shows the Line and speeds, example below: Line geometry with the line ID as well the ‘From_Chain’ and ‘To_Chain’ fields as parts of the attribute I have got to this point in the automation but can’t get the Snipper to work for some reason since doesn’t split the lines according to the speed lengths:  Any advise how to accomplish the task?Thanks 

FeatureReader setup with a parameterized connection.If an incorrect connection is selected, the errors are reported “The error number from ArcObjects is: '-2147216100'. The error message from ArcObjects is: {Insufficient permissions” But the workspace doesn’t terminate and nothing exits the rejected port of the FeatureReader. Rejected Feature Handling is set to Terminate Translation. I would expect the workspace to fail/and or output from the rejected port on this sort of error FME 2024.1 (Form & Flow)

Hello all,I have a Workspace that makes the reverse geocoding using PythonCaller.import fme import fmeobjects import json ,urllib2 # def processFeature(feature): att = urllib2.urlopen('http://maps.googleapis.com/maps/api/geocode/json?latlng=-23.2186725,-45.9056706') data = json.load(att) print "o json é ", dataWhen i run my workspace i see the results on the log file because i put the Print: How can i get this result with a new attribute?Thanks in Advance,Danilo de Lima

Hi, I just upgraded FME Form and FME Flow from 2024.0 to 2024.2.3. One of my jobs failed using a FeatureReader with the Directory and File Pathnames due to the extension not being in all caps because the extension on the file it’s looking for is in all caps (.CSV). Originally the parameter was set to filename.csv and the FeatureReader would have no issues finding the file on 2024.0. Now the FeatureReader is not able to find the file in 2024.2.3. I changed the parameter to all caps .CSV in the featureReader and it finds the file with no issue. Anyone else noticing this with 2024.2.3?