FME Form

I’m trying to query data from BigQuery using the GoogleBigQueryConnector and get a ‘Failed to get authorization header’ error message when trying to select a project. FME has been given access to my Google account to view and manage data in BigQuery.

Hi,I’m trying to modify the output file of a workspace using a Python shutdown script before it’s caught by the download service (or after, but before downloading). Is there any way to do that?The configuration is:workspace creating an output text file (interlis) workspace added to a Flow app with a download serviceI’ve tried to use the destination dataset parameter from the writer but without success. The script is :import fmedest_dataset = fme.macroValues['DestDataset_Interlis']with open(dest_dataset, 'r') as file: filedata = file.read()filedata = filedata.replace(',', '.')with open(dest_dataset, 'w') as file: file.write(filedata)Or if you have any clue on how to force an Interlis writer to use dots instead of commas as separator without changing the server locale, I’ll take that info as well. FME versions:Flow 2023.1.1.1 Form 2023.1.1.1 Best regards,Julien

Hi all.Is it possible to expose all attributes with a specific prefix with a transformer ?E.g. x_kjhkjhgk, x_iuyiuytiuyt and x_nmbvmnbvmnbvcAll attributes are read by FeatureReaders and renamed with a BulkAttributeRenamer.Or most I delve into doing some Python magic using the schema features and fmeobjects ??Cheers.

Hello community,I am trying to combine 2 different images. DSM (GEOTIFF) : Band 0 (Real32) as heights 50 cm GSD Orthophoto (JP2): Band 0 (RED8), Band 1 (GREEN8), Band 2(BLUE8), Band 3 (UINT8 - NIR) 10 cm GSD My workflows looks like this:  with following settings    Unfortunetly there are some pixels where values get lost, so when I add an RasterBandAdder, there are holes in it.Unfortunetly I dont know a solution where I can add those two images into one without loosing informations.  

Hi.After installing the latest beta, all my 2024 and 2025 workbenches have lost all access to our shared server and database connections.How can I restore the access without compromising everything. Will a regenerate work ?The access still works in versions 2020 and 2022.Cheers.

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). Example, Alabama’s only plant asset has parent ID Alabama01Plant.What am I missing?  Have latest FME 2025.1 Form.

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 applied when I am writing the data, instead of following up in SQL.

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. When clicking Blue (Water) the value is 11. Screenshot from FME. When viewing the Palette after using RasterPaletteExtractor it showed Blue as 0. and I cannot figure out how to get the value “11” out of it. Also If anyone can help me figure out how to write the raster file out with attribute table that would be greatly appreciated. I’m quite new with Raster, so I’m no

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 the diffuse color, which is correct. When read with the IFC_API reader:The geometry has the ambient color instead of diffuse. What is the recommended way to handle this? Do I need to wait for the next version for a fix?As a temporary workaround, would it be possible to change the ambient color to diffuse color? This seems difficult because in my actual project files, the hierarchical position of the geometry par

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:process-features("TO")}] ,"emailCcToId": "","emailCcToName": "" ,"emailBccToId": "","emailBccToName": "" ,"emailSubject": "T

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?