FME Form

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

Hello all, Please I am seeking help / support to extract ANGLE & LONGEST direction of the geometrical object in below format for each object. L is the longest direction of object (In the direction of the longest dimension on the element )  F is the object facing direction to (In the direction of the normal vector from the centre point) I could obtain the longest /shortest / angel direction from Bounding Box / Length Calculator but not sure to relate it in which direction ?    In this case its 3d objects fitted in a room. Square 3D ObjectsRectangular 3D ObjectsCircular 3D Objects

Hi, I'm using FME workbench 2022.2, Build 22789 - WIN64. I'm trying to process several thousand JP2 files.I'm finding that trying to open just one JP2 file (~1.5GB) in the inspector doesn't seem to work ... by that I mean I stop the process after waiting about 30 minutes.  Thanks in advance for help!

HI I use the Arcgis data Interoperabilty for the exercise present on the FME academy but I received an error related to the reprojection so I suspect that the Arcgis data interoperability reprojection is a little bit different than FME can you support please ?thx Francesco 

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

i want to add volume of each building part of my CityGML file in its attribute .And than export it in the CityGML format it self,but i dont want any kind of data loss in quality wise .  Can you guys please help me on this ?  Thanks Srikant

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 :)

Hello So i have been successful with all other features, but this one seems to me more challenging. The point of interests is 1 and 8 the same on other side of the RAIL . Highly obliged with LOGIC / FLOW

I have a spatial data set that contains line data that I need to write to a MSSQL table. Unfortunately at the moment the table is being created but no data is being written to it despite FME saying it is successful. I have my writer set up and it can be seen in the attached screenshot. I'm wondering how I can force the data into the table?

I can set an index on an integer or even a unique index, but there is no type for a primary key or autoincrement. How can I specify this? I could do this with an SQL Create expression. Can I use SQL to create a schema?I am adding a changeset with new records using insert but I need an OID column for ArcGIS to be able to use the table/featureclass separate from the real ID.

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?

GML reader can't read the attached gml and xsd file.GML can read the dataset only if select ignore schema 

Hello,I've just installed FME on several workstations successfully, however, on one machine, I am unable to run FME from the command line. It just says FME is not recognized and an internal or external command... It seems part of the installation maybe did not complete correctly. How can I get windows to recognize FME as a program from the command line? Thanks!

I have CSV file in the character format with a value as shown here. I would like to change it into Date format so I will be able to date calculation later. I tried to use Dateformater. it did not work. is there any other transformer that I can leverage to accomplish this?

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 

Hi all.I'm just being told, that we're importing 3D data (points, lines, polygons) with "missing" Z coordinates = 0.I need to delete each and every one of these values, or exchange them with the value -99.Is there a transformer that can do that easily ?I would rather not have to to explode all geometries to points, repair the Z, and reassemble all geometries.Any ideas ?Cheers

I was just wondering if anyone has done sunlight / shading analysis in FME? In Rhino 3d + Grasshopper, Ladybug and Honeybee are plugins that can do this. Below a few images. I know that one can do some interesting stuff with the surface footprint replacer, and change the angles, and thereby create shadows. But thought I would ask before diving deeper. Maybe another option would be to go the ESRI route.  Ladybug:Ladybug Tools | Food4Rhino  CheersFred

I have WGS84 WKT formatted geometries and have to convert them into LRMS geometry. Can anyone help what would be the best way to do it. I believe I have to first convert WKT to point location then I would be able to do conversion, but still how can I add manually built transformer into FME. Any idea can be helpful 😉

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