FME Form

I am trying to create a GML file that complies to the GML simple features profile (GML-SF) (http://portal.opengeospatial.org/files/?artifact_id=42729). I already created a GML application schema that complies to the GML simple features profile. It follows the pattern described in GML-SF, 8.4.2:<schema xmlns="http://www.w3.org/2001/XMLSchema" xmlns:ex="urn:uuid:3c615c60-013b-4006-bf53-d0ba4fb5fc94" xmlns:gml="http://www.opengis.net/gml/3.2" elementFormDefault="qualified" targetNamespace="urn:uuid:3c615c60-013b-4006-bf53-d0ba4fb5fc94" version="1.0.0"> <import namespace="http://www.opengis.net/gml/3.2" schemaLocation="http://schemas.opengis.net/gml/3.2.1/gml.xsd"/> <element name="FeatureCollection" type="ex:Feature

Hi All,I'm experiencing a bug in the Excel writer in the new FME 2024.0. I've made a script that outputs multiple data categories I need to process in a particular order to ensure my calculations are fed as desired. The bug causes the attribute names to not be written in the first row in Excel; it just starts with the data in the second row. Whenever I open the exact same script in FME 2023.2, the writer does write the field row names, without me changing anything in the writer settings.For now, my solution is to not use FME 2024, but since my customer does use 2024, it's not desirable. Does anyone have any ideas?Here is a preview of Excel. I can't scroll up to the first row, the data is not hidden, and the navigator also won't allow me to go to row 1. 

Hi, I’m having some problems working with the CSV Reader. I created a Reader from a CSV that has 3 fields: Address, City, and ZIP. I have ‘Case Sensitive Field Names’ and ‘Enforce Strict Schema’ set to No, but then if I modify my source CSV to have the attributes: address, city zip, and Notes, the Reader fails to read in any data.What am I doing wrong here? It seems like even though I changes some properties for the Reader, it is defaulting back to the original schema that I input when creating the Reader. Any help is greatly appreciated. 

Hi,I have one script in R running in RCaller, but the RCaller show some messages like erros but no erros, my script run properly. I would like to ignore these messages and generate one feature for the next transformer. How can I do this?  Thank´s

Hello ,i would like to insert some new points into ArcSDE, where each point will be positioned on and connected to various lines.How can I establish a relationship between each point and its corresponding connecting lines?Is it possible to set up this relationship in FME, so I can view the relationship class later in ArcMap?there is already a relationship exist between feature class lines and feature class points.But what  about the new points from FME?Could anyone advise me on a solution?Thanks in advance .FME 2023

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 f

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

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

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

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.