Transformers

Hi, I have HTML content stored in a table's html_content attribute, and file names in a file_name attribute. How can I upload these directly to Azure Blob Storage using the FME Azure Storage connector without writing local files or using the HTTPCaller? Is it possible to provide the HTML content directly to the connector as an attribute? I need to dynamically set the blob name using the file_name attribute. Any help is appreciated!

Hi there, I’m using the ChangeDetector to update some point data in a ESRI enterprise geodatabase (SDE). I’ve set up the CHangeDetector to check geometry as well as attributes. I have 3 points out of 1224 that seems to being updated due to a geometry difference. I think it’s just that typical geometry change you get between FME and SDE so I have set the vector tolerance to 0.001 which is very generous. I’ve try all the various settings 2D, Lenient Geometry even changing the tolerance to 0.01 but these still come up as being updated. Below are my setting for the ChangeDetector: I’ve specified a change list and it used to be that you could see the original coordinates and the revised coordinates so you could tell if it was a real change or just a artifact but I can’t for the life of me see where to find these coordinates anymore. It just gives me nothing in the change list: Can anyone tell me where I can see these coordinates? Or why these three points are behaving this way and what to d

Hello, I’m using Feature Writer to save my output in mdb format. I want to name the output file by User Parameter. When I run the workflow in FME Form, the file named by my input user parameter is generated correctly. When publishing to FME Flow, the user parameter is ignored and the output file is named randomly (e.g. “FME_5C2B2C70_1739440402445_7677.mdb”). In the log I can see that the parameter is not read, so the output name is empty. This is how it looks like when publishing the workflow: I’m using FME 2024.2.2 Do you know if this can be fixed? Thank you for your replies!

Hey. Does anybody know how to solve the situation where I need zipextractor to not preserve the tree structure of the archive ( if it contains subfolders ) and save the file itself? Thank you

I want to build a flat JSON array using the jsontemplater. I try to use this example to understand the syntax but using the pipe character does not go well. Starting with a simple creator for the root object and sending the actual information to the ‘ADDRESSES’ sub template. I try to define the root template as [| fme:process-features("ADDRESSES")|] and the sub template as { "ID": fme:get-attribute("Site_ID"), "Address": fme:get-attribute("Address")} Taking it from the linked example the pipe character is needed to separate the array items by commas. My translation log return the following warnings, and error message JSONTemplater (XMLTemplaterFactory): The following error occurred near line 1, column 3 of the query: JSONTemplater (XMLTemplaterFactory): invalid expression: syntax error, unexpected "|" JSONTemplater (XMLTemplaterFactory): An error occurred while parsing the ROOT template How do I use the jsontemplater to create some flat JSON array structured as [ { "ID": "Site_ID", "Ad

Hello, Using SpatialRelator, I want to test if a feature line from Requestor, is "Requestor is OGC-Within Supplier", where supplier is an other layer line. If end vertex of line are the same, the test works but otherwise doesn’t work. OK NOK

Hello , I'm working on finding the path for specific lines and reorder points .I have several lines, each defined by a start and end point, but these lines also contain intermediate points. Should I merge the intermediate points with the lines before using a shortest path finder, or how will the transformer know which intermediate points belong to each line if I don't provide them? My goal is to reorder all points, including the intermediate ones, to find the correct sequence from point A to the final point, such as A, B, C, D, E, F, G. Thanks in advance

Hello, I am seeking help with using a Regex to replace the first instance of an underscore in a string. I am using a BulkAttributeRenamer to rename a series of attributes with multiple underscores like this as an example: 0_4_C11_M I am trying to replace just the first underscore in the string with a dash with a regex replace to change the name from 0_4_C11_M to 0-4_C11_M. The regex I’m using is ([\_]+) When I test that expression in RegEx101 is does exactly what I need and only replaces the first underscore in the string as shown below: However, when I use the same expression in the BulkAttributeRenamer it’s returning and replacing all underscores as shown below: Hoping someone can help with advice on how to limit the return to just the first underscore in the string please - it the expression incorrect or is there something else I need to add to the parameters? Thanks :)

I am trying to find shortest distance from all points in red to all other points in green using network connecting all of them. The point feature has only types (A,B).Is it possible to have the short path finder to search the path always staring from point A to pint B.

Some workspace of us is using ogr2ogr to move data from one postgres db towards another (more performant then setting up a FDW in postgres itself and more performant then FME for doing the data move). Calling this via the system caller shows all information in the log file (including password information). Is there a way to avoid this more recent then this post:

I am creating a set of workbooks which require the correct value being set on a session based temporary table in a postgis database. To achieve this, I am using a multiline sqlexecutor, where the first query calls a function which sets the values, and the second query returns the values. The issue I am having is that the transformer is only returning a value for the first function call. FME_SQL_DELIMITER ;SELECT sms_1transact.goto_checkpoint('$(end_transaction_name)');SELECT "A"."fid", "A"."theme", ST_Envelope("A"."geom") [...] -- « This is the result I want returned by the transformer. I cannot change anything about the database I am getting the data from, as it is third party, and isnt in scope for change. For an earlier call, I am using the “SQL to Run Before Read” on the Reader, which works fine, but this second query is dependent of the values retrieved in the first, so needs to be inline.

We have been putting together a transformer using the FME Packages SDK using FME Packages SDK Guide. As part of the package we are using the fmeobjects.FMEUniversalReader to read features. When we pipe the features to pyoutput to one of the transformers output ports all the attributes are not exposed. As the UnversalReader in our package references parameters in the transformer the attributes will not be consistent. Is there a way to make the attributes exposed on the output? Thanks Brad

Case: To get an unified look I am trying to aggreagate line features before offsetting them. Once they are offset I want to deaggregate them back to their original geometries and attributes. I assume using ‘Geometry - Assemble hierarchy’ in the Aggregator is the way to go. Unfortunately I find the documentation a bit confusing. Q1: Could someone please explain the parent - child concept? I have features and their attributes, so two(?) levels deep. I want to “pack” and then “unpack” them. But I don’t understand where to get the ‘parent ID’ or ‘child ID list attribute’? It would make sense to me that they were created when I group the features, not before? Q2: In the documentation the word nodes is used frequently. I guess this should be understood as ‘parts’? NB this might not even work. When using the setting ‘geometry - assemble one level’ features wont deaggregate after being offset. If it is also so when using Hierarchies, is there an other tool to achieve my desired result?

As the short path finder requires FROM.TO. input with line terwork.I have a data that has 680(From) and 1882(TO). So the From To table will be 1,279,760 record which takes too much time. For analysis..My data extent is 1500m*4000m.The farthest From To path in my data never exceed 300m.My idea is to create a table using neiblghbour finder to search for all( From) point to TO points with a tolerance 300. OR within a boundary. Or something like excluding the To found with minimum distance shirt path finder found. Is this valid?I'm trying to minimize the matrix created by FME to reduce the process for short path finder.Any help or ideas.?

Hi, I have multiple lines / links that each have attribute per feuture ID Vehicle Load 1 0 2 300 3 250 In this case I would like all of them to create a single line with the total load, so new ID:4 and load:550. not keep the old ones. This is the easier part however ther are intersections as well. Some times very complex ones: Preferably this should be 2 lines with one node in the center. Maybe 2 parallell ones for the left lower part. I have done similar before with snapper and topologybuilder but would appreciate help. I used segment snapper. My workspace

I wish to implement a filtering procedure for the vertices of each polyline. The goal is to retain only the vertices where the elevation difference between consecutive points exceeds a specified threshold, for example, 10 cm. I have developed a script that extracts all the vertices and identifies them based on the polyline to which they belong, as well as their specific index. The process involves testing the elevation difference between each pair of consecutive points. If this difference is below the threshold, the point should be eliminated, and the process moves on to the next point. Example of the process: If Z_PL1_1​​ − Z_PL1_2​​<0.1, then point PL1_2 should be eliminated. Next test: If Z_PL1_1​​ − Z_PL1_3​​>0.1, then the point PL1_3 is retained. Next we test PL1_3 with the other points of the polyline excluding PL1_2, and so on. This principle is applied iteratively to all polylines. Problem encountered: I am facing difficulty with the implementation of iterations to apply this l

I have a workspace which writes multiple tables to a single Geopackage. When running manually it works with no errors but when running via tasks scheduler it fails with the following error: OGCGEOPACKAGE writer: A file system object called '\\xxxx\output.gpkg' already exists.2025-02-10 07:35:51| 25.2| 0.0|ERROR |OGCGEOPACKAGE writer: Unable to open or create file '\\xxxx\output.gpkg'. Please ensure the specified file exists and is accessible2025-02-10 07:35:51| 25.2| 0.0|ERROR |OGCGEOPACKAGE writer: An error has occurred. Check the logfile above for details How can I avoid this happening? Is this happening because multiple writers trying to access the same GeoPackage file simultaneously, causing a conflict? Thank you!

Hello everyone, I am reaching out because I have run into a problem recently and searched through previous thread and couldn’t quite find my issue with a solution. I am running into a hang up when I run a workspace that triggers an additional workspace through FMEFlow using FMEFlowJobSubmitter. I will paste an example of what the log looks like. FMEFlowJobSubmitter: https://your.specific. - Submitting a request to run workspace 'Your-Workspace' in repository 'YourRepository'… FMEFlowJobSubmitter: https://your.specific - Failed to submit request to run workspace ''Your-Workspace'' in repository 'YourRepository'FMEFlowJobSubmitter - 'Failure when receiving data from the peer' My workflow is submitting around 70 jobs so after this error occurs around 15 times the error switches to: Error: Failed to update access token. FME Flow error: `FME Flow error: `929026:Error: Connection reset'' FMEFlowJobSubmitter: https://your.specific - Failed to submit request to run workspace ''Your-Workspace''

Is there any possibility to use an if statement similar to the xmlTemplater: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/xmltemplater.htm The following code in the jsonTemplater returns the error "JSONTemplater_2(XMLTemplaterFactory): The following error occurred near line 2, column 50 of the query:JSONTemplater_2(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)" Suggestions and code samples would be very welcomed. { if (fme:get-attribute("IS_GRENZPUNKT") eq "1") then "1": {} else "2": {}}

I am getting some really strange results when trying to offset aggregated lines. The fat red lines below are aggregated. This is sent to an OffsetCurveGenerator, thin pink lines. In this instance it seems like the OffsetCurveGenerator treats the lines as individual parts and offsets them to different sides (I am looking at only left channel out here). In other cases it fuses the lines into unities that can not be restored afterwards with a Deaggregator. Any ideas on how to resolve this, or workarounds? Edit: I went back and checked the geometries in the examples below, there where to complaints in the GeometrValidator. This is a spinoff from my previous thread:

I have this XML that I want to update: 1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with="c:\\temp\\test.ifc"/>910 <savemodel file="c:\\temp\\test.smc"/>1112 <exit/>13 </target>14</batch> I want to read other files, for example, test1.ifc and test2.ifc in FME, and I want to add them to the XML to be like this: 1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with="c:\\temp\\test.ifc"/>910 <updatemodel file="c:\\temp\\test1.ifc" with="c:\\temp\\test1.ifc"/>1112 <updatemodel file="c:\\temp\\test2.ifc" with="c:\\temp\\test2.ifc"/>1314 <savemodel file="c:\\temp\\test.smc"/>1516 <exit/>17 </target>18</batch> Any suggestions?

Am using DateTimeConverter to change date YYYYMMDD into YYYY-MM-DD (CSV File), it is converting it when check on Visual Preview. But when open in excel, does not show it. Seeing FME_Rejection_Code = Invalid Input

Hello, I have 4 excel documents hosted on SharePoint, I am using a FeatureReader taking in a temp download path. As can be seen the 4 items are being opened successfully in the featurereader, but the data is not grouped in any meaningful way for me to extract and sort out the various excel documents data (which is varying formatting, some have multiple tabs with differing data/headers between them, as you can see there are 14 schemas (total tabs within excel docs), and 1546 generic bits of data (total rows)) I’ve read that I can re-group the datasets by using fme_basename but I cannot work out how to expose this, I’ve found the post below, which offers suggestions of how to expose that data. But the solution it offers is not applicable, I am using version Does anyone know how I can expose the fme_basename? OR Is there a better way to do this?

Currently I have 23 CoG’s in an Azure Blob container and I want to retrieve only the area of those CoG’s covered by a rectangle that I use as the initiator for a FeatureReader. Unfortunately, the FeatureReader is reading first all the CoG’s in before making the decision where the bounding box is within, and then it returns the entire CoG, where I was rather expecting it would return the part the bounding box is covering. The CoG’s originate from the Copernicus DEM coverage GLO-30, contain overviews, etc… It takes almost 3 minutes for the FeatureReader to process the request. The bounding box is within a single CoG. When looking at the parameters for the COG reader, then I can see there is actually the possibility to set a search envelope. I could feed the bounding box to the envelope, which sadly is missing in the FeatureReader. Is there a way to speed things up? I only want to have the parts of the COG’s covered by the bounding box used as initiator, basically performing a range reque

Hi All, I’m using the JSONTemplater and I am getting the following errors from FME when it parses the root template: JSONTemplater (XMLTemplaterFactory): The following error occurred near line 81, column 59 of the query:JSONTemplater (XMLTemplaterFactory): "fme.get-attribute": function with arity 1 not declared In the root template, I have the following starting on line 80: "Subfeature1Array": [ fme:process-features("Subfeature-First", "xxxNumber", fme.get-attribute("xxxNumber")) ], "Subfeature2Array": [ fme:process-features("SecondFt", "xxxNumber", fme.get-attribute("xxxNumber")) ], "Subfeature3Array": [ fme:process-features("ThirdFeat", "xxxNumber", fme.get-attribute("xxxNumber")) ] Both the root features and the sub-features have an xxxNumber attribute. I am following what is documented in the Help for the JSONTemplater “Selecting the Sub-Features to Process” section example but have no clue what the issue is. Any help would be greatly appreciated!