FME Form

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 example I’m sharing a screenshot below of MU0807 PID 41511155

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 a desktop file location, not the server location so I presume I have to upload the .gsb file to FME Cloud and change the GRID_FILE parameter values in the tr

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 TerminatingTranslation FAILED.child process exited abnormally'. TCL script was: 'lappend sysString $FME_MacroValues(FME_HOME_UNIX)/fme;lappend sysString {Generate};lappend sysString {GEODATABASE_FILE};lappend sysString {NULL};lap

I have a power shell script, which retrieves data and saves it to a Jason file. I can run this with a Windows schedule task. I have successfully created a FME project which retrieves that data and populates a database table. Now we want to look at the possibility of executing the power shell script, within the FME project. I have tried this with a SystemCaller but it does not work. Therefore I tried to simplify it. I have created a batch file that appends the current date time to a text file. I have tried using this instead, but when I run the workspace, the text file is now updated scratch that is not updated.Note, I have tried it with the full path as well as just the name of the batch file. Can anyone advise? Thanks 

Hi, I have multiple gdb with feature classes. I would like to get one feature class per each gdb as a sample. The catch is that I do not want to read all data as it's massive. I would like to filter/sample it while reading something similar to SQL Creator

Hi, I have a workbench where I download data from Arcgis online.For this I use the transformer "ArcGIS_AP_FileGDBExport". This works fine with FME Form. But I will use this workbench inside fme flow and during the upload comes the following warning: If I ignore the warnings the workbench is not working! How can I set up web connections correctly in fme flow?

Hello, quite difficult to find the right section for my question, so moderators, please move it in a more suitable one if it is necessary.  I create a FGDB with a feature class and a table. The table shall use the OBJECTID of the feature class, so this one shall be created first to be able to use the OBJECTID in the table. Is there a way to create the FGDB in one wb? Thank you, Corina

good week everyone There is a yield in point format. I want to produce a line from these points. There is a method I used before, but I did not get very good results. As an attribute, each point has a shooting time. Can I create a line using this shooting time?

Is it possible to search for multiple file extensions in the one directory and file pathnames reader simultaneously?Path Filter:* - returns all files*.dgn - returns all dgn files*.dgn,*.shp - returns 0 resultsCan someone please help me with the correct syntax for multiple file extensions in Path Filter?

Background: We have an almost complete library of Vietnam-war era topographic maps in CADRG format. There are some "holes" in the coverage that I am trying to fill. We use these maps as a background for creating tactical overlays of battlefield information, unit locations, prominent terrain features, etc. I am a Vietnam Vet (USMC), and these maps/overlays/annotation are provided to other vets and researchers at no cost. Up until now, I've use an assortment of other programs to covert both geo and non-geo map imagery into CADRG files (gdal, QGIS, GeoRect, CadrgConvertor, Open Map, Gimp, etc), and as "viewers" and overlay editors of the CADRG use primarily FalconView and Open Map. I'd like to learn how to use FME to do this end-to-end if possible. I've tried a few basic conversions in Workbench with varying degrees of success...mostly trying learn by and adapt work by other users. I'm a very basic user. Much of the source material for the map i

Dear FME Community, I am facing a challenge while using the SharePointOnline Connector in FME to load a CSV file directly as an attribute. My objective is to avoid storing this CSV file on any network drive, local drive, or an M365 named account OneDrive folder. Instead, I'd like to process it immediately within the FME workflow. Goal:My end goal is to convert this attribute—which contains the entire table from the CSV file in text form—into a temporary table or a temporary CSV within FME for further transformation. Version:I am currently using FME version [2022.2.0.0 (20221103 - Build 22765 - WIN64) ]. Problem:I can successfully load the CSV file as an attribute (see picture), but I am struggling to convert this attribute to a format (temporary table or temporary CSV) that I can then transform further.  Questions:How can I convert an attribute (_contents) containing a full CSV text file into a temporary table or CSV within FME? Are there any transformers or specific settings that

I have used the FeatureWriter to save a csv with a dynamic filename of "Name_@Left(@DateTimeNow(),8)" before passing on the features to be used by the Emailer transformer. However I only get a result from the Summary port and nothing in the output port.  If I change the file name so that it doesn't include functions and uses an attribute instead (creating a new attribute to handle the date function before the featurewriter) then I see features in the output port.

Hi, I am trying to run the attached fme workspace in fme server as datastreaming service. The workspace works fine in FME Workbench and while running in FME server web interface as datastreaming service. However, I am trying to access this service from my web app. Below is how I am forming the request : var httpRequest = new XMLHttpRequest();httpRequest.open("POST", url, true);httpRequest.setRequestHeader("Authorization","fmetoken token=*********")httpRequest.setRequestHeader("Access-Control-Allow-Origin", "http://localhost:8080");httpRequest.setRequestHeader("Accept","application/json;charset=UTF-8");httpRequest.setRequestHeader("content-Type","application/x-www-form-urlencoded"); httpRequest.onreadystatechange = function() { if (httpRequest.readyState == 4 && httpRequest.status == 200) { console.log(httpRequest.responseText); } } // send a request so we get a reply httpRequest.send(&quot

Hi, everyone I'm new to FME, I had some difficulty in getting the geometry shape of walls converted from CityGML to IFC. The details are as follows:I can get the Guid of each wall, but there is no geometry information, could you give me some help? Thank you very much. Best regards Ying

I have attached a screenshot of the start of the proces without the loop. I want the loop to continue until there are no failed output in the tester. Any ideas on what I can do? Thanks!