Questions tagged [fme]

FME (Feature Manipulation Engine) is an ETL (Extract Transform Load) tool by Safe Software. It reads and writes a wide range of data formats and services. Loaded with tools for manipulation of vector, raster, point cloud data and also non-spatial tabular data and code (XML/JSON).

Filter by
Sorted by
Tagged with
0
votes
0answers
30 views

FME Server is not able to connect to ESRI enterprise geodatabase and shows no error

I have an environment with a FME Server 2018.1.2 Build 18590 and ArcGIS Server 10.6.1. It has been running 2 pretty similar workspaces with no problem (A and B). The ArcGIS server was upgraded to 10.7....
0
votes
1answer
29 views

Problem running shell command with PyQGIS

I am building a QGIS plugin with Python (3.7) that is supposed to run a shell command. This command launches an FME Script with some parameters os.system("fme D:\script.fmw --param1 D:\file.txt --...
4
votes
1answer
37 views

Expose the Coordinate System Parameters in FME

I would like to take fields in the Coordinate System Properties. (Data Inspector) to use as user attributes.
0
votes
2answers
28 views

FME 2019: Generate a new PK based on a concatenation of a string and a three digit increment

I'm transforming a number of geographic tables from one MCD to another, so I'm using FME (I'm new to FME). I can map 80% of my fields with out any problem (MCD_A.fld_1 = MCD_B.fld_1) but in the in the ...
1
vote
2answers
30 views

FME list index number as attribute value

I have created list which has same road name but several separated segment. These has sorted using length of road lines (ListSorter). The list index inside () shows length order which road segment has ...
2
votes
1answer
40 views

Stopping FME TINGenerator processing unwanted nodes

I run an FME workbench quite often to convert .xyz point clouds to a LandXML TIN surface. I'm wondering if it is possible to stop the TINGenerator tool from processing the TINEdges, Triangles, and ...
6
votes
2answers
120 views

FME dynamic filename

With FME Desktop I'd like to write a text file with a dynamic filename, consisting of the date of today and a guid. I know how to create both parameters (date and guid), but I don't understand how to ...
1
vote
2answers
77 views

FME: Coordinates with a buffer - how to merge / dissolve points that overlap other buffers?

I'm trying to process some spatial query in FME. I have a dataset of cities with coordinate pairs and around these coordinates a buffer of 2 km. This results in multiple overlaps. I'd like to dissolve ...
1
vote
1answer
66 views

Read date of file creation from within a zip file using FME

I have a simple process that downloads a file from an FTP site and unzips the contents to a folder. Unfortunately the date of the file once unzipped is recorded as the date when the fmw was run but I ...
0
votes
1answer
24 views

Copying feature datasets weekly from EGDB to EGDB (geometric networks included)

I've been trying find a way to copy a few select feature datasets from our main production Enterprise geodatabase environment to a second Enterprise geodatabase. These datasets include geometric ...
2
votes
3answers
48 views

Remove duplicate values in an attribute using regex and fme

I have an FME process that is duplicating some values in an attribute. When I try to use regex in FME to clean it up it is deleting the separator (see screengrab below). Any ideas on how I can change ...
1
vote
1answer
23 views

Create Published Parameter as a Transformer Output

Using FME 2017 Desktop with ArcGIS 10.2.1 & Oracle 12c. I am filtering features using a WHERE clause which has a LAST_RUN_DATE being read from a control table. I am using a SDE reader to get the ...
1
vote
1answer
53 views

QGIS equivalent to FME Change Detector for vector data

Is there a Vector change detection tool for qgis that works similar to http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/changedetector.htm It's OK if there's two ...
1
vote
1answer
32 views

How do I determine which polygon feature with an SDO_geometry doesn't partially overlap a polyline feature with an SDO_geometry?

I have 2 datasets in the Oracle spatial format, built from Smallworld data; One with polygon features One with polyline features. I'm looking to determine which polygon features do not contain (part ...
0
votes
2answers
85 views

Does FME have spatial “Difference” like QGIS / “Erase” in ArcGIS and Mapinfo?

I am looking for an FME equivalent to the difference/erase tool in QGIS/ArcGIS/Mapinfo. Basically I want to see the spatial change between 2 datasets. https://gis.stackexchange.com/questions/76839/...
1
vote
1answer
84 views

FME FTP Caller - does not download file

In FME Workbench 2019 I am trying to use the FTPCaller as below It runs but I don't see an update to the file. The first version of this was manually downloaded into the folder as the "Target ...
1
vote
1answer
71 views

How to integrate some Python code in “PythonCaller” FME?

Following lines of Python code joins some fields of attributes in single attribute field. It works just fine in ArcGIS but it would be even better if that would work also within FME PythonCaller. In ...
2
votes
1answer
53 views

Remove empty spaces with FME PythonCaller

I have 4 fields in the attribute table. After I merge these attribute fields in one single attribute field using FME Desktop 2020.1, it empty records within the fields are producing empty spaces and I ...
0
votes
1answer
32 views

How to write route with measure to PostGIS with FME?

I have calibrated route in file geodatabase (ArcGIS). I have line coordinate (kilometre) in the start and the end point. I try export this route with M-value to PostGIS in FME. But in result I have ...
0
votes
0answers
31 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 ...
2
votes
0answers
69 views

FME: How can I use File Copy Writer to periodically copy new data within my project folders to a server?

All I want to do is copy a set of folders (and sub-folders) under a 'Projects' master folder on my laptop to the server. I want to automate this so it runs every hour or two and only copies new files ...
0
votes
0answers
31 views

Geoserver multiple nodata values ECW in alpha band

I want to combine multiple geotiffs to one ECW in FME and then upload the ECW in Geoserver. The responding nodata is stored in the alpha band. However with ECW compression (even when choosing 0 for ...
1
vote
3answers
40 views

FME Workbench Reader select tables to import using wildcards

In FME Workbench for various database format readers one can coose which tables to import: Because all in all I have thousands of tables, I would like to select tables that begin with certain ...
2
votes
2answers
72 views

How to handle with “no-Geometry” shapes in FME?

I have many shape files that I am reading on FME (points, lines and polygons), editing them little bit and writing back the same format. However I am having an issue that I as far as process comes to ...
0
votes
0answers
40 views

Reader character encoding problems in Oracle layers with where parameters in FME Desktop

I am using FME Desktop 2020 and trying to read an Oracle layer with -where- condition but i have problem because it failed with reading of character Ë or Ç. I get this error: ORA-01756: quoted ...
3
votes
1answer
42 views

INSERT only non-existing features into PostgreSQL/PostGIS table with FME

I have a PostGIS table of, lets say, adresses, for example id | adr | geom ---------------------------- 1 | Rathausplatz 1 | POINT 2 | Dorfstraße 2 | POINT 3 | Kirchenweg 3 | POINT ...
1
vote
2answers
93 views

Count number of features that matches a (minimum) value for each group (id)

Context In FME I want to count for each group (defined by a "group by" id in any kind of aggregation-like transformer, such as the StatisticsCalculator), how many occurrences equal to a ...
1
vote
3answers
87 views

Attribute-spliter to parse a text file containing key=values into separate variables in FME

Context Using FME, I want to read a text file containing several lines of variables I already defined, given in the following format: var_name = "var value" There are many lines, each one ...
4
votes
1answer
69 views

Write *.sql file with FME

Is it possible to write sql files containing all the CREATE TABLE... and INSERT... statements etc. with FME instead of directly execute them against the database (here: PostGIS)? Background is that I ...
0
votes
0answers
56 views

ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer

I have data in an Oracle table (11 million records) and would like to insert 2000 records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
1answer
28 views

FME Desktop 2019.2 Geodatabase_SDE writer copies Dataset parameter from reader when I said not to

I'm using FME 2019.2, Geodatabase_SDE reader and writer with different connection files. I have one database "Operations" with user1 and another database "Data_Sources" with user2. They both support ...
1
vote
1answer
46 views

FME workspace slashes ('/') missing in resulting attribute values

I have a MS Access DB table with attributes containing slashes /: When I process it with an FME workspace like (MSACCESS_JDBC reader) the slashes disappear in the resulting attributes (FME data ...
-1
votes
1answer
61 views

Convert XML files in to shapefiles using ArcGIS or FME? [closed]

I have attached a short text from XML file. Can this file be transferred to the spatial domain? How to convert XML files in to shapefiles using ArcGIS or FME?
2
votes
2answers
32 views

Rename workbench on FME Server

I'd like to change the name of a workbench I published on FME Server. I'm afraid I didn't find a way to do this. As I want to keep the history of commits I cannot add the workbench as an new file to ...
2
votes
1answer
84 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 ...
1
vote
1answer
120 views

Converting 32 bit image to 8 bit palette raster image using FME

I need to convert 32-bit TIFF image (input) to 8-bit palette TIFF image (output) by using FME. How can I do this by using palette of output image?
1
vote
1answer
58 views

Join tables using FME

I have a line .kml which is needed to converted to shape. And I need to make a relation between "Folder" and "Placemark". I have a common field (kml_id in "Folder" and kml_parent in Placemark). How ...
0
votes
1answer
43 views

Using WMS in FME inspector

I want to use Finland national WMS map (MML Kapsi) as background map in FME inspector. Is it possible? What information is needed? WMS URL is: http://tiles.kartat.kapsi.fi/peruskartta
1
vote
1answer
40 views

FME 2017 transformer AreaOnAreaOverlayer does not have Remnants port

Remnant port of the AreaOnAreaOverlayer FME transformer does only exists on the 2018 (or newer) version of FME. However, I only have access the 2017 version for now. Do you know a way to round it by ...
2
votes
2answers
420 views

Convert geometry type from Polygon to Multipolygon using FME?

I don't want to alter the geometry, just change the geometry type from Polygon to Multipolygon, in order to comply with a constraint.
8
votes
1answer
517 views

Filtering layers in QGIS atlas

In processing several spatial data sets (tbl_data_01, tbl_data_02, tbl_data_03, etc) using FME I establish a spatial table called "tbl_metadata" with information about each of the data set. This table ...
0
votes
1answer
171 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'...
2
votes
3answers
187 views

Running second FME workspace when first workspace is completed

I've got a workspace that inserts data in a database. It runs on FME Desktop and FME Server. After the insertion (the first workspace) is completely done, I'd like to run a second workspace that ...
3
votes
1answer
202 views

Controlling processing order in FME workspace?

I have created a workbench with 3 bookmarks: a Creator/ProjectWise connector which downloads an Excel file from ProjectWise a processing workflow a second Creator/ProjectWise connector which ...
2
votes
1answer
99 views

Transforming CAD File To shapefile (with Projection) Using FME Batch File

I want to convert files from within my application. I've tried a lot, but I can't find a solution. I have a DXF file with which I know the projection system (EPSG:4326). And I want to transform it to ...
2
votes
1answer
183 views

FME Use Output of reader in another reader

I have a ESRI geodatabase reader to read input table and i am using where clause to limit data based on date. write now i am using the user parameter to ask user latest date for input table. and then ...
0
votes
1answer
32 views

Does FME retain a log of the last run process

The hard drive where my FMW was has crashed and I was wondering if there is somewhere in the user profile or in the install location of FME that retains a log of what processes were run in the FMW? ...
1
vote
0answers
39 views

Getting geodatabase to SQL Server

I am currently attempting to load in 1000 data sets I have in 1000 different tables. I need to do this in Microsoft SQL Server. My data sources are either in Excel or geodatabases. The plan is to ...
5
votes
2answers
249 views

PyQGIS Problem adding certain vector layers to QGIS from postgres

I've created a tool to find layers from our PostGIS database based on a string match and add them to the current QGIS project. In the example below I'm searching for 'landscape' in the dataset name. ...
0
votes
1answer
118 views

Query to intersect polygons in PostGIS with points in MongoDB

Question: Is it possible to intersect geometries from No-SQL and SQL databases? Background: I need to delete the polygons from a PostGIS database that intersects with points (Lat/Long) in a MongoDB. ...

1
2 3 4 5
14