General

Hi, How can I check if two equal or similar geometries are displacement in some way when they overlap? I don't want to validate when they are not related in any way, but only if they are with some kind of displacement. Thanks

It is taking a considerable amount of time to run the workspace with a million row CSV as a reader. Please suggest how to reduce the run time

I want to perform an operation where I want to add a new attribute which will have value of next 23rd feature from existing attribute. Is there any quicker way to do this without enabling "Adjacent features Attributes"?

I am trying to come up with a way to use FME Desktop to process files that will be automatically exported from a system and will likely be named with a timestamp (eg filename20230512132945.xlsx). The goal is to create an automated process to handle these files as the appear. I already run FME Desktop from the command line (via windows Task Scheduler), but I am wondering if there is a way to do it and also specify the name of the file I want to have read as a parameter? Something like C:\\fme.exe workbench.fmw inputFile.xlsx I don't think I am going to be able to count on these files having the same name every time, otherwise I could just run the workbench (c:\\fme.exe workbench.fmw) I'd be grateful for any suggestions. I would happily try to do this with FME Server but it is not currently available to me. Thanks, Mike

I am trying to create a workbench to extract wms features into vector https://data.gns.cri.nz/tsunami/wms.html. I am wanting to extract out points and associated attribute data that is relating to each tsunami event

Hello!The FME im using: FME Workbench 2022.2.5 Im a student and using our floating license at school. No matter how big/small the script is, it will just freeze at random.If i place a simple node or hit export, the program just locks up and i have to either wait forever or just exit the program.  My computer is quite powerful so that shouldnt be the issue... Is there anyway for me to share more information that could help solve this issue?    

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 end of the line instead of only a point at one end of the line?

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 articles and I have not had a good explanation of how NaNs are handled in FME. Is there a way I can catch these with a data validator or a

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 I set a polygon to be its first ring o

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.ReadWrite SharePoint (7)AllSites.ManageAllSites.ReadAllSites.WriteMyFiles.ReadMyFiles.WriteProject.ReadProject.Write What am I missing here?Thanks in advance!

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 underline

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