General

What is the equivalent FME Transformer(s) of this ArcGIS Pro Geoprocessing Tool: Join Features (GeoAnalytics)—ArcGIS Pro | Documentation Including JoinFeatures by geometry (intersect).

How does fanout work for dwg files with FeatureWriter in FME Server. Hundreds of postgis tables are read in my workspace with Feature Reader and they should be written as DWG files by object category. The process works as desired on Workbench. Separate dwg-files from each table with the desired filenames ja layer names will come out. But when I publish my workspace on the FME server, in download zip everything comes out in one and the same file with all feature types on its own layers and filename with a generically generated filename. When publishing, you can only specify the folder path. I would want to use FeatureWriters because I don't wanna create a hundred writers with few transformers each.

We are on FME Desktop 2021.2.2 Currently have a FeatureWriter that can insert new records (Account ID with their correspondence amounts) into SQL table from a source CSV file. See below: For each import, the CSV file could have same Account ID with different amounts. Therefore, we'd need to truncate any existing matching Account IDs rows and replace with new data. Changed Table Handling to 'Truncate Existing' but the amount still doesn't change. Heard you can change Feature Operation to 'upsert' but don't have that option Thanks.

I have a table of street names in a single field in this format: George St Adeline Way Parker Blvd I want to split this into two fields that include, for example: FIELD1 = George FIELD 2 = St I think I need to use the SubString Extractor Transformer? any ideas on the best way to go about this?

what I trying to do is write the values in the Database and then read from there as a reader but the problem is when I run my workspace its runs same time what I m want is 1st load the data and then reader-run

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

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

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))/2 ERROR |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 could update our workspaces. John

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 required unauthenticated needs 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?

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

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.