FME Form

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

Hi!I have many workbenchs to manage and I would like to find a way to create a table linking the workbench name with the output writers of each workbench. The goal is to find which workbench generates which table(s). My idea is to add a custom transformer to all my workbench. The information I would like to have is :name of the workbench directory of the workbench writer information (table name, table qualifier and writer)With ParameterFetcher, more specifically, the FME_MF_DIR and FME_MF_NAME parameters, I can get the information about the the name of the workbench and directory. But I cannot find a way to extract the information of the writers. All the writers I have are in a postgis format.I would prefer not to use Python if possible. I’m sure there’s a way to extract the information since it appears in the log, I just don’t know how to get to it! Thank you 😀 !

"Hello, I have a folder containing multiple shapefiles, labeled as (a, b, d, e, f...). My objective is to utilize the AnchoredSnapper transformer in the following manner: initially, snap shapefile 'a' with 'b', where 'a' serves as the anchor. Then, the resulting snapped shapefile will be used as the anchor and snapped with 'c', and so forth until all shapefiles are snapped. I tried to implement loops but the problem is that the output have to be the new output after everh iteration, so i can't get a configuration of the loop.  I appreciate any assistance or proposition you can provide. Thank you."

Hello everyone,I have a colleague that uses FME Form 2023 in combination with the FME auto plugin (MApublisher)In previous versions he had nog problems using the FME auto plugin, however in FME Form 2023 he gets the following error:In  the previous versions one was able to succesfully extend the Avenza MAPublisher for Illustrator via the Integration console, however in read in a post that the Integration Console is deprecated :  https://support.safe.com/s/article/FME-Integration-Console-DeprecationI was wondering whether it would still be possible to make use of the FME auto plugin in FME Forms 2023.

Dears, If i have Revit Model that has multiple Locations and we need to separate each Location to single Revit file .Is it possible using FME?? Thanks in advance

Hello all,When trying to write my data as a geopackage I get the following warnings (see attached).In the reader I have to specify what geometry type I want to use but I can only select one, which results in some features being excluded.I have read a thing about the dynamic writer but that one is giving me errors.Using the GeometryFilter the only type I get is ‘area’ so it doesn't seem to make a distinction between those.Is there a way to write these different geometry types in one Geopackage layer? I am using version 2020.0 

We are getting an error while running FFS writer: Failed to write to file 'C:\\Users\\use\\AppData\\Local\\Temp "Please ensure that you have sufficient privileges to write this file, and that sufficient disk space is available" This should be a simple merging of .SHP file (3221) into a single FeatureClass in a GDB. The Reader set to read .shp in Single Merged Feature Type. Got a GeometryValidator set to degenerate or Corrupt geometry "Edit". A Tester to get the read shapes and then the GDB Writer. We have and checked that the user is admin on the box and folders, so Think the issue room for the temp file. this is running on a Server where c:\\ only has OS on it and not much space left after that. So can we run in a way that clears the Temp location after so many record run, or can we move the Temp to a larger drive??