Questions tagged [fme-form]
Form (previously know as FME) is an desktop ETL tool from Safe Software.
844
questions
0
votes
1
answer
29
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-...
- 17
0
votes
1
answer
33
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 ...
- 225
0
votes
1
answer
33
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://...
0
votes
1
answer
39
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 ...
- 41
3
votes
1
answer
71
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 ...
- 155
1
vote
1
answer
24
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&...
- 19
1
vote
1
answer
38
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 ...
- 155
1
vote
1
answer
28
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 ...
- 111
1
vote
1
answer
22
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 (...
- 173
0
votes
1
answer
78
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
"...
- 155
1
vote
1
answer
76
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 ...
0
votes
0
answers
16
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 ...
2
votes
1
answer
36
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" ...
- 173
1
vote
1
answer
111
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 ...
- 19
1
vote
1
answer
52
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 ...
- 155
0
votes
1
answer
34
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 ...
- 41
1
vote
1
answer
139
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 ...
- 29.6k
0
votes
1
answer
67
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 ...
- 19
1
vote
1
answer
35
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 ...
- 19
0
votes
1
answer
27
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 ...
- 157
1
vote
1
answer
27
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 ...
- 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 ...
- 191
0
votes
0
answers
55
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 ...
3
votes
1
answer
309
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 ...
- 501
2
votes
1
answer
128
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 ...
- 191
1
vote
1
answer
547
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 ...
- 334
2
votes
1
answer
70
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
- 453
1
vote
0
answers
50
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 ...
- 21
5
votes
2
answers
125
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 ...
- 51
1
vote
0
answers
63
views
Outliers in the resulting TIFF exceeding values of millions when creating a Pyramid TIFF from XYZ
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... ...
- 33
0
votes
1
answer
40
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 ...
- 19
1
vote
1
answer
398
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 ...
- 11
1
vote
1
answer
28
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 ...
- 716
2
votes
1
answer
158
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. ...
- 21
1
vote
1
answer
176
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 ...
- 155
0
votes
0
answers
43
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 ...
- 19
2
votes
2
answers
262
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 ...
0
votes
1
answer
192
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 ...
- 716
1
vote
1
answer
53
views
FME: Feature Name when feature is empty
I am exporting all the feature names and the count for each in an Excel Sheet.
Enable the feature names in all features
Custom Transformer:
StatisticCalculator --> Count
StatisticCalculator --&...
2
votes
1
answer
406
views
How to transpose a list attribute in FME?
Suppose I have one feature per attribute country that is linked to a complex list attribute called stations with the sub-attributes name and platforms that looks like this:
station{0}.name Gare du ...
- 716
1
vote
1
answer
95
views
Extract polygons which contain an attribute of a list
I have a problem regarding a shapefile and a list. To make it simple, I try to depict the problem using an image:
I have a list of elements:
List_Elements={"Apple", Carrot", "...
- 129
1
vote
0
answers
90
views
Extract railroad from Orthophoto and / or LiDAR
I would like to automate the creation of a vector line from either orthophoto or aerial LiDAR data. This line (or these lines in fact) represent both sides of a railway. We can see those pretty ...
1
vote
1
answer
220
views
FME: Import an Excel table as user parameter list
I have a list of possible errors in an Excel table and I am importing it as a Reader. I run more than 100 controls on my data and I generate a txt file with the data that don't pass the tests and what ...
2
votes
1
answer
93
views
Case Sensitivity in FME Schema Mapper
I am using FME to translate data from one database to another and am using Schema Mapper to help set attribute values where needed.
Unfortunately, it appears that Schema Mapper is case sensitive on ...
- 29.6k
-1
votes
1
answer
339
views
Converting geodatabase into Geopackage in FME
I have never used FME and need to convert some geodatabase files into Geopackages. So the data can be stored in a GeoServer and published online.
- 191
3
votes
1
answer
363
views
In FME: how to handle NULL values in numeric expressions as 0 using the attribute manager
i stumbled across the following challenge in FME:
how to deal with NULL values if you want to perform a calculation for a new attribute. For example, I want to sum up values (could be any other kind ...
- 343
2
votes
2
answers
865
views
How to escape an invalid character (0x1F) in an XML file?
I want to convert an XML-file to something else. However, when I try to read it using the FeatureReader, it throws an error. I'm using FME Workbench 2021.2, and read the file without any special ...
- 716
0
votes
2
answers
317
views
In FME, I want to copy a .tab file, place it in a new folder called 'GDA94 Archive' and rename the file with a prefix 'GDA94_'
I am very new to FME.
As part of my GDA2020 process, I would like to copy a .tab file from its current location, add a prefix to it called 'GDA94_' and then place it into a new folder in the same ...
- 21
1
vote
1
answer
105
views
How to consolidate FME readers into one?
I have an FME Workbench file that was built up slowly over time and has ended with many readers and many writers (each to a separate feature class), even though every reader points to the same ...
- 29.6k
2
votes
2
answers
162
views
A reader that requires a user to choose a file
I'd like to add a reader to a canvas, that instead of me already having a certain file that it is using, when run, it will force the user to add in a file.
It seems like when I add readers, I can't ...
- 21