FME Form

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

Dear Community, I want to read few CCTV inspection reports for pipe inspection which contains details about City, asset number, Inspection info from CCTV report, pipe information from CCTV inspection, defect information etc. in different line. I want to read this pdf in FME and convert those details in the table format. May I have a detail tutorial to understand ...how we can do this process in FME? 

I'm parameterizing the first portion of a dataset path name inside a feature writer dataset parameter to allow easier transition from our development environment to production. I've created the following published parameter.The published parameter's Configuration parameter is set to display name = 'dev', value = ""//myhost.org/Scheduled on FME Server/DEV/dev_start_stop_report_data/"" When the dataset parameter in the feature writer transformer is set as shown below, the writer is unable to find the directory. The error below is returned$(report_data_path)sa_output\start_stop_report.xlsxERROR |Excel Writer: Failed to save changes to the spreadsheet '""\myhost.org\Scheduled on FME\Server\dev_start_stop_report_data\""sa_output\start_stop_report_.xlsx'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'No such file or directory.'There may be a better way to go about it, but I'm attempting to use a str

fme_dataset and fme_basename attributes are there when read normally, but not when read with a FeatureReader.

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?

FME Desktop 2022 Build 22311: The “issue locations” generated from the “geometry validator” fails to be written in an esri feature class, As per the screenshot, the “issue locations” generated from the “geometry validator” fails to be written in an esri feature class What could be the issue here? The data is attached      

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

I'm trying to read raster data from postGIS using the 'PostGIS Raster' FeatureReader and keep getting an error about band metadata. However, I can load in the same raster data OK via a select statement in a SQLExecutor transformer. The rasters in question only have one band, but I don't imagine that should be an issue.  As the data returned via the SQLExecutor look fine, I'm assuming that there is nothing wrong with the data in postGIS, but the error is making me question that... The error I'm getting is;2022-03-30 15:46:00|  0.2| 0.0|ERROR |Error executing SQL command  ('SELECT ST_BandMetaData("rast",1), to_char(ST_BandNoDataValue("rast",1),'9.9999999999999999EEEE') FROM "schema"."table" WHERE "pk_index" = '1'') :'ERROR: table-function protocol for value-per-call mode was not followed CONTEXT: SQL function "st_bandmetadata" statement 1' Any thoughts or help much appreci

Hello, I would like to ask about converting a vegetation model from .skp to Citygml, but in the end it cannot be displayed in layers like buildings, do I need to set an extended ADE, I tried to select the feature type output of buildings such as wall surface, but Can not output successfully. What I want to ask is how to output a CITYGML vegetation model that can be displayed in layers

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

So I have a quick question about Sharepoint Online web connections in FME. A while back, I successfully set up a Sharepoint Online web connection in Desktop (2020.2) and published to FME Server (2020.2). https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection At the time, I must've followed the steps on this page or another similar how-to. Either way, it worked in Desktop and has been running on a daily/interval schedule in Server. I should also mention I'm using a service account for this, which has the proper SP privileges and is what my FME Server runs as. Now, I find that every time, I want to do some type of adhoc job or query in Desktop, the same connection I set up back then no longer works, and I have to set up a brandnew one. At the same time, the original web connection that was uploaded to Server during publishing continues to work just fine. Is there something specific to Sharepoint authentication or token expiration that I am not aware of tha

I have a polygon and I want to know the angle α  , β  , γ of each line.With the PointPropertyExtractor I get the Eula Angle if I set it beforehand with the PointPropertySetter and then rotate the object.Is there a possibility to find the angular inclination of the line to α , β , γ differently? PolylineAnalyzer, HorizontalAngle and TopologyBuilder have not helped me so far.   

We recently moved some processes from Esri tools into FME. One of these has a slope calculation component. We expected to see minor differences between Esri/FME but instead we are seeing differences of up to 15 degrees difference.Further investigation showed that by default, Esri uses a planar based algorithm. FME (and QGIS) only use a geodesic based algorithm. Esri does also have the option of using geodesic. The original Esri process was using the default planar algorithm. When these are compared to the geodesic outputs (FME, Esri and QGIS) considerable differences are apparent. Comparing the three different geodesic outputs shows that the results are (almost) the same – as expected.This difference has considerable ramifications for the application using these slope values. Looking at Esri documentation, it does state the geodesic is ‘more accurate’, but this doesn’t explain the 15 degree differences we’re seeing.We have raised this question with Esri, but are wondering if anyone her

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?

Dear community, I am fully out of ideas - we cannot successfully establish a sharepoint connection in order to make the List Reader work. I guess we tried everything and we followed the instruction here and the video here to the detail. The only thing that is really working - and that requires a super user with all possible admin rights - is the first option to replace the [TENANT] in the web service definition:The multitenant app our admins created for me comes along with all the rights as per tutorial - but no matter if I try the multitenant or the singletenant way of connecting, I always get this prompt which is basically telling that admin approval is necessary in order to access the resources of my organization:When we magically made it happen that the url got successfully tested (by simplifying the request URL) I am ending up with something like this when adding the SP List reader:Our local support at axmann.at cannot assist as well since this lies somewhere in the domain of admi

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.

I'd like to combine headers from 2 lines in Excel to form 1 attribute name.Should result in feature with attributes ID, AAA_XXX and BBB_YYYI've looked at debbiatsafe solution at Bulk Rename Attributes with Original Name plus the First Row (safe.com) but that doesn't do it all the way.Need to have the features with the attribute names to continue working with in the workspace.Any hints on how to proceed? 

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 have the same issue identified within this question but whilst using the PostGIS Raster transformer (https://community.safe.com/s/question/0D54Q00008p86kRSAQ/postgis-loading-default-values-being-overwritten-by-nulls-in-feature-writer) As suggested in the answer I downloaded the most recent Beta (FME(R) 2022.0.0.0 (20220323 - Build 22311 - WIN64) ) and gave it another try. Unfortunatley I still get an error when trying to write to my PostGIS raster table. The issue seems to be related to the columns with default values I am not trying to write to. FME seems to be attempting to write nulls to these columns.  Is the Advanced > Missing Attribute Behaviour functionality also going to be included within the raster writer or another way around this? Error message from log:  2022-03-29 09:36:45| 1.6| 0.0|ERROR |Bulk copy failed on table 'prime_data.paleodem' using delimiter ':'. Error was 'ERROR: null value in column "changedetect_date" of relation "pale