FME Form

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. 

I want to send ~150 users a stock email. No data translation in this one, I just want to read a list and send the email. (also a attachment, with a file that matches mostly matches their email addy but one thing at at time). 

Hallo FME community,I have many lines in a shapefile and some lines are connected to each other. I want to bring all lines that are connected together into one feature. I would be grateful if someone could give me an idea. 

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?ThanksBrad

I am building a workspace to do data prep for an AI model training process. This will involve, in this order: Copying a number of image files of type A When copying completed, creating image label .txt files for these when all image copying and label creation complete, copying an exactly equal number of images of type B (from a larger pool than that of the A’s) creating the image label files for these Terminate process when counts match1 and 2 are working fine. I’ve added a counter after stage 2, and I want stage 3 to keep running until the count of type B images copied = count of type A images copied. How might I a) kick off 3. only when 2. is finished and b) stop 3. when count of B = count of A?  

I saw a very similar question to this from a couple of months ago where the poster managed to resolve it on his own, but his fix did not work in my case.I'm reading from AutoCAD Map OD (multiple files) and writing to AutoCAD Map OD (single file). I've checked my template file and Shape File Folder Path and they all seem to be fine, so I don't understand this error or why my workspace won't run.

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

We have a model where we use a ArcGIS Portal Feature Service Reader. On the FME Desktop machine, the model works fine for me but not for my colleague. On the FME Server, the same error pops up as my colleague gets. In the logs, there is the following message when the model fails (on Dekstop for my colleague and on the FME Server):511 2023-3-31 00:32:15 | ArcGIS Portal Feature Service Reader: Logging into 'https://URLarggisportal/' as user 'username'512 2023-3-31 00:32:15 | Python Exception <MalformedPacError>: Malformed PAC file (ReferenceError: identifier 'myIpAddressEx' undefined513 2023-3-31 00:32:15 | duk_js_var.c:1258514 2023-3-31 00:32:15 | FindProxyForURL src\\pyduktape.c:41515 2023-3-31 00:32:15 | eval src\\pyduktape.c:1 preventsyield) When I run the model myself on FE Desktop, I get this log and everything works fine: 2023-03-31 10:34:00| 117.4| 0.3|INFORM|ArcGIS Portal Feature Service Reader: Using proxy http://proxy.url:port/2023-03-31 10:34:00

I have been given an xml file which when opened in Notepad++ shows encoding “Windows (CR LF)” “UTF-8” I need to write a new file with the same encoding. My writer has these parameters It writes the file ok but in Notepad++ the file encoding shows “Unix (LF)” UTF-8-BOM”  What writer parameters should I use to get the same output?

I have hundreds of json file saved to one location, they have a structure as example below: [    {        "json_featuretype" : "1da87ac9-2472-42da-a80f-cba37a36cce5",        "path_directory_windows" : "C:\\Magda_H\\test\\",        "uuid" : "1da87ac9-2472-42da-a80f-cba37a36cce5"    }] I’d like to use PythonCaller to save them to location as state under:  "path_directory_windows" : "C:\\Magda_H\\test\\". Can I please ask for the help with creating a python script to run this. Thank you

I found that Industry Foundation Classes (IFC) (Tech Preview) [IFC_API] Reader in FME 2024 cannot reader IfcOpeningElement features and non-subtracted wall, slab etc. features.In some cases it's essential to read IfcOpeningEelement features as simple solid geometries and non-subtracted features.It would be nice if the [IFC_API] reader would have parameters equivalent to the "Subtract Openging Geometries" parameter in the current Industry Foundation Class STEP/XML Files (IFC) reader. 

Hi, I have multiple lines / links that each have attribute  per feutureID  Vehicle Load1   02  3003  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 

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.

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 thi

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 detailsHow 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'' in r

I just learned that you can copy & paste Conditional Values from one transformer to another without having to open the "Parameter Condition Definition" windows each time. My question is: When pasting a Conditional Value, you have to select "Paste Conditional", if you select "Paste" it will paste a text equation that fails. I assume this behavior is a bug, can someone confirm this? This is better described in the second observation noted below.The screenshots below show how this works from AttributeCreator to AttributeManager. Observations I had which might be helpful to others are:When copying/pasting you need to select the text first (e.g. "3 Possible Values", not simply the Cell. (Right clicking the cell gives you options to Cut/Copy/Paste/Duplicate the row.) When pasting I noticed that you have to select "Paste Conditional", if you select "Paste" it will paste a text equation and refresh to appear like all is well (

Is it possible to write an image from a jpeg url into a file geodatabase? In other words, I want to store images directly from a url into a geodatabase. I need to extract the image from the url and move that image into a geodatabase. Thank you!

Hello there,i want to mark some points which are already placed at each corner of the building polygons in a DGN(MicroStation) file,i want to mark points which exist within 10m buffer from the road, and also points which at the road facing side of the building not at the back side of the building polygons,when i tried using the buffer it covered all the points including the backside points, if buffer reduced some building points got missedseen the image, the intention is to mark only the blue circled pointslooking for some suggestion, ideas are most welcome thanks. 

How to securely achieve the desired order of in which are feature types (tables) written in the database? I have some FK dependecies in the target tables and I have somehow discovered that its written from the bottom to the top of the feature types list. If its not written from the parent to the childs it crashes on FK violations. I know there is an idea registered. But so far what are the options? It consider the inserts/updates and also deletes where i would need the inverse order.Thank you for the suggestions.

Hello, I’m new to FME and I’m encountering a problem where the same rows of data aren’t being saved to both writers. I have two writers connected to the same database but with different tables. When the data is processed, the one saved in the shp_db_b table and can be seen, but there’s no output for the dashboard table (Even though it said ‘Translation was SUCCESSFUL’). I think the issue might be with the Aggregator transformer, but I'm not completely sure. I've attached the relevant pictures for reference.  

I’ve a Microstation DGN file where Building as polygons and each corner of the building polygons have a point, those points have some attributes in the form of MicroStation TAG, i want to check the TAG attribute of the points.Each point will have many attributes like building no, street name, etcif any point in the Building with TAG value ES=1 then the trailing point and successor point must be either ES=1 or ES=6in the below image red point are ES=1 and the orange points are ES=6i want to check the validate this caseany ideas most welcomethanks in advance 

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.htmThe 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": {}}

Hi,I am trying to put data in a zipped file geodatabase in 4 feature tables. Only 1 table is written to the zipped file geodatabase, the rest are not. (no error message). If I write to an unzipped geodatabase file, the 4 tables in the geodatabase are written. How do I write multiple feature writes in the same zipped file geodata tables? (I have tried feature holders to put tables 1 by 1 in the zipped file geodatabase but that makes no difference).