FME Form

I have removed ObjectID from the attributes and everything looks fine. My destination format is File GeoDB Open API

I currently have a dataset, see top half of picture below, that I wish to transform/transpose into the format that can be seen in the bottom half of the image. The blue/green/peach coloured fields are date/measurement.   I am totally unsure of where to begin with this, the current transposer tools seem to only be able to do simple transposing without adding the additional rows of location/sourcetype/date/measurement I need. As can be seen I want to make a individual row for each date/measurement combination.  I have also attached sample data in xlsx and csv. Any help would be appreciated!

I'm trying to combine the two pink polylines with the green closed curve and make them one entity without making an aggregate. They are for use in AutoCAD and can't be aggregates as they show up as a block and not a polyline. LineCombiner does not work.  

I am currently converting IFC format to Shapefile. So far, I have been successful in importing only the geometric objects. Due to the fact that most properties in the IFC are in separate classes, when they are brought into FME, they remain in their own feature types. How can I map these properties as attributes within the created feature geometry?

Hello,  I am having issues extracting info from a kml. Here is how the information is stored in the kml_description. What kind of transformer would I use to extract the info. <style type="text/css">td {white-space:nowrap} th {align:left} td.padr {padding-right:0.5cm}</style><table><tr><th></th><th></th></tr><tr><td class="padr">GPS Date:</td><td>03/29/17</td></tr><tr><td class="padr">GPS Time:</td><td>02:26:15pm</td></tr><tr><td class="padr">Datafile:</td><td>R032913A.cor</td></tr><tr><td class="padr">Avg Horz Prec:</td><td>0.9</td></tr><tr><td class="padr">Worst Horz Prec:</td><td>1.2</td></tr></table> 

Hi When working with full Desktop FME it is possible to set where the log file is written to disk through the GUI (or set it to be a parameter), however when working with the ArcGIS Data Interoperability Extension version setting the log file location is not available in the GUI (none of the workspace parameters are). Is it still possible to set where the log file should be written to on disk through a variable or is this functionality removed for a reason? Ideally, I would like to write the log file to sit alongside the data being processed. ArcGIS Desktop 10.5 which uses FME 2016 Many thanks Duncan

Hello, according to the docs, "to view recorded features, click an inspection icon on an output port". I would say that's what I'm doing, yet no features are shown in the Inspector. According to the number on the junction, there should be 4:What am I doing wrong?

Hello, I use the transformer Bufferer in a workbench.I don't understand the result pour some features for which I have an ellipse in result (fme_geometry = fme_point, fme_type = fme_ellipse). I join a very simple fmw (2022.2) with 2 polygons. What parameters should I take to always have features with fme_type=fme_area et fme_geometry=fme_polygon ?  Mélanie

I have a dataset that includes 'from' and 'to' values in separate columns. The 'from' column contains latitude and longitude coordinates. Both 'from' and 'to' values are unique.My question is: How can I create a line that connects the 'from' and 'to' values in FME? I would like to visualize the connection between these points using a line geometry.Any guidance or suggestions on the workflow or transformers to use would be greatly appreciated.Thank you in advance for your help!

How to convert all the attribute names of all the feature classes within a File Geodatabase, to uppercase?

Hi team,I've seen this at multiple locations, where Sophos will prevent FME from installing custom transformers from the Hub (i.e. Emailer) and display a Lockdown alert, Sophos believes it to be malicious behavior. Has anyone else experienced this? Is it possible for Safe to reach out to Sophos to see if this can be looked at, as the only way to get around this, is to allow exceptions per Transformer on the Sophos side and we have to re-do this each time we upgrade FME Desktop.

Attemping to connect to a hosted mongodb I get this error message:MONGODB3 reader: Server at xxxx:yy reports wire version 5, but this version of libmongoc requires at least 6 (MongoDB 3.6): generic server error I can see FME's reader doesn't like some app version on my db server. Is this something I can resolve in FME, or does the server require updating to allow FME to connect to it? Thanks,Clay

Hello everyone, I am trying to use a SQLExecutor with embedded connection parameters provided by some published user parameters. Here's an exemple:After saving the SQLExecutor parameters and reopening it, it seems that the last parameter (password param, i.e DB_PASSWORD) is not being persisted:At first i thought that it would not affect the connection parameters (i.e. maybe an small UI bug), but that's not the case since the SQLExecutor did not use the provided $(DB_PASSWORD): This is a local test, but i have similar results when targeting prod servers.Interestingly, this happens on

I have an API Key from MaintainX but I'm trying to get pass the first stage of Authentication with Bearer Tokenhttps://api.getmaintainx.com/v1/docs

I have a string column containing lake names in the format ''Blue, Lake'' and I would like to reverse the format to ''Lake Blue''. I somehow can't find a way to reverse a string at the comma.  Is there an easy way to accomplish this using string functions in FME ?

I am wanting my StringReplacer to search for values which start with a certain string, and replace the ENTIRE value with a new string (not just the start). I have table with a list of values starting with "Sh 1" and "Sh 77", and they all have following text after Sh 1 and Sh 77. I would like to replace the entire value, e.g. "Sh 1 Rs 401 Rakaia to Chertsey" should be replaced with "State Highway 1".  I have tried a few expressions, but currently I am only able to replace the "Sh 1" part of the string, not the following text.  How do I change my expression so the entire value is replaced?   

I have a large set of featureclasses that need to be run into a workspace, one at a time because loading the dataset all at once will make my FME workspace terminate because the memory is full. I have used workspacerunner on a folder with multiple csv files, which solves the memory problem. But I can't figure out how to do a simular thing with multiple featureclasses. I wouldnt mind if the featureclasses need to merged into one and the input the first xx number of features into the workspacerunner. If that is even possible.

Hi there, Until a few days ago we had a working SharePointOnline Connector in FME which uploaded a .dwg file every day. After updating to FME Workbench 2022.2 that stopped working. A saw in the webservices options that the Tenant-ID was replaced with the string 'common' so I reverted this to our setttings. I used this YouTube-video for implementing the right settings inside FME. I can test the webconnection which is succesfull. But encounter a number of error messages. See below. I've also been troubleshooting together with IT to make sure that all proxy/FireWall settings are correct but nothing has changed there.Thusfar I've encountered the following error-messages: 

The writer stops working after I added a geolocation field to the sharepoint list. Even without writing anything to the geolocation field, the writer still gives me this error. Could anyone help me? Kind regards.  https://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint-user-attr.htm

Hello, I managed, with a PythonCaller, to create a dialog box with a dropdown list of choices, a button opening a url link depending on the selection. I would like now that:1) the choice list be taken from an FME list  (code line 38 below)2) once the coordinate is chosen, by clicking on "button2" ("OK..."), the FME attribute "Choix_adr" takes this coordinate and the FME script continues.  (code line 88 below) I have the following code that works at the list level (but without taking a FME list or defining the "Choix_adr" attribute once chosen) and the hyperlink button:from PyQt5.QtWidgets import *from PyQt5 import QtCore, QtGuifrom PyQt5.QtGui import *from PyQt5.QtCore import *import sysimport webbrowserimport fmeimport fmeobjects class Window(QMainWindow):     # Initialisation de la commande    def __init__(self):

Hi there. I am outputting SQL data into a CSV into well known text. Some of these features are polygons and others are multipolygons. I am finding in the output some multipolygon WKT strings are spilling over into other fields which throws everything out. I'm not sure the field length is exceeding the maximum length for a CSV but is there anything I can do to keep it all on one line or is this a problem with multipolygons? I'm using a GeometryExtractor to convert to WTK, then a couple of StringReplacers to remove Z and change the SRID from 0 to 3857 so the csv can be brought into Power BI. Most are appearing fine. Regards, Josh

Hi, I'm looking for a way to generate a random 6 character alpha code. SequenceGenerator looks like it would work but it only uses numeric values.

I don't understand why I'm getting a failure to transform the projection system and save it in another format.jpeg - ecwundefined - 25830 

Is there a way to copy to excel user attributes table? I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast?