FME Form

In Attribute Manager I have created 3 fields (Borough Code, Block_Leading, Lot_Leading), 2 of which have leading zeros in them. I need to concatenate the three fields into a 10 digit string while retaining the leading zeros in the order listed above. My formula for for Block_Leading is @PadLeft(@Value(Block),5,0) and the formula for Lot_Leading is @PadLeft(@Value(Lot),4,0). Can I concatenate all three fields in a single formula in a new field in Attribute Manager and if so how? 

I want to visualize 2 raster (DEM) the first is for terrain elevation and the second is a dem of a flood. I want to modilise the elevation of the flood compared with the terrain elecation and I want to visulise them in cesium just like I did in Arcscene. Is there a way to that like converting them in 3d tiles or something.

There is a FME server setup with 8 engines, each on their own server. Error: Authentication failed: java.sql.SQLException: COM.safe.fmeserver.database.FMEServerDBException: org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections Anonymized event before the engine faillure: INFORM  xxxxxxx  418049 : Received HTTP Basic credentials for user: xxxxxxxxx Temporary solution is restarting the FME-services on the servers. Possible cause: recursive connection error during authentication check which eventually shuts down the engine?

Their format: X = 2067764.503 Y = 543479.582 -> I don't know this formatDesired format I need is: X = -82.1483 Y = 39.4917 

Hello , I am working on migrate the data from arcmap to utility network and I have read some articles that FME can help in data migration .could someone explain me ,which ideas and steps should I consider to success in converting data from arcmap to Esri electric utility network Thanks in advance FME 2021  

I would like a PRJ file written alongside the DWG when using a dynamic format workflow. The bespoke AutoCAD writer has a setting, just looking for how to do with with a dynamic workflow.

I’m currently receiving polygon geometry from various consultants, using various methods for deriving the polygons from Raster’s (GeoTiff). As part of our Data Validation process I validate all geometries to OGC Standards. Which, depending on software used, results in different issues, or not.While working through methodologies, to provide consultants with Software Specific guidance, I noticed that when using FME to generate the polygons it results in a Hole Outside of Shell geometry Issue's see Image below.   We have only come accross this issue in FME, we have used ArcMap, ArcGIS Pro, QGIS and GDAL/OGR. The ESRI products result in 'Self Intersections', but the ArcGIS Pro 'Repair Geometry' Tool set ot OGR, fixes the issue. Both QGIS and GDAL/OGR are the only tools tested which by default result in OGC Compliant Geometries as outputs.I would like to be in a position to generate OGC compliant outputs from FME, considering we are using FME for our Validation process.I

I'm having some trouble when trying to upload Python libraries to FME Cloud and I couldn't find any documentation over it. I have tested that the workspace successfully imports the PyPDF2 python library on my desktop (windows 10). I then followed the directions on the post that is linked below and I am still unable to have the workspace on FME cloud import PyPDF2. I'm still fairly new to Python and haven't had any experience with Linux, so I'm not sure what I might be doing wrong.My stepsCreated a virtual machine with ubuntu (32 bit. No option for 64)Downloaded the source code for PyPDF2 from: https://github.com/mstamy2/PyPDF2Compiled the library on the virtual machine and copied the folder created in the dest-packages folder to FME Cloud folder located at Resources>Engine>Plugins>Python>Python27. (no files in site-packages)Reference to Post: https://knowledge.safe.com/questions/4164/python-libraries-on-fme-cloud.html?childToView=69192#comment-69192Any h

Hi, we have some problems during clipping raster datasets!So the black area in the example is successfully clipped. But then as result we have raster clipped by clipper. But FME makes the raster square again and fills the missing pixels black. I can remove these nodata values but then sometime black pixels inside the raster are also deleted not only the black areas on the edge! We want to get only the clipped area without black areas. It does not have to be square.Is this possible?

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 FME2022.2 (Build 22765) but not on FME2018.0 (Build 18312) Do you notice the same behavior on your workbenchs ? Is there's an workaround for that? (I tried using an ParameterFetcher, same results)Thanks in advance!  

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 ?