Transformers

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 expectedA fatal error has occurred. Check the logfile above for detailsThanks 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 | CommunityI 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 PRIMARYFIELDError: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?

HiI 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 1Route 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.1FME 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 modulesimport arcpy # Set environment settingsarcpy.env.workspace = "C:/data" # Set local variablesinput_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 Masksarcpy.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.htmI modified the script in PythonCaller to fit my d

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_pathif (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 <- 2025output_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

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

I’m trying to retrieve a WebConnection using the FMENamedConnectionManager in a PythonCreator as described here.Content of the PythonCreator:import fmeobjectsimport fmewebservicesclass FeatureCreator(object): def __init__(self): fmewebservices.FMENamedConnectionManager.getNamedConnection('SAP S4') def input(self, feature: fmeobjects.FMEFeature): pass def close(self): passThe execution fails with the ErrorPython Exception <TypeError>: descriptor 'getNamedConnection' for 'fmewebservices.FMENamedConnectionManager' objects doesn't apply to a 'str' objecteven 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. 

Hi all,Currently I have a process that gets an excel file from an open data site, saves it into a Network File share location, and then i read it back into my workbench to continue my ETL process.(Download I am using from open.canada.ca: https://data.ontario.ca/dataset/7a049187-cf29-4ffe-9028-235b95c61fa3/resource/6545c5ec-a5ce-411c-8ad5-d66363da8891/download/private_school_contact_information_eng.xlsx)I would like to stream line the process by avoiding the need to download the file and then reading it into my workbench. I’d rather save it to an attribute and go from there. When I use a BinaryDecoder with default settings, it’s able to read the attributes (see attached image) from the attached HTTPCaller, however, when I run it, It just fails with this huge hexadecimal error log. FYI, I am running FME Workbench 2022.2, and I shared a portion of my workbench in the attached zip. Anyone have a similar process that can provide some guidance? Am I limited to only downloading? Any and all h

Hi everyone,I'm trying to replicate the "Explode" functionality of ArcGIS Pro in FME. The Explode tool in ArcGIS Pro breaks multipart geometries into individual single-part features. For example, if I have a multipart polygon, it will split it into multiple single-part polygons, each becoming a separate feature in the output.I've looked into the GeometryPartExtractor, but I'm not entirely sure if this is the correct transformer or how to configure it properly for this task. Is there a specific transformer or method in FME that is directly equivalent to ArcGIS Pro's Explode?Any advice or examples would be greatly appreciated!Thanks in advance for your help.

Folks,  I have upgraded from 2024.1.x to 2024.2.1.0Clearly the Transformer Suggestor where you start typing a name and it suggests transformers to you is not working properly (I dont know what the function is officially called)But in the previous version - i would start typing and it suggested everything with that name. Now it hardly suggests anything - and when it does its decidedly odd. For instance i type the word “String” and get nothing.. Is there anyway to change the behaviour of this feature? its been useful for years and i really liked it returned a longer list.

Hello everyone,I am trying to use the change detector to compare changes from the current input data compared with previous runs to filter out Features that have not changed in order to save some processing time.  In order to do that I create a hash using the CRCCalculator and save that away. With each new run those hashes are compared agains the previously saved hashes. The ChangeDetector gives me pause though.For some tables the ChangeDetector identifies changes where there are none. Whats more is, when I rerun the ChangeDetector, second time around the results are as expected without changing anything in the workspace. Maybe anyone has some insight into what could be going on here?1st time running identifies updated features that arent updated at all2nd time running without changing anything: different (this time correct) results 

HiI need to extract the distinct attribute values of each field/column. An example is provided below: Input    Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam Office 1980-89Row 3: Steve House 2001-5 Output:   Owner Building_Type Building_ AgeRow 1:  Steve Office 1970-79Row 2: Adam House 1980-89Row 3: NULL NULL   2001-5 Any help will be appreciated. 

Hello everyone,My colleague is trying to read a zip file in FME Form that contains 3 .xlsx files. My colleague read in this these three files and exploded the data, so it looks like image 1 and we were wondering how we would be able to transpose it to image 2. A criteria is that A1, B1,C1 should be in the same row  as shown as in image2. I was thinking of using the xlsx_row_id variable and maybe the name of excel file as attributes for sorting that out later. However, to go from image 1 to image 2  beforehand is unfortunately still  a bit of a mystery to us. I looked up into the attributetransposer, but that didn't yield the result I wanted. image 1image 2

​Bonjour,Je bataille depuis quelques temps avec l’appel de l’API SIRENE v3.11https://api.insee.fr/catalogue/site/themes/wso2/subthemes/insee/pages/item-info.jag?name=Sirene&version=V3.11&provider=insee En utilisant un HTTPCaller j’arrive bien à faire fonctionner l’API mais je ne comprend pas comment appliquer les variables de la recherche multicritère de l’API POST /siret.Avez vous déjà fait appel à cette API et des conseils à me donner ?Merci d’avance :) Voici l’appel à l’API que je souhaite : Et voici les paramétrages que j’ai essayer dans mon transformer :Fonctionnel mais sans filtresNon fonctionnel