FME Form

I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!

I have workspace that's using Creator, Workspace Runner and Emailer to run a parent workspace. I would like to attach the log file to both the Successful and Failure emails?

how to remove these unwanted connections from PostgreSQL Reader (highlighted) 

I am trying to edit features (location) that are within a trace network from FME.When editing in ArcGIS Pro I’m able to move features and have the network adjust (example: Move a point connected to a line and the line moves with the point) but I am unable to replicate this behaviour when running from FME. It simply moves the point feature away from the line. Notably I did have this working in a geometric network but since completing a recent upgrade and moving to the trace network in ArcGIS Pro it’s not showing the same behaviour.Is it even possible to maintain the network structure using a trace network out of FME?

Hi all,  I want to run a workbench in quick translator mode instead of running whole workbench using .bat file 

i want to generate profile point along the road both edges and paint lines inside the road edges , as shown in the picture , please suggest how to accomplish this , through out the road network. 

I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL). By default, the writer copies it into either the "public" schema or the "sde" schema. However, I aim to copy the data into a schema of my choice (which is “test” in this example). Although I've attempted to add the schema name before my table name using a dot, as suggested in an older post on this forum, I am still encountering errors. Please see the attached image for reference. FME Workflow 

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_ROLE_ID)SELECT @Value(CA_ID), '@Value(BA_ID)', @Value(CONTRACT_ID), @Value(CA_ROLE)WHERE NOT EXISTS (SELECT 1 FROM CONTRACT_ASSOCIATE WHERE CONTRAC

I have IFC file with 3D Room and Excel Records with XYZ and i am trying to clip the XYZ coordinates that totally fall or touch the boundaries of 3D Room.  I would like to confirm is that,  i am following the right steps in Workbench ? I would like to ADD 10 cm buffer to 3D rooms, so that i don’t miss any XYZ records, so not sure what is equivalent value as there is UNIT in buffer :( Also i would like the EDGES to be SHARP after applying buffer not sure how to do  PS: Attached is FME Workbench for further reference, as its does work if anyone would like to refer as well. But open for any enhancement as well.      

I recently upgraded my FME Workbench install on Ubuntu 22.04.  Everything had been running correctly before this.  I had set up the .profile in Linux to point at a much larger hard drive (7 TB) rather than the small 50Gb drive they have configured as the HOME/default.  When I am running processes on large data sets (hundreds of millions of records) the temp fills up with gigs of data so I needed that pointed to that larger drive.  After installing FME 2024 it is acting like it doesn’t see the FME_TEMP setting and longer.  I even went in the .profile this morning to check that it was still there. Have there been any changes made to the software related to this setting? If not, how do I get workbench to start playing nice again? Any information or guidance would be appreciated. 

I have a column of data with a 10-digit alphanumeric value.  I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost.  I use this exact same string function in MapInfo all the time and it works like a charm.  But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results inThanks in advance

Completely new to fme and trying to find my way.I have a GIS feature class titled wMeter.  I want to take fields from this feature class and load the data into an existing excel database (provided by others). I added the feature class as a reader and the existing excel database as a writer and field matched which fields from the wMeter feature class I want to go into which fields in the database. I used an AttributeKeeper transformer to remove the unneeded fields from the feature class and it seemed to work at first however each time I ran the form it would append the data in the database. I changed the Writer Mode to Update so now it appears that I am getting the data 2X in my results.

Hi Community, I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `' 782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 784 2024-3-19 11:07:16 | Opening the Esri Geodatabase reader 785 2024-3-19 11:07:16 | An ArcGIS license is already checked out. The product checked out is 'Advanced' 786 2024-3-19 11:07:16 | Ins

I have been working on FME for a while now. But not much with geo-related issues.A user receives requests :  With and without address. Requests without addresses do contain coordinates (in both RD-Amersfoort and ETRS89)The user would like to see a map with a polygon in it.What steps/attributes do I need to realize this?I have already tried with the following attributes : AttributeReprojector, AreaBuilder, HullAccumulator Please give your advice and tips

I’m fairly new to FME.  I’m using FME Workbench 2023.1.  I am trying to recreate an excel output similar to the below image, but I’m not sure FME is capable since there isn’t much information out there on using FME to write an excel output like what I have a need for…  All I see is more simple outputs.  I need to be able tie the output values of a lot of those cells to data created in other transformers, but since the layout is not your typical excel sheet layout, I can’t seem to find any info if you can use a template and then tie the output from another transformer to the particular cell it goes with in the excel template.  If anyone knows where I can find more information on this, I would greatly appreciate the help! Sample template with values 

I am totally new to FME.I would like to merge all the shapefiles located in the all the folders called 2012. Any ideas how to do it? 

 Dear FME community.I got xml data with geographic location,  I tried to use coordinateExtractor but I could not get x and y coordinates and I could not also visualize the polygon using FME inspector. How do  Extract the X and y attribute? Any idea would be apricated and thank you in advance.  

Hi... I seek your assistance, sir/ma'am.I am currently trying to convert IFC to CityGML 3.0. In FME, only version CityGML 2.0 is available. I have found an example on GitHub that includes XSD files for each CityGML 3.0 feature (although it is still in draft phase). My question is, how do I incorporate these files into the FME write library? Your help is appreciated. Here is the GitHub link that contains the XSD files: https://github.com/tum-gis/ifc-to-citygml3/tree/master/xsds

Hi I’m using FME Workbench 2019.2 to read a DGN-file and then transform that to an SVG-file.This is working quite fine but we have seen that the texts are slightly offset. I did some investigations and figured out that if I could move the text-features to the coordinate value that their attribute igds_insertion_x and igds_insertion_y pointed to then was the text more accurate placed in the SVG-file.So I used an Affiner to move the text features to coordinate (igds_insertion_x,igds_insertion_y). But the strange thing is that after the Affiner is executed then is the values fme_text_size, igsd_text_size, fme_rotation,igds_rotation changed. The inspector  below shows the same text before and after the Affiner.  Am I doing something wrong here or is this a bug? RegardsNils

Hi There,i have workspace and trim transformer - Post/processe/Radarsat2/20240313 for example, it should leave 20240313 name of the file, but it remove 2 at the begining, 0240313 remains as file name. How to keep that “2” at the beginning? 

I am attempting to get the value of a date field from a subset of data tables in an Enterprise geodatabase.  I have narrowed down the list of tables with the required attribute from the SDE_column_registry and I only want to query those data tables for the value of that date field.I have attached two screenshots showing the inner join and rejected output and part of the translation.log.  Perhaps I am formulating my query incorrectly. I am only concerned with getting the value of the date field from 133 data tables that have the attribute.Please help.SheilaCounty of Kern, CA

Hi, I have this problem on FME qnd I don’t know how to fix it : Microsoft Excel Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DictionnaireVariables_ITV.xls;Extended Properties="Excel 8.0;IMEX=1;HDR=YES"'. Provider error `(-2147467259) Erreur non sp\xE9cifi\xE9e'Can you help me please ?

Hello,I have two polygon datasets: folios and townlands(see image below). For the most part, the folios(grey outline) are nested neatly within the townlands dataset(red outline) so the outer folio boundaries are shared with the townlands’ boundaries. I would like to extract the areas where these two datasets’ polygon boundaries cross...i.e. where they are not nested neatly. Most of these will be slivers.  SpatialRelator(and Tester) helps to extract the offending folios using the Spatial Predicates Test: "Requestor OGC-Overlaps Supplier" however the output is the entire folio polygons(not overlapping area) as SpatialRelator does not edit the input dataset. I am unsure as to what to do next, I would like to automate this process in FME Server if possible so having one workflow would be useful. 

I’m doing a project where I have to generate and compare multiple DTM TIN-models. In regards to this, I wonder: Is there a difference between TINGenerator and Surfacemodeller in regards to how the triangulation algorithms work?How does the triangulation algorithm(s) work, in more depth than that it is delaunay triangulation?​​​​​​​Are there any other transformers/methods to produce TINs in FME?

I would like to identify snapping errors of newly captured layers which is snapped to old layers only.I do not want to find any old layer's errors as it is not my scope of work.Please suggest the best transformer. RegardsArun