General

Hi, Running a script to truncate an existing feature class in a sde that has attribute rules attached thru ArcPro. The warnings state the below items - table must exist - it is there, can see it via Catalog and SSMS. User has DBO. Running 2021.x FME, 2.9.2 ArcPro. Any ideas as to what I may be missing? Did set the compatibility to ArcPro, used sde connection created by ArcPro.Thanks,Lorinda2022-04-06 12:41:23|  1.2| 0.0|INFORM|Transactions are being used by the Esri Geodatabase Writer2022-04-06 12:41:25|  2.9| 1.7|ERROR |Esri Geodatabase Writer: Feature Class or Table 'IDF_Stormwater' must exist when Table Handling is set to 'Truncate Existing'2022-04-06 12:41:25|  2.9| 0.0|ERROR |GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details2022-04-06 12:41:25|  2.9| 0.0|STATS |GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total of 0 features.2022-04-06 12:41:25|  2.9| 0.0|INFORM

 In my workbench I have a WKT that I send (using HTTPCaller POST) to an API. The API then runs a background model and I need to use a HTTPCaller GET to retrieve the json results via the same API. The model can take anywhere from 5 seconds to 3 minutes to run. When the model is still processing it returns a '202' status code and when it completes successfully with a '200' code. Right now, I have various decelerators, however, this slows down the entire workspace, I would like have the HTTPCaller wait or check for a 200 response and continue the rest of the workbench immediately.

I would like some advice on setting up a workbench that could retrieve the number of interior angles in a polygon that are classed as concave (i.e. >180 degrees). So far I have the following:run my polygon featureclass through the 'convexity filter' to obtain only concave polygons. I then use the 'Orientor' to assign the right hand rule before passing it through the 'VertexAngleCalculator'. I then use a tester to filter those angle that are negative (i.e. concave).Use 'statistics calculator grouped by original polygon UID to get the total count of features.merge these attributes with the original feature class. This works fine as long as the first/last vertex in the polygon is not a concave angle. This is because the 'VertexAngleCalculator' returns a value of '0' for the start/end vertex - and therefore cannot be classified.  Unless there is a simpler way to obtain all interior angles for each polygon, my thoughts would be to re-run the pr

Hi all,I have three layers district, plans and plots.When I cut the yellow polygon (plans) based on the red one (district) the plan will be 4 parts.My question is how can I make the cutting conditional if there is a plots cut the plan based on district (the right corner in the image bellow), otherwise don’t cut and according to this condition the plan will be just 2 parts.

I have a scenario where I have a HTML report generator, it saved the report on a local disk. Once this HTML report is saved I then wish to send an email with the HTML report as an attachment, but as the Writer doesn't have an output port, I cannot trigger the emailer this way. How do I tell the emailer to run once the Writer has finished? 

Is it possible to color code coordinates based on range values ie. 4 colour coded levels low 0-500, Medium 501-1000, High 1001-1500 Very High 1500+. I am trying to color code rainfall data against above. I have attached a sample

Hello,We have been using FME Desktop for a number of years and have just recently started wit FME Server and I am not sure I fully understand how all of the pieces go together. I was working my way through the Invasive Species tutorial and got to where you pass the 'webhook.feature' from FME Server to an FME Workspace to complete the workflow. My issue is we are using FME Desktop 2021 and with the new User Parameters I cannot create a User Parameter with a '.' in it. As far as I understand the 'webhook.feature' is what I am trying to pass into the workflow but FME Server automatically created the 'webhook.' syntax while FME Desktop no longer allows for the '.' Please excuse my very basic question about user parameters but am I not trying to create a user parameter called 'webhook.feature' to grab what's coming in from FME Server or am I totally out to lunch as to how things are passed back and forth with FME Server and Desktop? Any

Hi, I have 3 polygons. (Print screen; purple) Project A, Project B and Project C. The polygons overlap. In addition, I have another layer consisting of polygons. These are roads. (Print screen, gray). Now I want to assign the project name to each road object. So if a road belongs to 3 projects I want to get 3 road objects, each with a different project name. How do I do that?With a spatial relator, the road section that falls within 3 objects gets the same project name 3 times instead of 3 different project names. Clipper does not clip on al the 3 object bounderies.    

I have a file like the example in my hand. There are photo midpoints in the file. I make useful models for stereo drawing by using them. How can I create these areas automatically?Attached is a sample file and picture.model-1 and model-2 created by manuel for example.

I have three polygon shapefiles, they all contain a column called GUID, this column is unique, the shapefiles often overlap.  I also have a point shapefile, these points will generally fall within 1 or Many polygons.  I am trying to end up with a table similar to the one shown in my sketch. Each point feature should have one or more GUID in it... I am sure there is a simple process to do this in FME, currently I have an overly complex looking scenario that isn't working, I am really over thinking this one.  

The FME is upgraded to Build 22311: How to align points converted from texts  as per their (texts) alignment in AutoCAD table? In the screenshot below, texts contained in an AutoCAD table are “middle right” aligned. How to keep this alignment as they are converted to points so that they are kept vertically aligned? The dwg file is attached           

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