Questions tagged [fme-form]

Form (previously know as FME) is an desktop ETL tool from Safe Software.

Filter by
Sorted by
Tagged with
1 vote
1 answer
25 views

Deleting features based on matching attributes in Feature Service using FME (similar to row selection)

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead. Essentially, I am performing bulk edits in a feature service by ...
Mar's user avatar
  • 11
0 votes
1 answer
35 views

FME restart identity sequence when using Truncate Existing in the writer table handling drop-down menu

In FME 2023+, when using Truncate Existing in the Table Handling drop-down list in a PostgreSQL/PostGIS writer, is it possible to reset the numbering sequence associated to the primary key when this ...
swiss_knight's user avatar
  • 10.2k
0 votes
1 answer
30 views

FME discard destructive operations in the table handling drop-down list for PostgreSQL / PostGIS writers

In FME 2023, one can use a PostGIS writer to write some spatial data to a PostGIS database and that's great. In the table section, one can select one of several Feature Operations: When using upsert ...
swiss_knight's user avatar
  • 10.2k
1 vote
1 answer
43 views

FME Counter transformer - Assign a grid with numbers, change order that features are counted

I have a 100x100 grid made up of square (1x1) polygons. I would like to assign each square a unique number. I have used the Counter transformer in FME, but this assigns the numbers in the grid ...
gisndev's user avatar
  • 348
0 votes
1 answer
21 views

Write a raster to an Esri ArcSDE geodatabase using FME

I would like to write a raster (ECW) to an Esri ArcSDE Geodatabase using FME. I think this should be possible as I have been able to copy and paste the raster layer in ArcGIS from it's original ...
gisndev's user avatar
  • 348
0 votes
1 answer
27 views

How to make labels in AGOL look exactly the same as they do in ArcGIS Pro

I recently prepared a very good looking map with labels in ArcGIS Pro (v3.2.1) and published it in AGOL. Now in AGOL labels are not looking the same way as they do in ArcGIS Pro! How can I export my ...
gisgis's user avatar
  • 592
3 votes
0 answers
75 views

FME PostGIS reader results in a data set with no geometries

Using FME(R) 2023.0.0.1 [build:23288] (the same behaviour occurs on 2023.1.1.1 [build:23636]) at the time of writing, I'm facing a severe bug(?) with a PostGIS reader. Indeed, when connecting to a ...
swiss_knight's user avatar
  • 10.2k
1 vote
3 answers
102 views

FME DateFormatter is not correctly setting white spaces to null and DateTimeConverter doesn't offert this option

Using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) at the time of writing, I'd like to format a date field from an Excel spreadsheet into an ISO date which should then be written to a PostgreSQL ...
swiss_knight's user avatar
  • 10.2k
0 votes
0 answers
20 views

Displaying Multiple Results in FME with a Spatial Intersection

I have a workspace that outputs planning scheme data against properties. Quite a few properties have multiple overlays and some have multiple planning zones. However, I am finding no matter which ...
Joshua J Geoghegan's user avatar
0 votes
0 answers
30 views

Revit pipe to GIS automated junction connection using FME

I have a revit model of pipes network having fittings and valves and network. I can export the pipes using FME workbench as 3D polylines and junctions as 3D points. How can I snap polyline edges to ...
Ankit Sharma's user avatar
2 votes
1 answer
41 views

Calculating area of vegetated areas within building buffers in FME

I have two feature layers, buildings buffered with 50 meter and a polygon layer containing vegetation occurence. I want to compute the area of vegetation within each 50 meter buffer. How do I go ahead ...
Apierre's user avatar
  • 21
1 vote
0 answers
45 views

Reprojection from EPSG:4167 to EPSG:2193

I have PostgreSQL database with defined EPSG:2193. WMS service that I need to use and upload data from it is in EPSG:4167. https://data.linz.govt.nz/layer/105689-nz-addresses/ https://data.linz.govt....
Maria Savchenko's user avatar
0 votes
1 answer
37 views

Using FME Stringpadder

Trying to use this in a workbench and not getting the output i'd expect, i.e. no apparaent padding in the output. The SAFE documention seems inadequate: https://docs.safe.com/fme/html/FME-Form-...
Mat's user avatar
  • 17
-1 votes
1 answer
44 views

FME Postgres Serial - Red Attribute

I have a small table of wells with just a name, lat, lon, and geometry in an Esri Shapefile. I am putting them into a PostGIS database and it works well, so I added an arbitrary well_id as a serial ...
Andrew T's user avatar
  • 243
0 votes
1 answer
77 views

FME data conversion from CityGML to GeoJSON results in multiline not multipolygon

I am using FME to convert my CityGML data into GeoJSON format to import it my 3D mapbox application. Mapbox uses extrusions to visualize 2D GeoJSON objects in 3D with their height values. (https://...
sevvaldurmazbilek's user avatar
0 votes
1 answer
62 views

Install FME Server on 2 nodes sharing the same FME Flow System Share and FME Flow Database (PostgreSQL SQL DB)

Is it valid to install FME Server (version 2023.1 Build 23619 x64) on 2 nodes (2 separate express installs) with both the nodes sharing the same FME Flow System Share and FME Flow Database (PostgreSQL ...
captonssj's user avatar
3 votes
1 answer
83 views

SR-ORG:8369: _MI_0 - What coordinate system is it?

I have a TAB file with strange coordinate system. QGIS shows coordinate system as unnamed: But places objects in the correct place on the map. FME (2023 version) recognizes it as _MI_0. I have found ...
Maria Savchenko's user avatar
1 vote
1 answer
51 views

How to write AGOL data into an Excel sheet using FME

I am using the AGOL feature service reader to read in the data and then writing to an Excel file. In the Excel writer parameters I have set the template file and sheet and set the mode to "update&...
Will97's user avatar
  • 19
1 vote
1 answer
54 views

FME Form - Measure FME transformers execution time in the FME workbench

One of my FME workbenches takes too long time for processing data. I am trying to optimize it. Therefore, looking for the stage where data being processed the longest. Is there a way to measure ...
Maria Savchenko's user avatar
1 vote
1 answer
90 views

How to get a notification or email through FME desktop or FME server if downloaded table all the fieldvalues are "NULL"

Every week, I download a CSV table from an FTP server, which contains a variable number of rows ranging from 700,000 to 800,000. This CSV table serves as the foundation for subsequent data processing ...
Ram's user avatar
  • 111
1 vote
1 answer
25 views

How to use a shared .py file across multiple workflows in FME? [closed]

I have a python methods "toto" that I would like to use in multiple FeatureProcessors of multiple workflows. In FME (2023) options O added a new shared folder and put there my python file (...
serge's user avatar
  • 173
0 votes
1 answer
136 views

FME Form (Desktop) - Dissolver Transformer Generates Redundant Remnants

I have line geometry that I buffered with 50 feet buffer. Now I need to dissolve common boundaries for overlapped polygons, to reduce the size of the file in general. Source lines Buffer "...
Maria Savchenko's user avatar
1 vote
1 answer
174 views

FME issue while updating AND inserting data in Esri Geodatabase (File Geodb) writer

I have a geodatabase file to update with FME Desktop : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several ...
theonewhodidnotknow's user avatar
0 votes
0 answers
18 views

I want to break a .SP1 navigation file into individual files based on the 2d Seismic Line names (col 1) in the compiled .SP1 file

I received a .SP1 (navigation text type file) from Seismic Exchange and I need to break up that file into individual .SP1 files based on the 2D line names (col 1) and the associated row data preserved ...
baltazaar76's user avatar
2 votes
1 answer
37 views

FME: how to do a multicriteria search on a supplier from a requestior

I have two flows to merge. One is the Contacts table (with fields like "City", "PostalCode", "Address", "CellPhone", "OfficePhone", "Email" ...
serge's user avatar
  • 173
1 vote
1 answer
199 views

Merge overlapping portions from two polygons to one or the other using FME

I have a shapefile with many polygons, of which some portions overlap. When I use the AreaGapAndOverlapCleaner, it disconnects the overlapping portion, but makes it an independent feature with data of ...
SaFaL's user avatar
  • 19
1 vote
1 answer
92 views

FME Server - Can't Enter to FME GUI

I have an issue with FME Server. I can't entre GUI under admin user. I was doing some work in there, while it got freezed. (I resubmitted running job). I decided to log out and log in. After that I ...
Maria Savchenko's user avatar
0 votes
1 answer
35 views

Creating an ascending network of strings using two columns

I'm attempting to build a network based on the 'From' and 'To' columns. Essentially, each number in the 'From' column is connected to a corresponding number in the 'To' column. Subsequently, I need to ...
HellblaZer's user avatar
1 vote
1 answer
235 views

Case tools, or wider if, else if, else if (etc.) tools in FME

Is there a "CASE" type transformer in FME? If so, what is it called? Failing that, a transformer with a wide if, else if, else if, else if... else? I'm currently working with an ...
Midavalo's user avatar
  • 29.7k
0 votes
1 answer
112 views

Set value to a new created (named ID) attribute for an Excel writer with number format in FME

I modified the schema of my Excel writer and now I have some new attributes one of which is ID and it must be number. Then I added an attribute manager to set value to my new attribute. I am trying to ...
marrysharif's user avatar
1 vote
1 answer
37 views

How many workspace, readers and writers to use in FME?

I have an Excel dataset, and I want to translate features(rows) to different formats like txt, date, number. I don't know what is the best practice. Should I create multiple workspaces with multiple ...
marrysharif's user avatar
0 votes
1 answer
37 views

Joining CSV to feature class in oracle dB and writing out matched records to feature class in file geodatabase on local machine using FME

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly: But when I connect the joined output to the geodatabase writer no records are written to ...
Kurt Cederholm's user avatar
1 vote
1 answer
29 views

Fast column binding in FME

In FME, I would simply like to bind 2 tables columnwise ; they haven't any field in common (but I know that they have the same row order). I have done something with the FeatureMerger (using 1=1 ...
mzuer's user avatar
  • 11
0 votes
0 answers
16 views

FME 2021 Overwrite one feature in a geopackage [duplicate]

I am using FME 2021 and would like to delete or overwrite one feature in a Geopackage. Is there any tool in FME that will be able to delete or overwrite a feature. For information, When I created the ...
GIS Noh's user avatar
  • 311
0 votes
0 answers
67 views

Creating Geomedia mdb files without ArcMap Interoperability extension

For our day-to-day tasks, my team uses ArcGIS Pro. Unfortunately, we work in a very niche industry with a very niche software which requires most of the other teams to use GeoMedia .mdb files. As of ...
PintSizeSlash3r's user avatar
4 votes
1 answer
453 views

FME : Populate a column in Table A with the value(max) from StatisticCalculator transformer from table B

What I'm trying to do : I have two shp file readers as input. I'd like to calculate the maximum value in column 1 of Table B and then populate a new field in Table A with that same value (same value ...
lhowarth's user avatar
  • 531
2 votes
1 answer
160 views

FME 2021-22 delete features in GeoPackage

I used FME to convert some geodatabases into GeoPackages. However, I updated some layers inside some geodatabases and need to do the same for the GeoPackages in FME. I opened the FME Data Inspector ...
GIS Noh's user avatar
  • 311
1 vote
1 answer
815 views

Use FME to remove columns with all missing values

I have a table which has over 100 columns, of which many columns have no values (or missing values) for every line. In FME, I would like to remove the entire column from the table in the case that no ...
gisndev's user avatar
  • 348
2 votes
1 answer
74 views

Compacting table in FME?

How to compact table using FME which table has grouped by CODE and different value of class are as columns? Before After
Mickeler's user avatar
  • 453
1 vote
0 answers
60 views

Problems reading in JP2 files in FME [closed]

I'm trying to add JP2 files to fme and it gives me a very vague error when reading in the file. I have plenty of space and ram memory available for the process. I have also tried it on a more powerful ...
Stefan's user avatar
  • 21
5 votes
2 answers
152 views

How to calculate distance to nearest neighbor when new candidates are created over the years?

I want to calculate distances between sold properties and the nearest wind power turbine over the years 2013-2022, in FME. QGIS is also an option. I have coordinates for them both and also dates for ...
Josefin's user avatar
  • 51
1 vote
0 answers
71 views

Outliers in the resulting TIFF exceeding values of millions when creating a Pyramid TIFF from XYZ [closed]

I'm creating TIFF files from XYZ files, which goes well and works fine. Now I want to create pyramids (6 levels). But for some reason the statistics are all up in the millions. Minimum and maximum... ...
DHend's user avatar
  • 33
0 votes
1 answer
41 views

Why are features showing up near Malaysia when using the Michigan State Plan South coordinate system?

I am using FME to write in shapefile and then read them to dwg's. The shapefiles have are assigned the Michigan South coordinate system, but show up near Malaysia when translated to CAD. What am I ...
Will97's user avatar
  • 19
1 vote
1 answer
591 views

FME Compare polygons from two datasets

I'm trying to compare and see what the differences are between polygons from two different datasets, they have matching unique IDs. What I want to end up with are features where the two polygons don't ...
John Stone's user avatar
1 vote
1 answer
30 views

Why does the FME AdjacentFeatureNullAttributeMapper not work?

I have a set of feature types for which I need to fill in some missing values. I thought the AdjacentFeatureNullAttributeMapper was exactly what I need, but when I try the dummy example from the ...
saQuist's user avatar
  • 716
2 votes
1 answer
209 views

automatic extraction of contour lines from a scanned paper map

I'm currently trying to detect contour lines from a georeferenced raster image, which looks like this: With the help of FME I could extract the lines very good. But they are divided at every section. ...
mawagi's user avatar
  • 21
2 votes
1 answer
238 views

FME - SpatialRelator Transformer Settings

could you help to validate and adjust my FME workbench, please? Input info: Polygon layer A with counties. Polygon Layer B with areas of the random shape that may intersect or fall inside of the ...
Maria Savchenko's user avatar
0 votes
0 answers
58 views

Working within FME and trying to snap newly created line features together within a certain distance of each other

I have two features, a point feature (addresses) and a line feature (fiber). My end goal is to create a new line feature from the point to the nearest spot on the existing line. I have that process ...
Jonathan's user avatar
2 votes
2 answers
317 views

FME Loop: Many to many connection

I have two tables with lines. The 1st table has an attribute end_point The 2nd table has an attribute start_point I want to join the first table with the second table (end_point = start_point). It ...
Theodora Vasileiou's user avatar
0 votes
1 answer
243 views

How to order attributes by suffix in FME?

I have a table with attributes containing a suffix of the form _DIGIT. FME displays the table like this: country name_0 name_1 name_2 platforms_0 platforms_1 platforms_2 The Netherlands Utrecht ...
saQuist's user avatar
  • 716

1
2 3 4 5
18