General

Hello! Thanks for joining us for another edition of What’s Up Wednesday.  OGC and FME 2021FME 2021 is now certified as OGC compliant for 4 key standards: GML, KML, Geopackage, and GeoTIFF! We are also registered for having support for over a dozen more formats. If you are interested in the full list, see the OGC website.  FME TrainingIf you’re looking for something to do in your free time this summer, check out a free live online FME course! If you’d like to learn something on your own time check out a recorded course or the new FME Academy! Integrate Data with the FME Platform - June 22nd - 23rd, 2021, 9:00am- 1:00pm PDTIntegrate Data with the FME Platform - July 21st - 22nd, 2021, 9:00am - 1:00pm PDTPublish Workflows to the Web - July 28th, 2021, 8:00am - 12:00pm PDTGetting Started with the FME Platform - August 12th, 2021, 8:00am - 12:00pm PDTCreate Data Integration Apps - September 1st - 2nd, 2021, 8:00am - 12:00pm PDTAutomate Your Workflows - September 21st, 2021, 8:00am - 12:00pm

Hi. I have two directory with lots of PDF. I want to merge the PDF with the same name of each folder. Also the name is little bit different between the folder:Ex: folder a: Carte_PZ1_juin2020Folder 2: Log_sondage_PZ1_mai2021 Can you help me.Thank you :) 

The upgrade to FME Desktop 2021.0.3 Build 21326 was carried out yesterday morning (Desktop / Server)Issue 1 I have a workspace which used to work until the upgrade.Simply put, a downloaded CSV file is read then written into a truncated Postgis table.This table is responsible for the functioning of this site including its contents as FME generated. (https://molevalley.cloudmappin.com/mmv/) The scheduled workflow reported that it was successful through an e-mail notification. However when I checked the site this morning, the address lookup failed to work therefore no one could use the site. During investigation I realised that the table was empty. (Truncated but no data)  Took a closer look and saw the following: Features were read as line geom whereby the original CSV is read as point data. PS: The reason why the Vertex transformer is used is to ensure the correct X/Y (Easting/Northing) fields are used Data detected as point geom when bypassing the Vertex transformer The "fix"

We want to use Snakegrid projector transformer in FME Server, How we can use it. Snakegrid is coming with its licences , and its working at FME desktop application. But we have workbench which is having Snakegrid projector ,we want to publish this wokrbench on FMe Server.

I have a network of lines. I would like to check if there are overlapping lines or portions of line in said network. Which transformer should I use?

Hi list.In the curiosity department, I have a workspace, that seems to finish , but misses some data, adding a small FATAL error message "Expression: false": What triggers this ???

I have a list of permits joined to address points. About 100k points after that join. I want to join those 100k to the parcels which have about 40k so there would be some parcels that are 'stacked' and have 5 rows. I'm trying SpatialFilter, SpatialRelator and PointOnAreaOverlayer and not having any luck. I'm using 2021.0 desktop.

Hi all, I have a data set with a start_date column and an end_date column. What I need to do is determine which date ranges overlap, similar to this: https://www.get-digital-help.com/find-overlapping-date-ranges-in-excel/" alt="http://https://www.get-digital-help.com/find-overlapping-date-ranges-in-excel/ I am fairly new to FME so I apologise in advance!

i could read all atributes and create a table from a geometry instance. i know yath i could use "geometrytraitextractor" but i put each name to expose each one.but i need expose all, and i dont know how do that

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 some value which is not in the domains.  This is fine, however, I would like to identify the actual value in a particular field in a particular feature class which doesn't match the domain assigned to it. Is there some tool that is out of the box which I can validate records against domains as I

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 somebody know how to change it! :)

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. Using Azure Services for Messaging Protocols: Ryan highlights the different brokers and protocols that can be used with Azure, as well as which Azure service is right for your project. Linear Referencing 101: Managing Infrastructure Data: Another entry in our GIS 101 series, Tiana explains what linear referencing is, and provides real-world examples of how it is used in workflows.  Knowledge BaseA quiet week in the Knowledge Base as we prepare our content for the 2021.1 release, so stay tuned for new articles! K

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?