General

The above before the parentheses is the error and following up on the solution, I have a web connection that I'm trying to establish in FME Server. When I go through the steps to authenticate, I get the attached dialog. I do not understand what this is telling me. It says to "Navigate to FME" but this dialog came from FME server (after logging into Google) so why isn't it just using it. I do not understand where to put the authorization code.  I found these instructions that cover "Managing Web Services" but the Web Service already exists and I don't feel comfortable pasting over what is there because I didn't create it (2nd screenshot).https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Web-Connections.htm

GreetsWhen I cut the green polygon according to the red polygon the result should be 3 polygonsMy question is can I add a tolerance to avoid small area and in this case the result will be just two polygon (A and B with small area in C)?

I want to create a workspace that checks input data for various criteria. For example: are there polygons smaller than a certain threshold. Ideally I would like an output in a textfile/PDF, that says "2 features have an area below X". I can calculate the area of the feautres and with a Test_Filter I can redirect the features not passing. What is the FME way to extract the count of those features and write it with a meaningful message to a report?

Goal: I am trying to standardize the raw CSV files. The output file columns should look like below.Date Time Level Temperature ElevationBackground Info: Each file might have multiple tabs. I need to only process the sheets that named as 20* (2011-2012-2019-2020 etc). Sometimes there is header information in A column in some of the sheets. Thus the table header starts at different row number.Issue: I am using FeatureReader to detect the schema dynamically. If the table starts with header information, the transformer reads the data as a new table. Thus it creates new column names which turns into a larger issue.Normally there are over 200 files with multiple tabs but I've prepared a sample data and included my workbench. Looking for help.

When I try to run the AWS DynamoDB reader in FME desktop i Get the error.ERROR |com.amazonaws.SdkClientException: Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target I tried following what this question says:https://community.safe.com/s/question/0D54Q000080hbz0SAA/httpcallser-ca-certificate?t=1647334797980 Connecting to dynamo DB using same credentials using CMD workes fine and uploading Workspace to FME Server also runs fine. Only problem is on local Desktop version 2021.2. I have tried to add the certificate to Windows Certificate Store but no luck. Any ide what might help?

Hello everyone, I'm new to FME and i'm using FME desktop. I would like to know if it is possible run my workbench automatically without clicking the run button in fme?  Thanks in advance.Best regards, Gentjan

I'm working on a script someone else wrote. Is this stored SQL procedure going to be executed for once for each incoming feature, or once on the collection of features?  

Hi, I have a workspace that truncates an SDE geometry table and refills it. The workspace runs daily and sometimes there are no records to write. In that case the writer only has to truncate the table. I don't see an option truncate first or anything like that in a sde writer.How can I truncate a table while the writer is empty?  

FME Desktop 2022 Build 22304: How to get an esri feature class generated in case the number of passed filtered features are zero (no features are filtered)? For example, in the screenshot below, no passed features are filtered as an output for the tester transformer. How to get this result reported in an esri feature class stored in file geodatabase? Currently, no feature class is generated in case no features are filtered    

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 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!