FME Form

@david_r​ Hello David, Need your help on the issue related to distributed engine setup with FME standard trial license where single engine is installed separate machine and remaining FME components on another host including Flow database on same. Kindly refer below link with example#2 that has been followed.https://community.safe.com/s/article/A-Guide-to-Choosing-your-FME-Server-Deployment-Architecture#FTEx2I have attached the log snap for your reference.Thank you.

I have yet to successfully use dates as an axis in ChartGenerator. Ideally, I would like to be able to use more natural date formats e.g. %B %Y or %m %Y and set the scale accordingly based upon time increments. Is this possible (in Chart Generator or another transformer) ? Or am I going to need to take it out into PowerBI, Excel, etc?

I have a dataset from a spreadsheet that i have created a counter for each row successfully. The SQL table i am importing this dataset into has a primary key (highlighted). This primary key is not recorded anywhere in the database as a sequence number. I have added in a statisticsCaculator transformer to obtain the max number.  I want to insert each row from my dataset (first screenshot) but i want to insert the LUPID as count + LUPID.max. so i end up with 1691+1 = 1692, 1691+2 = 1693, 1691+3 = 1694 etc for each row what transformer would i use to do this?  

Solved with LISP (.lsp) and csv export. Read my last post I working on a script that need to test some parameters in a hundres of dwg files.Just to make it short. Autocad_layer_frozen and Autocad_layer_description are two attribute that I need to check and what I use in this example. However, the only way I have succeeded so far to get empty layers visible is to use a dwg reader and choose individual file types. B No data of course. Nothing is read since the layer is empty.  Both DWG reader and feature reader can only read layers that are not empty. Feature reader and with format "Any schema" can read all layers, also empty layers, but does not contain the native autocad attributes like Autocad_layer_frozen and Autocad_layer_description. Is there any way to read empty layers to get all the attributes that exist in a autocad layer feature with only use of FME?

Hi, I have a couple of queries, I will try my best to elaborate. I am transforming to DGN cell to CityGML.1) How do i ensure, that exterior rings are counter-clockwise, and interior rings are clockwise? I am using the Orientor Transformer, and setting Let-Hand-Rule, however, on surfaces, i still see (from using Inspector against the CityGML) that the polygon is right-hand rule.2) When viewing the resultant CityGML in Inspector, it is showing the wall surfaces rather strange..... some are rendered as exterior (solid) representation, some have the interior (dashed) representation.Does it matter that FME represents it in this way? or does it actually mean something? is it related to point1? These are shown as right hand rule (i want left hand rule).Thanks,Steve

Yesterday I used the FME clipper transformer to curve out unwanted portions in a polygon feature class from another polygon feature class. Both feature classes are in two separate Esri file geodatabases. It is a very simple geoprocessing operation, but it runs very very slow, measured in hours, some even became hung. Tested this in several feature class datasets, the same behavior - terribly slow. On the other hand, using the Erase geoprocessing tool in ArcGIS desktop, it finishes in 2 - 5 minutes for all the tested datasets. The results between FME and Esri Erase tool are exactly the same. So wondering why the FME clipper is so slow. I have been successfully promoting FME in my company in the last few months, but this came as a big slap on my face. I am at FME 2019.2.

I'm wondering how to use the Python Caller transformer to run the arcpy.RepairGeometry_management geoprocessing tool. I'm working with some input File Geodatabase data that's getting re-projected and producing self-intersections. The Geometry Validator transformer is identifying these but not repairing them (i.e. they come out the Failed port, not the Repaired port). I confirmed that using ArcGIS Geoprocessing tools on the same machine fixes the self-intersections, so I wanted to use the Python Caller to do the exact same thing in the context of the FME Workspace. What I'm getting is a generic error though, see below. Maybe my syntax is incorrect but I've tried a few different ways and haven't had success. Any help would be appreciated! Python Syntax:import fmeimport fmeobjectsimport arcpy # Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameter

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 then goes to level 7- Hierarchy Level 6 o  Exception C: Any record is N/A then goes to next level 7 in the hierarchy.- Hierarchy Level 7 The following screenshot shows the conditional statement for

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 workbench everytime there is a change required to the HTML Thanks

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 appreciated!

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.