FME Form

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 

I am reviewing some of the Transformers I either rarely use or have never used and came across the Feature Holder. Can someone provide me an example or two of why/when it would be a good idea to use the Feature Holder Transformer?

Hey. I have created a workspace on my desktop where I used source data from a local disk as part of my testing. Now I would like to have the data for all WS that use these sources in one place on the FME server, specifically on the Resources\Data path. The specific file path is "$(FME_SHAREDRESOURCE_DATA)/TopSky/AirportHeliport.BASELINE". Before publishing WS to the server I set this path on the reader as well, see attachment, however the file cannot be found when running WS from the server. Do you know where could be the problem?Thank you

Hi All,I would require your help dealing with empty values in a columnI have a file with "n" features. In one of the column (Example: Column A) certain values are null/empty. I would like to replace it with non-empty value. Also, Column A has only 2 distinct values - either null or date.Example:Feature     Column A1            Jan 20252            Jan 20253            Jan 20254            null5            null6            null7            Jan 20258            Jan 2025I would like to change Feature 4,5,6 to "Jan 2025" instead of null.In Java world, I would store them in local variable and run column A in loop and replace with value if null.Not sure how to perform similar scenario in FME. Would really appreciate your help in achieving the above expected output.Thanks in advance

Hi all.I'm having a hard time figuring out why lists with one entry, especially if it's read from XML, is mishandled in FME.A list may have any number of entries, and if reading such from XML, they often have any number including zero entries.When flattening the output, cycling thru the list, one normally uses ListExploder. However, if the list in question has one entry, it's auto-exploded, which makes ListExploder reject it. So I have to check the rejected features to see, if the list had been auto-exploded or if it had no entries at all. E.g. two or more transformers instead of just one.Why?Wouldn't it be more logical to _always_ create a list, if there are 1 or more entries ?It works as such in 2021.0Is this behaviour specific to XML (or JSON?) flattening ?Cheers.

Dear community,I want to automatically write all metadata for my geodatabase using FME. So I managed to set this up using XMLUpdater. But I only manage to do this for feature classes. I would also like to write metadata for the feature dataset, and even on the highest level, the geodatabase itself. How can I access the XML for these higher levels of gdb structure?The XML that I find with FME for a feature class only contains metadata for that particular class and not for the higher levels.Thanks in advanceNathan

I have Excel sheet with 2 fields, and I need to create folders with the values of the field 

Hi all,We have a set of points that we want to replace with symbols that are currently in a .dgnlib file. Opening the .dgnlib file does not give us the symbols directly within FME.How can we style the points using the symbols from the .dgnlib file?Kind regards,Ivan

Hello Guys I have a polygon  we need to know the length of each segment and which direction the segment is facing north , south , East or Ouest. Thanks 

I want to read some views in Microsoft SQL Server Database using a Database-Alias (not the Servername).I tried to make a DB-Connection using Microsoft SQL Server (ADO), but it didn't work with the alias (it works with the Servername).With a Microsoft SQL Server (JDBC)-DB-Connection, I can access the DB, using the DB-alias. Then I wanted to read the views, using the Microsoft SQL Server Spatial (JDBC)-Reader:I can access the database, but not the views. (In a database-application like DBeaver it works fine) TheDB- user account I use, is allowed to read the view, but not the underlying tables. Is FME not able to handle those permissions?  

This is my first time using the FeatureReader and the WHERE clause. I’m trying to tidy up my workspace and make it a bit more efficient.In the workspace I want to read in all the track points from an ArcGIS Online feature class and then in the WHERE clause filter it to just the last 24 hours.This is the WHERE clause I’m using. It has the correct date field. I’ve formatted it in the DateTimeConverter like this %Y-%m-%d %H:%M:%S."location_timestamp">='@Value(_24hrsago)'It filters immediately (I think) to what I need (first screenshot), but by the end it has passed through all the points in the feature set. Do I have the wrong output port connected up? Is there something I need to select in the parameters? This is what the FeatureReader Parameters look like. An additional question I have is if I want to filter to the last 24 hrs (as mentioned above) plus Projects A, B and C. How would I combine this in a SQL expression? I currently have this going into a Tester and then Clipper, but wo

Hi I had to create a script to be able to webscrape a web page using Selenium. I would like to be able to launch the script from FME but I don't know how to do it.If I share the script someone can help me ? thx Francesco

Which version of FME Desktop/Flow supports “Microsoft SQL Server Spatial Reader/Writer”? I want to re-project MapInfo Tables in the GIS database. Currently I’m using FME Desktop 2022.1. Is there any alternative transformer I can use to re project the objects in the live database? 

Hello,I’ve had a workbench running on FME Server and FME Desktop 2022.2 perfectly fine through the last 2 years. Suddenly, it’s throwing an error HTTP Transfer error: Transferred a partial file. I tested it with FME Server and FME Desktop 2022.2 and get the same error. When I access the url through a browser, it perfectly downloads the zip file. But the HTTPCaller fails. Request Url: https://static.aer.ca/prd/data/wells/PLA_RTF_SHP.zipAny insights would be greatly appreciated.Thank you. Sample below for testing purposes, attempting to download the file in my local.HTTPCaller settings:  Error: 

Hi, We are deploying FME Desktop 2022.2 in our server (it’s a virtual machine).  The security team had done a security scan and expected us to upgrade the FlexNet Publisher to version 11.19.6.0 or later. However, the FlexNet installer downloaded from this link (https://fme.safe.com/downloads/) is Build 11.19.2. And it looks like bonding with FME Desktop so that we cannot upgrade FlexNet Publisher individually. How can I upgrade the version of FlexNet to version 11.19.6.0 or later? Thanks in advance. Best Regards,Qubbie

Room output from an Architectural Revit model are solids. I need room polygons and I’m not finding a transformer that will do this.  Each floor of the model has a floor elevation value which would be perfect for slicing the room objects.FME version 2024.1

Hello everyone, I transformed some Orthophtos in a new coordination system and the nodata areas are black. How can I make these areas transparent? (The output data formats are TIFF and JPEG.)(I have read the related discussions, but couldn’t find the solution for my case.) Thank you for your help!  

Hi,I have encountered a problem. I have built a script that reads in from several SHP files followed by multiple SpatialFilters against another SHP file (A). The aim of my script is to check which polygons from (A) intersect with any of the other SHP files. I never know how many polygons from (A) will intersect because it is regularly updated.So, here is my problem. The result of this is a CSV and an SHP that contains the polygons that have intersected, and all the attributes from the SHP it checks against are appended. I want to remove all the attribute columns that contain only missing as values, but I have not been able to do that. The result can contain up to 25-30 different attributes! I have tried AttributeManager, NullAttributeMapper, and PythonCaller, but I can't make anything work.Any suggestions would be very helpful!

Hi,I have FTP Link, User, and PasswordHow Can I download a file using FTPCaller?Thank you for your assistance  

I am using Survey123 that generates a feature point at a default location. Every new point contains the name of the Road and from to information for the line segment. I am wondering whether there is a way to auto move that point right on top of the line segment using the Road Name information.Is there any functionality in FME that would allow me to move those points?