FME Form

Hello , I'm looking for an efficient way to compare the versioned SDE with the original SDE. I'd like to perform this comparison before running the compression and before posting the jobs in the database.I believe it would be time-consuming to read and compare all tables from both the versioned and original SDE. Is there a method that would allow me to read only the specific tables that have been edited in the versioned SDE?Thanks in advance FME 2021

I have a pair of longitude latitude coordinates that I’m trying to measure the distance between in KMIf I cross-reference this “distance” result in ArcGIS Pro, I get approximately 1.44kmThis is also roughly the same result if I use a online calculator;My question, is how does the result 0.01630799258600798 translate to 1.44km? is there something I’m missing??

I have an FMW that writes a CSV file and then uploads that CSV to Azure BLOB. The CSV that's created on the server's disk is okay. It has 201 records as expected and opens up just fine. That CSV--after FME uploads it to Azure BLOB via AzureBlobStorageConnector has about 25 less records--seemingly randomly removed. To rule out Azure BLOB itself as the problem, I used Microsoft Azure Storage Explorer to upload the CSV--when I do that, all records are in the CSV file when downloaded back down from Azure. I have experimented w/ a folder upload (upload the file w/ a containing folder) vs. a file upload--no luck w/ that, same result. What really bothers me about this is how it makes no sense. The CSV that gets uploaded should be the CSV that's on disk. It's a file and file-upload process. What could possibly be removing certain lines/records from the file?

Is it possible to use Microsoft app registration in Entra ID to connect to Azure BLOB (non-anonymous, for read+write)? I find information on using a key to connect to BLOB--but my IT policy doesn’t allow keys. I need to be able to connect to BLOB from FME Flow.App registration with Entra ID works w/ connecting to Sharepoint. How about Azure BLOB?

Hello,I have posted my question in esri community but I did not get answer yet .i hope ,if someone could fix my issue  .I am inserting points into an SDE version using FME, but after creating the point, I'm unable to edit the UT Attribute Data. My company uses UT-Editor (developed from ArcMap), and typically, when I create a new point in UT-Editor, a window automatically appears to fill fields in the UT Attribute Data.some fields are necessary to fill in like Adresse and … However, since I'm inserting the points through FME, when I use the UT Attribute Data symbol to select  the point to try  fill the fields in, the window does not open. How can I resolve this issue? Is there a specific method that would allow each new point to linkage to UT-Attribute Data by FME ? or How could open the UT Attribute Data window in UT-Editor for each new point ,come from FME ?Thanks in advance . FME 2021 

I have an aggregated line, containing three parts. Every 50 meters I need to have a point/vertex/measure and using the MeasureGenerator in conjunction with the MeasureExtractor works in principle fine.The MeasureGenerator will only work if I ‘Deaggregate’ the parts and then every part gets a list of measures, starting from zero (as defined in the MeasureGenerator).My challenge is, that the next part of the line should actually not start from zero, but should set the first measure with regards to the remainder from the part before, where there might be the last measure at e.g. 250 m, but there is a remaining piece of 2.2 m.These 2.2 m should basically subtracted from the start value when creating measures for the next part.Is there a way to achieve that?

Hello fellow FME enthusiasts!We've run into in issue with writing Excel files to our sharepoint. We have a workspace that output's an Excel file.We've set it up to use a template to make sure it has the same easily readable layout for our users. We store the Excel file on our sharepoint. Our sharepoint folders are available locally on the PC through One Drive. So we store them to a location like: C:\Users\[User Name]\[Sharepoint name]\[Folder name]The issue we have is that every time we do this with the Template setting active in the Excel writer we get a sync error saying there is one file in out local folder and another one online. It's easy enough to fix this manually (One Drive gives us this option). But it is a manual action. If we write to the same location without the template setting in the Excel writer all works fine.We are working with FME version 2024.0.3.0 (build 24220)Has anyone experienced this before? And found a way to fix this?

Hi FME ninjas.I'm trying to replicate this end result:These are city streets, they started as line objects and have been converted into polygons.I'm guessing the workflow is as follows:- Convert street lines with a buffer into a polygon- Inflate those polygons until they touch an adjacent polygon- ???- Proft! 😀But I don't have a clue how to do this or what transformers I need.Who can help me out creating this workflow?​​​​​​​Thanks.   

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