Questions tagged [fme-form]
Form (previously know as FME) is an desktop ETL tool from Safe Software.
840
questions
1
vote
1
answer
29
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 ...
- 3,834
1
vote
1
answer
131
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 ...
CommunityBot
- 1
1
vote
1
answer
14
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 ...
- 13k
0
votes
1
answer
305
views
Where to place workspace runner while running second FME workspace inside another workspace?
Case 1 :
I am facing issue is when I placing WorkSpaceRunner at starting it taking all records which is not required but files are getting generated(Output is getting as per expected).
Case 2:
...
CommunityBot
- 1
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 (...
- 9,207
1
vote
1
answer
437
views
Fetching the geometry and attributes from PostgreSQL Using FME Workbench
I have 2 fetching administrative areas one inside the other. For that, I am having servers to get the data.
When I am running anyone query in SQLCreator, it is working fine separately, but while ...
CommunityBot
- 1
2
votes
1
answer
1k
views
Merge DWGs to 1DWG and put all corresponding objects to one new layer named as the original filename
I have 1000 dwg that has text and lines on 2 layer, i want to merge them all in one dwg and the final dwg should have as layer names all the filename and all the objects (text,lines) should be in ...
CommunityBot
- 1
0
votes
1
answer
670
views
Using dynamic feature types in FeatureReader (Excel) constraints
I am new to FME.
I have 100+ Excel workbooks, each of which has 2-4 worksheets in them. To prep to do some schema mapping, I'm trying to read out all of the attribute names to a new spreadsheet (Excel ...
CommunityBot
- 1
0
votes
0
answers
19
views
FME File path directory output to xml
I have used the directory and file paths reader to read in a folder and subfolders to filter out vector only files.
I want to be able to view each vector layer as an XML and set the parameters to ...
- 3
0
votes
0
answers
28
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
"...
3
votes
1
answer
291
views
FME GeometryReplacer, WKT Error
I am trying to load POINT WKT Geometry from MS SQL Server, it is in WKT Format. Using the GeometryReplacer, I am receiving an Error, and everything looks right as far as I can see, it continues to ...
CommunityBot
- 1
2
votes
1
answer
118
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. ...
- 2,400
0
votes
1
answer
43
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 ...
- 2,400
1
vote
1
answer
29
views
FME - 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 ...
- 2,400
2
votes
2
answers
454
views
Cannot read PostGIS RASTER into ArcGIS using the interoperability extension, either directly by Query Layer
This post Accessing PostGIS raster data using Query Layer in ArcGIS Desktop? was created in Jul-12. Since then, I have not found any other related-post published.
Using QGIS with DBManager ON, my ...
- 19.8k
1
vote
1
answer
33
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 ...
- 36
2
votes
1
answer
517
views
FME - Cannot load versions in ArcSDE Geodb Writer
I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
CommunityBot
- 1
0
votes
2
answers
149
views
Writing multiple geometries to Interlis using FME
I have to write Features with more than one geometry to interlis. In the Interlis model there is a class which has an optional second geometry as an attribute. Enabling the (Oracle-) Reader to read ...
CommunityBot
- 1
6
votes
1
answer
11k
views
How to process GRIB2 Data for Visualization?
My goal is to extract wind information from data provided to me in the GRIB2 format as it has been done in the attached image.
I was curious if anybody had any experience with this format. I'm not ...
CommunityBot
- 1
0
votes
0
answers
11
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
35
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
2
votes
1
answer
1k
views
Generate Cesium 3-D tiles from shapefile with FME
I'm trying to generate 3-D tiles from a shapefile. Just simple shp reader directly to Cesium 3D tiles writer. It does generate files, but after uploading them to Cesium Ion it does not work.
It can'...
CommunityBot
- 1
1
vote
1
answer
69
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 ...
- 13k
2
votes
2
answers
1k
views
Batchtransform multiple shapefiles with FME
I would like to batch-transform multiple shapefiles which are stores in several different folders.
I used the batch deploy with the option "recreate source folder structure" which works well for ...
- 19.8k
1
vote
1
answer
252
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 ...
CommunityBot
- 1
1
vote
1
answer
286
views
FME: SQLExecutor [PostGIS Format] ST_Intersects() Not Recognized
Scenario:
[A] 5,784 polygon geometries + [B] 2,100,000 address points
Source Format: [A] GDB Feature Class, [B] PostGIS Table
Goal:
Find which address points [B] intersect with polygon geometries [A]
...
CommunityBot
- 1
1
vote
2
answers
74
views
Import Point Data to Oracle through FME with considering few other Point file attribute
I have three Point file (*.mif); Pole, Switch and Transformer
Pole is the main feature which will be my Output, but I need additional information within pole layer attribute using information from ...
- 64.9k
0
votes
1
answer
233
views
Quick Import FME Reader Gallery Not Populated with FDS (ArcGIS 10.5 Adv Licence)
I wanted to import GeoJSON files, but after installing the Background GP and Data Interop packages, I find that the FME Gallery contains only GML and WFS formats. This is with both ArcGIS 10.4 and ...
CommunityBot
- 1
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
86
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 ...
- 13k
1
vote
1
answer
34
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 ...
- 13k
14
votes
4
answers
1k
views
How to extract a small area from a big GTFS feed?
Is there a tool that supports extracting a small region from a bigger GTFS feed? Google's Transitfeed library contains a Merge tool but no Extract/Clip tool, as far as I can see. Other libraries I've ...
- 281
1
vote
1
answer
181
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 ...
CommunityBot
- 1
0
votes
1
answer
24
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 ...
- 64.9k
1
vote
1
answer
21
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 ...
- 13k
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 ...
- 171
0
votes
0
answers
39
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 ...
- 64.9k
-1
votes
1
answer
247
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.
CommunityBot
- 1
1
vote
1
answer
313
views
FME Desktop - JSON Extractor Transformer Error
I have a workbench which takes a JSON file and uses the following transformers to parse the data: JSONFragmenter, JSON Extractor and a vertex creator.
I am getting warning errors in my translation log ...
CommunityBot
- 1
3
votes
1
answer
202
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
3
answers
3k
views
Converting "string" date to "date" format using FME
I have a string field with values such as 04.07.21 and I am trying to write to GDB but it's not working because date format is expected and string is provided.
How can I convert these values (04.07.21)...
- 1,632
2
votes
1
answer
98
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 ...
- 13.2k
2
votes
1
answer
284
views
FME Server Automation: Watch URL/Published data in the internet
I'd like to build an automation in FME Server consisting of one trigger (watch URL/xlsx-sheet) and an email-action.
The problem is about the trigger: There is a federal environment agency that ...
CommunityBot
- 1
1
vote
1
answer
328
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 ...
- 13k
1
vote
1
answer
568
views
Forcing FME to read a date column in Excel as a text-encoded attribute
I am reading an Excel spreadsheet which has a column containing date values using FME.
The problem is that all date value are encoded as normal text in Excel, except a few cells which are encoded as ...
- 11
2
votes
1
answer
68
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
- 13k
5
votes
2
answers
112
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 ...
- 13k
1
vote
0
answers
35
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
1
vote
3
answers
2k
views
I can not see geometry column on SQL Executor of FME
I have build a simple workflow in FME 2014 (as shown in the image) to get data from an excel file and store them in a postgres database. For this purpose I use SQL Executor.
I manage to pass all the ...
- 171
1
vote
0
answers
54
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... ...
