General

I have a table containing ten lines (each one a street). Each street has a name and a zone value. But there are some duplicate records…  Street_name                       Zone_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone BHigh Street                         Zone DHigh Street                         Zone DAcacia Avenue                   Zone BAcacia Avenue                   Zone B Acacia Avenue                   Zone B Acacia Avenue                   Zone C Acacia Avenue                   Zone C  How would I reduce these down to unique records only. So, I’d end up with this… Street_name                       Zone_nameSt James Street                  Zone BHigh Street                         Zone BHigh Street                         Zone D

I know that I am missing something obvious, but if I have a point that is on a line dividing two adjacent polygons, how do I select both polygons. At present I am using the point on area overlayer transformer and just getting one picked up?? The image below should make this clearer..Regards...

In the source file, i have 4 files but when I aggregate the fields it gives me only two files please anyhow help me where I doing wrongSource fileAfter Aggregate the fields

I'm working with the SchemaScanner transformer and trying to compare two similar schemas for differences.  However, one of my datasets is a shell and has no features in it (the top feature reader and stream in the workspace screenshot) This seems to be causing SchemaScanner to output different results than my dataset that has features.  I'm basing my workspace off this article here - https://community.safe.com/s/article/How-to-SchemaScanner-Transformer How can I compare the schemas in this case?  Here's the list exploder output from the feature class that has features

Hi allTrying to generate watersheds based on input points and a DEM. The ESRI Create Watersheds tool does what I need but I haven't been able to figure out how to do it in FME. Any pointers? Inputs: DEM + PointsOutput: Watershed areas per pointESRI tool https://doc.arcgis.com/en/arcgis-online/analyze/create-watersheds.htmThank you

I have one column with this values. I would like to filter only words that contais ABC letters. But can´t be JACABC or RDABC. Sometimes the ABC is stay in second or third word after the comma, like image below:  Thank´s

For more information visit us:AutoCAD Classes in PuneAutoCAD Course in PuneAutoCAD Training in Pune

Hi, I'm trying to insert a decimal into a string of numbers, so 123456 becomes 1234.56  Thanks!

Hey there, So I recently set up a Data Distribution service on FME Server using this tutorial https://community.safe.com/s/article/data-distribution-fme-server-app . Everything works fine and I can use the area of interest box to draw an area and download all the relevant layers. I am trying to add a second option in the User Parameters to allow the user to either draw a selection or choose a layer to clip by.In user parameters I added a 'Choice' option and added a layer as an option to clip by my thought was I could add a second geometryreplacer, set the encoding to OGC well known text and the source as $(LAYERCLIP) by when I run it and select the City Bounda

I am wondering about how it works if you want to have mulitpled editons of FME Desktop using the same Lic seerver, so floating lic. So say if we had 10 floating lic, and had 8 ESRI Editions, and 2 professional Editions how does that work on a Lic server, can users pick an edition when they start FME Desktop ?, or do you have to set up user groups for specific edtions, or would you need 2 lic servers, one for each edition ? Just trying to understand how this would work and what the options are for users to be able to choose an edition.

My organization is upgrading to FME Server 2021 (from 2018), and we'd also like to update our authentication method from Windows Directory to Azure.  I restored the backup configuration from our FME Server 2018, so all our user profiles are coming from the Windows Directory. I have successfully set up a connection to Azure and can import new users (the user says Type = Azure AD), but is there a way to migrate my existing users from Type = Directory Server to Type = Azure AD? Alternatively, I could re-import all my users from Azure AD and re-assign roles, but I was hoping there would be a way to switch the authentication.  Thanks

Hello FME friends, Server Apps TroubleshootingAs I mentioned previously, I'm getting a weekly report of new and updated knowledgebase articles, and the one that stood out this week is FME Server Troubleshooting: Server Apps. Besides simple troubleshooting steps, there are a number of FAQ-type issues, such as "Why don't users have the ability to upload files to my app?" Solution: Ensure the "User Can Upload" setting is enabled.  Also, there's an interesting issue where the OK button doesn't work (answer: there's a user parameter that's hidden, but is required and has

Hi! I just want to know if this is possible before I start to dwell deeper into it.  What I have is a web-application created in ArcGis Portal. I can select points within the app using a polygon. What I need is to be able to send only the selected points to an FME-script that should run and do an analysis on the points, all from within the web-app. The point layer is published to ArcGis portal and its stored inside a PostGis database. Is this possible at all?  

I need to use a unified database connection string which contains primary and secondary/DR database. Secondary /DR database is an exact replica of primary database. When the primary database is down , it should automatically connect to secondary database. All my existing workspaces are configured considering a single database connection . With the change to include primary and secondary db connection, can you please suggest how I configure this FME with least number of changes since it has an impact on all the existing workspaces.

I have Workspace where shapefile has polygons they overlap so i want they should be no overlapping . lowest values are normally on outside so I start clip with the next highest values then you move from low to high 

The error in log isERROR |GEOJSON writer: Transcoding the binary string '\\xFF\\xFF\\xF9\\xFF\\x02\\x00@5^:\\xBF$)A`;\\xDF\\x0F\\xCE/)A(1\\x08,\\xC1$)A`B>\\x88\\xCE/)A\\x16\\x00\\x00\\x00E\\x00x\\x00p\\x00A\\x006\\....0' to another encoding can not be doneWhat's this mean?

I have a dataset of parallel lines that I have buffered (150ft) and dissolved into one polygon. My question is, is there a way I can preserve the actual flow (direction) of the main buffer, and split out where the buffer separates from the main path? I want to keep the main segment as one feature, and where it splits as a separate feature. In the image below kind of explains what I am attempting to do. Segment 1 would be one solid feature, while segment 2 would be another solid feature.    

Hello FMEers,Welcome to What's Up Wednesday. Academy UpdateThis week, the FME Server Authoring Trail has been updated on the FME Academy. As you might know, a "Trail" is an extensive course composed of multiple modules, so this is a comprehensive update.  In fact, you can see it's 7 hours of content, worth 4,000+ points, and even consists of multiple smaller trails: Publish Workflows to the Web trailWhat is FME Server?Publish Workflows to the WebCreate Data Integration Apps trailBuild Basic Self-Serve WorkflowsManage FME Server Data

Hello There we have a set of point features we want to filter the point that has the same distance +- 5m to each other as You can see in the picture we should keep 1 ,3.5, and 7 since there are at +- 5m distance and should delete 2 ,4 and 6 If we go with a neighborhood finder with a max length 5m will work but point 2 and 4 are also located at a 5m distance, the goal is to keep only one set of points the green or the blue  

We have two formats to connect with SQL Server : Microsoft SQL Server Non-Spatial Microsoft SQL Server Non-Spatial (JDBC) What is the difference between them? 

Does anyone know what causes the error?

Hi, I have multiple strings that are in this format 560_20170619_0900, I would like to remove all before and after the '_', leaving me with just 20170619. Is this possible using the attribute trimmer and regex?ThanksB

This error occurs once and and while and the issue resolves itself on it's own, sometimes the next day or sometimes it persists for several days. The issue seems to be with any transformer/reader that reads in oracle non-spatial tables.

I am doing the FME Server Authoring 2021.1 trainig and I see video day 3 is completely irrelevant to the FME server training modules. Now I started day 4 it seems few modules skipped as day 3 was not the correct video.Is there any other source to the trainig video that match with course modules?

Hi all, I am new to FME and am struggling with how to clip a raster and keep the z values. The raster is an ESRI ASCII file and contains flood depths around buildings. I want to keep the raster cells within x meters of he buildings and then calculate statistics based on the kept cells only (z_max etc). Any ideas on how to achieve this? Thanks in advance!