- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,296 Posts
49,362 Replies

When you subscribe we will email you when there is a new topic in this category

12296 Posts

Recently active

Most replies Most views Newest first

jonathanhetheri

asked in Transformers

can FME support Nato Vector Graphics (NVG)

1 month ago

kattContributor

asked in Transformers

add an if condition to the json templater

Hello, I am creating a JSON file using several fme attributes. I want to include an if condition. If the typ =’HC’, I want to have an additional attribute (the name) added to the JSON. is it possible? The way the if condition is written here is not correct but it gives you an idea what I would like to do.{"Device": {"Type": fme:get-attribute("TYP"),"latitude": xs:decimal(fme:get-attribute("LAT")),"longitude": xs:decimal(fme:get-attribute("LON")),if fme:get-attribute("TYP") eq "HC" then "Name": fme:get-attribute("NM")}}

1 month ago

chris_accContributor

asked in Transformers

Copy data from ESRI File Geodatabase to SQL

Hello, I am attempting to copy data from an ESRI FileGDB to a Feature Class in a SQL DB but no data appears to be copying.I have attached an example of a record from the log. I have pasted “etc etc.” into it to shorten it as it is very long otherwise.I also get this error-Microsoft SQL Server Spatial Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'Hopefully this helps you troubleshoot my issueThankyou in advance

1 month ago

sylvainlContributor

asked in Transformers

vimva679Contributor

asked in Transformers

IFC 3D Room Clip and Buffer

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.

1 month ago

dwenning68Contributor

asked in Transformers

Feature Class to Database field mapping

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.

1 month ago

hiyhelgContributor

asked in Transformers

I could not visualize the boundry of the polygon and extract the geograhphic location

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.

1 month ago

nurbekContributor

asked in Transformers

Trim remove more than required

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?

1 month ago

gehanis2Contributor

asked in Transformers

SQL Query

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

1 month ago

buckrogersContributor

asked in Transformers

Extract area overlap of two polygon boundaries

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.

1 month ago

anderssonaxelContributor

asked in Transformers

Choice of triangulation transformer

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?

1 month ago

aruja2000Contributor

asked in Transformers

Identify Snapping errors between newly captured layers in Micro Station file.

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

1 month ago

jelleveParticipant

asked in Transformers

Write multiple geometry types as geopackage

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

1 month ago

gvenhorstContributor

asked in Transformers

Problem with ListExploder with Version FME Desktop 2024.0 (build 24187)

Hi,Have a workbench that I have been using for a while in previous version (2023).This is to convert data with attachments from ArcGIS online to a FGDB.I use a ListExploder for this, I don't get an error message but also no objects.When I use the workbench again in the old version, everything works fine again.The problem occurs when a space is used in the naming of the layer and/or feature class. Does anyone know about this problem? Any solution would be helpful. Gerard

1 month ago

jaygrg111_Contributor

asked in Transformers

How to write several dwg files to new created folder from PythonCaller

Hello everyone,I am converting several SDE geod to respective CAD files. All CADs need to be written in the same folder (with suffix of the currentdate). I created this folder in Python Caller. How can I now route CADs to this folder?

1 month ago

hn35987Participant

asked in Transformers

I want to convert the obj model with map coordinates to the glb model with local coordinates (0,0,0).

I'm converting an obj file to local coordinates, glb.Running one obj file in FME will take you to the desired local coordinates.But when I run thousands of obj files in FME, they don't move to local coordinates (0,0,0).I want to move thousands of obj files all to (0,0,0) at once.For reference, I activated move to local coordinate.

1 month ago

blupikaContributor

asked in Transformers

IF loop in FME with creator (i++)

Hello guys, Damjan here,i have problems with my FME process so i need your help. Task:I have 1 dwg file with 6 polylines (3 pairs), each pair must go to PROCES (process makes a polyline between 1 pair, that's fine all works), then process must save this polyline in dwg and go to start for next pair.Shema: FME:DWG GRT: Each polyline has an attribute id which represent pairs (for example: 2 polylines (grt_dt & grt_lt) have the same id which means they are 1 pair), the second attribute is Description (DET_OPIS): grt_dt = right polyline, grt_lt = left polyline. I add Creator to make counter, with the Attribute manager making the same attribute like in dwg (GRT), and then connect to tester. My idea is that the tester test if value of counter equals to id. If its true, then go to process, when process finish, save to dwg format and then go to start for next pair. Problem:I have problem in tester cause i dont know how to setup tester to make him work. If anyone know how to fix that or

1 month ago

andr__dContributor

asked in Transformers

Writing xlink:type with AIXM5 writer

Hello,I need to write the xlink:type in an AIXM5 file (see below) But when I look at the User Attributes of the feature type AirspaceTimeSlice (AIXM5 writer), I can only see 3 parameters of the xlink which can be set: href, role and title. Anybody knows how to write the xlink:type with the AIXM5 writer ?ThanksAndré

1 month ago

anderssonaxelContributor

asked in Transformers

Calculating vertical error of TIN from point cloud

I want to compare different methods of generating TIN-models. To assess the quality of each model, I want to calculate the vertical distance between each point in the input point cloud and the generated TIN in order to later calculate for example the RMSE. Any tips on an approach?

1 month ago

vxn43Supporter

asked in Transformers

FTPCaller and Emailer question

I am using FTPCaller. If I add the Emailer to the rejected port will it send me an email if the output gets kicked to the rejected port? I would have the Emailer already configured to send me an email. I want to double check with the Community since my workbench will stop running if the FTPCaller output is rejected. Here is a screenshot of a mock up workspace (note I have not set up the transformer parameters yet hence you see the red gear icons.) Not shown below, I know it will send me an email if the FTPCaller output is sent to Output.

1 month ago

gvatin06Contributor

asked in Transformers

Postgis writer with default values

I want to write lines into an existing PostGIS table, which has default values for most of the columns. With FME PostGIS Writer, when executing the process, I have errors returning (in french):Bulk copy failed on table 'XXX' using delimiter ':'. Error was 'ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « YYY» dans la relation « XXX » I would like to use the Postgres default values for these NOT NULL columns, but I cannot find the way to do it.I use FME Form 2023.2

1 month ago

r_hueskenContributor

asked in Transformers

Performance ECW reader

I'm trying to read a (big?) ecw file (EPSG 28992, 173 Mb) using FME 2020.1.0.1.This is very slow (> 10 minutes), QGIS displays the same file in a matter of seconds. I'm wondering if I'm missing some reader parameters that might speed up the process. I do need best resolution though...

1 month ago

bbeaumontObserver

asked in Transformers

FME equivalent of ArcGIS Tabulate Areas?

Dear all, I’m fairly new to FME but currently I’m quite impressed by the software :). My question is rather simple: is there an equivalent in FME of the Tabulate Areas function of ArcGIS Pro: Tabulate Area (Spatial Analyst)—ArcGIS Pro | DocumentationI have two datasets:The cadastral parcels of Wallonia in polygon format ; A land cover classification (TIFF raster) with 20+ classes.I would like to calculate for each polygonal entity the proportion of land cover classes.The result should look like this:ID | LC1 | LC2 | LC3 | … | LC201 | 10% | 0 | 0 |25 | … | 02 | …3 | … Many thanks in advance for your feedback :)

1 month ago

Page 7 / 492

Badge winners

kt_fishhas earned the badge Teacher (Grey)
rahulsharmahas earned the badge Enchanted by Attributes
olympiadoshas earned the badge Student (Grey)
nicol.riccihas earned the badge Teacher (Grey)
syahrastaniahas earned the badge Teacher (Grey)

Show all badges

28,811: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.