FME Form

Hi there, I keep getting this error message: ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '405' and the message was: 'This SqlTransaction has completed; it is no longer usable.'. Details: 'Unable to apply edits. Please check your parameters.'  Any ideas? It’s attempting a truncate. I have purged temporary files and tried to replace all the connections and make a copy of the workbench but still no dice. Thanks,Joe

I have an exsiting MS Access database. I would like to insert some updated rows to the existing table named tbl_STATIONS, so that the existing rows will be updated. However, it fails with the following error.Microsoft Access Writer: Failed to write attribute `Id_station' of feature type `tbl_STATIONS'. Provider Error `(-2146825023) Impossible de trouver l'objet dans la collection correspondant au nom ou à la référence ordinale demandé.'What is the issue here?

How can I use the Python caller transformer to call Arcpy and run the ArcGIS Repair Geometry tool? I have polygons from a file geodatabase that I'm importing into our Postgres SDE. After loading them, many of the records won't display due to geometry violations. I tried using the FME Geometry Validator transformer in my workspace, but it didn't seem to resolve the issue. Alternatively, is there a way to configure the Geometry Validator (or combine it with other transformers) to repair the data?

The Extension Dictionary information is written using C#, as shown in the picture below: 

I have installed Smallworld version 5.3.2 with FME 2022. Currently, there is an issue when trying to view the tables after adding a reader or writer:In the Smallworld Explorer application, I added collection X in the Exporter section and collection Y in the Importer section.When I insert an FME Reader or FME Writer, in FME, when I request to display the collections, FME always shows the collections added in the Exporter section for both the reader and writer.Is this a bug, or is there something else I need to configure?

Any idea how I could cut my 3D surfaces pipes where the 3D surface wall stands ?Thanks

Hi All, I am trying to configure Portal from FME Forms and having this issue. I followed instructions from this earlier post. Failing to connect to Esri ARCGIS Portal | Community. While testing Web Connection in FME Forms, I get this error. I am not sure what is causing this error? Appreciate any input. Thanks  

Hi everyone,I’m trying to set up FME to geocode addresses using a custom locator hosted in ArcGIS Portal, but I’ve hit a roadblock.In the Geocoder transformer, one of the parameters is the Authentication Type, where I selected Web Service (see attached image). From there, I’m required to create a web connection. This is where I’m having trouble. I’ve been following this guide, which explains how to connect FME to an ArcGIS Portal locator. The guide seems to focus on locators tied to an "Application" type item, but our locator is a hosted locator, not an application.  Here’s where I’m stuck:  I’m using the **Geocoder** transformer in FME and trying to configure it to connect to our hosted locator.   The guide asks for information like a client ID and client sec

Hi, im doing a workspace to check DGN files and i would like to see the linear units as shown bellow: Is there any attribute to expose for this or do i need a python script for it? I have checked the DGN readers help page for this but cant realy find anything. Very thankful for any answer. 

HelloI have set up a feature reader, reading a geopackage and have also set up a user parameter requesting the GSS code from the user to find.When i add “gsscode” = $(LOCALAUTHORITY) nothing is exited via the reader, however, if i remove the where clause from the reader and add a tester with gsscode = $(LOCALAUTHORITY) everything works as expected.Please see images below, but any ideas what is wrong.  I dont mind having a tester, but would just like to remove it and use the WHERE Clause..Regards Andy Feature Reader Parameter  

Bonsoir,Je rencontre des difficultés pour télécharger des données depuis la plateforme data.gouv et des données IGN (BD Topo, BD Carto) via URL en utilisant FME.Je ne sais pas si cela provient des liens url que j’utilise, des Transformers employés, ou des paramétrages de mon workflow FME.Mon objectifJe souhaite récupérer des données exploitables selon les thématiques suivantes : environnement, économie, agriculture, etc.En pj, mes traitements en détails avec des captures. Merci d’avance de votre précieuse aide

If i run this command in the command prompt (OS) it takes about 15 seconds.M:\\Survey\\'COGO DATA>DIR /S *.DWGIf I run the Directory and File Pathnames Reader with essentially the same parameters it takes 5 hrs! Why can't fme do this any faster?

Hi, While trying to read a shapefile, I encountered the following error. Has anyone come across this issue? It stopped reading all other files: Shapefile reader: Unexpected end of file reading 'filepath\filename.dbf'. Please report this error to Safe SoftwareGeometryFilter_InputPassThrough (TeeFactory): Failed to get block of 235 features starting at index 0Failed to get block of 235 features starting at index 0 When I tried using the FME Data Inspector, I received the following errors: Shapefile reader: Unexpected end of file reading 'filepath\filename.dbf''. Please report this error to Safe SoftwareFFS writer: Failed to get block of 235 features starting at index 0Failed to write feature data to `C:\Users\--\AppData\Local\Temp\FFS_1736990572395_5844_DATA.ffs'Failed to specify the feature index as constraints on the reader

Hi,I think this question has been asked before, but the links in its answer were broken so I’m unsure what the answer was.If anyone is able to put me in the right direction that would be greatBasically I have a complicated workspace doing a few things on large files. In order to make it more efficient I would like to know if there is a reasonably easy way to get a rough indication how long each individual transformer was running in total. Then I can get an idea of where bottle necks are, or things I could improve.Currently I just look through the log to see if something takes a while, but that's tedious. Is there a better way? Is it possible to get some sort of summary how long each transformer takes to run?I do run the workspace on FME server/flow, though I do test it locally as well.Thanks

When reading a file from the web the only options available to configure the client is the Authentication section. In some cases it is needed to tweak some of the client settings in order for requests to properly get though. Sometimes it would be nice to add custom headers or change the SSL settings for example.Of course the workaround is to just stick a HTTPCaller followed by a feature reader, however, this also means that you need to deal with temp files etc etc which just adds complexity to the workspace

I’m trying to retrieve a WebConnection using the FMENamedConnectionManager in a PythonCreator as described here.Content of the PythonCreator:import fmeobjectsimport fmewebservicesclass FeatureCreator(object): def __init__(self): fmewebservices.FMENamedConnectionManager.getNamedConnection('SAP S4') def input(self, feature: fmeobjects.FMEFeature): pass def close(self): passThe execution fails with the ErrorPython Exception <TypeError>: descriptor 'getNamedConnection' for 'fmewebservices.FMENamedConnectionManager' objects doesn't apply to a 'str' object

Hi, Can someone help me with the Chartgenerator transformer. As a result I plot a pdf that looks like this:  The only thing that I would like to do is to plot the values of the points as text labels next to the points. Like what was done before in EXCEL.  Can anyone here help me to get labels next to my points? Thanks in advance. 

Hi all,Currently I have a process that gets an excel file from an open data site, saves it into a Network File share location, and then i read it back into my workbench to continue my ETL process.(Download I am using from open.canada.ca: https://data.ontario.ca/dataset/7a049187-cf29-4ffe-9028-235b95c61fa3/resource/6545c5ec-a5ce-411c-8ad5-d66363da8891/download/private_school_contact_information_eng.xlsx)I would like to stream line the process by avoiding the need to download the file and then reading it into my workbench. I’d rather save it to an attribute and go from there. When I use a BinaryDecoder with default settings, it’s able to read the attributes (see attached image) from the attached 

I have 3 Excel files and each one has multiple sheets [T1(sheet1, sheet2..,etc), T2 (sheet1, Sheet2,..etc), T3(sheet1, sheet2,...etc). The names of the sheets in all files are identical and the name of the fields in each sheet are identical too but fill with different data. I need to join or merge each sheet from one Excel file with the corresponding one from the others based on a common field (ID) and have one excel file. I did different attempts but I did not get the right results. Could you help please.

Hi everyone,I'm trying to replicate the "Explode" functionality of ArcGIS Pro in FME. The Explode tool in ArcGIS Pro breaks multipart geometries into individual single-part features. For example, if I have a multipart polygon, it will split it into multiple single-part polygons, each becoming a separate feature in the output.I've looked into the GeometryPartExtractor, but I'm not entirely sure if this is the correct transformer or how to configure it properly for this task. Is there a specific transformer or method in FME that is directly equivalent to ArcGIS Pro's Explode?Any advice or examples would be greatly appreciated!Thanks in advance for your help.

Folks,  I have upgraded from 2024.1.x to 2024.2.1.0Clearly the Transformer Suggestor where you start typing a name and it suggests transformers to you is not working properly (I dont know what the function is officially called)But in the previous version - i would start typing and it suggested everything with that name. Now it hardly suggests anything - and when it does its decidedly odd. For instance i type the word “String” and get nothing.. Is there anyway to change the behaviour of this feature? its been useful for years and i really liked it returned a longer list.

Hello everyone,I am trying to use the change detector to compare changes from the current input data compared with previous runs to filter out Features that have not changed in order to save some processing time.  In order to do that I create a hash using the CRCCalculator and save that away. With each new run those hashes are compared agains the previously saved hashes. The ChangeDetector gives me pause though.For some tables the ChangeDetector identifies changes where there are none. Whats more is, when I rerun the ChangeDetector, second time around the results are as expected without changing anything in the workspace. Maybe anyone has some insight into what could be going on here?1st time running identifies updated features that arent updated at all2nd time running without changing anything: differ

HiI need to extract the distinct attribute values of each field/column. An example is provided below: Input    Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam Office 1980-89Row 3: Steve House 2001-5 Output:   Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam House 1980-89Row 3: NULL NULL   2001-5 Any help will be appreciated. 

Hello everyone,My colleague is trying to read a zip file in FME Form that contains 3 .xlsx files. My colleague read in this these three files and exploded the data, so it looks like image 1 and we were wondering how we would be able to transpose it to image 2. A criteria is that A1, B1,C1 should be in the same row  as shown as in image2. I was thinking of using the xlsx_row_id variable and maybe the name of excel file as attributes for sorting that out later. However, to go from image 1 to image 2  beforehand is unfortunately still  a bit of a mystery to us. I looked up into the attributetransposer, but that didn't yield the result I wanted. image 1image 2

Hi all,I’m facing some troubles converting IFC data to Cesium 3D Tiles.Background:I have several IFC files containing mostly 3D objects concerning civil engineering source coordinate system: EPS:2056 different, user-defined PropertySets different IFC versionsGoal:Cesium 3D Tiles with all attributes (PropertySets)What I did so far (transformers in FME):Adding a dynamic reader with autodetecting IFC version Extracting PropertySets from Geometry Doing some cleaning on Geometry, i.e. removing extra Bounding Boxes and adding Vertex Normals Scanning the schema Writing dynamically to Cesium3DTiles FME Version: 2024.2.1.0 (Build 24801)Problems:some features are missingI cannot see why some features/objects are missing. They obiously run through all transformers until the writer. There are no errors, only 2 w