FME Form

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 secret, which seem to apply to an Application type item in Portal. Since our locator isn’t an application, I’m not sure what to provide for those fields.  Can someone confirm:  Is it even possible to use a hosted locator from ArcGIS

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  Tester 

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 Thank you for any suggestions on how this can be resolved. The file is recognized in ArcPro. Thanks,Magda

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' objecteven though the documentation clearly states that the first parameter must be a string object (connectionName (str))What am I doing wrong?

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 HTTPCaller, however, when I run it, It just fails with this huge hexadecimal error log. FYI, I am running FME Workbench 2022.2, and I shared a portion of my workbench in the attached zip. Anyone have a similar process that can provide some guidance? Am I limited to only downloading? Any and all h

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: different (this time correct) results 

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 warnings saying:NOT changing coordinate system of reader identified by keyword `IFC_1' from `EPSG:2056' to `IFC_COORDSYS_0' -- mapping file setting of `EPSG:2056' overrides coordinate system

hello there we need to calculate the length of each polygon edge , the polygona could be in irregular shape considering the polygon is 4 edges if we use chopper or Geometrycoercer  transformer we get many edge  we are suppose to get only 4 Thanks  

​Bonjour,Je bataille depuis quelques temps avec l’appel de l’API SIRENE v3.11https://api.insee.fr/catalogue/site/themes/wso2/subthemes/insee/pages/item-info.jag?name=Sirene&version=V3.11&provider=insee En utilisant un HTTPCaller j’arrive bien à faire fonctionner l’API mais je ne comprend pas comment appliquer les variables de la recherche multicritère de l’API POST /siret.Avez vous déjà fait appel à cette API et des conseils à me donner ?Merci d’avance :) Voici l’appel à l’API que je souhaite : Et voici les paramétrages que j’ai essayer dans mon transformer :Fonctionnel mais sans filtresNon fonctionnel

Hello everyoneI am trying to do the following: My workspace writes into a database. I have set a user parameter to give the user an option “delete Database and start a fresh database OR continue adding data onto existing data”. In case of deleting the Database the creation of IDs (which are created in the Process) should start at 1. In case of adding data to the existing database the creation of IDs should continue from whatever the max value already existing in the database is.I believe this should work as follows using a YES/NO User Parameter.Test Filter on that User Parameter:YES → Sampler (create single initiator) → SQL Executor (delete all data with “delete from tables”)NO → Sampler (create single initiator) → Feature Reader on Database → Statistics Calculator (extract max ID) Now in a different path within the workspace I have a Counter which I use to create the IDs. I thought I could simply use a conditional Value set on my YES/NO User Parameter withYES → Start at 1NO → Start at

Hi having an issue where my FME data update job is running fine from Desktop when you click run.  But when I published the job to FME server and set up an automation to run nightly, it seems to be pulling in old data when it runs. The job reads an excel spreadsheet in a folder and plots it and inputs the output data into our SDE.  It seems like when I publish to FME server the excel spreadsheet is not being picked up live from its file location.  

Happy 2025!I’m processing some OpenStreetMap PBF data and have found a duplicate attribute name, hard to believe but I think an artifact of OSM’s XML ancestry, two attributes differ only in string case, like my_attribute and My_Attibute.  My processing changes all attributes to lowercase so I have two fields my_attribute.  I tried a ListDuplicateRemover on the Schema output of a SchemaScanner but I get an invalid schema definition.  Does anyone with knowledge of FME internals have a tip for dropping one of the duplicate attributes?  Thanks.

This is a HowTo.I had a hard time adding a raster to an HTMLReportGenerator. Thanks to some remarks in an old Question of the Week I found a solution. Many thanks to ​@mark2atsafe!I share my solution here for others that may encounter the same problem (and for myself, in case I encounter the problem once more in a few months 😉).HTMLReportGenerator can't use a raster, but it can use an image. This image must be in binary encoding. The image can be embedded in the HTML, so it suffices to have a temporary image. The temporary image will be automaticaly removed when the workspace finishes.So the process becomes:Use a TempPathnameCreator to provide a path for temporary storage of the image file Use a RasterExtractor to convert the raster to a blob Use an AttributeFileWriter to export the blob to a temporary file. Specify FME-binary Encoding In an HTMLReportGenerator embed the temporary file as an image