Transformers

Hello Community, I have data in the following format: Attribute value field1 a field2 b field3 c field1 e field2 f field3 g field1 j field2 k field3 l Which transformer can I use to transpose my data into this format? field1 field2 field3 a b c e f g j k l The names field1, field2, and field3 can be dynamic, and their number may also vary

I am using a WorkspaceRunner so that I can run multiple times the same FME workbench on different DNG separately. Just to be clear I will call the WorkspaceRunner to the workbench that runs the “child” workbench, and i will just call Workbench to the child workbench. I was all working fine the first times and now I find that some User Parameter (in my case “DNG”) I was “sending” from the WorkspaceRunner to the Workbench is not working anymore (I didn’t change the parameter in the WorkspaceRunner but maybe i used it in more places inside my Workbench). When I run it directly inside my Workbench it makes no problem. But when I run it from the workspacerunner the following error appears: ERROR : Undefined macro `DGN' dereferenced in file `G:\Buzon\Miguel\CQ_topologia_copia\wb-xlate-1738321227449_8672' I think the wb-xlate is a temporary file of some sort. I have a wb-xlate in the root of the project but not the name does not match the one appearing here. That wb-xlate actually contains th

Hello Everyone, I am trying to use RCaller in FME 2024.1.3.0 with R version 4.3.3. To get started, I followed the tutorials, but in every case, the script gets stuck at RCaller. There are no errors or warnings—it simply does nothing and keeps running indefinitely. The last thing I see is: It seems that the connection to R.exe is working. Does anyone know what beginner mistake I might be making?

Hi All, Need your help fix the below scenario, I have a dataset approximately 100,000 records and these records have Polygon geometry I am using "aggregator" transformer to group the records as per column attribute and it creates 100 aggregated records. My requirement is to show each aggregated record as 1 shape on the map when user clicks on it. Issue: I am facing issue with geometry aggregation. When I plot data on ArcGIS online, I see all 100 aggregated records, but see some empty spots on the map.If I plot the same data on map without aggregating it, it plots fine. looks like something is going wrong with geometry aggregation. Would really appreciate if you could provide some input on how to handle it. Below is the configuration of my Aggregator transformer, Thanks,

I’ve got a test filter with about 12 different output ports. My goal is to unfilter all of these but have an attribute of “test result” and the value set to which output port the feature filtered through. Is there a way to expose the output port name? I know I could add attribute creators after each port or set one with a conditional statement but was hoping there was an easier way.

I am using FME Form 2021. I have been running two workspaces for about a year now. These upload spreadsheets to an SFTP site. Every once in a while, I get this error message: The FTPCaller Error Message from the Rejected Port: Error in the SSH layer This error prevents the spreadsheets from being uploaded to the SFTP site. Usually, the error seems to go away after a few days with nothing done on my end, and then the workspaces run normally. There does not seem to be a pattern of when the error is received. I checked the Log Files, and they show nothing unusual. I checked with our IT Network Admins, and they say nothing is blocking files from being uploaded to the SFTP Site. Here is a screenshot of the parameters in the FTPCaller Transformer I use: Questions: What is the cause of this error? Could the error be on the side of the folks who manage the SFTP site? (outside my organization) Is it a bug in FME Form 2021? Is this error received when using FTPCaller Transformer in FME Form 2024

Hi, our ArcMap license will expired tomrrow and will not renew after it expired. Also, I have Arcgis pro installed on my machine and the license is valid (will not expire). Currently all of my script setting is set AUTO under the “Esri ArcGIS Compatibility” . Will the AUTO setting pick to ArcGIS Pro license, after ArcMap license is expired? or do i have to manually set to ArcGIS Pro in each FMW script individually? “FME Workspace, go to Navigator --> Workspace Parameter --> Translation --> Esri ArcGIS Compatibility --> AUTO” thanks, Wilson

Is there anyone here already converted esri file gdb or shapefiles to mbtiles? I tried but it's giving me this errors: MBTILES writer: Failed to obtain raster from feature. Only features with raster geometry are expected A fatal error has occurred. Check the logfile above for details Thanks for the help.

I have been checking a lot on this link but its not exactly what I want. Combine overlapping/touching lines into one long simple geometric line | Community I have one geopackage with lines of different types that overlap, 2 attribute types, the blue type and the red. As you can see they overlap. I want the red lines to take priority, meaning where the red lines are the underlying blue lines should be remove so I only have 1 layer of polygons with the 2 types. Note that the length of the blue line doesn’t always match the length of the red so the underlying blue line have to be cut. I have filtrered them, tried line combiner, line on line overlay which generates INVALID_POLYGON_GEOMETRY_VERTICES error. Reader polylines with attributes TestFilter, filters and splits the 2 types I want based on the type name ??? Before reader im gonna do a snapper since dataset have some gaps some of the read doesnt reach the entire way to the blue in some instances. Result example (also want snapper in t

The documentation is not entirely clear here for how to upload files to a ACC store using the AutodeskDocsConnector. I seem to be able to upload folders..However when i try to upload files i get an FME rejection message that says. Any ideas? 'NoneType' object has no attribute 'status' AutodeskDocsConnector

I am trying to find shortest distance from all points to all other points in my dataset. the data set contains network lines and points The points feature has only types (A,B).100+ points of typeA and 500+ points of type B. Is it possible in FME to have the short path finder to search the short path always starts from point A to pint B.Then write the output to writer.

Hello, I can Successfully connect SharePoint list in workflow , can perform Insert operation with no issues, as soon as Change Detector finds the record updated from Original Key field with Revised Key field values with update transform in SharePoint list, i am getting error for FMEException - where last part the PRIMARYFIELD Error: Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Writer: Client-side error: '400 Client Error: Bad Request for url: https://cambridgeca0.sharepoint.com/sites/DesignDeliveryDigital/_api/web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)' returned from SharePoint. Error message was: 'The expression "web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)" is not valid.'

Hi, I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN. I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

Hi I am having an excel sheet like below. I need to group them in Field name route and assign a value for route field . let's say (routeNo) or any other unique value. the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones. Any help is highly considered. Route 1 Route 2

My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it. Is there any workaround for this without having to change the password ? This happens in both FME Desktop and Server. Edit @TiaAtSafe: The password also contains this special characters $&@= Versions: FME Server 2017.1.1.1 FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)

Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum! I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are 20+ polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed. Does anyone have any tips how to solve this?Many thanks! //Andréa

Hello everyone, I am trying to run the Feature Outline Masks tool from ArcGIS Pro in FME using the PythonCaller transformer. I am new to Python and would greatly appreciate your assistance. I copied the script from the ArcGIS Pro tools website (as shown below) and made modifications to fit my data: # Import system modules import arcpy # Set environment settings arcpy.env.workspace = "C:/data" # Set local variables input_layer = "roads.lyrx" output_fc = "cartography.gdb/transportation/roads_fom_polys" reference_scale = "25000" spatial_reference = arcpy.SpatialReference(4326) margin = "5 meters" method = "EXACT_SIMPLIFIED" mask_for_non_placed_anno = "ONLY_PLACED" attributes = "ALL" # Execute Feature Outline Masks arcpy.FeatureOutlineMasks_cartography(input_layer, output_fc, reference_scale, spatial_reference, margin, method, mask_for_non_placed_anno, attributes) Source: https://pro.arcgis.com/en/pro-app/3.3/tool-reference/cartography/feature-outline-masks.htm I modified the script in Pyt

Hello, I have a geodatabase file to update with FME : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several attributes. First in my script, I read the geodatabase file. Then I change some values and create new ones. Finally, I use a "Esri Geodatabase (File Geodb)" writer to update former data and insert new data at the same time. I chose feature opeartion "upsert" and table handling "create if needed". When I open the resulting "updated" gdb file in Arcgis Pro, I can see the updated data and... only part of the new features. There are several of them missing ! But why ? Here is what I should have : And here is what I get : Am I doing something wrong ? Is there a way to correct this ?

I have built a custom transformer. Now I am looking for a way to share it with my colleagues, without having to actually sending them te file. Ideally, I’d have them show up like all other HUB-transformers like this: However, as the trasformer contains private information, I connot actually upload it to the hub. Is there a solution, for example through FME Server, where I can get my custom transformer show in this list, only for my colleagues?

Hi, I am using the Change Detector transformer and had planned on using the Match all Except Selected Attributes parameter for the Attribute Matching Strategy since my list of excluded fields is shorter than the list of included fields. I'm wondering if this parameter is working as it should? Everything appears to have changed when I used this parameter (which is not correct). However, when I reverse it and use the Match Selected Attributes (and select all the appropriate fields), it works as expected. I can use the transformer the way that I have it working but I was wondering if I am missing something? Thanks, fiona P.S. I'm using FME 2013 Build 13264 WIN 32 with SDE 10.1 data (from SQL Server).

Hi, I have a sample R script. While the output is correct, FME is logging incorrect information. The Code: library(sf) shp_path <- Output$shapefile_path if (is.null(shp_path) || shp_path == "") { stop("location empty or no exists.")} shp_path <- normalizePath(shp_path, winslash = "/") if (!file.exists(shp_path)) { stop("location not found: ", shp_path)} print(paste("read shapefile:", shp_path)) shape_data <- st_read(shp_path) if (is.null(shape_data)) { stop("Error in shapefile:", shp_path)} shape_data$ano <- 2025 output_path <- shp_pathprint(paste("Writing:", output_path)) st_write(shape_data, output_path, delete_layer = TRUE) print("Success.") Log below: Error in utils::read.table(value, sep = sep, header = header, skip = skip, : no lines available in inputCalls: dbWriteTable -> dbWriteTable -> .local -> <Anonymous>In addition: Warning message:In file(file, "rt") : file("") only supports open = "w+" and open = "w+b": using the formerExecution haltedFailed to execute scripted code Than

Any idea how I could cut my 3D surfaces pipes where the 3D surface wall stands ? Thanks

Hi everyone, I’m trying to set up FME to geocode addresses using a custom locator hosted in ArcGIS Portal, but I’ve hit a roadblock. In the Geocoder transformer, one of the parameters is the Authentication Type, where I selected Web Service (see attached image). From there, I’m required to create a web connection. This is where I’m having trouble. I’ve been following this guide, which explains how to connect FME to an ArcGIS Portal locator. The guide seems to focus on locators tied to an "Application" type item, but our locator is a hosted locator, not an application. Here’s where I’m stuck: I’m using the **Geocoder** transformer in FME and trying to configure it to connect to our hosted locator. The guide asks for information like a client ID and client secret, which seem to apply to an Application type item in Portal. Since our locator isn’t an application, I’m not sure what to provide for those fields. Can someone confirm: Is it even possible to use a hosted locator from ArcGIS Port

I’m trying to retrieve a WebConnection using the FMENamedConnectionManager in a PythonCreator as described here. Content of the PythonCreator: import fmeobjectsimport fmewebservices class FeatureCreator(object): def __init__(self): fmewebservices.FMENamedConnectionManager.getNamedConnection('SAP S4') def input(self, feature: fmeobjects.FMEFeature): pass def close(self): pass The execution fails with the Error Python Exception <TypeError>: descriptor 'getNamedConnection' for 'fmewebservices.FMENamedConnectionManager' objects doesn't apply to a 'str' object even though the documentation clearly states that the first parameter must be a string object (connectionName ( str )) What am I doing wrong?

Hi, Can someone help me with the Chartgenerator transformer. As a result I plot a pdf that looks like this: The only thing that I would like to do is to plot the values of the points as text labels next to the points. Like what was done before in EXCEL. Can anyone here help me to get labels next to my points? Thanks in advance.