FME Form

HiI am currently trying to create a web connection in FME desktop but it says the following: Unable to store connection. Please try againSQL Query INSERT INTO fme_nc_namedconnections (connectionname, username, servicename, connectiontype) VALUES (?, ?, ?, ?) failed. Error: attempt to write a readonly database This happens with any connection type I try with this particular windows user account. If I log in with a different account, I am able to save the connection, but I no longer use that account and need to run it through this one. Does anyone know how to resolve this please? Thanks  

Hey guys, So I ran into a problem I shouldn't have. For my workspace I'm trying to subtract two integers from one another. The problem that I'm facing is that the arithmatic expression is not giving me any usable data. This is also the case when slightly change the expression. Below is the most recent attempt. Can anybody point out how I might be able to make this work?I have performed similar expressions in older versions of FME with no problems whatsoeverI I'm currently running FME 2024.2.4.0. The data type is originally Real64 but I converted it to Int32. Any help would appreciated. 

I have land parcels that are currently separate features in ArcGIS SDE.  Below highlights 2 parcels that that belong to the same property 1st and 2nd floors.  (2nd floor is the smaller shape)I want to aggregate these into a multi part single feature grouped by an ID that they share called LANDNO.After using the aggregator transformer, it looks like the below where the second floor has been totally cut out leaving nothing.  I haven’t tried a Disslove yet but I reckon that would remove all vectors of the second floor which I still want to keep.Here are the settings in Aggregator.   Any suggestions to achieve my objective ? 

I’m building a value for the Longitude of a point feature. The field type I have defined is number (20,6) I create the value using this in the text editor:   @Format(%.5f,@XValue())So I want 5 decimal places.   eg.     15436225.30510However, what I see in my result table viewer is 15436225.3051   (no trailing zero)But when I double click on that value, it displays the value “with” the zero.  15436225.30510 The value that gets written to the writer (to AGOL) is the one without trailing zero.Works fine until I use a change detector, then it decides that the trailing zero is causing a difference and wants to update the value to have the trailing zero.So my question is,  can I enforce the trailing zero in the table result?  Then I will rewrite my destination records one time again and hopefully my change detector will realise they are the same from that point on.   My original format statement again is :  @Format(%.5f,@XValue())

Hi, I am trying to insert feature from DWG format to GDB (with existing schema) .While translating I am getting following error. Kindly let me know how to avoid this error. FileGDB Writer: A feature could not be written+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `RD_Road_Infra/CURBSTONE'Attribute(string: UTF-8)           : `filegdb_type' has value `geodb_polyline'Attribute(string: UTF-8)           : `fme_color' has value `1,1,0'Attribute(string: UTF-8)           : `fme_feature_type' has value `GIS_DROP KERB'Attribute(string: UTF-8)           : `fme_geometry' has value `fme_line'Attribute(entangled: string: UTF-8): `fme_type' has value `fme_line'          entangled to filegdb_typeAttribute(string: UTF-8)           : `multi_writer_id' has value `0'Coordinate System: `'Geometry Type: IFMELineNumber of Coordinates: 2 -- Coordinate Dimension: 3(370808.8449767388,2682910.8213489666,271.036)(370808.4028391096,2682894.483091897,271.015)=============

 I try to find out how i pass attribute values assigned during runtime to the shutdown script.I want to pass values of total features read and written from the feature reader\\writer. I have tried to create private parameters and set the values in runtime with the attribute manager. But the values are <null> / not set when i fetch them in my python script  This is the value I am tying to set my private parameter as.I feel somehow this is the wrong way to do it? What other ways can I set dynamic values that I can use in my shutdown script for logging.

I have been able to successfully connect to Asana by using two resources (attached at the bottom) and extract a list of task names and custom field names, but I have been unsuccessful in using the JSONFormatter, JSONFlattener, and the JSONExtractor tools to create a list of tasks and their corresponding custom field values for a specific Asana project. If anyone is experienced in working with the Asana API to collect this kind of data from a particular Asana project, I’d be really appreciative of any helpful tips to create a final output of a project’s tasks and their custom fields. Thank you so much!https://hub.safe.com/publishers/safe-sandbox/web-connections/asana)

I know I that you cannot delete feature under DWG, but what if you want seleteed a few because one of them is bad.  I am GIS Specialist and I have the DWG files here… The DWG I have is a campgound that somebody worked on it and gave it to use and as I prepare to make a map for that campground and discovered that one of the entity I think “X” is out of  place.What I was trying to open the 2024.1 Data Inspector and bring that Dataset into the View to see it andI use the X to turn it off and use the Save As as a new Dataset without the  “X” layer . When I save it and it still  comes with it every time. I tried to use different method.here is the screen shot I have here.  The one I want to remove this X layer under the DWG Layer is “X” . The Red line I drew is that one that I want to delete it. I don’t have the latest version to 2025 yet… Can anyone tell me if there is another way around to fix this ?          

HiI am doing a comparison of multiple AGOL feature services and am using a workspace runner to iterated through the feature services. I have created a published user parameter for the feature service name, which is populated by the workbench with the workspace runner. This appears to work fine but the problem is I cannot seem to make the layer name a parameter so it keeps reading the layer name from the feature service that the agol reader was set up with originally.Does anyone know a way round this please? Or perhaps it is resolved in a newer version of FME desktop (Im currently using 2023.1)?

Hello, I'm currently working with FME 2022.1 on NETCDF files from https://daac.ornl.gov/cgi-bin/dsviewer.pl?ds_id=1851 The files are .nc4 and when I try to open them on FME Workbench I have this warning. (on picture) It seems that FME can't link the dimensions defined in the file with its own "lat/lon and time functions" I tried opening these files on ArcMap 10.8.1 and the dimensions are immediately recognized correctly.  How can I make FME understand that lat = lat, lon = lon and time = time ? Or how can I set it when reading the nc4 file ?  

 Hi, Screenshot sample of data above: Essentially I have a csv with several sites (columns C-G), to import this data into the software I use, I need to import one site at a time, so i’m looking to split this csv into several csvs which contain the date time columns and then one site column per csv. I can do this in a convoluted way, using multiple attributekeepers to split the data, is there any quicker way to automate this? Thanks  

Hi everyone,I'm working with a topologically accurate line network in FME 2023.1.1.1. I have:Two source points located at the start points of some lines (also refer to pipe-network_plus_point-features.png)→ the blue rhombusValves represented as point features, located somewhere along the lines (not necessarily at endpoints)→ the magenta colored pointsMy goal is to identify all topologically connected lines starting from each of the sources and continuing until the valves are reached. Each group of connected features should be treated as a separate subnetwork. In this case, I expect to identify two distinct subnetworks, one for each source. Also refer to desired_result.png and the detail 1 and 2.Has anyone tackled something similar? I’m looking for a solution that ideally avoids using Python and relies on standard FME transformers (e.g., using loops or topology-based logic).Any suggestions or best practices would be greatly appreciated!Thanks in advance

Hello all,is it possible to use one AttributeRounder to round different attributes to different accuracies?Let’s assume i have two attributes, A and B. I want to round A to 2 decimal places, whereas i want to round B to three decimal places. Is this possible with one AttributeRounder or do I need to use the AttributeManager.Cheers!

 I have a parent WS that runs a load of WorkSpaceRunners. I want to pass on some User Parameters from the parent to the “kids”, see settings below. The child workspace is already setup with these User Parameters and run fine with them when run on their own. I have not been able to find any documentation on this, so the settings below are my best guesstimate. My steps are User Parameters in parent -› User Parameters in workspacerunner settings -› User Parameters set up in child workspace settings -› use them in child workspace.So, how do I fix this?Does the child WS need to be set up in a special way in order to pick up the incoming parameters? Is there a misstake in the syntax? Anything else I can look into?  

I'd like to understand what this error means in the following context and how I might go about resolving it. I have a workspace that works perfectly fine if I run using cached features up to transformers just prior to a FeatureMerger then run from the FeatureMerger to a writer. However, when I try to run the entire workspace it results in an error that aborts the translation at the writer. I've also tried many other methods of joining these 2 streams and all are resulting in the same error output. MULTI_WRITER: No MULTI_WRITER_TYPE{*} or MULTI_WRITER_TYPE{3} was specifiedIt seems like I need both streams to be ready at the FeatureMerger at the same time but I have not been able to gain control over execution order or block passthrough features through a variety of attempts. The goal is to read from both a CAD model and a DB, then compare the two datasets on a unique key, then write an SQL statement to a text file or SQLExecutor. I've only attempted this with the text file writer while 

No bookmark navigator in 2024.2Bookmark navigator in 2023In FME 2023.2, there was a "Show Bookmark Navigator" checkbox under Tools → FME Options → Toolbars.In FME 2024.2, this option seems to be missing on my system. We're in the process of switching versions and noticed it's no longer there.I use this feature frequently to quickly navigate between bookmarks in large workspaces.I've attached two screenshots showing the difference between versions.Has this functionality been removed, renamed, relocated or is this a bug?Thanks in advance.There is no additional detailed info in the docs:https://docs.safe.com/fme/2024.2/html/FME-Form-Documentation/FME-Form/Workbench/options_toolbar.htm

HiWe are migrating from one AGOL portal to another (with regional hosting). I have used the AGOL connector to list all service definitions of hosted feature services, download/upload the .sd files and publish the service on the new portal. This appears to have been successful.However, I am now trying to compare the feature services in each AGOL account and am struggling. I want to iterate through each feature service and compare it with the the one on the other account using the Change Detector. I have used the AGOL connector to list all the feature services and fed that into a feature reader. Unfortunately, all the features just come out the generic port without any schema so it seems impossible to compare the feature services. Does anyone know a way this could be done please?Also, I need it to finish with one feature service before it moves on to the next one. Is this possible?Many thanks 

We've set up a process for a client that takes data and writes it to CSV. That CSV is then loaded into a data warehouse.That CSV conforms to the official CSV standards and thus the last line ends with a CR/LF:Shown here in Notepad++. This means there's a last, empty, line in the file. The data warehouse system apparently cannot handle this. Is there a way to remove this last CR/LF from the file? (post-processing python, probably).I must admit I am not convinced this should be fixed on the FME side, but trying to get the data warehouse developers to move on this is not going to happen.

Has anyone else had any issues with the SubstringExtractor in FME2025? I have a process that works in an older version (2021) but in the 2025 version I am seeing a different behavior.Wanting the last 7 characters in a string I used a Start Index of -7 and an End Index of -1. This worked in FME 2021. When opening the workspace in FME 2025, it initially works, but when I upgrade the transformer from V2 to V3, it then returns no value. I created a new blank workspace and added a brand new SubstringExtractor in 2025 and saw the same result. It seems to work selecting values from the start like Start 4 End 7, or Start 2 End -1. But having the start be negative seems to always return no value. The change listed for the V2-V3 upgrade was adding bulk mode support.Hoping I am just missing something/doing something wrong here.Version is 2025.0.1.0Attached is a version of the workspace with the transformer not upgraded, that way you can see the before and after by just upgrading it on your end if

Hi all. I am just trying to do something very basic but keep getting a “1019 error. The specified feature could not be updated or does not exist” when using the update feature writer.This only happens with polygons and lines/polylines but works fine with points.The workbench below is taking a polygon boundary dataset from portal, taking a polygon from AGOL putting it through a change detector - whose unique identifier is a name in both features- then updating/inserting/deleting when necessary to essentially make the AGOL layer the same as the portal layer….Or in theory this is what i want it to do. Any help would be much appreciated.  

When ‘Remove Output Attribute’ is selected for ‘If Input Attribute is Missing’  The missing attributes (the attributes with no data) are still present in the output.  Any clues? 

I’m currently dynamically reading web feature service layers by using a feature reader and trying to write them up to AGOL. I have no issues dynamically writing to a File GDB, but if I attempt to write to AGOL, I only get a Python KeyError, which isn’t telling me anything. Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'Cadastre_Address_LGATE002'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for detailsThis only occurs when I want to write dynamically to AGOL, if I just write the exposed attributes it functions. Is there any way around this? I’m aiming to use one workspace to read in the features based on parameters, and write it out using parameters, as a way of creating and updating feature services.I should note that it seems to be half creating the feature service itself, but when it comes to write any features to the newly made feature service, the error appears.Thanks

Anyone ever developed a VS Code “language” for FME logs files? Years ago somone -  I wish I could remember who _ did this for NotePad++ and it was awesome.The defaul VS Code log view is actually not bad so this is really a - “would be nice”

Is there a way to specify that the email needs is high priority ?

The scenario is   The ask how can i eliminate to read from row 1. The attributes that I intend to process is No, Name and ID