Stack Overflow
Stack Overflow

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
2 answers

Transpose Rows to Column in FME

how can I Transpose from Row to column? from this to this
Assad Amjad
  • 29
  • 1
  • 9
0
votes
1 answer

How to convert a DGN file (shared cells) into a DWG file (AutoCad blocks) in FME?

Me and my colleague are currently trying to convert a DGN file (with many points) into a realDWG file. The DGN file is roughly 90 MB, since there are shared cells in the DGN file. Shared cells are elements that are stored only once in the DGN file,…
Joy
  • 93
  • 1
  • 12
0
votes
1 answer

How to add boto3 AWS S3 object tags in FME?

new to coding and researching a work project. There are many files stored in S3 buckets that are processed by FME automations. I want to be able to add S3 object tagging to my FME transformers so they are uploaded with the appropriate tags. I found…
Victoria
  • 3
  • 2
0
votes
1 answer

Updating Google KMZ Popup Contents & Removing "Directions" in FME

By default a KML balloon will contain links "Directions to Here" and "Directions from Here" (driving directions). I want to know, how to remove these links from the balloon using FME, as well as use HTML to set KML Balloon content, URL links and…
user17167519
0
votes
1 answer

FME issue, deleting row based cell value

Hell all, so let try to describe my problem in the best light possible. I have experience with Python but have never used FME. I would like to delete a full row of data based on criteria in a particular column. I have an idea of how I would write…
Hondabear
  • 21
  • 3
0
votes
1 answer

How to extract/ generate the coordinates of intersection points of a line intersecting an area (in fme-workbench)

I have a question concerning the FME workbench. I would like to know how I can extract the coordinates of the intersection-points of a line intersecting an area (a mesh with poligons). The coordinates of the intersection-points should have a maximal…
Chris_Len
  • 19
  • 5
0
votes
1 answer

How to deal with Kafka JDBC Sink Connector with FME

I already setup the Kafka JDBC Sink Connector where it will consume the data from the kafka producer api, however I want to setup FME to deal with the data side and sink it to the database where it will interact with GIS (geographic information…
user14560049
  • 49
  • 6
0
votes
1 answer

SQL Server execution plan in FME

I would like to use FME to handle an execution plan from SQL Server (I trying to get a table with a row for each field which is used within a query). The SET SHOWPLAN_XML ON function has to be run in it own batch. The normal way would be to us the…
J.Warren
  • 728
  • 1
  • 4
  • 14
0
votes
2 answers

Beginner to API Json - Attempting to understand URL output

I am using FME to get output from the following: https://coronavirus.data.gov.uk/developers-guide I am just a beginner and is first time I want to write this up. To generate an Output URL from this with the relevant columns, can anyone explain what…
cardiokhan
  • 29
  • 6
0
votes
2 answers

How to return more than one match with regex expression

Hi I am currently trying to use regex (in FME, using StringSearcher) to match and return every instance where there is a hashtag, and the 5 characters following it. e.g "#29777 is close to #19666 and also make sure #12345 is there" would…
Sam Appleton
  • 1
0
votes
2 answers

PostGIS: How to create a table with a generic 3D GEOMETRY column?

While attempting to import geometry information from a CAD drawing into PostGIS, I am having a problem with 3D geometries being coerced into 2D. The dataset that is being worked contains both 2D and 3D objects. Unfortunately, the tool I am using for…
J Spratt
  • 1,762
  • 1
  • 11
  • 22
0
votes
1 answer

Making a list of streetadresses

SOLVED :-) I'm having this list, and would like to get the expected result, but no luck. Tried in python and FME If there is more than 2 between the current and then previous number, a new line has to start Can anybody help? Preferable in FME, but…
Mads Borggaard
  • 3
  • 3
0
votes
0 answers

Massive performance fluctuations with MS SQL Server 2016?

I have an ETL job (extract, transform, load, developed with Safe FME 2018) and running against MS SQL Server 2016. This job processes only regular data (no spatial data): The data is extracted from several MS SQL Server tables, transformed with FME…
Tobias Brühlmeier
  • 1
0
votes
1 answer

FME: Calculating Multiple attributes using Expression Evaluator

I am new to FME, so please accept my apology if my question sounds too simple or stupid. I want to calculate two new attributes. Both attributes have different calculations. I am using Expression Evaluator. I can only calculate one attribute. For…
user2293224
  • 2,128
  • 5
  • 28
  • 52
0
votes
1 answer

Archiving Files Using Python Apart from Latest File

I am trying to archive existing file apart from the latest modified file in Python or FME. I have managed to get it to point where I can get python pick up the latest modified file but any ideas on how I can archive all the files i have in my folder…
cardiokhan
  • 29
  • 6
1 2
3
4