FME Form

I'm using the TopologyBuilder with default settings to create linkage in an ESRI sourced water network - mainly because there's no node-to-node connectivity like there is in Oracle.Generally its working well but has thrown up an anomaly. The transformer has created the edges of a line which should be two adjoining mains at the left and right edge, but instead the left edge is showing as joining to itself. In the picture the highlighted main should be showing with a left edge of edgid 83360 and the right edge of edge_id 83331. Instead the left edge is 83391 - which is itself:   Any ideas why this is happening? I have used a snapper and GeometryValidator and there appears to be no issues with the geometry. Do I need to add a tolerance into the TopologyBuilder?Many thanks in advance!

Hello,I want to create simple mesh trees from Point Cloud (LIDAR) in FME. And the closest thing I came to was with the "PointCloudSurfaceBuilder" transformer.Can anybody help me with this, please. The file is the way I want the final trees look like (it seems like it is about 8 piece of pentagon polygons for each tree).And the file is the closest I came in FME.I attach the FME-Workbench file and the input LAS file (and it looks like this ).Best regards,Jonas

Hi. I try to create a HTML report (with Esri Leaflet) with point and polygone on the same map. It's possible ?

100 % new to FME and FME Academy. As a new user I have started my first trail, Integrate Data with the FME Platform. The third Module, Transform Data, has the student connect to a postGIS database, called fmedata at: I have tried this as documented, but get no response. A ping to this returns: Pinging ec2-54-214-172-21.us-west-2.compute.amazonaws.com [54.214.172.21] with 32 bytes of data:Request timed out. Is the database available? 

I use Data Interoperability extension. I try to change the location of the log file, but the Log file parameter is missing from Navigator > Tool parameters > Logging . There is another ETL tool in the same toolbox, where I can see the parameter. Any ideas why is it missing, and how can I make it visible? Thanks.

Hello everyone,For my colleague I would like to convert dgn (V8 and 3D) to a IFC file.I tried based on the following link that converts dwg to IFC. I tried to adjust the workbench from that link to make it work with Microstation (V8), however I am already stuck at the Creating the Space Geometry part. There are a lot of attributes for which I don't know what the Microstation equivalent is and I am not sure whether what I want is to currenlty possible to achieve in FME desktop 2022.For example I don't know the Microstation equivalent of these autocad attributes:Height LongName Nameautocad_entity_handleI was wondering if someone can send me in the right direction

I have a workbench that reads .dbf tabular data and .shp spatial data and writes both to a Fgdb. It works fine if I manually point to an existing gdb but when I try automate gdb creation by exposing the "fme_dataset" and use that for a location and filename, via fanout, it only writes the tabular data. I can get it to write the spatial data but it comes out in another gdb labeled "null."  I'm guessing that since the dbf and shp and not directly linked the writer doesn't see the "fme_dataset" based gdb as an option. I've even tried directly linking the table to the shp with an AttributeKeeper but its still creating a second "null" gdb instead of inserting the spatial data in the "fme_dataset" based gdb.

I am trying to visualize all speed bumps and elevation changes such that there is a height difference every 0.5m in the 3d model.What I have tried: Clip the raster using the clipper, followed by RasterStatisticsCalculator (tried maximum, mean, median) followed by Attribute manager to rename 'band0.max' to 'Height' followed by Feature Merger to join the shapefile to the GEOTIFF. Then followed by Extruder transformer using the 'Height' attribute.  I don't get the 3D roads in 0.5m resolution but rather long stretches of road surfaces. How can I change my workflow to get the elevated roads from the GEOTIFF in 0.5m resolution?  Thanks!

I have a dataset that has multiple records, each with a different types. Each of those types could have any number of records from 1 record to 5000+ records.  How can I write these records to individual files based on a limit of 50 records per file with no more than 10 types? For example: File 1 would consist of:Type 1 = 10 Records,Type 2 = 37 RecordsType 3 = 13 Records File 2 would consist of:Type 3 = 50 Records File 3 would consist of:Type 3 = 5 recordsType 4 = 45 records and so on... and so on... I've tried groupers, and I have tried building lists, I've also tried the modulocounter, but I can't seem to find a way to build this criteria with any of those. Any help is much appreciated! Thank you! I've built a sample set of data that could be used to do testing. My final output needs to be no more than 50 records per file with no more than 10 Circuit ID's in each file. Please help! 😁

I'll be the first to admit this may be a dumb newbie question, but I'm struggling! I have an input field that contains a file path like the following:q:\\staging\\incoming\\1930s\\WI\\Sauk\\1937\\Sauk_WI_WU_11_908_19370707.tifI need to construct a URL to the file as referenced in a URL, and dump it into another field:https://server.com/1930s/WI/Sauk/1937/Sauk_WI_WU_11_908_19370707.tif My conceptual approach has been to use string processing to replace q:\\staging\\incoming with https://server.com, and then replace backslashes with forward slashes. Well, you can see where this is going... the slashes and backslashes are wreaking havoc. For example, I've tried various combinations to escape the \\, like:@ReplaceString(@Value(inputpath),"/\\","/")... but I either get no results, or a syntax notice. Am I even in the ballpark?? I'd love some suggestions on how to approach this issue.  

Hi Guys, Lets assume below shown line has a certain distance , in that I need to generate line from 1.1 to 1.7. To do this can any one help me on this? Thanks and Regards,Prashanth  

Hi Guys, I need to generate values between 1 and 2 ,it includes decimal values like 1.1,1.2... Can anyone help me on this? thanks and regards,Prashanth

We are working with a legacy dataset of scanned images and are moving everything to SharePoint. We discovered these files that have all the document information stored as a title property that is lost when moving to SharePoint. We are hoping that there is a way we can rename these files with the title information using FME. I have tried to expose it using the Directory and File Pathnames reader but cannot find the attribute anywhere.

@nielsgerrits​  I have a road shape file with numerous segments (links), all of which share the same road id. Now the user has provided me with csv data, claiming that this is the bad route from chainage 0.75 to chainage 5.1. In order to highlight the road, I must add another line geometry (a long line) on top of road features. The created line must overlay eactly on top of road. the created line begins at link 1 (0.75 chainage far)and extends to link 9 at a 5.1 chainage. How do I accomplish this with fme? I tried a lot of different things, but none worked. Actual line length and chainage length are two different metrics. We can take the proportionately dividing road length since chainage length is accurateWhat I mean is that if the real length of the line is 1.5 km and the start chainage and end chainage (attributes) difference is 1 km, then it becomes 100 m = 150 m in geom length. sample source shape file attachedand source shape ,desired output line, how it looks like( jpg files) 

Hello,I use FME to transform data in S-57 format (the native format of our databases) into more traditional formats, in particular shapefiles. The database export is therefore in S-57 format (extension .000), with the classes and attributes present for the ENCs, but this model is enriched with additional attributes and classes. This can be done by modifying the files s57attributes.csv, s57objectclasses.csv and s57expectedinput.csv in the directory $FME_HOME/s57 (Custom Object Classes File and Custom Attributes File). These files are also useful for correctly displaying additional attributes and classes in QGis (in the directory C:\\Program Files<QGIS>\\share\\gdal). While in QGis an S-57 file with additional classes and attributes is displayed correctly, this is not the case in FME.For additional classes: some are handled correctly, others generate an error when read and you can't go further in the processing (there are also cases where the class seems to be ignored, without

ERROR |HTTPCaller (HTTPFactory): [1]: HTTP transfer error: SSL connect error.When I run a ws with a http-caller on a Remote desktop (and FME-server) I get the fault.When I run the same ws with a http-caller local it runs well (but very slow).There is no firewall issue running on the remote desktop and running on the fme-server.  Why do I get this error? and why is the same workspace running well lacally?Are there steps I can take to locate and solve this fault/message.

I want to put the coordinate value in the obj file modeled on the 3D building in FME Desktop and print it out as a City gml file. I'm going to upload the printed file to the website of 'CESIUM ION'. I'm curious about how to put the exact coordinate value and print out City gml and upload it. I would really appreciate it if you could tell me the process sequentially. 😂

I want to extract data within the masked polygon by using FME. Can you please guide me how it should be done. Which transformer to use?

I have a requirement to read from a service that is published to ArcGIS Portal but I need to read from a historic moment based on the last run time of my workspace. If I were able to access the database directly, I could query the archive tables. However, I need a solution that will read the service. There is an idea which requests this functionality, but so far, this doesn't appear to have been implemented. Is there a workaround for this?  I'm using 2022.2.2

I have the 2023 beta and authored a workspace that I would like to use in your latest official version (2022.2.5) which came out after. It looks like a number of updates that were in the beta are also in the official one. Before I try to open my beta workspace in 2022.2.5, I had a few questions: If the updated transformer versions match, should the prod version accept them?What is the best way to back up or document a workspace to use in an earlier version? Any insight is appreciated, and yes, I learned my lesson.

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

I am trying to create a workbench which will read in the data from a table in an ArcGIS Online feature service, where the feature service is determined by input User Parameters at each run of the workbench. The output will be an excel export of the data from the ArcGIS Online feature service table. I have hundreds of different feature services, identifiable by a unique alphanumerical code and feature service ID. The aim is for the user to input the alphanumerical code for the data they want to export when running the workbench (e.g DA019). This code will act as a look up to a table that contains the feature service ID for the required data. I have then attempted to reconstruct the syntax of the AGOL connection as seen in an ArcGIS Online Feature Service Reader.E.g [AGOL Group Name]/[Feature Service Name]([feature service ID]) I then have passed that as a field called fsid_search into a Feature Reader under the 'Feature Service:' constraint. I've included a screenshot of my

Hello everyone, I am new to FME and I would like to do automatically the task described in the photo, which is an "unmelt"s . I went and check the transformers "ColumnToRow" that did not work for me, and AttributeCreator that works but needs to add one by one every attribute "Thing1", "Thing2" ... Or maybe I missed something ?Thanks for your help !

Hi, I'm trying to convert An AutoCAD(DWG) file to Esri Geodatabase with the labels (Annotation) to attributes. How can I do that?? and also if I have the Geodatabase schema, how can i convert these labels to the attributes?

I am taking a feature reader (ESRI geodatabase) and putting a feature class through an attribute manager. The feature reader shows the guid fields correctly as guid.However, the attribute manager shows them guid fields as buffer.This is happening for all guid field. I've tried "reset table" and import from dataset in the attribute manager. I've also tried recreating the attribute manager. How can I fix the attribute types to be accuate?