Questions tagged [fme]

FME (Feature Manipulating Engine) is an ETL (Extract Transform Load) tool by Safe Software. It is able to read and write a wide range of dataformats and services (+400). Loaded with tools for manipulation of vector- and rasterdata but also tabular and code (XML).

FME (Feature Manipulating Engine) is an ETL (Extract Transform Load) tool by Safe Software. It is able to read and write a wide range of dataformats and services (+400). Loaded with tools for manipulation of vector- and rasterdata but also tabular and code (XML).

The suite has two products:

  • FME Desktop

Build workbenches (models) to run the data through.

Sample workflow

  • FME Server (local) / FME Cloud (saas)

Upload workbenches and run them as a service.

60 questions
0
votes
1 answer

How can I connect to Google Cloud SQL over SSL without TLS Client Authentication?

I'm trying to connect to a postgres database on Google Cloud SQL from Safe FME, a GUI-based desktop application that can connect to postgres databases. It supports SSL but Google Cloud SQL apparently requires the use of "TLS Client Authentication"…
Tobias Fünke
  • 2,034
  • 3
  • 24
  • 38
0
votes
1 answer

How can I copy FME format attributes

I am using FME Workbench 2018.1.0.1 in Windows 10. I am inputting a kmz file. The only parameter I am reading from it is PLACEMARK because I see no reason to read the others. I need to copy format attributes kml_name and kml_description to NAME and…
Regulus
  • 13
  • 3
0
votes
1 answer

how to start fme workbench from c#

I'm using 2017.0 fme workbench version, I'm trying to start fme directly from c#. I have a windows application that calls cmd.exe and from there I call fme and pass some parameters (command line), there's any way that I can start fme from c# without…
0
votes
1 answer

SQLite loop routine to read excel and assign value from one table to another

I am trying to write a short SQLite routine for reading one table, compare it to another table and copy a value to that 2nd table. I am working in FME's InlineQuerier so reading the excel file is not a problem. The process flow: Row i T1(Excel)…
user13597
  • 125
  • 1
  • 6
0
votes
1 answer

Change GML geometry attribute from Linestring to Multicurve in FME

I am currently converting a shapefile into a GML file for an online Mapviewer. this application requires the geometry to be in a seperate attribute and needs to consist of multicurve features. using GeometryExtractor, i get the…
BHaag
  • 17
  • 4
0
votes
2 answers

FME: How to ged rid of overlapping polygons and keep only one

I am stuck with a problem related to FME and hope you can help me sort it out. Background: I am working with a Feature Class which consists of digitized polygons from different sources. Due to that many of these polygons exist more than one…
chajamalka
  • 71
  • 1
  • 8
0
votes
1 answer

Python line by line execution

I couldn't fine solution for this question using search option so my question is: I have a script that does the job but only for one file. Just to explain what`s going on here: import sys sys.path.append('C:\Program…
0
votes
0 answers

FMEWorkspaceRunner Python

I am trying to batch run workspaces from a standalone python script and it fails. I am particularly wondering if I am passing the parameters correctly. I was using an exception catch with a message but it actually provided less…
Gary Lester
  • 226
  • 2
  • 13
0
votes
1 answer

Transforming Excel worksheet with multiple table in FME

I need to transform Excel files to ESRI FileGDB using FME. The problem is that my excel worksheets contains more than one table. Example: At row 1, I have the attributes of the first table. Row 2 to 4 contains the values. At row 6 I have the…
kbonnelly
  • 189
  • 1
  • 1
  • 11
-1
votes
2 answers

SQL query for CONTAIN check and JOIN excel TABLE

Supplier Requestor Expected RESULTS SQL Code : SELECT T2."Fullname",T2."Town", T2."Age", T1."Surname" FROM "Requestor" as T2 LEFT JOIN "Supplier" as T1 ON (T2."Fullname" LIKE '%' + T1."Name" + '%') ORDER BY T2."Fullname" ; Not sure why the value of…
Vim
  • 1
-1
votes
1 answer

FME- Process feature one by one

How to process features in FME one by one For Example:- Take all the data of one country add certain data and write in FGDB, then take data of another country and then process it.
-1
votes
1 answer

Transform GeoTiff into JPEG under condition of number of bands

I'm super new to FME. I have lots of GEOTIFFs which I want to convert to JPEG, which works fine (as seen in the picture below (without the Tester)). But now some of my tiffs have 3 colour and some have 4 colour bands. If the tiff has 4 bands, I can…
uelf1
  • 7
  • 3
-1
votes
2 answers

Can we run an FME from a powershell?

I want to run an FME.fmw file from a PowerShell.ps1 one. I know that I can do that from a batch with the command fme C:\Path\of\fmw but I do not find a way to do it with PowerShell. Start-Process will only open FME and not launch it…
Rhon Yz
  • 145
  • 1
  • 1
  • 8
-1
votes
3 answers

trying to crate a regular expression for string

I have a string like a Taxi:[(h19){h12}], HeavyTruck :[(h19){h12}] wherein I want to keep information before the ":" that is a taxi or heavy truck . can somebody help me with this?
1 2 3
4