FME Form

Hello, I am hoping to get a little guidance on how to properly extract m-values from a ESRI line feature class. In ArcGIS Pro, I can confirm that my feature class is m-value enabled. I need to extract the m-value locations in FME, convert all the vertex locations (with associated m-value) to points, then use the neighbor finder transformer to join the m-value to my point data. I’m having trouble isolating and exposing the m-values from my source line data. In the Feature Information for the line data, I can see a “Measure (1)” value under Geometry > Line (screenshot below). Under Coordinates, if I click into an individual coordinate the value is displayed as: -11697066.4549, 4955884.293300003 Measures:<default_measure> = 0.035799999997834675 How can use an AttributeExposer (or other transformer) to properly isolated the coordinate and associated m-value data into a list? Once it’s in the list I’ll be off and running and can also handle any unit conversion that is necessary. Any info is

FME 2025.0.2.0 I’ve built an embedded custom transformer which uses a web connection as a parameter. When I initially use the custom transformer in my workspace I’m able to specify a deployment parameter for the value of the web connection. e.g. However, as soon as I close and re-open the transformer properties the connection becomes invalid and the OK button is disabled: It’s not possible to re-assign the deployment parameter as the connection value unless I first clear it, then re-add it. I’ve tried various workarounds (e.g. creating a standard published parameter to hold the deployment parameter value) but I can’t get this to behave like I think it should. Has anyone been able to successfully use deployment parameters for web connection values in a custom transformer? Also, not sure if it makes a difference but I’m using a custom web service for my web connection.

Hi, I would like to save a copy of Map Image Layer from Esri Portal into gdb. Esri ArcGIS Portal Feature Service does not recognise raster layers and ArcGISOnlineConnector does not recognise geomety. What is the way around?

Hi! I’m using FME Workbench 2022. I’m trying to insert some data in a table in PostgreSQL. The table has a composite key, like this: (id, feed_id, env_id). The table, obviously, has the constraint: CONSTRAINT agency_pkey PRIMARY KEY (id, feed_id, env_id). In FME, I’m reading from a GTFS file, doing some transformations, and then, trying to write into the DB with a FeatureWriter using PostgreSQL as Format. I have all the configurations right. I checked it so many times, and before posting this question, I talked to some experienced mates. The problem I have is, in runtime, the FeatureWriter is not adding the attribute called “id” to the insert, so the database is sending the error “null value in column id violates not null constraint”. It happens with and without bulk mode. Now I’ll provide some images for visual context and information. Flux: Data in logger: FeatureWriter Parameters: FeatureWriter User Attributes: I added the Debug to the log to see what is happening in the FeatureWrit

Hi there, I am trying to calculate a rolling average across a dynamic number of features for a certain attribute. I saw this post here explaining that you can do it using the adjacent features parameter in the attribute creator: Calculating moving average (3 rolling points) in FME. | Community However my issue is that the number of features that the rolling average needs to be calculated over is dynamic, it could change depending on the requirement of the incoming data. This number of features required is stored in an attribute called ‘consec_avg_requirement’. I therefore need to be able to set the number of prior features to use in the rolling average to be whatever the value is in that field -1. The only option shown here is to use a user parameter… but is it possible to assign an attribute to a user parameter that could vary with each run?

Occasionally the upstream service from external provider might not retuning any features, in those cases, there will be 0 features going to the “Revised” stream. How do I stop ChangeDectector instead of keep running and delete existing features.

Hi, I’ve got two polygon datasets A and B, and I’d like to identify which polygons from dataset B that touch polygons from dataset A, but only edge to edge contact count as touch. How can I get the ideal result or exclude vertex touches?

Dear all, I am trying to do something that seems very simple :I have a table that has 3 columns “id”, “category”, “value” and I would like to reshape it in wide format “id”, “category.A”, “category.B”, etc. (in R, it would be reshape(dt, direction=”wide”, idvar=”id”, timevar=”category”) I have tried the AttributePivoter with the settings : Group rows=id, group columns =category, attribute to analyze = value but it does not work, in the output I still get the 3 columns id, category, value with missing values everywhere in the category and value columns what am I doing wrong ? would another transformer do the job ? thanks in advance

How to trace downstream in the network with multiple sources and accumulate the value from the intersected nodes of each trace? To Illustrate please see below. Black circles are the starting points. Appreciate your help.

Is there any way to get the “path” of a transformer so that it can be reported for a custom error logging solution. The standard FME log file has this information but I can’t find any way of getting at it inside a workspace. For example, in the image below we can see log lines being reported from a ParameterFetcher transformer which is inside the Log_Error custom transformer. If I could even just get the name/instance of the custom transformer that would be helpful but something really useful would be to have access to the <prior> transformer. I’ve seen some other posts on this topic which talk about hard-coding log messages but it would be nice to have a more automated approach and those posts are all from before Safe changed the way log files work to include the links to the transformers…. I guess what I’m really looking for is access to something like the FME equivalent of a stack trace from any point within a workspace.

I’m creating an automatic process to read in data in a feature reader and then output same attributes in the same order that they were read in, to an oracle spatial writer. I have set up user parameters in the FeatureReader for both the data to be read in and attributes to expose(.csv) however the order of attributes is not retained and neither is the data type. Currently, the attributes are alphabetised and they are all given the same data type of “varchar2”. Any suggestions on this would be appreciated.

I am trying to figure out how to parameterise the layer name for a Portal Feature Service reader. In the screenshot below you can see the highlighted Layer Name field. However it does not seem to have the ability to set it as a user parameter. You can see it is possible to set other layer variables as parameters, eg Input Geometry Type, etc. Just wondering how I might do the same for the layer name?

I upgraded a workspace with a dynamic writer from FME 2022 to FME 2024. When inspecting the schema before writing there is fme_date and fme_datetime time fields. When writing to geodatabase it created dateonly fields from the fme_date fields when using FME 2024. When writing to SDE we get a ORA-210 / ORA-308 (invalid field type). What is the solution to this problem? I posted this before as addition to another forum topic. However someone from FME suggested to make a new topic.

Hello Forum, Does FME Form have the concept of creating a layout which could then be saved as a image file or PDF? So, think about how in QGIS I may bring several vector layers and some base mapping together and post to a ‘print layout’. Into that print layout would go the vector layers and base map. I may then add a title, north arrow, map, legend etc. I would then export that layout out as a png or PDF. Does FME Form, have a similar concept. I’ve been looking in FME Form and running online searches but have found nothing, which is surprising. Any thoughts? Thanks, Stuart

Hi all, I'm working on a workflow using FME where I want to use the SQLExecutor transformer to query data from a File Geodatabase I've set the input to point directly to the FGDB file, and tried several SQL queries — even very simple ones like:

We have several Database Connections for our workflows, and most of them are for our county ArcSDE geodatabases. Each one has a Default version and a Sync version for editing, and we have all of the connection strings saved with the Sync version. We use FME through a Data Interoperability license, and after FME updated to 2025.0.0.0 (with the ArcGIS Pro update to 3.5 from 3.3) the Version Type is now set to ‘NONE’ for all of them instead of ‘Version from SDE Connection’ like it was before, and the Transactional Version is set to Default automatically. Plus, it seems to us that our connections strings have changed too. We found this the hard way, after changes were written straight to Default. So I guess I’m writing to see if anyone else had this problem, or to see if we’re missing something - I haven’t found any posts or fixes in the changelog about it yet. And, are there tips for how we should be storing these database connections? (I am aware it could just be a Data Interop issue - w

I have logged a support case about my problem, but figured I might as well check to see if anyone else have encoutered this problem: I am writing a workspace to geosynchronize a Feature Service with a database. The Feature Service contains about 30 layers that need to be updated, so I have put my bet in for a dynamic workspace, since the operation is the same for every layer. This saves me a lot of transformers and makes the maintenance of the workspace much simpler. My challenge here is that both the FeatureReader and FeatureWriter requires the name of the layer to be passed in as a parameter, not the layerid, which would not be a problem. Almost all of these layers have names containing, at least, one space, and this is what is causing my trouble. On the reader side, I can enclose the layer name in double quotes, like “My Layer”, and this works without problems. On the writer side, however, things are messed up. I have so far tried three different approaches: Enter the name “as is”,

Hello to all,3 months ago, kailin told me that the 2024 version did not allow writing zones. I would like to know if it is the case now. If not, what is the planned schedule because for the moment we are blocked for the enrichment of our models Best regards Bruno

Hi, Anyone used the i-twin model API to download data? Any advice?

Hello, i saw this in FME documentation : “... The ACAD format writer will look for custom hatch patterns in custom <filename>.pat files located in folder specified by the ACAD operating system environment variable, or in the related folder for any installed AutoCAD product. The REALDWG format writer will look for custom hatch patterns in custom <filename>.pat files in the <FME install folder>/plugins/realdwg/Support folder. Predefined patterns can be found in the acdb.pat file in that folder, and additional patterns can also be added to that file.” The Autodesk AutoCAD DWG/DXF Writer is fine : i get custom hatch patterns in my dwg file. (didn’t try REALDWG Writer) But when i use the Autodesk AutoCAD Map 3D Object Data Writer, i get the warning : “AutoCAD Writer: The combination of pattern type 'Custom-defined' and pattern name 'MYHATCH' was found to be invalid. Using a default predefined hatch pattern of value of 'SOLID'” How are custom hatch patterns managed in this case ? (using FME

From the attached image, I am running a workflow for QAQAC for 2nd Level Check of Electricity Data, and I discovered that some of the transformers is showing under Incomplete Transformers, and also I am having an error showing (ERROR_2.1B:Wrong QA/QC WorkflowKindly run data with the most recent workflow) based on the way the FME Administrator developed the workflow. My question is this, if a workflow is developed with older version of FME like 2 years Gap, does result to some Transformers been listed under Incomplete Transformers, and how can I resolve such Transformers.

I am trying to set up a process that downloads new zip files containing shapefiles from a Google Bucket. The bucket contains four folders at the top level and in each of those folders are folders for individual project areas. In those project folders there are mp4s, pdfs and zip files with the shape files. I would like to just download those zip files, and keep them grouped by project, and none of the others every time the flow is triggered. So far I have figured out out how to list the files and filter out everything else not a zip file. The list is great but I want to download them and not just list them. This is my first time working with Google Cloud Storage buckets.

I have a workspace in 2023.2.1 that is writing to ArcGIS Portal. What I am finding that in some cases the original layer that is in portal had spaces in the layer name i.e. Layer Name. When it is written to Portal either FME or Portal replaces the spaces and with underscores i.e. Layer_Name and when I try to update it, FME can’t find the layer as it is looking for the original name with the spaces. The only attribute that is available is fme_feature_type or my user parameters. Is there a way to create a parameter prior to both of these writers that replaces the spaces with underscores and is then available to the FeatureWriter layer name attribute?

Has anyone resolved the workspace log Warning for coordinate system when working with Snowflake Spatial Reader? Coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' has changed from `LL-WGS84' to `' If you set the coordinate system on the Snowflake Spatial reader to LL-WGS84 the warning changes to. NOT changing coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' from `LL-WGS84' to `' -- mapping file setting of `LL-WGS84' overrides coordinate system `' read from file. If you set the coordinate system on the Snowflake Spatial reader to EPSG:4326 the warning changes to. NOT changing coordinate system of reader identified by keyword `SNOWFLAKE_SPATIAL_1' from `EPSG:4326' to `LL-WGS84' -- mapping file setting of `EPSG:4326' overrides coordinate system `LL-WGS84' read from file. Ultimately the Warning has no impact on the workbench or translation, the data is definitely LL-WGS84 and a CoordinateSystemExtractor will confirm this but best practice for me

I have a Microsoft Access Database Table. I need to delete all the records in it and just keep the schema. Basically, the output will be an empty table. There are 10,000 records in the table. Delete all records in Table A. Table A will be empty. Just keep the Table A schema. I know I can use the SQLExecutor with a SQL Statement to do this, but how to do this using Transformer(s)? What is the best way to go about this?