General

HeyI have a question that I am awkward with not much time.I have entities after an aggregator, I need to pull out the entity with the maximum Z point.For example here in the screenshot: Between rows 1 and 2, which is the same manholenum, I need to pull out row 2, because it is higher.And so on, between rows 3 and 4, you need to pull out the 4.There is no legality, because the manhole will be different later, or as in line 10, there will be only one.Would appreciate help!Thanks!

I have found several articles on creating and writing a Relationship Feature Class with FME, but I am struggling to read one from ArcSDE. I know about un-ticking the "Ignore Relationships" box in the Reader, and I can read the 3 components - the layer/attribute table, the "_ATTACH" table and the "_ATTACHREL" Relationship Class. But how do I put them together? Once I've done that, is it easy to export the data and the attachments as well?

I am trying to validate fields in several feature classes in an enterprise geodatabase against domains that are applied to the fields. I have two database views which contain information about the domains on the database. V_DOMAIN_CODED_VALUES is a database view which contains the domain name, the code and the description.V_DOMAINS_ON_FIELDS is a database view which contains the feature class name, the field which has a domain and the domain name. My FME workspace reads all of the above views, merges them together by domain using a FeatureMerger. I am able to concatenate values to produce a giant where_clause which I can pass into another FeatureReader to identify any records which contain s

Hi,I'm having some problems finding the right transformer to do the following operation.I have some points and i need to select only a part of them. I crated a line between two of them (red line) and now i need to find a way to select only the points close to that line.I tried NeighborFinder but couldnt make it work.Any input on how to do that easy operation?Thank you very much, Davide

Hey,I have two shapefiles - one is a line shapefile with power lines (blue in Screenshot) and one is a point shapefile with power poles (red in Screenshot). I want to reduce the power poles by only symbolizing the power poles, where the power line changes the direction by more than 2 degree. In other words: I only want to symbolize the power poles, where the power lines change the direction by more than 2 degree. Can you help me how I can achieve this and with which transformers?  Would be great if somebody knows how to achieve this! :)Cheers!

I'ts pretty clear on how to edit, remove and add attribute columns to a file. But what transformer do I use if I want to edit rows within the attribute field and then write the file?  I want to edit the row where it says "<missing>".

Hello everyone,It’s my first time on the forum, my excuses if im not following the requiered procedures. So to the explanation and question :I know that the readers for Shapefile and DBF interprets « null » numbers as 0, so i’ve writen a script using python3.8 that uses an external library to change number types to strings.It works very well on the FME Desktop 2018.0 instance but when i try to upload it to the FME Server ( resources/engine/plugins/python/) wich is on a Linux ( Ubuntu 20) and using the docker images provided by Safe i have the following error when i launch a job that uses a pythoncaller that uses the « dbf » library :-         Python Exception <ImportError>: dynamic module does not define module export function (PyInit_dbf)After some research the cause it’s that the engine doesnt find the directory where the module is installed. Any ideas ? Tips ? Thank you.

Hey, this is my first time I´m asking something because I always found solutions throughout the FME-Community. This time I couldn´t find a post, where somebody had the same problem as I have right now. I have a shapefile including points with names. These names are just written in small caps. For example I have one point named "vierge du ballon" and I want to rename it to "Vierge du Ballon". Is this possible? I have 211 points where I need to change specific parts of the name (see the screenshot below!). I know there is a StringCaseChanger, but this one only changes Fullt Title Case... Just for understanding, there are some more examples (see screen):1) I have "vierge d'alsace" and want to change it to "Vierge d'Alsace2) I have "tombe de l'ermite" and want to change it to "Tombe de L'ermite" Would be so great if some

Hi,I have a CSV file which i would like to convert to Shape file so that it can be mapped. Within the data there are Easting and Northing fields with coordinates and can convert successfully but there are some records that have no coordinates.The records with no coordinates do have zipcodes/postcodes however and I hope to match to their centroid as I have the postcode data with centroids to hand.I figure I need to somehow identify the Easting and Northing fields that contain no values then match them using the Postcode in a stand alone table that has the centroid coordinates then join all the data back up again to generate a single shape file.Not used FME very much at all and rather confused as to which Transformers etc. required. Thanks in advance.

We are upgrading to FME 2020 from v2015 in a new server. We are using a temporary hostname and IP on our new server and as soon as FME Server, FME Desktop and the floating licence server are installed and everything works as it should, we will stop the old server machine and change the IP and hostname on the new server to the old ones.  My concern is how this will affect licensing for both FME Server and Desktop.As far as I know licenses are tied to hostname so I guess we cannot request licenses until we have changed the hostname. Am I right?

I have Lat\\Longs for points in WGS84, is there a transformer\\method I can use that will determine which projection each point will fall in, or better yet, find the projection and give me X,Y coordinates from that projection?

Welcome to What’s Up Wednesday, your weekly dose of FME news. FME 2021.1 BetaThe upcoming release of FME 2021.1 is fast approaching. If you are interested in giving FME 2021.1 a spin before the release, download the beta. Be sure to let us know if you find any issues!  BlogThree new posts on the blog this week!The Ultimate Guide to APIs: Nathan walks us through what an API is, why they are so popular, how to perform a cloud migration with an API and how you can use APIs in FME. 

Anyone know the best dataset/portal for the US territories (American Samoa, Puerto Rico, Guam, Northern Mariana Islands, and virgin islands)?....Trying to find an arcgis rest server that would provide possible parcel/address data. Is this information out

Is Snakegrid Projector FME hub transformer works on FME Server ? Becasue Snakegrid Projector lic is tied up FME registration key. We have to use this snakegrid projector on FME Server . Please help us on how to configure snakegrid lic on fme server ?

We're about to update FME-Desktop and FME-Server to 2021. Is 2021.1 soon to be released? If so, we would skip the update to 2021.0. Thanks, Vera

Converting a KML file to a LYR file seems like such a simple task, and can be done in ArcGIS Pro, but why can I not find a KML reader in FME 2021?

Hi, We have moved to using a floating licence manager, which I have successfully configured against FME desktop. However the software is showing that it still has a fixed node licence attached to it as well. Is their a way to cleanly remove this without having to uninstall the software ?

I have two different linear writers, I need to find all intersection between these two writer. But when I intersection with FME, it’s put many points where it has any intersection.  So, I use a line combiner or a aggregator, but I have the same problem.  Result :Yellow = Intersection (point)Red = road 1 (linear)black = road 2 (linear)

Hi, I've been struggling for hours to try and create a simple flow that would extract the coordinates / project them to another coordinate system, and report it into a CSV file. I've tried many different ways, but I'm not getting any data into excel or CSV. 

I have a set of csvs where the X,Y fields are named differently in each file, but always in the pattern {prefix}LocationX, {prefix}LocationY. The prefix is unrelated to the filename or any other easy way to predict. In order to process all the files through the same workflow, I would like to copy the attributes to _x and _y so the rest of the transformers can reference those attributes irrespective of the original names. Is there a simple way to do so without dropping into python?

I have some aggregate geometry in Multicurve form. Is there a way to filter out features where it looks like a donut from ones where the geometries are separate? Please see attached screenshots of both types.  The goal is to extract donut holes (after converting to area) and making them a separate attribute in the same feature. The problem is that converting to areas deaggregates the non-donut geometry. These need to be kept intact and treated separately.  Thanks,@larue​   

I am working on FME script which generated two output one is 1-1 where building outline are link to one parcel ( even if it related to multiple parcels) and another output is 1-M where building outline are link to many parcel which are relate to. Below are data inspector output of two custom transformer. which I need to joined as final output and exported to CSV. FeatureMerge i tried not giving right output. Output1 :  Output 2 :   Expected Output after joined :   FeatureMerger output :

Geometry replacer is not working for me. Both features contain FME Binary geometry. I have tried renaming the attribute, cloning, etc. How does this work? Thanks,@larue

I have a data set with numbers in x y z sequence separated by "," representing 3D geometry polygons and points. It was originally WKT and had been formatted to work with Dynamo (Revit).  Here is a sample of a point:841.99951171875 678.6250000000001 -132 Here is a sample of a polygon:409.000000000001 473.499999999999 372,409.000000000001 797 372,487 797 372,487 871 372,1275 871 372,1275 476.286679607417 372,1275 461.500000000111 372,409.000000000001 461.5 372,409.000000000001 473.499999999999 372 My hunch is to chop everything up into x y z attributes and then reconstitute into points/polygons. Using two AttributeSplitters, I can create a list, but then, how do you assign these numbers to x y z in sequence? It is so close to WKT, maybe there is an easier way? Thanks,@larue​   

Greetings,Is writer to PostgreSQL inherited table is supported by FME desktop. It's not working and return error.Regards,Maha