General

Hi, I have lengths for two different types of cable and i need to see the difference and generate report. Calculating values using excel formula in a column. The formula returns TRUE and FALSE values in CSV output. I want to manipulate more to filter out TRUE and FALSE values and outputted as a separate CSV file. Its seems like difficult to do as my column in FME look like this: I would appreciate any help and suggestion to accomplish this task! Thank you,

I have some texts that I have read from DGN format ,texts are colored.I would like to aggregate the texts and be as one together .i have found that the colors converted to black and white .so my question , how could I aggregate the texts and still has the original color . Thanks in advance FME 2018

FME Desktop Build 22304: The fme workbench has “parsing error”, I couldn’t figure out why the fme workbench has “parsing error”. As I open it, all the transformers are deleted. fortunately, I could restore it from the backup What could be the issue here?   

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 pr

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

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 H

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