General

I am running a workspace with SDE readers and writers. It has designed to run on one market. I need to run the same workspace on other markets with a new database connection and I was wondering if I could set user parameters to input SDE connections and it will change data in feature readers accordingly. I tried to create a user parameter that allows users to create a database connection, but it did not change the connections in Feature Reader. I still see my old connection. 

FME Desktop 2022 Build 22311: The AutoCAD “island detection style” property appears not to be available in FME, I wanted to filter based on “island detection style” type (normal, outer, and ignor) but appears that this property is not available in FME     The dwg file is attached

I have a basic workbench where I have points stored in an ESRI ArcGIS Online Point Feature Layer, and I have an ESRI Enterprise SDE Polygon Feature Class. 99% of my AGOL points fall within a SDE polygon.  I have created a simple workbench with two readers (AGOL and SDE as previously described), as my screenshot shows, the points fall within the polygon areas, but the tool is not returning a single overlap whereby a point sits on a polygon, yet the screenshot clearly shows the point within the polygon. See '_overlaps' column in screenshot are all 0 Is there something basic I am missing? I just want each point to have an attribute outlining the polygon it is within.  

Is there a way to read and write the .ovf file format of orbithttps://kb.orbitgt.com/209/technology/supported_formats/vector/ovfThanks

I am trying to do something that seems completely benign, which is to aggregate CAD file features by their filename. Instead, it gives a generic error after processing the 6 dwgs selected. Please see the attached log file, which was created with debug on. Any ideas? Is this something you should not do in general? Using just a REAL DWG Reader and the Aggregator. Any insight is appreciated.

Hello there we looking to calculate the distance between 2 opposite buildings across a street, if we use a neighborhood finder it will not work Any idea Thanks 

Hi all,Is there any way to extract the area and length attribute from the cad file.I tried AttributeExposer but i couldn't extract area and length..

hello, I am deploying a script which uses InlineQuerier Transformer which executes SQL queries against xlsx files "coming" from another system. Everything works ok when FME Server is installed on Windows env, also works ok in FME Desktop on my Windows laptop, but when I deploy the script (and execute it) on FME Sever (from Linux environment) I receive following errors:   2022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Error preparing database query: near ",": syntax error Unable to execute statement2532022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Database was unable to prepare query 'SELECT2542022-3-30 15:51:09 | *2552022-3-30 15:51:09 | FROM2562022-3-30 15:51:09 | "Failed"2572022-3-30 15:51:09 | WHERE2582022-3-30 15:51:09 | ("CALL__T","ACTION_NO","CREW","EVENT__T") not in (select "CALL__T","ACTION_NO","CREW","EVENT__T" fr

The problem is where the markers are closer than approx 10 m each other. Gocad tells me these are collocated markers. How is it possible to fix? I do not want to discard the bores from the model.

we have run FME server on windows. Here we used an UNC path as the input folder parameter for the workbenches. This allowed us to store the data that we would like to process on a (windows) network share. Another benefit is that we are able to run the workbench in FME Desktop with the same parameters as in FME Server, since we do not rely on the FME_SERVER_* parameters in the workbench. We are now migrating to a FME Linux / Docker installation, and the UNC path solution does not work anymore. We are looking for a way to just change the content of input parameter, and still access the data on the (windows) network share. I can't find the instructions on setting this up. Would we need to mount the windows network share from the linux server?  Additional questions: Just mounting the windows share from the linux host is not sufficient. Is it possible to access this mount on the linux host from within the FME server docker by using bind mounts?

Hello,With an URL, I Can create polygon with a json Extractor and a geometryReplacer but it's impossible to keep the attributes. I can't expose any attributes. I don't know how to do. The Json looks like this  Any idea?Thank you so muche

I have a shapefile that contains about 10'000 points and need to merge some data from a polygon shapefile that describes administrative areas. I need to add the relevant admin area data to each point. Is there a way to do this in FME?

Hello FME'ers,Welcome to What's Up Wednesday The World Tour StartsThe FME World Tour is off to a flying start with a virtual event held by Locus in New Zealand.   Today is the final day and I'm scheduled to appear as part of a round table discussion. Of course, there are many more events to come, with Safe's own "Virtual Brunch and Learn" beginning next Tuesday (5th).  And while Red Geographics don't have the same supercar (is that a 2CV?) they definitely have the colour-coordination done well, just as you'd expect from a team of cartographers.  So visit the full schedule to see what events - both in-person and virtual - you might wish to attend. What's Under the Hood?If you want to see what's under the hood (or bonnet) or FME and take a peek into the engine, then I can recommend an upcoming webinar called, well... Lifting the Hood of the FME Engine. That's myself and my colleague Andrea who are presenting, and we hope to cover in a bit mor

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?