- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,033 Posts
13,789 Replies

When you subscribe we will email you when there is a new topic in this category

4033 Posts

Recently active

Most replies Most views Newest first

viviancfhungContributor

asked in General

translate fgdb dataset to shp format failed

We get the error when translationfme Unexpected Input Remover Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)What's that means

123

2 years ago

mr_fmeEnthusiast

asked in General

Inset date in Column name

I need to insert current date (month_year) in column name all time that run my workspace Look Bellow: Thank´s

262

2 years ago

robertrContributor

asked in General

Trigger a Reader only if condition is met

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!

1214

2 years ago

bgeorgesContributor

asked in General

Math expression error in the PointCloudExpressionEvaluator

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:

FME Client sending incorrect URL to Oauth2 Service (Keycloak) authenticator. Is this a bug?

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?

koenvdwContributor

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:

121

2 years ago

john_gis4Contributor

asked in General

Availability of password user parameters in Python

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 could update our workspaces. John

373

2 years ago

gogopotter90Contributor

asked in General

How to find parallel lines and closet line

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

1253

2 years ago

babintParticipant

asked in General

Convert fbx to vrml(.wrl) , the 3d object is upside down??

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?

Connection to SharePointOnlineConnector

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 the app.Do you have an administrator account? Sign in with that account When I use my login, it just works. So the Web Service seems to be fine. Did I forget a step? Or did IT tighten the app aproval process in the meantime?

Workspace information

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

2 years ago

andrea

asked in General

Filter out tables based on their name (using prefix)

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!

261

2 years ago

ruth_hContributor

asked in General

Splitting a table into several tables based on the value of an attribute so I can create a new table with the different attribute values as field names and counts. Or convert original table to one with additional rows for the attribute value counts.

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

331

2 years ago

james_c_452Supporter

asked in General

ChartGenerator not showing trend line

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)

148

2 years ago

dustinInfluencer

asked in General

Writing geometry to PostgreSQL database

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?

967

2 years ago

scarterContributor

asked in General

Filter out (with TestFilter?) records starting with specified word

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.htm, but couldn’t work out exactly what string I need. Any ideas, please? Thanks,

128

2 years ago

gogopotter90Contributor

asked in General

Could I get road map Geometry from Google maps to enter as input data in FME

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

How to sum attribute of all points in an area

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!

682

2 years ago

virtualcitymattEvangelist

asked in General

Best was to modify existing Appearances?

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?

2 years ago

vxn43Supporter

asked in General

Spatial Join of Points with Lines

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.

881

2 years ago

sussexpeteContributor

asked in General

Errors every 10,000 records in FME Desktop 2022.0. How to fix this?

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 upgraded to the latest 2022.0 versions. In all cases after every 10,000 records, several records are corrupted on the

How can I use variable database connections in fme server depending on the specific user parameter input? This works fine in desktop but not with server.

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.

How to merge a list ointo separate attributes under one feature?

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.

2 years ago

pwilkebrownContributor

asked in General

Connection to AWS RDS Postgres using Forward Proxy on FME Server

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

How to use the LDAP Reader with LDAPS within FME Desktop?

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

535

2 years ago

Page 52 / 162

Badge winners

jkenneyhas earned the badge Teacher (Grey)
jkenneyhas earned the badge Welcome Back
obellohas earned the badge Welcome Back
0xbox0has earned the badge Student (Grey)
0xbox0has earned the badge Teacher (Grey)

Show all badges

30,162: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.