Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
tamadur
Contributor
tamadurContributor
asked in Transformers
How to create File folders from excel column

I have Excel sheet with 2 fields, and I need to create folders with the values of the field 

355
tomfriedl
Contributor
ivanbakker
Participant
ivanbakkerParticipant
asked in Authoring
Point styling using symbols from .dgnlib

Hi all,We have a set of points that we want to replace with symbols that are currently in a .dgnlib file. Opening the .dgnlib file does not give us the symbols directly within FME.How can we style the points using the symbols from the .dgnlib file?Kind regards,Ivan

151
james_c_452
Enthusiast
boubcher
Contributor
boubcherContributor
asked in Data
Extract Polygon information

Hello Guys I have a polygon  we need to know the length of each segment and which direction the segment is facing north , south , East or Ouest. Thanks 

566
david_r
Celebrity
vki
Contributor
vkiContributor
asked in Data
Microsoft SQL Server Spatial (JDBC) Reader fails to read views

I want to read some views in Microsoft SQL Server Database using a Database-Alias (not the Servername).I tried to make a DB-Connection using Microsoft SQL Server (ADO), but it didn't work with the alias (it works with the Servername).With a Microsoft SQL Server (JDBC)-DB-Connection, I can access the DB, using the DB-alias. Then I wanted to read the views, using the Microsoft SQL Server Spatial (JDBC)-Reader:I can access the database, but not the views. (In a database-application like DBeaver it works fine) TheDB- user account I use, is allowed to read the view, but not the underlying tables. Is FME not able to handle those permissions?  

233
s.jager
Influencer
epro_admin
Contributor
epro_adminContributor
asked in Authoring
First time using FeatureReader and WHERE clause

This is my first time using the FeatureReader and the WHERE clause. I’m trying to tidy up my workspace and make it a bit more efficient.In the workspace I want to read in all the track points from an ArcGIS Online feature class and then in the WHERE clause filter it to just the last 24 hours.This is the WHERE clause I’m using. It has the correct date field. I’ve formatted it in the DateTimeConverter like this %Y-%m-%d %H:%M:%S."location_timestamp">='@Value(_24hrsago)'It filters immediately (I think) to what I need (first screenshot), but by the end it has passed through all the points in the feature set. Do I have the wrong output port connected up? Is there something I need to select in the parameters? This is what the FeatureReader Parameters look like. An additional question I have is if I want to filter to the last 24 hrs (as mentioned above) plus Projects A, B and C. How would I combine this in a SQL expression? I currently have this going into a Tester and then Clipper, but wo

342
epro_admin
Contributor
checcosisani
Contributor
checcosisaniContributor
asked in Integration
Run Python script in FME

Hi I had to create a script to be able to webscrape a web page using Selenium. I would like to be able to launch the script from FME but I don't know how to do it.If I share the script someone can help me ? thx Francesco

1074
hkingsbury
Celebrity
shilpak
Participant
shilpakParticipant
asked in Data
Hi there, Could I please have an update on if the I3S writer support point clouds after the release of 2023.1.1? If not then could I please have an update on the timeframe on this? Thanks, Shilpa

Hi there, Could I please have an update on if the I3S writer support point clouds after the release of 2023.1.1? If not then could I please have an update on the timeframe on this? Thanks, Shilpa

615
kailinatsafe
Safer
sandanuwan
Contributor
sandanuwanContributor
asked in Transformers
Microsoft SQL Server Spatial Reader/Writer Supported FME version

Which version of FME Desktop/Flow supports “Microsoft SQL Server Spatial Reader/Writer”? I want to re-project MapInfo Tables in the GIS database. Currently I’m using FME Desktop 2022.1. Is there any alternative transformer I can use to re project the objects in the live database? 

793
kailinatsafe
Safer
messagemauri
Contributor
messagemauriContributor
asked in Transformers
HTTPCaller transferred a partial file

Hello,I’ve had a workbench running on FME Server and FME Desktop 2022.2 perfectly fine through the last 2 years. Suddenly, it’s throwing an error HTTP Transfer error: Transferred a partial file. I tested it with FME Server and FME Desktop 2022.2 and get the same error. When I access the url through a browser, it perfectly downloads the zip file. But the HTTPCaller fails. Request Url: https://static.aer.ca/prd/data/wells/PLA_RTF_SHP.zipAny insights would be greatly appreciated.Thank you. Sample below for testing purposes, attempting to download the file in my local.HTTPCaller settings:  Error: 

1564
messagemauri
Contributor
qubbiewu
Contributor
qubbiewuContributor
asked in Authoring
How to Upgrade the Version of FlexNet License Server

Hi, We are deploying FME Desktop 2022.2 in our server (it’s a virtual machine).  The security team had done a security scan and expected us to upgrade the FlexNet Publisher to version 11.19.6.0 or later. However, the FlexNet installer downloaded from this link (https://fme.safe.com/downloads/) is Build 11.19.2. And it looks like bonding with FME Desktop so that we cannot upgrade FlexNet Publisher individually. How can I upgrade the version of FlexNet to version 11.19.6.0 or later? Thanks in advance. Best Regards,Qubbie

6354
crystalatsafe
Safer
nea
Contributor
neaContributor
asked in Data
Not able to create polygons from solids

Room output from an Architectural Revit model are solids. I need room polygons and I’m not finding a transformer that will do this.  Each floor of the model has a floor elevation value which would be perfect for slicing the room objects.FME version 2024.1

7110
nea
Contributor
n.d
Contributor
n.dContributor
asked in Authoring
Removing black areas in a transformed raster

Hello everyone, I transformed some Orthophtos in a new coordination system and the nodata areas are black. How can I make these areas transparent? (The output data formats are TIFF and JPEG.)(I have read the related discussions, but couldn’t find the solution for my case.) Thank you for your help!  

1198
n.d
Contributor
victoriageo
Participant
victoriageoParticipant
asked in Transformers
Remove attribute columns with missing as only values

Hi,I have encountered a problem. I have built a script that reads in from several SHP files followed by multiple SpatialFilters against another SHP file (A). The aim of my script is to check which polygons from (A) intersect with any of the other SHP files. I never know how many polygons from (A) will intersect because it is regularly updated.So, here is my problem. The result of this is a CSV and an SHP that contains the polygons that have intersected, and all the attributes from the SHP it checks against are appended. I want to remove all the attribute columns that contain only missing as values, but I have not been able to do that. The result can contain up to 25-30 different attributes! I have tried AttributeManager, NullAttributeMapper, and PythonCaller, but I can't make anything work.Any suggestions would be very helpful!

771
s.jager
Influencer
marjan_nikoukar
Contributor
marjan_nikoukarContributor
asked in Data
how to downloads data from an FTP server using FME

Hi,I have FTP Link, User, and PasswordHow Can I download a file using FTPCaller?Thank you for your assistance  

3034
virtualcitymatt
Celebrity
hyperx
Contributor
hyperxContributor
asked in Data
Moving Feature Points on to the Road Segments

I am using Survey123 that generates a feature point at a default location. Every new point contains the name of the Road and from to information for the line segment. I am wondering whether there is a way to auto move that point right on top of the line segment using the Road Name information.Is there any functionality in FME that would allow me to move those points?

242
hyperx
Contributor
kkq
Contributor
kkqContributor
asked in Authoring
Aggregation/Grouping in stream processing

Hi,I’m getting data from a streaming source (Kafka) that contains multiple geometry per feature read in WKT. To process the geometry, I “desaggregate” the feature first, produce a geometry from the WKT string, then try to aggregate it back with the Aggregator transformer. As stream processing doesn’t allow blocking transformers, I have set the Group Processing parameter to “When Group Changes”.My issue with this solution is that the feature leave the Aggregator only when effectively, the group changes which means when a new feature is read… I was wondering if there was a way to force the output of the latest feature, or if it was possible to make the process “Desaggregate/Produce geometry/Aggregate back” treat one feature per feature. Edit: this is most probably possible with a PythonCaller, I’m wondering if there was a “native” solution.

545
ebygomm
Influencer
vxn43
Supporter
vxn43Supporter
asked in Data
Extract metadata from a shapefile

Hello,  What is the best way to extract metadata from a shapefile? This would include Title, Tags, Summary, Description, Credits, Field Names, and Summaries. I want to export the metadata to an Excel spreadsheet.I am looking for some ideas on what transformers to use. 

971
redgeographics
Celebrity
leon.bowers
Contributor
leon.bowersContributor
asked in Data
Cannot write dynamic ArcGIS Enterprise feature layer

Hi,My goal is to read multiple (unknown) Hosted Feature Layers (HFLs) from an AGOL group and write those to ArcGIS Enterprise (11.3). I can successfully specify a single HFL in my FeatureReader and using an Automated schema in my FeatureWriter, specify each individual layer and write it to Enterprise. As I need this to work for multiple HFLs, most with multiple layers, I need to use a dynamic schema in my FeatureWriter. As soon as I do this, my workbench fails. Every time I switch to a dynamic writer, using the fme_feature_type as layer name and schema from schema feature, the workbench fails due to these errors:Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'My_HFL_Name'ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details I’ve tried everything I can think of to get this working and cannot understand what I’m possibly doing wrong. Any help would be greatly appreciated. My workbench (so complex...) AGOL HFL FeatureRea

673
leon.bowers
Contributor
miguelhacar
Contributor
miguelhacarContributor
asked in Transformers
In the exercise: "Add Appearances to a 3D City Model" I have a problem with the "AppearanceSetter"

In the exercise: "Add Appearances to a 3D City Model" I have a problem with the "AppearanceSetter" transformer because I cannot get the colors in the buildings in the PDF output, as described by Liz Sanderson. I always get them in RED in both cases, namely: "AppearancesRed" and "AppearancesBlue". I have run the workspace as I downloaded it but both types of buildings always come out in RED in the PDF.https://support.safe.com/hc/en-us/articles/25407543263373-Add-Appearances-to-a-3D-City-Model

343
kailinatsafe
Safer
muhammadsambe0
Contributor
muhammadsambe0Contributor
asked in Data
téléchargement automatique des données IGN (BD topo, BD, cart), OSM, DatatGouv, INSEE sur FME

 Bonjour,je veux d’automatiser le téléchargement et la mise à jour des données accessibles via les plateformes de diffusion de données géographiques (IGN : BDTOPO, BDCARTO, etc., OSM, DREAL…).Actuellement, je travaille sur la partie automatisation du téléchargement dans FME, qui consiste à moissonner ces données. J’ai déjà fait quelques avancées, mais je sollicite votre aide sur des conseils; liens utiles  ou des pistes afin d’approfondir mes travaux..En vous remerciant d’avance. 

1306
muhammadsambe0
Contributor
olyster
Contributor
olysterContributor
asked in Transformers
Prevent Logging of authorization header with HTTPCaller

Hi,When using HTTPCaller with an authorization header with a bearer token, the token appears in the log.How can I prevent this ?I’m using FME desktop and server version 2021 so LOG_FILTER_MASK doesn’t work. Updating the version is not a solution. The bearer token is obtained at runtime so I can’t put it in a private parameter (PP cannot be updated at runtime).Thanks.

929
olyster
Contributor
muhammadsambe0
Contributor
muhammadsambe0Contributor
asked in Data
Découpage ECW assemblé 30GO

Bonjour, Je rencontre des difficultés depuis plus d'une semaine pour lire et transformer un fichier raster étendu au format ECW (orthophotographie avec une résolution de 5 cm et une taille de 30 Go) sur ue version FME 2020.  Je sollicite des aides.Merci d’avance Mouhamed 

9415
muhammadsambe0
Contributor
emiliodepalma
Contributor
emiliodepalmaContributor
asked in Data
how to read an Oracle multi spatial column table with FME Workbench

In some tables stored in an Oracle database there are more than one spatial column.The reader can't read all the spatial columns but it reads onnly the first column it encounteres.how to read an Oracle multi spatial column table with FME Workbench?Emilio De Palma 

715
emiliodepalma
Contributor
milo89
Enthusiast
milo89Enthusiast
asked in Authoring
Are the dashboard workspaces available online?

I’m wondering whether the dashboard workspaces for various versions are available online anywhere.I note that this question has kind of been asked before for a couple of reasons, most commonly that a restore and overwrites the dashboard workspaces of a new FME Flow installation.While it’s probably best practice to download the workspaces before the restore occurs, with the best answer for the previous question was for the workspaces to be attached (attachment is no longer available though), I’m wondering if it would be possible to have some hosted or available online, potentially via the FME Hub.As always, thanks in advance.

312
milo89
Enthusiast
cossy27
Contributor
cossy27Contributor
asked in Data
Strange view of CityGML model

Hello!I generated a CityGML building model from an fbx model. The model could be opened in FZKViewer but the view is very strange. I could see the textures in the back when I am on the front view. It is like the surface in front of me becomes a very transparent glass.This happens at all of the sides of the model except the roof and ground surface. When I turn off the texture, everything is back to normal. Is it the problem of the texture? How could I check if it is on the texture and how could it be fixed? 

262
cossy27
Contributor

Badge Winners

Show all badges

Community Stats

31,842
Posts
120,952
Replies
39,474
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.