FME Form

Hi, I have las files to process and update the SDE as contours. One of the attributes which I need to include is a creation date. Unfortunately, when I try to use Attribute Manager to create the new column 'DATE' the value based on 'las_file_creation_date' is added as a new row and doesn't update the whole column as the attached print screen. Does anyone come across similar problem? Thanks

Table 1 Table 2

I am snapping points to line based on unique id (using group by). I tried using both vertex snapping or segment snapping. In both of these case, the points are being snapped to endpoints in some cases ( as per screenshot). I don't want to snap the point to endpoint at all, but it can be anywhere on the line. How to achieve snapping the point on the line other than endpoint of the line? Thank you

I would like to try the Visvalingam-Wyatt algoritm in one of my projects since the results look promising and it can be run on polygons.  Thing is that I have never used PythonCaller, or coded in python. Before I dive in I have a few questions: Has anyone got this simplification algoritm up and running in FME using one of the code samples of github? Was there a way to retain the borders between areas? That would be a must have for me.  

I'm trying to solve how I can get the properties for a Excel worksheet. I have over 5000 Excel files trying to parse. These files fall into 6 different formats for data extraction. However all the files are created from an Excel template which starts with all the worksheets for all the different formats. Depending on the user's initial selection using a VBA marco in Excel certain worksheets will be visible or not.  I'd really like to test if certain worksheets are visible and then take actions accordingly in FME.  Also important is all these files are formatted as XLS (older Excel) and not XLSX .

The file with the error is not the one listed here, and I don't know where the translation is getting the parameter that has the error.

Hi, I would like to merge the two lines below into a single line, since they have the same ID field number, and the other information is the same, except VARIED, which can be any value, either BBC2 or BBC4. How can I do that? Thank´s 

Hi, Attached I have two sets of data with several polygons. The two are almost identical, but one has different polygons or more polygons than the other. How can I do it using FME? I already used the Spatial Relator transformer and change detector transformer but the results were not good. I want to know the difference between the two, that is what appeared in one and what disappeared in the other. can anybody help me? Thanks

I have created a custom transformer and exposed all external attributes from the input port. I have two attributes, they are called Attribute1 and Attribute2. On the output port, I have set Attribute To Output to Specified Attributes Only. Now I can select/unselect attributes from the list. I have unselected Attribute2 and pressed Ok but the settings don't work. Both attributes are still present outside of the custom transformer on its output port. When I reopen the properties of the output port, both attributes are still selected. But now I cannot unselect them anymore. They are greyed out although Specified Attributes Only is still selected. It doesn't help to change Attribute To Output to All Attributes and back to Specified Attributes Only. When I restart FME, the attributes are not greyed out anymore, but it doesn't matter if I unselect attributes on the output port. The settings take no effect when I press Ok.

I've been trying to find a solution to change the start /end vertex of a closed polyline. I have a point where i want the polygon to start, how can I easily reorder all the vertices?

I've recently been provided with a large number of relatively small KMZ files which contain track data recorded by field staff using GPS. This is usually a simple extraction process, however the data is now being provided as a gx:MultiTrack within the KMZ file.(More Info - https://developers.google.com/kml/documentation/kmlreference#gxmultitrack)When using FME, it processes the features as if they have no geometry. Currently I'm reading the data in as an xml and extracting the coordinates to build line features as a work around, but not sure it's the best way.Has anyone dealt with MultiTracks before using FME and have any tips or tricks to extract the geometry cleanly? Thanks in advance.

HI,  I am copying Multipatch features from one file GDB to another, but when i do this they rendered and solid black features when viewed in ESRI  This  Instead of this   Any thoughts on what is happening?  Thanks Jacky

Hello,  I am a GIS Database Analyst at the Province of Nova Scotia’s Nova Scotia Geomatics Centre working along side John Power. We have recently encountered a possible issue with FME in a workbench we have created that reads in CARIS files and coverts them to ESRI file format data where topological errors sometimes appear to be occurring during the conversion. We are trying to create a process that converts our Nova Scotia property records database’s management units (MU’s) from CARIS to ESRI format filetypes and also build polygons from the existing linework.  Our FME Version being used is FME Desktop 2022.2, I have also attached a copy of our current workbench and one of our zipped CARIS MU Units as an example.  The issue we appear to be encountering is that our FME converted lines sometimes appear to have an extra vertex added that is causing topology errors that don’t allow certain polygons to be successfully built. The ex

I have a workbench that reads in three road datasets, does a bunch of tests and outputs to a file gdb. Two datasets have around 3000 records each and the third has almost 11,000 records, so not huge datasets. The problem I am having is the two smaller ones write successfully but the larger one only writes 956 records.  If I write to shapefile all is fine but no matter what I try the file gdb writer fails. I have tried writing to fresh gdb and still same result. I am using FME Form 2023.0 and ArcGIS Pro 3.0 Any ideas?

I've used the Airport demo as a base and all features are connected properly in the output file except that the point feature is missing. I've attached the image below where you can see that the gml_object_name is populated just like in the demo. I've tested all posibilities in the demo and reduced the attributes to gml_id and gml_parent_id just to remove any other possibilities.  Could you tell me why is this happening? What is expected for the ElevatedPoint to be added? Thanks 

Hi allI've been given a handful of grid shift file (.gsb) that I need to add to FME Cloud so that I can use them within a published service (via the CsmapReprojector transformer).This is what I've done so far.On Desktop I've copied the .gsb files to C:\\Program Files (x86)\\FME\\Reproject\\GridData\\Australia and modified C:\\Users\\<user>\\Documents\\FME\\CoordinateSystems\\MyCoordSysDefs.fme, adding the custom transformation definitions which point at the relevant .gsb. For example:The transformation was tested and worked fine using desktop.I then uploaded this modified MyCoordSysDefs.fme file to FME Cloud when I published the workspace I'll be using. I uploaded the file to myfmecloud.com/fmeserver/resources#/Engine/CoordinateSystems.I realize the transformation definitions in MyCoordSysDefs.fme points to

Hello,I have numerous las v1.4 pdrf 7 tiles from a dual channel airborne lidar sensor - there are multiple source ids (flightlines) in each tile, and most have the scanner channels coded correctly as 1 and 2.  One line however has the scanner channels coded as 0 and 1. Is there a way in FME to go through all of the tiles and only change the scanner_channel for a particular source_id?  I would envision a script running through all of the files, then at any instance where the source_id matches a user defined value (the flightline with the problem), then it would change then scanner channel from 1->2 or from 0->1 while retaining all the other non-matching points, and all other parameters such as classifications. Thank you for any tips or suggestions,Ben

Hi, We are trying to connect zo an Azure postgresql database via oatuh2.0. Does anyone know if this is possible? Oauth2.0 is available for web service connections. kind regards, Fran

I am using the SBS-Plugin for Smallworld to connect to Smallworld datastores. The plugin version is 2021,FME version 2021, the Smallworld version we are using is 5.2.3. We have connected a new datastore to Smallworld. Unfortunately this new datastore does not appear in the table list dialog of the SBS-reader. Any ideas?

Hi, I need to download files using WFS link and zipped it and publish to FME Flow so that I can share the link of the zipped WFS files to other. Can anyone assist on how to achieve this? Thanks

Is it possible to delete rows in Excel based on a cell value? I am comparing a data-set in Excel to another Excel file using Feature Merger. I want to delete the rows in the data-set which match a specific field (DETECTOR) in the new file(s).I feel like this should be very basic since Power Automate can do it (And MS has a surprisingly poor integration with their own software). The closest thing I found was the Database Deleter, but it doesn't have an Excel option for format. I can add Microsoft Excel as a new custom format, but that doesn't behave the way I would expect (opens a new workspace?).

When reading a PostgreSQL table with FME Workbench (2023.1) that has been droped (or renamed) before, the error in the logfile looks like: "Error executing SQL command ('select * from "schema"."table" where false limit 0'): 'ERROR: Relation »schema.table« does not exist".Despite of this error the logfile says that the "Translation was SUCCESSFUL". (The parameter "ignore failed reader" is already set to NO.) I need to know, if a table has been deleted (or renamed). So, how can i make the translation fail on missing input PostgreSQL table instead?  

When, oh when, will the wallpapers for 2021 become available ??I have a wall to decorate ......

I've been using a couple of Affine transformer to transform data from/to a custom, local coordinate system. I just discovered the possibility of defining a custom FME coordinate system with the TMAF projection, so I'm trying to simplify my workspace using this. I put a new TMAF (based on UTM32) into MyCoordSysDefs.fme and then use it in a regular Reprojector transformer. It's my understanding that such affine transforms should be invertible, and that I should just need to change the from/to coordinate systems in the Reprojector to get the correct transform, but I can only get it to work one way? How is this supposed to work?

I would like to extract the coded domnain definition from a geodabase.There is already an article about it here. However, when dowloading the ETL extract-domains-from-geodatabase-gdb-py34.fmw, I couldn't run it with my 2021 FME version.FME_BEGIN_TCL script returned error on execution. Error message was: '                FME 2021.2.6.0 (20220727 - Build 21821 - WIN64)                        FME Database Edition (floating)                               Permanent License.                         Machine host name is: 237146PT          Operating System: Microsoft Windows 10 64-bit  (Build 19045)                 Copyright (c) 1994 - 2021, Safe Software Inc.                               Safe Software Inc.GEODATABASE_FILE reader: An unknown exception occurredProgram Te