General

I have tried using the unique value transformer but it only accepts a single column. The SQL Executor doesn´t read FDGB. So how could I do an SQL distinct on two columns?

Hi everyone,we have hundreds of excel-files that we would like to read in and format with fme. But the data is scattered over one spreadsheet each. like this:We would now like to sort this data so that it is in order in a row.Is this possible with FME? If so how. Thanks for your help

How to convert esri SLPK file format to PLY file format?

Hi, community! I have not found any solutions to this problem in FME. The problem is to create underground terrain surface for each polygon class (such as clay, sand or gravel in this case <MRR, MRR, KM and MKM).  Polygon classes have different z coordinate (from 1.8 to -8.7) and the colors represent their classes. I want to find a way to merge/dissolve the nearest polygons in the z coordinate (begin from the top) of each class to create terrain surface, see image below.  For example, the gray color (see image below) should find the nearest gray color within a z range of 0.5 m or auto, and the next gray color should find the next closest gray color downwards and so on. If a green color is between two grays, the upper gray will stop merging/dissolving on the lower gray. The same process now begins for the lower gray to search downward for the nearest gray color and so on. Once the different polygon classes have been merged/dissolved, they should not overlay or cross each other.   Ap

Hello FME'ers and welcome to What's Up Wednesday... Safe World Tour NewsLet's start with news about Safe's event on the FME World Tour. We call it a virtual brunch-and-learn, and it takes place on April 5th and 6th.  Day 1 is a set of higher-level talks about the value of FME and how it helps to fuel business decisions. Day 2 is a more technical series of talks with specific demonstrations and examples. Meanwhile, before the event starts, you can also take part in our Data-Driven Photo Contest:  Not only do you get to dress as a racing driver, there are also epic prizes including a pass for the FME User Conference and a PS/5! Partner World Tour NewsObviously, there are many partner events going on too, some in-person and some online, but all with the same racecar theme.  One in-person event is hosted by Norkart, in Oslo on 21st April. An online event coming up even sooner is hosted by Locus (New Zealand/Australia), 29th-31st March. Why have I picked out those two events

Hello sir/ madam, I want to output my result as a HTML format. I want to output my source data (let say I have 3 source data) on new line.Like this: abccdefgh May I ask how to do it?I am not sure why mine is still on the same line. ( i have uploaded my capture screen below). Thank you. Zach 

I am attempting to add a new web connection/web service that I have created from the Esri ArcGIS Online service with my own app ID/secret.  I have tried to upload the web connection both during workspace publication and also through the Manage Services dialog. In both cases, I am getting the following error: Web service upload failed - FME Server encountered an error and reported the following message.929018:FME Error: Unable to create derived service from a non system web service..  Please contact Safe Support for more informationThis is happening both on our on premise FME Server (version 2021.2.3), as well as an FME Cloud instance (2021.2.2). I tested from another computer and was able to successfully upload the connection from Workbench there, running 2021.2.3 on both machines. I have already tried uninstalling FME, deleting the FME folder from my Program Files, restarting, and deleting the registry entries under HKEY_LOCAL_MACHINE\SOFTWARE\Safe Software Inc, and am still running i

Hello, I am looking at trying to build a transversal gain function for numeric rasters. I have several elongated rasters which form corridors. These rasters have a decreasing mean value from one side to the other. Since these rasters have varying orientation it is not simple to establish the row column relationship from side to side.Do anyone have a tip for me how to be able to handle the distance relationship from side to side together with a custom built rasterexpressionevaluator to either scale up or down depending the spatial location in the raster.

Hi,When downloading a geojson file through S3, I get a _content attribute containing my file's content. How can i convert it to geojson and write a geojson file (I do not want to use the S3Connector download to file as it does not let me name the file the way I want).

Hi there, I have merged two tables by using FeatureMerger and kept some attributes by using AttributeKeeper. when I am writing this merged table to Excel by using Writer, I am asked to choose a feature type from two. If I select one, the writes takes all attribute from one type. In that instance, some attributes from the merged table are left out. Can anyone kindly tell me how to overcome this issue? A screenshot is attached here. Thanks in advance.

hellowe migrated to new sql server (names changed from SERVER1 to SERVER2) and now jobs is failing.i open failing fmw file in FMW Workbench, changed sql server names in parameters (where found), saved file, but jobs keep failing.any suggestions?thanks.

I have an incoming string attribute e.g. 20220322100000 which I need to convert to milliseconds after epoch for writing to an ESRI Portal Feature Service. I can't seem to work around this output format error below in Desktop 2021.2?`Failed to evaluate expression '@DateTimeFormat(20220322100000,%s)'. Result is set to null'

Hi, I have the StatisticsCalculator that mysteriously looses one feature:I would expect both input and output feature count would be the same. The StatisticsCalculator doesn't do any group by: What am I not understanding?Thanks in advance!

Apologies if this is a dumb question! What I'm trying to do is build a dataset extraction tool for a third party in the organisation, but need to keep any login credentials secure.

FME Desktop 2022 Build 22304: The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available, The “harmonize ad filter by fme_type” option in the “geometryfilter” appears not to be available in the Build 22304 that’s used to be in the Build 22257         Is this by design?

i would like to know : Does the data transmitted in encrypted form? https/TLSor which encryption form is using in FME Desktop ?please ,refer me to the documentation regarding to encryption form ,if available .Thanks in advance FME 2020.2

Can GIS layers be setup via a relate in a workbench similar to how it is done in ArcMap

I'm not sure what is happening, but when I inspect a CSV the values in the CSV are not equal to the values read in by the CSV reader in FME Desktop 2021.1.0.0 Win64. Actual CSV ValuesFME Inspector As you can see it is not reading the first few digits of the easting values. Any ideas as to what might be the issue? My first thought was some sort of encoding problem, but wasn't sure. I've attached the CSV file in question.  

Hello there how could we move the blue line in order to make it parallel to the read one?

I'm restoring some data from/to a MS/SQL database, which has been stored in a PostGIS database.PostGIS lowercases all attributes, and I'm getting errors in FME when writing them to the original database, where attribute names are mixed case. The database itself uses collation Danish_Norwegian_CI_AI, i.e. Case Insensitive.FME is case sensitive, and I presume that's why it throws this kind of error:Existing table for feature type `PARKER.d_basis_attribs_kontrolflader_traer' does not have attribute with name `tr_bemaerk'. Cannot continueThe database table has an attribute TR_BEMAERK, i.e. as uppercased.How come FME doesn't respect the case INsensitivity of the target database ?It feels kinda stupid to have to rename all attributes needlessly, and no, they're all very mixed case, not all uppercase.(still) using 2020.2

Hi Please am looking for your INPUTS on different idea what kind of services we could develop. What are mote transformer for this industry . Data is mostly from indoor Surveying Data ( point cloud)  OPEN to any suggestion, ideas or help . Highly obliged with your response. thank you

Hi all, I am trying to find an FME solution to an optimisation problem. I have ‘x’ polygons of varying sizes, the combined area of these polygons adds up to ‘y’. I need to allocate these polygons across ‘z’ number of groups, each of which require a different proportion of ‘y’. For example:·        10 polygons (x) of varying sizes with a combined total area of 62ha (y) that need to be proportionally allocated across three groups (z) ·        Group 1 – needs 60% of y (37.2 ha)·        Group 2 – needs 30% of y (18.6 ha)·        Group 3 – needs 10% of y (6.2 ha) Possible solutions: I am after an optimised solution for the groupings of these polygons (in the above example, the first solution would be considered the closest to the allocation requirement). Please note, I do not need to worry about the spatial position of these polygons, I just need to determine the best group allocation of each polygon so that I end up with the closest possible required outcome for each group. Thanks! 

Select RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CD, MAX (YR_TXT) as LAST_YR_DVLfrom IMAGE_CTLGGroup By RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CDOrder By RD_ID, RDWY_ID,MAX (YR_TXT)

Hello FME'ers,Here is your weekly update on all the news related to FME. New 2021 (2021.2.4)Of course, we're all looking forward to the release of FME 2022, but fixes are still made to 2021. In fact, a new version of FME 2021 was released last week, 2021.2.4. As usual, there are few highlights (because it's not meant to be a spectacular release) but you should consider looking into this if you have experienced problems with either the ArcGIS Portal Reader or Excel writer. The changelog file has more information. Dmitri and Lena's AR SpectacularOtherwise known as the Exploring Outdoor Infrastructure with AR webinar! This took place yesterday and was very successful. Congratulations to them both for pulling off some great live demos. If you missed the webinar, you can find the recording on our website, or on YouTube.  FME's Favourite TransformerThe Favourite FME Transformer contest is now into its second round of voting, and there are some close matchups. For example,

Hello there we have a set of points getting to the line builder, not in sequence how we could organize them to build them straight line we are getting this from the line builderI think the line builder is connecting the point in the order they enter the linebuilder Any ideathanks