FME Form

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

FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64 Hello Just detected this possible bug when importing Attribute Names / Values using Attribute Manager. The Names are pre-sorted and the "Sorted" option unticked as shown below. Once the dataset has been imported (Select * for Input/Output/Values) the values are set as shown below. Was I not meant to see the actual values or have I misunderstood this part? Looks like the Attribute Names have been set as values. If that's intended then what could be a potential use case?  Original Attribute Names order / Table structure as defined in the Postgis Db

Hi, I have two datasets, each with thousands of features, I need to check the spatial relationship between them, but if for example 2 features are the same, I would like that based on a certain field with the value of the year for example, it would always be considered the most recent year.  Can you help me? Thank´s

I downloaded gml file of munich and want to use only few buildings, specifically TUM, from it. However the gml covers large area.  How do I cut out the buildings that I want and remove the other buildings from the gml and then save it?  I tried using "Clipper" transformers but I dont have any other information or files to use other than personally knowing that I only want the specific few buildings.  

Hello, I'm reprojecting tens of millions of complex polygons from LL-WGS84 to Esri's USA_Contiguous_Albers_Equal_Area_Conic_USGS coordinate system. There are many other transformers in the workspace as well. Using the EsriReprojector, the reprojection works as expected but takes a very long time. Using CsmapReprojector, the polygons are 3ft (~1 meter) off from where I'd expect, but it's about 30 times faster (many hours!). I've noticed this difference between the two transformers before with any reprojection that has a datum transformation. Does anyone have any ideas that would allow the performance of CsmapReprojector with the results of the EsriReprojector? Notes:I saw another post where a user believes

I am able to complete the geometry transfer from GIS .shp to DGN v8 however the attributes from the writer are not available once the format has been changed even though the reader and writer seem to recognize them.

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 

When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.

Hello,In a model that I am creating, i would to expose attribute in the feature reader automatically . The idea is to use the same model for different dataset. I have seen that is not possible to do it automatically but I would ask you if it's possible to do that using the user parameters. if yes, please, can You explain me how to do?Or if there are some other ways.The input file is not stored locally and it's a zip file. Thanks to all. Max 

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

I have a COLLARS table with the following columns : hole_number, X, Z, Z; I also have a SURVEY table with hole_number, depth, azimuth, and dip. Currently I use the QGIS "Geoscience" plug-in with those tables, it does a nice job but it's static and I can't really schedule it. Any thoughts?

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

Hello, I have been sent a SketchUp model that includes roads, cars, trains, buildings, and other features. I do not have a SketchUp license. Viewing with Inspector, all of these features are aggregated as one, so I cannot select individual buildings. What is a potential workflow to extract the individual buildings from this mass SketchUp model? My end goal is to incorporate these buildings as COLLADA (.dae) format to be used in an ArcGIS Pro Scene for land use planning and visualization. I know an appropriate workflow may be difficult to determine without having the attribute information, so even suggested potential transformers to use is appreciated. Thank you.

Hi everyone,This is a very specfic question and is targeted towards the persons who work a lot with dgn files in FME Desktop. I ask this question on behalf of my colleague.  He is reading in a lot of dgn files in FME Desktop made by other persons from other departments and some drawings have a global origin that is not x = 0, y= 0 such as in beneath image. My colleague would like to derive these global orign x, y and z values so we can move the global origin of these dgn files to x en y =0. Does anyone thus know if the global origin x and y values are stored in some kind of parameters? When reading in the dgn files in fme desktop the global orign x, y and z are known (see image below). So it looks to me that these values are stored in some kind of variables. 

 

I don't see the grid in email body when I use table in htmlreportgenerator and emailer

Hello everyone, I'm trying to create a automatization of the Viewshed geoprocessing (a raster and a shape file in input and a raster in output) from Arcgis in FME (because its ModelBuilder doesn't work as well). But I didn't find any transformer or python script by Python Caller about it. Have any ideas or tips for me about how can I do exactly the viewshed geoprocessing but in FME ? thanks !

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?

I have an MSSQL database, where new rows will be added on and off. I have setup a workspace that will be run nightly, that checks the database for rows with null in the field "email_sent_with_data" and sends it in a beautifully formatted email and it works wonderfully.  However, I would like to send along a map, either a pdf or a shapefile or similar containing the three geometry columns in the row. Any ideas for solutions to this problem?

Dear Sir / Madam, I have an indoor data set. As shown in the figure below.  Red line represents network path.Blue circle is the POI (Point). Black dot is just the vertex. As I have an indoor data for the entire building. I would like to find network that is unnecessary (not linked with any POI), as shown as Yellow Circle. I am just wondering what transformers I can use to find these path?I cannot just simply break the lines as some vertex are necessary for turning. I would really need some hand. Thank you very much!

I am creating PDF reports from ArcGIS Portal Features w/ attachments. The workbench is set up to write to a word doc to use the template doc functionality (custom header/footer) and then converting to PDFs with a PythonCaller. It seems that when writing more than 2 images (from the feature attachments) to the MS Word document, it corrupts the file. Two images or less works correctly and the documents are able to convert.  I am writing out images from attachments to a local drive using the BinaryDecoder and AttributeFileWriter. Then specifying them for the word doc using the MSWordStyler --> Image Source = From File. I've tried using a PythonCaller after the the AttributeFileWriter to compress the images (jpeg and png) and resize them before being written to the word doc, but that doesn't seem to help. Any help/ideas would be appreciated.

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.