FME Form

I would assume (dangerous in this case), that a Terminator would halt processing completely.I have a workspace, that imports from a WFS. It errs because the provider made a breaking change by removing a column in the read dataset. This issues a rejected feature, which triggers a Terminator.But even then, the postprocess action of my SQL writer is triggered.Why does this happen ?If a terminator is called, it indicates that the workspace has failed. And then triggering postprocessing is a dangerous action, as this usually requires the writing to have been completed without errors.Is this not a bug ?Using FME 2022.2.6 on FME Server/Flow.Cheers

Hopefully easy question: what is the easiest way for me to check if a workbench is running on FME Form or on FME Flow?On Form, when testing, I want to read the source data from my C-drive. But when on Flow, I want to read the official data uploaded on the server.

Whenever we cancel a running job (in our case: using the REST API), the job is cancelled successfully on the FME Server core (the job reports itself as aborted when we fetch the status), but the engine on which the job is running (on a different physical machine than the Server core) just keeps on going: the job simply runs until the end of the translation. This is not what I expected, but since I don't see any errors in the server logs e.g. about communication issues with the engine, I started to wonder.Is this intended behaviour? If so, are there ways to actually stop the job process on the engine as well? If not, any suggestions on how to fix this?

In the olden days, you could mark your own reply as best answer, if you figured it out yourself.This is no longer possible.Why ?

Hello,How can I use the values from two fields to match against another dataset? image 1, filtered portI have a test filter, which filters out all items that contain ‘FeatureWriter’ in the transformer_parameter_value field, I now want to take the items from the unfiltered port,Image 2, Unfiltered port.and match these against the initiator_workspaceId AND transfomer_id items from the filtered port (image 1). I do not want to do a row by row comparison, I want to match all items that exist in the filtered output (image 1) against all items in the unfiltered port (image 2). If they have a matching combination of both the initiator_workspaceId AND transfomer_id.I attempted to use a featureJoiner to achieve this: image 3. failed attempt but as can be seen, there should be 3 items with transformer_id 81, but unfortunately some of the items were merged, which I do not want. I want all items from the filtered list and unfiltered list to be in the output, without any sort of merging.  How can t

Hi there,  I have connected to a Sharepoint Excel file in my workbench. I am able to read the rows and values when inspecting the Excel.  However, when I connect the Sharepoint Excel reader into any transformer, I get the error below: Exception ignored in: <finalize object at 0x13bf76a0; dead>Traceback (most recent call last):  File "weakref.py", line 590, in __call__  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections    conn.close()  File "http\client.py", line 1020, in close  File "socket.py", line 505, in close  File "ssl.py", line 1311, in _real_close  File "socket.py", line 499, in _real_closeOSError: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failedException ignored in: <finalize object at 0x13bf7cc0; dead>Traceback (most recent call last):  File "weakref.py", line 590, in __call__  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections 

Build 24627Hello, I am having issues reading a single Feature Type while using the Constraints in the FeatureReader transformer with both the File Geodb and the File Geodb API formats. Each of the Feature Types are visible when clicking on the ellipses; however, after you select one or multiples, the transformer updates and the only outputs are Schema, Generic, and Initiator.There is a workaround, to not select a Feature Type to Read, however, this will then read all of the feature classes in the File Geodatabase.Thanks,Justin

Hi FMErs,I have 3 rasters of equal extents and cell size (clipped to the same 2D polygon)a) representing the floor elevation of a sub-surface stratab) representing the thickness of the same sub-surface stratac) representing the roof elevation of he same sub-surface strataLooking for tips on the best / most efficient way to create a 3D polygon in FME similar to ESRI extrude between, and assuming other strata sections are available in the same raster form , iterate through each strata section to create a 3D subsurface model.Thanks in advance

I have a workspace that is calculating the shortest path across a network for a dataset of start and end points (joined as lines). The length of time it is taking to process the data through the ShortestPathFinder transformer is a lot and it sits as follows for hours on end:  Is there a way to speed this up at all? I know I’m trying to process a large amount of data which could be the primary reason but I am curious if there are ways to perfect this process to enable it to complete much faster.

Hello everyone,I'm working on a project in FME and need to filter date values from a CSV file. I have the following requirements:The date should be between 01.01.2021 00:00 and 22.07.2021 23:59. The date column is in the CSV file and is formatted as dd.MM.yyyy HH:mm.I've tried using the DateTimeConverter and Tester transformers, but I'm not sure if I've configured everything correctly. Does anyone have tips or examples on how to implement this?Thank you in advance!

Happy new year, FMEers.Our question-of-the-week was posted just a few hours before I started to review the week. It's about parallel processing and the ShortestPathFinder transformer. Question of the WeekQ) I was hoping to speed up my ShortestPathFinder calculations with "Parallel Processing", but I don't notice any speed improvements. The 2018.1 documentation says "If it is enabled, a process will be launched for each group specified by the Group By parameter." However, the most recent documentation does not mention parallel processing at all. Am I missing something? Asked here by @magnus A) Yes, there are a number of points. The first is what happened to parallel processing in 2019, the second is how to ensure parallel processing works... Parallel Processing in 2019So here's a quick refresher on parallel processing in 2019. Basically it was removed from individual transformers and retained only in custom transformers. I wrote a blog article to explain

In the change detector is there any way of transferring an attribute value from the original feature to the updated feature when it's not either a Key Attribute or one of the attributes listed in the matching strategye.g. 

Hi All,I have been building workspaces that get data from an api and write that data to Excel, using Template files. FME Flow can’t access the location of the template file, so what I did was: Make them a published parameter and publish. Then once one Flow, I change the parameters to the Flow resources path where I uploaded the template file as well. I do this in the Workspace properties. However, this doesn’t work, when running the workspace, the log says it can’t open the Template File and still pointing to the old/local location of the template file.What would be the right workflow here?

Sono un neofita del programma, devo convertire un IFC in cityGML con un algoritmo già elaborato. Inserisco il mio file IFC ma mi compaiono questi errori :ISO10303-21: Unknown entity or type name '\xD0\xCF'.ISO10303-21: Invalid file format, unable to continue readingCosa posso fare? Ho provato ad inserire il file in IFC 2x3 coordination view 2.0

Hi folks,I’m hoping this is relatively straightforward and I’m making this more difficult than it seems. I’m collecting images in the field and trying to store the images as blobs in a database. There can be up to 6 images for each property. In the below example only 3 images were collected. I’ve got to the point in my workspace where I’ve joined the images (as blobs) to the survey data, but I’ve got 3 features instead of one. I have a unique survey id. How do merge the data so that I have one feature, with up to 6 images stored as blobs? I’m trying and failing to use lists in the most efficient way possible; via the Aggregator then List Element Filter, then somehow bring the data back together, but this is the point I’m stuck on. Any help is greatly appreciated. Many thanks,Aaron

Hello,I am attempting to use the FeatureWriter to update a spreadsheet. From the screenshot you can see I have Addresses Input into which is pushed 3 updates and 95,393 from the original spreadsheet. The Output port, Addresses adds the 3 records to the original spreadsheet making for 95,396 records. Is there a way to get FeatureWriter to update the spreadsheet so the output is 95,393 with the 3 records in 95,393 updated not added to the output? The FeatureWriter is writing to the same spreadsheet in the Addresses Reader.  

What modules are available in the PythonCaller transformer in FME Server?I am interested in these modules;urlliburllib2requests 

Bonjour la communauté. Je cherche à créer un tableau avec mes données d’entrée et par la suite insérer ce tableau dans un pdf.Pour insérer ce tableau, je devrais sûrement utiliser le pdfpageformater, mais quel transformer va me permettre de créer mon tableau comme je le souhaite. Merci d’avance pour vos réponses.

I am clipping a raster and then running RasterStatisticsCalculator. The results are completely wrong to what I get in ESRI using  zonal statistics and the only stat that is correct is the max value.FME Results: When I export the raster and bring it into ESRI, cell values are different and zonal stats are different Zonal stats results from ESRI:  I would appreciate some help in how best to run zonal stats in FME. Thanks,K

Hello FME Community,I have point data with attributes for the X and Y coordinates of the top-right and bottom-left corners (e.g., X_TopRight, Y_TopRight, X_BottomLeft, Y_BottomLeft). I would like to create a rectangle based on these two corner points.Could anyone suggest the best approach or transformers to use in FME to accomplish this?Thanks for your help!

Hi Team,I am new to FME and would appreciate if you could help me by giving some tips on Error handling in FME, Below is my scenario,My FME application reads the data from Database and writes to arcGIS Feature layer. Application overwrites the data to feature layer everytime it runs.If application fails for some reason, is there any transformer (or any other method) to retry running the workspace again or add some kind of Try/Catch mechanism?Below could be possible error scenarios in my application,    1) Error connecting to Database    2) Error occurred during transformation    3) Error occured writing to arcGIS Online    Thank you in advance,Regards,Syed    

Hi - I am hoping someone can help.Apologies in advance for the long message.I am using FME Workbench 2022.2.8.I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database.I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script.I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas.I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1).I created an environment called fme_env and set the Python version to 3.9.I was able to successfully set up all this, but I encountered the no module called FMEObjects error.I went into my FME installation path and there was a folder called fmeobjects and inside that there were several version bu

I have a SPATIAL table with the following columns: X_coord, Y_coord and a SPATIAL column GEOMETRYThe X and Y coordinates are adjusted. With which attribute can I adjust the GEOMETRY columns?It has data_type SDO_GEOMETRY (Oracle). Contents of a record:MDSYS.SDO_GEOMETRY(2001, 28992, MDSYS.SDO_POINT_TYPE(201234.5678, 47123.4567, NULL), NULL, NULL)  

I used Workbench 2022 to clip buildings (composite surfaces) onto an area with the clipper transformer. The buildings at the clipper boundary however are open geometries (refer to screenshot). How can I insert closure surfaces to each boundary building to create closed volumes?I tried to coerce the composite surfaces to a solid and coerce them back to surfaces after the clipping, but the method is not reliable, because most of the solids become faulty. Is there another solution? Best regardsAlex

Hi,I’m trying to save a polygon as a GPX track and am running into an issue. Here’s what I’ve done so far:Converted the polygon to a line using GeometryCoercer Reprojected to EPSG:4326 Created track_id, source, and name attributesThe translation completes successfully, but when I try to open it, I only see the attributes and no geometry. Any idea what I might be doing wrong? 2024-10-29 11_22_11-Window.png