FME Form

I’ve seen both examples of creating KML:https://support.safe.com/hc/en-us/articles/25407754952717-Creating-KML-Folders-Through-KML-IDshttps://support.safe.com/hc/en-us/articles/25407609389453-Creating-KML-Folders-By-Feature-Type-FanoutI’m able to create folder structure:When I tried to add placemarks under subfolder, my folder structure gets overwritten.   Subfolder has ID in the form of State and AssetType (minus spaces and special characters, you can see the ID below in folder name

Hi all,I’m encountering an issue with the InlineQuerier transformer in FME Form 2024.2.1 (pre-production environment) that seems to differ from previous behavior.(FME Form 2024.1.3 in developement environment)🔧 Workspace Setup:The InlineQuerier has two input ports:tubes (can sometimes receive no features)parametre_generique (always receives data)I’m using this request :❗ Problem:When no data arrives at the tube input port, the transformer throws the following errors:InlineQuerier_2 (InlineQueryFactory): Generating output 'tubes_statuts_inactifs' using query 'SELECT * FROM "tubes"WHERE (    UPPER("statut_administratif") NOT IN (

Normally I use FeatureReader to import my datasets. This time I am dealing with a 4.5 GB GML dataset. What are the best settings to improve reading speed for my FeatureReader? Just like a general approach to use, reading GML file is just an example. I also other formats like .gdb, xml, json etc.I try to use the SpatialFilter when possible which makes the reading already more targetted. Hence, its switched this time also using my study area as Initiator.  

I need to write my data into an MSSpatial database with a spatial index. However, when setting the SQLSERVER writer to the following then I do not get any spatial index generated. When I now go into SSMS to ‘clean up’ after FME Form then I face the issue that I have a column id of type identity, but it isn’t a PrimaryKey. Looking into the possibilities to set an index in the attribute definitions I can see that I set the index to ClusteredNotNull. I can also see there is no possibility to generate a ClusteredPrimaryKey, as it is necessary to create the spatial index. I assume I am going somewhere wrong here and would like to hear how I get my spatial index generated and

Hi All,I am trying to migrate Dimensions from AutoCAD to ESRI. But while doing so, i get an error "An error occurred while attempting to set the 'DimensionShape' property on the 'IDimensionFeature' interface for the dimension feature class 'PD_ServiceDim100'. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.}". I have assigned the coordinate system in dwg. I have tried by normally migrating the Dimension as well as re-projecting the same, but am getting the same error. To test, whether the coordinates are correct or not i placed a point feature in the same and was successfully able to migrate (without reprojecting) it to a point feature class in GDB. Not sure, whether any attribute is creating a problem for Dimensions. Any ideas ?

Hi everyone,I'm encountering an issue when running a workspace in FME Workbench, and I get the following error:“Zorba Internal Fatal Error”What would be the best way to troubleshoot or fix this issue? 

Hi everyone, I'm facing an issue in my workflow: when I process two shapefiles with the same name, the Feature Reader (in Generic mode) interprets them as a single file. This causes an error in my Join. Is there a way to handle this so both shapefiles are read separately?

I’m working with getting raster imagery in the area of interest out from the WMS. It’s the Land Coverage WMS. (https://dmsdata.cr.usgs.gov/geoserver/mrlc_Land-Cover-Native_conus_year_data/wms?)End goal is to clip the Raster out from WMS into smaller area, and I need to be able to write attribute table showing the value number & RGB value in the Raster.End Product. (Smaller Raster with attribute table)​​​​​​The issue I’m having is that the Palette index seeing inside ArcPro and FME is different. (Approximate location, SE corner of Possom Kingdom Lake, Graford, Texas, USA.) (32.856463, -98.431004)Screenshot from ArcPro.

Hi everyone,I have a very large dataset made up of numerous GeoTIFFs that I need to merge using FME’s RasterMosaicker. Unfortunately, the process stops due to memory issues, most likely because of the amount of data being processed.What’s the best way to get around this limitation and still perform the mosaic?

Hello,I've encountered an issue with how color attributes are read by the different IFC readers.The IFC reader (deprecated) reads a color value as the diffuse color, but the newer IFC_API reader reads the exact same value as the ambient color.Consequently, when using a writer like the CityGML writer, the diffuse color information is missing, which results in incorrect materials being created in the output file.Let me show you with a simple IFC example.When viewed with BIMVision: The color appears correctly as expected. When read with the IFC reader (deprecated):The geometry has

How can I maintain the exact postgre data type of numeric , when write it back to database. The image below is the database datatype (numeric)  used used as a Reader but the above image is the writer output data type as numeric (1000,500) 

Is anyone else encountering  vertices that are not displaying when Mark Coordinates is turned on in the Data Inspector? The coordinates are in the feature record, and display when I select them. Currently using FME 2025.1The features I’ve noticed this in have been donuts, and it’s the inner ring that is not appearing.

 I have workflow that pulls large groups shapefiles of different geometry types from a folder using a feature reader and then exports them to a geodatabase. I would like to export them into a feature dataset inside the geodatabase. I have tried including the dataset in the file path but that either gives me an error or results in a blank geodatabase. If I don’t try and put the data in the featuredataset and just put them in the geodatabase everything exports without any problems. How can I get the data into featuredatasets?Creating the path using an attribute manager.Putting the path in the Feature Class or Table Name parameter.

Hi all,I have two CSV files (A and B) that I've included using CSV readers, and I need to join them using a feature joiner on a specific column. CSV A contains numbers in all rows, whereas CSV B has numerous <Null> cells in the column. When I run the feature joiner it fails. I already tried:Changing both attribute types to number I included attribute managers before each CSV to include letters with the numbers of each CSV file to force matching as textDoes anyone have any suggestions? Many thanks.  

Hi,I’m struggling with reading JSON as a flat table, which I could use in GIS.I have the following JSON: I enabled option “Flatten Nested JSON Values into Attributes” but that produced one row with many columns. In some other post someone proposed a query json["collection"][*], but that also didn’t work.What options should I use to produce a flat table with JSON attributes as column names?

StringReplace does not do what I expect (version 2024.2.1.0)Newlines are not replaced, can someone please point out what I'm doing wrong?  

Hello everyone,I’m having trouble reprojecting a shapefile. The file is currently in SIRGAS 2000, and I need to convert it to WGS84. However, when I run the reprojection, an error occurs (see attached image).Additionally, I need to extract the current coordinate system of the shapefile. In the table, the field shows up as _FME_0, but it should display SIRGAS 2000.Does anyone know how to fix these two issues?

HelloIn one tester I enter a value through a published parameter. Then I have a second tester in which I would like to retrieve the previously entered value. How can I do this?Thanks

I want to filter all unique values of an attribute with the attributeFilter. Iam importing the values stright from the data source using the import Wizzard but it is failing to list all availabel values. It really caught me of guard.I checked the database for unique values marked “Correct” in the image vs the wrong output by AttributeFilter.I used DuplicateFilter to aslo check for unique values and it returned the same as my SQL Query. Am i using AttributeFilter wrong or is it not trustworthy?   

Hi all.We’re migrating email submittals to a http based service, which takes a JSON body in a POST request.One of the fields in the post body is “emailBody”, which can be text or html.So I’m attempting to use a JSONTemplater to build this, but it fails:JSONTemplater (XMLTemplaterFactory): All features receivedJSONTemplater (XMLTemplaterFactory): The following error occurred near line 7, column 50 of the query:JSONTemplater (XMLTemplaterFactory): invalid expression: syntax error, unexpected "QName", expecting "," or "}"An error has occurred. Check the logfile above for detailsTranslation FAILED with 1 error(s) and 4 warning(s) (0 feature(s) output)Line 7 in the ROOT expression is the HTML, with escaped apostrophes and removed linefeeds and whitespace between tags:{ "emailFromId": "planinfo@lifa.dk", "emailFromName": "planinfo@lifa.dk" ,"emailAddresses": [{fme

Hi All I have an FME Server App configured for data streaming with two output: one a HTML page, the other an MS Excel file. Independently, either output is streamed to the browser but when both selected, a zip file containing both is streamed. Is it in any way possible for the HTML to be streamed to display, with the Excel file streamed for download?

I am using FME Form 2025 and the ChangeDetector to identify differences in records from two tables with the same schema. I have ChangedOutput create List(s) named “Changes”. What Transformer do I need to connect to the Inserted and Deleted Ports to get a look at the Lists? 

Setting up writer by default adds attribute: fme: fill-opacity="0.1" to each feature. Is there a simple way to add  fill-opacity="0.1"to each feature instead ?  UPDATE: As per a comment by @chrisatsafe, I am interested in setting style per feature in this scenario to obtain this transparency effect you see below. The thing is, 'fill-opacity' has to be set to the same value 0.1 for all features within dataset.  Thank you,Aleksei

In addition to the defaults “name” and “type”, I would like to add a third, custom member named “data_owner” at the start of a GeoJSON file I am creating using the GeoJSON Writer (see example below). Is there an easy way to do this - I can’t find anything in the writer parameters - or do I need to use the JSONTemplater or another transformer? (FME 2023.2.0.0){    "name": "gis_assets",    "type": "FeatureCollection",    "data_owner": "CompanyName",    "features": [      {        "type": "Feature",        "geometry": {          "type": "Point",       etc.

Hi everyone,I'm working on a workflow that writes/updates features to an ArcSDE database using FME. The process completes successfully without any errors or crashes. However, I've noticed that for certain tables, the geometry (and possibly other data) is not actually updated in the ArcSDE database.I'm fairly new to ArcSDE and would appreciate any guidance on what might be causing this issue. Specifically, I’d like to understand: What table properties or configurations could prevent updates from being written, despite a successful translation? Are there permissions, versioning, or schema-locking issues I should be aware of? This is a non versioned table but the writer only works if I select versioned. Archiving is activated for the specific table. Is there a difference in how certain tables are registered with the geodatabase that could affect write operations? Any tips on how to investigate this