Authoring

Hi, I’ve seen this touched on in other posts, but I wanted to ask directly: has anyone had success getting data into a Microsoft Fabric Lakehouse, and what are the best authentication methods?I think there are potentially options using the Azure Blob Storage connector to push CSV files in, and possibly using the Fabric API as well. Before I go down the governance route and request SAS tokens or API keys, I’d like to hear about others’ experiences to make sure what I’m asking for is actually going to work.I have a few data rescue use cases where I need to scrape large volumes of documents, structure the outputs using FME, and then write the data to a Lakehouse so the business can use it for reporting.I’ve managed to get data out of Lakehouses using the SQL endpoint with a SQL Database Reader, since it has Entra ID authentication integrated.Any insights apperciated.  im using FME 2024

Hi,I recently upgraded from 2025.1.1.0 b25615 to 2025.1.3.2 b25646 and noticed that whenever I open a .fmw file, a new folder, “.sentry-fme” is created in the same directory.When I started FME from my desktop shortcut, a “.sentry-fme” folder was created on my desktop once the program was up and running.Could we get this fixed? I’d rather not bloat my directories with temporary files if I can help it. I’ve since downgraded back to 2025.1.1.0.Thanks,

Hi FMEers.I have an interesting task and thought I’d come directly to the experts for advice! I want to pick a random position on Earth, but it has to be on land. How would you go about it?The obvious route is to simply pick a random coordinate, repeating the process if it doesn't fall within a land boundary. That seems inelegant. Alternatively, maybe I could use H3 hexes? Generate all level 15 hexes over land and pick one at random. That seems slow.I'm open to any suggestions. I want lat/long coordinates to about 7 decimal places, and I need it to run (on Flow) in around 1 or 2 seconds.Thanks for any suggestions.Mark

There are situations when I want a variable or parameter to determine whether a certain process is run or not. I could add the variable as an attribute to each feature and then test for the value of the variable. But that way the variable controls the process for each feature, when I already know that I don't want put any of the features through the process. And it feels like creating an unneccesary amount of extra data (even though temporarily), which I have to remove later on.I've come across this before, and now I have a case where I want to run part of my workspace once a week and another part every day. (An alternative is to distribute the processes across separate workspaces, of course.)What I'm thinking of is functionality like the feature reader has: it only reads features when triggered by an initiator. But I can't think of a way to do this with other transformers.Does anyone know of a way to achieve this in FME Workbench / Form?

I am reading data from SQL Server that is in the default dbo schema. I want to write the data into a specific schema in postGIS.But i struggle to make to do this as a dynamic workbench.The setting is to Always create tables. The table is created as expected (dbo. is replaced with correct postgis schema name in StringReplacer).But i get an error trying to write featurePOSTGIS Writer: Fanout for feature type '' failed to find feature type template ''Seem to be a missmatch between the schema feature and the feature itself?  

I have an odd problem. I have suddenly lost the ability to view the lists on my objects in the “feature information” pane. They are indeed there, I can search and explode them, but for some reason -mid working on this workbench- I have suddenly lost the ability to see my lists.I am in version 2024.2. I havent found anything helpful or related online yet so thank you if anyone is able to assist. created list ^ no list visible ^ I am ONLY able to see the lists in the “Found” port of a list searcher, but in NO other occasions can I see them.  

Hi,I recently moved to FME Form 2025.0.3 from FME Workbench 2021.1.2.The install is on a central windows machine. Some workbenches run as other users. ArcMap and ArcPro (3.4) are also installed on this machine.All our workbenches involve ESRI enterprise geodatabase readers or writers, so require an ESRI licence to run.Users of FME all have named user licences for ArcPro, they are able to launch Pro and obtain a licence on the central machine.When I use FME Form there is no issue accessing the ESRI licence and using the readers/writer. However when testing with other users, who have the same type of named user ESRI licence, FME reports the error: “Worker 6428 > Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this art

Hello,Does FME has some kind of DefaultCoordinateSystemSetter? I've created an FME workspace that dynamically transforms FileGDB layers into an Oracle SDE database. For this, I need the Oracle SRID and ESRI WKT coordinate system descriptions. To get these, I use the CoordinateSystemDescriptionConverter transformer (handy tool!). However, there are tables without geometry (which crash the ESRI WKT conversion, luckily a TestFilter or something similar fixes that). But it gets worse when geometries enter the workspace that DO have coordinates, but NO coordinate system. Setting the coordinate system on the reader doesn't work because I expect multiple coordinate systems in the data, and setting one of them as the default on the reader will incorrectly overwrite data with a different coordinate system.So here's what I need to do:Extract the existing one (CoordinateSystemExtractor) Test if it resulted in an empty value (Tester) Set the "default" coordinate system (CoordinateSystemSetter) Re-

Hi all.I just ran into a curious problem. I tried to generate a buffer around my data, exporting it to GML. The problem is that QGIS won’t open the generated GML.I found that the GML data contained geometry errors (OGC Simple), and that these in part was made by the Bufferer transformer !??When I debug run a GeometryValidator->Bufferer->GeometryValidator setup, only running passed+repaired features into the Bufferer, the second GeometryValidator outputs failed geometries, i.e. output by the Bufferer..Is this a known problem ?CheersUsing 2025.2 beta

I have been trying to find a good use for the ‘ai assist’ function. I don’t think it has ever succeeded in providing a useful answer. Have any of you had any luck?Or do you also copy paste to a real ai?In this example I needed a SQL Query edited, but my request was invalid for no reason. When I post in any other LLM I get a thorough response and description of this and that.My overall questions is probably, why is the FME implementation so poor? Is this spelling the early signs of the end for FME? 

I try to create tables where schema definition is from SQL Server into PostGIS. Schema onlyFor this i have a simple workflow. But for the life of me i do not understand why my tables are not created despite FME report everything went well?String replacer is just changing the name of fme_freature_type_name to remove the standard “dbo.” table qualifyier from SQL Server.   Writer setup Log                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-rplanforslag_alternativ_forslag.RpAngittHensynGrense                         1rplanforslag_alternativ_forslag.RpAngittHensynSone                           1rplanforslag_alternativ_forslag.RpArealformålOmråde                        1==============================================================================Total Features Written                                                       3=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--~-~-~-~-~-~-~-~

Hello,is there any version of FMEFORM 2025 that will allow me to select a coordinate system in the reader from outside the short list without automatically closing the entire application? I checked 2025.1.1 and 2025.1.3. or is there any tip to do this? I tried different scenarios and always when i am trying to open More coordinate systems the application closed by itself.Regards Artur Gustowski  

Hi everyone I have been having some issues with the new ArcGIS feature service writer. When using this writer in combination with a change detector, it doesn't seem to update or insert any of my changed records and i have been getting weird behaviour all over the place. Let me preface this by saying that everything works as expected on the old portal feature service writer, it's when switching to the new feature service writer that weird things start to happen.  Under the advanced parameters I have enabled the following fields to adress the first problem I encountered (namely that the writer no longer seems to care that global id is a read only field and skips it for writing):  Afterwards, I ran into the next set of errors:All global id's for the update actions are filled and added as an attribute. I don't really get what i am doing wrong, but furthermore I really don't understand why the behaviour seems to be so different in the new arcgis feature servicewriter. Why do i have to jump

Hello,I have a configuration table that my FME workspace reads to update a GIS database. This table includes ArcSDE database connection information. The workspace dynamically reads each database connection one at a time and passes it to the Feature Reader. Because it's dynamic, all features are routed through the generic port.Currently, I use an AttributeExposer to make feature attributes available for processing. However, this requires manual updates whenever database schemas change, which is problematic since the workspace runs on a schedule.Is there a way to automatically expose attributes at runtime, based on the schema of the next database being read, so I can eliminate the need for manually updating the AttributeExposer? Thank you, 

Hi all, My colleague and I are preparing to do the Form and Flow certification exams. We use our work laptop to start Talview. The laptop only has FME Form 2024 (scripted). We would like to remote desktop onto our azure virtual machine to access Form 2025 for the exam.  This machine is also set up for publishing to Flow.Will Talview allow access to a remote machine for the exam? Thanks,Annette

Hi Long time user, havent posted as not been hands on in a long time but here goesWe are looking to add new extensions into GPX files Something like: <trk>    <extensions>      <htrk:HemaTrack>        <htrk:difficulty>          very_difficult        </htrk:difficulty>      </htrk:HemaTrack>    </extensions>  </trk> We have an XSD definition for the namespace as well <?xml version="1.0" encoding="UTF-8"?><xsd:schema targetNamespace="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" elementFormDefault="qualified" xmlns="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" xmlns:xsd="http://www.w3.org/2001/XMLSchema">        <xsd:annotation><xsd:documentation>    This schema defines the Hema Maps extensions to be used with the GPX 1.1 schema.    The root elements defined by this schema are intended to be used as child    elements of the "extensions" elements in the

I have an orthometric DEM that I need to convert to WGS84 Ellipsoid.   I know the CSMAP reprojector treats all raster data as 2D.I tried converting the raster to a point cloud, reprojecting it and then re-rasterizing, but I am getting a weird striping effect I don’t know how to deal with.  

Just upgraded from 2022 to the latest version for Flow and Form. Whenever I publish a workbench the publication works then shortly after the log gets the message “The web connection 'FME Account' could not be loaded”We don’t have a Web connection “FME Account “ and the task has completed anyway. Any ideas where this is coming from?  

My company does SSL inspection/interception which is causing errors when trying to view background maps in FME Form.  I have seen ways to fix this for the FME Flow (Server) side, but is there any way to change any configurations for FME Form to handle this?  The CA certificate for our authority is in the Trusted Root Certification Authorities certificate store on machines so I’m not sure why it isn’t trusted if FME is using the machine’s certificate store for trust.  Below is an example of error seeing from FME Flow 2025.0.1 (but have seen on previous versions as well).Stadia Maps Reader: Failed to load 'https://tiles.stadiamaps.com/tiles/alidade_smooth/5/19/14.png'. Error: 'HTTPSConnectionPool(host='tiles.stadiamaps.com', port=443): Max retries exceeded with url: /tiles/alidade_smooth/5/19/14.png (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1018)')))'Python Exception <FMEExcepti

Hi there,I tried to write some data to a ArcGIS Portal feature service using the new writer.  It skipped my feature as globalid was NULL, missing or empty:So i fell back to the old writer and this writes features fine. It sees that globalids are read-only and ignores them, along with the other ArcGIS server managed fields:I imported the same layer from the feature service using the writer - import layer approach, and fed the same data into both of them in the same workspace.  One works, one doesn’t.Am I missing something?Thanks,Marc

2024.2 (24820) I am building a self serve workspace app for flow. the user will drag and drop a dwg onto the app.The workspace will convert the mapped drive to UNC and use that for a featurereader.prior to the featurereader the path will go through the filenamepartextractor. The output is NOT exactly the same location as input, and changes certain parts depending on the file dragged and dropped by the user. I use the source name in the filenamepartextractor and then build the output folder (which may or may not exist in full or in part). Then there are 3 types of files to output to that folder.I currently have the output dwg name built by hardwiring the filename and extension. The form workbench runs successfully with no output in the destdataset which is set as the output attribute for the filename. there is however a file in the workspace folder named @Value(DestDataset) with no extension. Tested by renaming this file and adding dwg extension (which opened correctly in autocad). Why

I’m attempting to configure a workspace to use a database connection that is published as a deployment parameter.  However when I try to set a feature reader to the deployment parameter I getWorker 12476 > An error occurred while attempting to retrieve the connection parameters from the connection file 'SWS_GIS_DB'Worker 12476 > Failed to obtain any schemas from reader 'GEODATABASE_SDE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationWorker 12476 > Failed to read schema features from dataset 'SWS_GIS_DB' using the 'GEODATABASE_SDE' readerI published the database connection myself and created the deployment parameter so I’m not sure why form cannot use it.  I would like to use the deployment parameter as opposed to having the user have to select the connection themselves. 

Goal: Use the KLIC Transformer output to produce a FileGDB. I have used Esri Geodatabase (File Geodb Open API) as the writer. What the workspace does: Reads raw KLIC output, Builds dynamic layer name, GeometryValidator → GeometryCoercer, AttributeKeeper keeps only required attributes, (Latest attempt) GeometryFilter to keep only Line geometry to avoid mixed-geometry, FileGDB FeatureWriter with Feature Class or Table Name = dynamic layer name, Dynamic Schema Definition = OFF, Table Handling = Create If Needed (sometimes Overwrite If Exists while testing), No dynamic schema port connected. What happens: Translation reports success, In the output GDB, I get only one feature class (the first encountered). For all other values in the dynamic layer name field, the writer logs warnings and doesn’t create those classes.What I’ve tried: Narrowed the schema with AttributeKeeper. Verified in an Inspector that dynamic layer name field has many correct, distinct values (not just one). Deleted the o

I am trying to automate the conversation of a large series of CAD drawings to save the data to be used in ArcGIS Floor Aware apps.One of the criteria is to have levels / floors in a building sorted in vertical order, with the ground floor as 0 and increasing by one for each floor above the ground and decrease by one for each floor below the ground.Unfortunately my data has inconsistent naming for floors. With some having a Lower Ground (LG) and or basement (B). There are also some that have a messanine (M) between Ground (G) and Level 1 (L1). To top it off there is a Roof (R) in some.So my problem is that I need to sort the list of floors in such a way that I can get the vertical order, both positive and negative,  centred around Ground as 0 where it exists. Does anyone have suggestions on how to tackle this?Here are a couple of examples and the vertical order needed.   B, G, M, L1, L2, R => -1, 0, 1, 2, 3, 4B, LG, G, L1, L2, L3 => -2, -1, 0, 1, 2, 3LG, L1, L2, R => -1, 0, 1,

Hello yet again.This time I am experimenting with a complex Microsoft Excel document, its basically a calculation file that contains quite a lot of sheets, macros, references and formulas. Idea is that instead of sharing the excel document with the people that need to use it that I would just host it on our Flow, people would then have an option to fill out some published parameters in a flow app and then get a single excel sheet returned with their results (cutting out all the underlying datasheets and formulas and macros etc).Or to sum it up: I have a complex excel with formulas, read that excel in FME, change values in cells in FME, write out an excel from FME that would then recalibrate/recalculate based on those changed values.So I have figured out how to single out cells in the excel table where (basically using counter, and tester for that single number, link to attribute manager where the new value can be inserted to replace the old one, back to a FeatureMerger to put the new v