General

Hello,I have a workbench that checks several files for some data mergers. Problem is, this one source I have (30+ excel files with thousand of rows each) is useful only when there is a certain value in one of the columns. I was wondering if there is a way to open these files only if a condition is met beforehand (like a user parameter prompt). I wouldn't want to read all files every time knowing that if the condition is not met, they won't bring any value to the end result. For example, If I chose at the start of the workbench "Toronto" - it should trigger this reader; if I chose some other city, it shouldn't. Any advice is appreciated. Thanks!

Hi, This is probably a stupid question but I dont get why the following expression is in error in the PointCloudExpressionEvaluator with FME 2020 @round((@Component(x)*2))/2ERROR |PointCloudExpressionEvaluator (PointCloudEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. The provided value was '@round((@Component(x)*2))/2;@round((@Component(y)*2))/2'. Please ensure that your syntax is correct Curiously, the @round function is not available in the Math functions list in the transformer: 

Hello Forum. I'm trying to help a colleague to setup an Oauth2 service (Tools->WebConnections->+->Oauth2Service) but we're struggling. We have the parameters from the data-owner, and the "Preview" window in the setup dialog presents an acceptable URL (see attached image), but when the connection is made to the server, the URL is malformed. The problem is that the URL received on the server is terminated (prior to the parameters) with ampersand thus: /realms/fdir-dev/protocol/openid-connect/auth&redirect_uri=https://localhost/&client_id=yggdrasil-sa  instead of question-mark as reported in the setup-dialog Preview (see image) The question-mark is required by the server and html convention. Has anyone had success with the OAuth2 server connector, who might be able to guide us, or is this simply a bug?

Hi I have a lot of tif tiles that together form an orthophoto of a municipality. There has been a problem and the colors of the different tiles don't match that wel. Is there a way to color match the different tiles so that they match better? Here you see what it looks like now: 

We have a number of workspaces developed in older versions of FME that use various database connection parameters (e.g. database name, username, password etc). In some of these workspaces we do post processing (e.g. building indexes), usually via shutdown python scripts or pythoncallers and access these parameters in python using FME macro values.  I've tried running one of these workspaces today in FME 2021 (2021.0.2 - build 21321) and the python scripts no longer seem to be able to access the "password" parameters and python reports a KeyError.  If I try to test by creating a new pythoncaller in the workspace, I cannot see the "password" parameters in the list of user parameters, so I assume this may be a deliberate change?  Any ideas if this is a bug or a deliberate change by Safe in FME 2021? I can't find any info on that change, so if it's deliberate, it would have been nice to know about this so we coul

hello , i have lines from data A and Lines from data B I would like to find the closet lines or parallel lines for Lines A then get the attributes from B to A .i have used Neighbor finder but i get not always the correct result .As example at my data , there are also intersection or curves between lines a and lines b , so I got wrong result . I have read that there is Fuzzy parallel line ,but I am not sure if this transformer what I want and how this transformer work .thanks in advance .FME 2021 

I have a 3d building in fbx format, while converting to vrml. The building is completely upside down.I am not able to crack the idea?

A while ago I followed the article How to create a Sharepoint Web Connection and successfully created a web connection using the "Connecting to Sharepoint with your own Client ID [Multitenant]" steps. Now a coworker needs to use SharePoint in FME as well, so I exported the Web Service from my machine, imported it in the other machine and created a Web Connection based on this. Creating a web connection with the other user fails, after the username is entered. The error message is: Administrator approval requiredunauthenticatedneeds access to resources in your organization.This access can only be made by an administrator. You must ask an administrator to grant this app permission before you can use

I am looking for Inside workspace table feature count is there any way to get information 

I'm using a Geometry filter split out points, lines, polygons and tables (<unfiltered>). With the tables, I'd like to filter them further to split up the tables that begin with the prefix "Insp_" or "Maint_", because I want to exclude those from the rest of the script. I can only seem to figure out how to filter based on Attribute, but I can't figure out how to filter based on table name. Any suggestions would be greatly appreciated. Thanks!

Hi there, I have used a statistics calculator to group and count Shops on a streets by use - eg vacant, retail, leisure, financial etc. This gives me a table with the street name with different rows for the use and count of shops with that use on that street. Ultimately I would like to create a table with the uses as field names and the count of the use below with just the streets for rows. So for example - Converting the table in grey to the table format below that. I am sure there is an easy way to do this! If anyone can help I would be very grateful.Thanks Ruth

I'm trying to make some pretty histogram reports of some error differences and I'm having trouble getting the chart generator to actually show the trend line. I want to show it because my data should be close to normally distributed.I have tried to use the trend line in the scatterplot option but that does not work also.Does anyone know what I'm doing wrong? I should have enough data to get a trend (60+ data points)

I'm attempting to write data into a PostgreSQL database using the PostGIS writer. The issue I'm having is that the geometry is not being 'drawn' in ArcPro. When selecting the record in the attribute table, the geometry highlights but is not visible. When creating a feature from scratch in ArcPro, it draws as expected. This makes me believe it's a configuration issue within FME. I have verified the Shape Column is 'shape' (as defined in the database), and that the SRID matches that which is specified as a constraint in the database (3857). The coordinate system I'm using on the writer is EPSG:3857. I'm converting from DGN, if that is relevant. When reading the data back in with FME, all geometry appears normal and in the correct location. What could be the issue?  

Hello Group, I have a polygon dataset of LSOA boundaries read into FME. It contains a field called ‘LSOA21 2021 name’. The values in that field are entries like 'Southwark e09', 'Lambeth e08' and 'Lewisham e13'.  I want to filter out only those records where the value begins with the word ‘Southwark’. I’ve added a TestFilter with an If Test Condition of @Value(LSOA21 2021 name) CONTAINS_REGEX Southwark. But that is maintaining the entries where LSOA21 2021 name equals, for example, Lambeth e08. I’ve been looking through https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/!Transformer_Parameters/StringFunctions.ht

Hi, i Would like to have the road map geometry as input from Google maps or any other app.and use it as input data to FME to define which cable located at this road and so on .FME 2021

I have a point shp file that has an attribute with a number and I need to do a point on area overlayer, but the count in the area needs to be a sum of the attribute in the point file. I am stuck on how to do this! Hope this makes sense!

I'm trying to convert 3D models to GLTF, however, the output models tend to be a little do dark in the application we're using. I'm trying to make them brighter by setting the SpecularColor factor to white. I also want to set the shininess, but only if there is no shininess set. In addition I want to also apply a fallback appearance to the surfaces which have no appearance. The conversion needs to work for all inputs and ideally be nice and fast. I've been playing around with the SharedItem tools and have gotten very close to what I want, however, there are some edge cases where my process doesn't work.It seems like it should be really easy but I just can't get it to work. Has anyone had luck doing this?

I have Lines (13,000 Street Centerlines) and Points (7,000 Intersections). I want to do a spatial join of the Lines and Points so that the attributes of each point is merged with the 1 to 4 lines that intersect each point.  I just started using FME, after completing the training last month. What Transformer(s) would you recommend I use for this process? My goal is to have the lines each have the CROSS_ST_NAMES field which is in the points layer be joined to each line that intersects a point. In the points layer, the CROSS_ST_NAMES field has no <null> values, when they are merged with the lines there must be no <null> values. Below is a screenshot of what I am working with. Each line is a street centerline, each point is an intersection.  

I have recently installed FME Desktop 2022.0 (Database edition – Build 22337 – WIN64) and want to migrate old workspaces to this latest version. I have a workspace that was written and runs in FME Desktop 2019.0 (Database edition). It reads in about 120,000 records via SQL Creator (non-spatial Microsoft SQL data format), does some transformations, and writes to a CSV file. It works perfectly in FME Desktop 2019.0. However, when I open and run the same workspace in FME Desktop 2022.0 it is not working correctly. I have tried this on Windows 10 Enterprise and Windows Server 2012 R2. I have tried with Feature Cache on and off. I have tried running as a batch process. I have tried running the workspace in 2022.0 unchanged (as a 2019.0 workspace). I have tried running the workspace in 2022.0 unchanged (as a 2022.0 workspace). I have tried running in 2022.0 with transformers upg

Hi,I have a workspace where I use the oracle database connections as a variable. This works fine. When a runs the workspace a published parameter determines which connection is used. But when I publish this on fme server. I get an authorisation failure: FME Server error: `Unauthorized request by user due to lack of proper permissions for connection: **@**. Please see: http://fme.ly/zn8' Connections in fme server are available as in the variable.

Hi new at this...I am trying to separate some data from a CSV separated by a comma and then merge it back into one feature, I can't work out how to merge the 4 results I get from each entry.

I can create an AWS RDS Postgres Reader and Writer on FME Desktop and successfully run the workspace. However after publishing the workspace FME Server it fails. It looks like Readers/Writers to AWS RDS Postgres are not using system Proxy Settings. Completed steps in manually setting the proxy:port using fme.exe in the FME Documentation.  Thanks 

Hi everyone, I'm using FME Desktop 2022.1 and I would like to use the LDAP reader with an encrypted connection (LDAPS, Port 636).  When testing the stored connection I get the following error:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetI know how to get the root and the ldap server certificate. But where do I have to store them within the FME Desktop installation? Kind regards,Peter

I would like to calculate the average of pixels for each polygon, how can I do that? I have several raster fragments and several polygons.  Thanks

Hello FME friends,Welcome to the What's Up Wednesday newsletter for October 26th, 2022.  For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. Spatial "For Dummies"Did you know that Safe Software helped to produce an e-book on this subject? The actual title is "Spatial Data for the Enterprise for Dummies", but that was just a bit long to fit in a heading.  The book is