A space to discuss FME Form
Recently active
Hi community, does anyone know how I can convert a LAS file into an RCP point cloud file using FME?
Hello, I have a field consisting of two lines:Line 1: (empty space) String1 (empty space) String2 (empty space) String3 (empty space)Line 2 : (empty space) String5 (empty space) String6 (empty space) String7 (empty space) String8Both lines exist within the same field.My objective:If I choose to keep, for example, **String1** from Line 1 and **String5** from Line 2, then all other strings in their respective lines should be replaced with empty spaces.Alternatively, if I choose to keep **String3** from Line 1 and **String7** from Line 2, the rest of the strings in each line should become empty spaces.In short, I want the ability to retain specific strings from each line while replacing all others with empty spaces.example : Thanks in advance
Hello,I have recently upgraded from fme flow 2024 to 2025.0.1. - (still using fme form 2024 for now)(EDIT: I have since aligned the versions between form and flow, and still getting the same error.)I have a workbench which uses the SharePoint online connector transformer I am currently using python version 3.12+.I can run this workbench without any errors on fme form 2024, but when uploaded to fme flow 2025 I am getting the following issue: Any tips on how to resolve this?Thanks.
I created models in QGIS Desktop. These models repair geometries of lines and polygons. Now I want to reduce the working steps, so that the data gets directly repaired in FME. Does anyone has experience in that?
Can you help us complete this list of URLs used by FME? Some of our users work in environments with limited access to the internet and need to request access to specific URLs via a proxy . We are building a list of URLs used by FME and we are asking you for more input. Below are URLs we know FME may access in typical use. Are there other URLs you think we should add to the list? We will edit this list as answers come in.Of course, there is a multitude of web services you can connect to with FME using Web Connections and the HttpCaller transformer, and we don't want to add them all here. We are looking for URLs used by FME Workbench, standard FME readers and writers, and FME transformers. Please note: You can, of course, run FME without any internet access at all but you won't be able to use the FME Hub or access resources on the web.Workbench Startupwww.safe.com/ *fmestartup.safe.com/Help and docs:docs.safe.com/ FME Hubhub.safe.com:443**fmehubproductionopsworks-appstorage-c2mc0
I don’t know if this is a bug in build 25220, or if it’s the intended behavior. But it’s very different from past versions, and will likely cause issues in our workflows.When the ‘Merge Attributes’ option is unchecked, no Candidate attributes are carried forward in the Passed port as a shown in this screenshot. The Candidate attributes are only carried forward in the Failed port.If the ‘Merge Attributes’ is checked, the attributes are passed: However, the issue is that there is no configuration in the ‘Merge Attributes’ section that will only pass the original attributes from the Candidate. You are forced to either merge the Filter attributes, create a prefix on the Filter attributes (and likely have to remove in bulk post-SpatialFilter), or simply use the Filter attributes. No option will spatially filter the Candidates without altering the schema.I’ve found this behavior in many transformers that have the ‘Merge Attributes’ option, including SpatialFilter, SpatialRelator, PointOnArea
Hi,I am getting this annoying warning - it seems to be with dynamic writer - Using SQL Server 2017 / 10.9.1GEODATABASE_SDE Writer: Renamed user attribute 'Shape.STArea()' to 'Shape_STArea__' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute 'Shape.STLength()' to 'Shape_STLength__' based on format constraints for invalid characters, length, and caseNormal writer works fine
Hi community! Can someone tell me how I can add a basemap in FME in the Graphics Viewer?(Stamen Maps, MapBox, Microsoft bings maps..)TNKX EVERYBODY!
Hello, have bumped into the problem of generic reader not being able to read a GML and have read the literature on how to circumvent this by adding a separate reader as a resource to make the generic reader understand my GML’s. But I cannot get it to work the reader just runs and doesn't find data, no error or warning, Total Features Read 0.,So my GML is pretty straight forward as there is no problem getting FME to read it with a OGC GML reader without needing to set XSD schemas and so forth, just reads it in by default. I have tried various settings in a GML reader that have all worked and then copied that workflow when I add the reader as a resource without any luck.Have I overseen some step here or any ideas what I might be doing wrong? Send hilfen, Hlynur
Hi,I have a raster file (attached), and I would like to convert it into a 3D representation, similar to the image below. How can I do that? Thank´s
I’m using an Excel Writer in FME Workbench 2024.2. This is a workspace that will be run yearly and I have created an excel file to write to in the format that I need so that the end user gets the same output year after year. I would like to use FME to clear any existing data in the excel file from row 5 on down, but still keep the data and formatting that exists in the rows above. I tried Truncate Existing Sheet/Named Range: with my Start Row set to row 5, but cleared all of the existing data from the sheet and then wrote the new data starting at row 5. In the below images, you can see what the sheet looks like before the writer is run, the writer parameters, and what the sheet looks like after the writer is run. Is there a setting in the Writer Parameters that I need to change to ensure that the data and formatting in rows 1- 4 doesn’t get deleted? Or is there another way that I need to approach this? Any help would be greatly appreciated. Thanks! Sheet view before writer is r
We upgraded our migration chain last week from FME 2025.0.1 to FME 2025.0.2 and our Excel writers started to mess up xlsx files. Some column names are renamed and hundreds of them added all with the same name: "Created by LibXL trial version 4.5.0. Please buy the LibXL full version for removing this message."Strange thing is that not all workbenches are messing xlsx files like in the screenshot. Some of them behave as before in FME 2025.0.1. I indeed find libxl.dll library in the plugins folder of FME installation and version is 4.5.0.0.During upgrade to FME 2025.0.2 all workbenches, transformers, readers and writes are upgraded. Recreating Excel writer in FME 2025.0.2 does not help.Can someone please give me a hint if its possible to overcome this issue in FME 2025.0.2?
I have a HTTPCaller to access an API from the Dutch road service Melvin. It returns an attribute with the json including geometry (response_body - here renamed to ‘gegevens’). I am quite new to JSON.In order to extract the features I use 2 JSONFragmenters: one for the attributes and one for the geometry. I've tried many other setups with JSONfragmenters,-flatteners,-extractors etc, but I can't seem to find an answer as to how to get geometry and attributes from a json nicely joined back together.Current setup below. First I extract the geometry from the attribute (gegevens) and then from the same attribute (as the resulting attribute gets changed, thus I created another with the same information named gegevens_basis) by the fragmenter for the attributes. However it multiplies the number of attributes (700+ to 500,000+). Another setup (also below) sent all geometry to rejected. I also tried to do it from the same attribute from a junction but then I cant join then as I cannot get the id
Hi,i have an problem with the Oracle Non-Spatial (and Spatial) Reader / Writer.FME seems to have an issue when the password contains a section sign (§).Other special characters don't seem to cause any problems - at least dollar signs ($) and slashes (/) work.As soon as a § is included, the login fails.Version: FME Form 2024.2.1.0 (Build 24801)I tried with Named-Connection and with Embedded Connection Parameters.Maybe it is a similar problem as this post:Error Message:Creating reader for format: Oracle Non-SpatialCreating reader for format: Oracle Non-SpatialEnvironment variable ORACLE_HOME is not set.Connecting to ORACLE database `ABC' with user name of `CARLO_TEST' and password of `***'Error connecting to Oracle database: message was `ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt'. (serverType=`ORACLE8i', serverName=`ABC', userName=`CARLO_TEST', password=`***', dbname=`')Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' from 1 datasets. This may be due to
While looking through a folder of workspaces with a text editor, I noticed that one workspace fmw file was not in the usual XML-like format. It was instead a JSON file with a leading header line:# application/x-fme-json-workspaceThe last build/saved metadata states "FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64)" - however when I create a new workspace with this version, it is saved in the XML format. I tried a variety of FME Desktop versions from 2019 to the most recent 2022, none save to JSON, but all are able to open the JSON fmw. This question is in part simply out of curiosity, and also because I have made a small Python script that iterates over a folder to gather some metadata that the WorkspaceReader does not publish (luckily the attributes I'm looking for are in the same "path" in both formats).
Hello !I want to extract files wich have everytime a different expression but there is some text who would be everytime in the file name :Example : [200072692_ZONE_URBA_20220412] “ZONE_URBA” will be the text present everytime in my extract file.I want the String Searcher to download the files which only contains “ZONE_URBA”The numbers in the example before and after “ZONE_URBA” will change everytime because they are the number of the EPCI (french administrative numbers)After calling ZIP file from HTTP with HTTPCaller, I use the ZipExtractor to extract the zip file.Then I use the StringSearcher but I don’t know how to configure the parameters to recover only the ZONE_URBA files … Anyone got an idea ? I think it’s not something impossible but i’m beginner.Sorry for my english, I promised I’ll improve !!Thanks a lot Here my work chain :
I have a MapInfo table which I want to modify by inserting and/or deleting records.I would like to modify the MapInfo table in place.I think that I can use the Precisely MapInfo Extended TAB Writer Feature Type Parameters?https://docs.safe.com/fme/2022.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mapinfo_extended/mapinfo_extended-ft-param-w.htmMy software is FME Desktop FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)But how do I build a workspace that performs this task?How do I build a Writer transformer that recognises an existing MapInfo table?
Hi all,I seem to have an issue with writing to the Temp folder location (E:\\Temp, in this case). I will get an error like the following -Failed to write feature data to `E:\\temp\\wb-cache-NSPL_V3.2_ShortName-rUhMFp\\Main_FeatureJoiner_20 -1 24 fo 0 JOINED 0 6641bd2679d46e05f371fbb029766a8cafbc270f.ffsupdating' I've tried creating a new workspace from scratch, renaming it and I am able to copy files to that folder without any issue. I also ran FME Workbench with elevated privileges and as a different user, even with a different Temp location but no success with any of them. Has anyone here had anything like this occur? And if so, is there a known way to resolve it? I've deleted all Temp files and again, no change. All a bit odd out of nowhere!Thank you
I am having some issues converting a .NVD to .GDB to display in ArcGIS Pro. I can get the attributes all across but cannot view the geometry in FME Does anyone have any guidance on how to transform the geometry so it displays in a geodatabase in ArcGIS Pro?Thanks
Question:Is there a way to speedup the geocoding process or an alternative approach like a diifferent Geocoding service people got good results from?Background of question:I have a dataset of 21.000 adresses and want to geocode them using the Geocoder.Geocoding Service: OpenStreetMapMode: FowardTo run the first batch of 500 adresses took approx. 10 minute to run which is not that fast to be honest.
I’m migrating to ArcGIS Pro and working on a workflow to convert geodb_pro_annotations to geodb_annotations so that I can edit/create annotations in ArcGIS Pro and downgrade them so that they can be used in ArcMap and read with a legacy tool (that currently has no ArcGIS Pro upgrade path).I seem to be having an issue writing some of the features to a new local FGDB where the FeatureWriter errors out with the following message:“An error occurred while attempting to create a feature using the feature class 'StreetName_Rural_Smaller_LEVEL_63'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.}”The data is created/edited in an SDE and exported to a local FGDB for this downgrade. There are 25 annotation features containing 1 to 2,000,000 annotation records. This error seems to only occur on annotation features with more than 500,000 annotation records. The others are able to be written out to the FGDB with no issues.I’ve tried
I have a word template with me and I would like to use that template to create a new document along with the custom content dynamically. Cheers,Srikanth
Hi,I have a CSV file containing ObjectID and associated AttachmentNumber values.I want to group the ObjectIDs so that the total number of attachments in each group is as close to 1,000 as possible.How can I achieve this?
Hi, I use a FeatureReader for two purposes: to clip features with a polygon, and to select some desired geodatabase layers (of several geometry types: point, line and polygon).After the “succesful translation” the new geodatabase has been created. However, this database seems to be empty.What could be possible causes? Wrong Schema/Data Features of the FeatureReader? In the Reader I have:In the Writer I have:Connectiefile is the file where the polygon for the clipping purpose can be found. Other schema sources are not available.Any ideas?
Hi all,I have .shp data sets (100+) which I read with feature reader. The attributes’ values are saved as list ,attribute “ID” for shopA.shp has values as {0, 2, 4, 8} and another attribute “Desc_”: {cake, bread, drink}, my aim is to save them as json file so the json will look:{ "uuid" : "1b2299d1-b97a-48d9-9a99-9994491ebb34", "path_directory_windows" : "O:\\M\\A\\B\\", "members" : [ { "base_name" : "shopA.shp", "created" : "20240225", “attributes” : [“ID”: “long”, “0, 2, 4, 8”, min = 0, max = 8, mean = 3.5, median = 3, mode = None,“Desc” : char(256), “cake, bread, drink” ] }, { "uuid" : "322299d1-b94a-48d9-9a99-99944912bb34", "path_directory_windows" : "O:\\M\\A\\C\\", "members" : [ { "base_name" : "shopB.shp", "created" : "20240225", “attributes” : [“ID”: “long”, “1, 2, 3, 4”, min = 1, max = 4, mean = 2.5, median = 2.5, mode = None,“Desc” : char(256), “cake, orange, apple” ] }, Thank you so