General

I have street centerlines (Line Feature Class) with intersection points (Point Feature Class) the end of each line. ​I am using the PointOnLineOverlayer and only the attributes of one of the end points is included in the output. ​Using the picture here as an example, I want the Line output from the PointOnLineOverlayer Transformer to include the attributes something like this:A St will include attributes of Pt 1 and Pt 3; B St will include the attributes of Pt 3 and Pt 2;C St will include the attributes of Pt 3 and Pt 4;Currently, here is my Line output:A St includes attributes of Pt 3;B St includes attributes of Pt 2;C St includes attributes of Pt 3. Any ideas on how to ensure each Line includes the attributes of the points at each e

How to find the column that has an empty fields ? as example. I have 50 attribute names some of them has values and other is empty .i do not want to use 50 tester to check for each attribute if it has value or not ? is there easy solution to get the required columns that has no value ?FME 2021 thanks in advance

Download older versions of Desktop? We need to download FME Desktop 2018. How can we do this?

Hi all,I am working with a huge database with 300+ layers. Many layers are the same for each province and they have the same structure in their attribute table. Many of the attributes are empty but that differs from state to state (f. ex. height might be empty in 20 provinces and in 5 there is a value). Is there a transformator that shows me which attributes are completely empty for each layer and allows me to filter them without checking each attribute for each province individually? That would be a great help.Thank you all :)

Hi guys! I inherited a very long workbench that includes a lot of readers and lots of processes that writes to a final table output. Is there a way to quickly review each attribute and trace the logic and processes in retrospect in FME workbench?

Hi guys, I am trying to read a data from oracle and I connected that as reader while checking connection test status is showing successful but while I try to fetch the table it showing "Failed to retrieve feature type".can anyone suggestion to override this issue? Thank you in advance .Regards,Saravanakumar 

I have a workspace that can sometimes generate some NaN-valued Real64 data types (from the surface draper specifically).  I'm really struggling with how to handle these. FME seems very inconsistent with how I can test them. I would like to test for them and terminate the workspace if they are found.  So far I have tried:Attribute Validator by type (numeric)Attribute Validator by 'Has a Value' Attribute Validator by 'Not Null' Tester by all of the above The only thing I was able to get to work is a tester using @abs(@Value(MyMaybeNANAttribute)) < 0.00000000000000000000001where I just used the number on the right as an arbitrarily small floating point number. This evaluates to True for my nan values, so I can filter them out. However, this is not a good workaround because I can have valid zero value in some cases. I have searched the forums and the art

We have short Workspace to update attributes and geometry (polygons) and added the Dissolver transformer, but when run the polygons are not Dissolved. When run we get more tract in the output than when in. Cannot see why this is not striate forward. Thx 

Hey Everyone,I am a newbie in FME wonderland can anyone help me out how can I convert bson to json. I am using http caller to get data from our asset management system named Alloy by Causeway. Al the data is in bson format and i don't know how can I convert that into usable format. All the data is sitting under _response_body. Let me know if anyone can help or want any more details :)

I’ve been wrangling a large number of Shapefiles recently (almost half a billion!), converting them to a PostGIS database. A small command file calling FME (with return code checking) was just the trick and, after several days of processing, the job was done. The problem is… my record count on one of the output tables is larger than expected. ☹ After some research and experimentation, I’ve discovered that if you pass a polygon with bad geometry (in my case touching rings, which is fine in a Shapefile), it causes multiple records to be written to a PostGIS table! So, if a record has a polygon with 3 rings, not overlapping but touching, it would be expanded to 3 rows in the output table. FME does not report this in its output summary, which makes be suspect it’s a PostGIS behaviour in trying to deal with the bad geometry. Fortunately, in my case, any additional rings are always artefacts in nature and can be discarded, so my main question is how can

Most of our automations are started by a FME-Server Schedule-Trigger. I would like to make a list with all automations and their start-times. I can get a list of all automations with the REST API, but how could I get all the start-times? Thanks, Vera

Hello!I've been struggling with the SharePointOnlineConnector transformer for a couple days now. I have set up a web service following the official tutorial (first I've set up one for Sharepoint List, then an identical one from the Sharepoint Online template as well). When using a Sharepoint List Reader I can successfully access the lists, but I can't access anything from the SharePoint Online Connector. I get the following error: "SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0/sites?$select=id,webUrl,name&search=: Access token validation failure. Invalid audience." The app I've set up in azure has the following permissions (might be overkill, but I'm just testing for now):Microsoft Graph (5)Sites.Manage.AllSites.Read.AllSites.ReadWrite.AllUser.ReadUser.ReadW

I have mxd file and I would like to extract layer names and each table names related to each layer FME 2021 Thanks in advance

I have a text file that is created in an Oracle database and output to a folder on a UNIX server file directory. Can a FME workspace read a text file from this type of location?

Basically, I want to match meter IDs from two different datasets: shapefile and excel file. Meter IDs in both datasets might have typos such as dashes, dots, letters, slashes, which I need to remove first. Then I want to match MTR_NO from Excel against Mother_1 , Child_3, & Child_4. My idea is to export an excel table that will include only matching meter IDs.   

is there any reader where i read the Google analysis data ?

Within ArcGIS Pro 3.1 I am creating annotations with the help of Arcade (a lightweigth expression language). The outcome is as shown below, basically a fractionWhen I read the annotation layer from the file geodatabase, FME does not interpret the HTML tags in the text string, but counts them as part of the text.I there a way to make FME interpret these tags correctly? My final product should be a dgn file with a level holding these 'labels' and I was wondering if that is possible, and if I can achieve this with FME. The 'fracture' consists basically of three parts as I see it:nominator that is underlinedline breakdenominator without unde

Hi I am reading various tables from Oracle each of which contain many date attributes. Is there a transformer that will allow me to filter out all the attributes that are have a type of date as I want to check the dates make sense (I know there are some with some very dodgy data in and wont write out to a sql table) Thanks

Hello , i have around 800 tables at my oracle database and I would like to ask if there is a method that I can find which tables has the same object id .i think ,if I read each table then use feature merger between one table and others and so on .it will take time is there a quick method that compare between all tables and eachother to find which tables has common id and show me the name of tables that has common id.my target to find the name of tables that has common id.FME 2021  

In Ideas @bilal​ said "One of the benefits of having a creator attached to such a transformer is the ability to define the order that the creators run in a workbench." https://community.safe.com/s/bridea/a0r4Q00000HbroNQAR/dont-require-creator-for-transformers-that-read-data How?

We are running desktop and server at version 2022.1.2.0 (20220831 - Build 22627 - WIN64). One particular workbench that we published runs to completion in desktop, but fails in server. I've checked some other cases and articles (such as this one), but none of the causes (including available memory) or workarounds seem applicable.When reviewing the job's log it seems to consistently fail at this step:156 2023-5-4 15:09:41 | AttributeFilter_NBI <MISSING> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)157 2023-5-4 15:09:41 | AttributeFilter_NBI <NULL> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)158 2023-5-4 15:09:41 | StringForma

Hello, Recently we attempted to adopt single sign-on through our Windows AD. However, we are having difficulties getting it to work. I have followed the steps outlined by: https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/IWA.htm It worth noting that we have also switched our server to using HTTPs Whenever a user clicks "Use windows credentials" they get an error "Login failed, please try again". Its worth noting if a user manually inputs their AD credentials, the login is successful. When checking the fmeserver.log file I do see the message "Unauthorized request by user <User> due to lack of proper permissions or the object does not exist." I have also noticed that when using the generate token URL:

I was experimenting with the OSM PBF reader, and I noticed that I get different results when I filtered on the Map Features vs the Feature types. In my sample data, if I selected building in the OSM Map Features, it read in 47691 features.If on the other hand I left the Map Features blank and selected building in the Feature Types to Read, only 45050 features were read in.Thoughts on why the mapping is different?  I assume it has something to do with Multiple Map Feature Resolution, and I would expect extra features if it was set to Duplicate Features, but since it was Use First, I&

The List Date in the bottom photo contains a field called ListDate which is stored in a SQL database. We're using their WFS to download the data however due to the validation in Pro we can't see any date fields so we're using FME. I'm trying to use the transformer 'date time converter' but I get the prompts asking which fields I want & as you can see the software is splitting out 1 field into several which are all 'missing'. Which list elements should I select? Also in the select list elements box what number should be entered there? I just need the date so can strip out the time element. 

Is there a similair function as DateTimeNow() which takes only the current date and not the time part? I know I can make use of Timestamper but I'm curious if there are other even more simple ways of naming by date in the writer using Date functions.