FME Form

I have a query relating to raster analysis in FME Form using the RasterExpressionEvaluator I want to extract the maximum value of each pixel from a multiband raster, so for example if band 3 has the maximum value compared to bands 1 and 2 for a particular cell, only the value for band 3 for that pixel will be extracted and used in the resulting single band raster.  The syntax I believe should work for this is as follows in the attached image but I cannot get it to work. The "maximum/max" functions are unavailable in the transformer and I am thinking that this logic not be usable on data of this type or within this transformer.  Can anyone confirm if maximum syntax is workable on this transformer or even have another method of how to go about this? Thanks Andrew

How to access ADO work-items from FME ? I explored different ways like providing personal Access Token, Username password but it is giving Status code 203 Non-Authoritative Information

Hi, I'm recently working on a workflow that creates a customs IFC property set and pushes it back to an IFC file. I have gone through all the materials I can find online but still encountered a problem.  The GeometryPropertySetter successfully outputs the traits I intend to set (see column 1&2 in the attached image) but for some reason they can not be written in the IFC file. I can supply more info if required.  Does anyone know what is causing this? Thanks a lot.

I need to create a Minecraft world from the FME Workbench that is compatible with MinecraftEducation.It is possible to import a world but only in .mcworld format.I'm trying to update my workbench but it doesn't work.Help me please

I believe currently each FME Flow engine only uses one core per engine. Meaning each workspace that is being ran is only utilizing one CPU core. My question is does this also apply to Python ran through a Python Caller in the workspace when being ran in FME Flow? For example, I have a Python caller running an Esri tool and set the parallel processing of the tool to be 5 (meaning the Esri tool will use 5 cores). Does this mean the Python will use all 5 cores? Or does FME Flow still limit the Python from only being able to use one core?

Workbench was set up in FME 2020.2 where the Writer spits out a csv file, however in the new FME version 2023.1 it creates a sub folder then spits out the csv file. How would I configure so it doesn't create a sub folder?

Hi All, I'm putting together a workbench to run a multi criteria analysis (MCA) based on a hierarchy (hierarchy level 1, 2, 3, 4, 5, 6, etc). The conditional values in the Attribute creator will help me with that. The problem is that some of the values of the hierarchy need to the next level of the hierarchy . Here is the hierarchy that needs to be followed:  - Hierarchy Level 1- Hierarchy Level 2- Hierarchy Level 3 o Exception A : Any record in level 3 is ‘No main habitat’ will go to level 4 in the hierarchy, if level 4 is empty then goes to level 5, if level 5 is empty then goes to level 6, if level 6 is N/A then goes to level 7.- Hierarchy Level 4- Hierarchy Level 5 o Exception B:  Any record in level 5 is ‘Individual Tree’ then goes to next level 6 in the hierarchy, if level 6 is N/A

Hi, I create a filter in an Excel worksheet and then I want to read the filtered result with FME. Is that possible? Or do I have to copy the filter result to a second worksheet?

Hi, I have a workspace that write to SDE using a dynamic schema. The schema is build from an excel sheet where I have the name of the field, the type and the alias. I manage to write to SDE with all the correct parameter: attribute{0}nameattribute{0}.fme_data_typeattribute{0}.native_data_type The problem is that I cannot find a way to write alias. Anyone know if this is possible within a dynamic schema?  thank you!

Does FME support a connection to active directory with a group managed service account (gMSA)? Or are only regular accounts supported?

Given a call to a stored procedure like this:declare @return_value intexec @return_value = dbo.myProcedureHow do I re-assign @return_value to e.g. an attribute or a variable?

Got a situation where I would like the store attribute values, @Value(attribute_name), in some HTML code which itself is stored in a SQL table. The idea is that the @Value(attribute_name) will be different for each of our clients, sending them a personalised email based on their own data. Currently FME reads the table in and keeps everything as plain text, @Value(attribute_name) does not get replaced with the appropiate attribute value. Is there a way to get FME to recognise the attribute names in the HTML code and replace it with the appropiate attribute values? if I copy and paste the HTML code into atttributecreator then it works as expected, however we would like to manage all this in SQL server - saving us having to update the

I'm attempting to use FME to inventory folder locations for all shapefiles and file geodatabases, and all feature classes within the file geodatabases to export to an excel file. I am able to identify all shapefiles and geodatabases, and can complete what I'm attempting to do but the performance is really slow. Some background on the workbench I've made - I'm using the feature reader transformer to read the file geodatabases to identify the feature classes (Esri Geodatabase (File Geodb Open API) Reader). The workflow seems to be getting super bogged down at this transformer. I've set the parameters to read only 1 feature, but it still seems to be reading all of the features within the feature class. Is this just the nature of the transformer or is there something I'm missing that's causing the transformer to still read all of the features? I've attached a picture of the feature reader parameters below - any suggestions are greatly

Hi, I'm trying to create a connection with my enterprise ESRI account, but only have the option to enter a username and password, when I can only connect to this account via SSO. Any idea how to work around this? I have set up a web connection to my ESRI account but it doesn't automatically connect to the map service through this.

I have two layers point and a polygon, I wanted to have the aggregate of a column name "Progress" with its respective polygon name and polygon id. The progress field in the point layer has the values namely 1, 2, 3, 4, 5 . The count is the total number of points inside the polygon.  The result should be like this   I have currently done this process in FME The result is How to change the workbench to attain the desired result. Any leads will be helpful. Thank you. 

Hi, i have a problem where most of a large number of point clouds are missing the first number of the gps_time attribute, so "367091181.0231084" should be "1367091181.0231084". It is always a 1 that is missing at the start.What would be the best way to go about changing this attribute for every point in every pointcloud?The context for this is that the point clouds are data from lidar mobile mapping and need to be matched using the gps_time with trajectories in another software.Any help would be much appreciated.

FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) Hello As stated in the subject line, the Feature Caching icons can be seen in the "Main" tab but not showing in the "Custom Transformer" Tab at all. However the features are cached. So I think they are just missing.   ThanksSameer

Hi, I need help and guidance. I have 2 questions. 1st. I've been using the GeometryValidator transformer and selected the OGC standard checks. When I run it, all my geometry fails. How can I check what is failing and how to fix it? If possible, please provide an example of how to fix it. 2nd. I've read the OGC Geopackage standard and found that there are some tables that need to be included in the Geopackage file, such as gpkg_spatial_ref_sys and gpkg_contents Table. Is there an automatic way in FME to create these tables, or do I need to do it manually? Hereby, I am attaching the file for your reference, tqvm all.

Hello, I would like to prioritize a layer using the AreaOnAreaOverlayer transformer, is it possible ?Thanks

Dear All, I am experencing the following problem on FME (FME Desktop 2022.1.0.0 - Build 22618 - WIN64)  : when I work with PythonCaller, my workspaces randomly crash. For example, starting from empty workspace, I add a Creator followed by a PythonCaller ; run to the PythonCaller -> it works fine ; I add "import arcpy" in the PythonCaller and run -> it works ; I add "print("hello")" in any function of the FeatureProcessor class -> it crashes. Also, the crashes happen in an unpredictable way : sometimes, it crashes after having inserted "import arcpy" ; sometimes I can add 2-3 five more lines in the function of the FeatureProcessor and it works and then after 1 more line it crashes. By crashing, I mean the following : after clicking "run", the mouse cursor takes the form of a blue waiting circle during a few seconds and the window suddenly closes -> when it crashes, it seems that the trans

Hi, I want to amalgamate polygons from a map of natural environments to distribute it on a larger scale (1:5000 to 1:25000). For this I used the AreaAmalgamator tool with the settings that can be seen in the photo. I have 12193 objet in total. However, the software has been running for 10 hours and nothing is happening. Has anyone ever had this situation? 

For instance, one 58 unit apartment results in 17 rows with variously 1-24 units added together. We can't explain why this is happening but need to fix it. Have also tried adding a dupliate filter and another aggregator but this didn't work. Any suggestions are appreciated.

Is there a way of validating that the data contained in an attribute is valid based on a table of values?I know I can use a CSV list in a tester with 'in'. But my table of preset values is 4-500 entries long, and has the possibility of change, is there a way of comparing directly to this table, or using the table to populate the CSV value (maybe through a parameter?) automatically?

Hi,I'm trying to convert a DGN file wiht mixed geometries: most of them are read by FME; but not all. It seems like the geometrytype "smart solid/surfaces" isn't read by FME Desktop at all? Is it possible to read those geometrytypes? We really need them ;-)Added this message are pictures of the same file showed in MicroStation and in FME Desktop. Also added is the DGN file.

 I have used @PadLeft(@Format(%.3f,@Value(FLOW)), 8) in an earlier attribute manager in the workspace to format the values to three decimal places and pad left. My output data and workspace are as shown below: