General

Our Tenable Security Scanner keeps complaining about the Tomcat version inside FME Server. We're ready to upgrade to 2021.2.5.0 but we want to know if it will solve the TC version issues.  

I would like to build a server app that will use specific folder locations as dynamic choice values. I have the basic values set up as user parameters.the user selects a project name (unc folder location). Then the user selects 1 or more files in a subfolder of the selected project.I used the import button on the choice value/description. the problem is these are not dynamic. The project folder would only show folders that are already created. and the file chooser would only show the one folder used to import the values. there seems to be no good way to accomplish this. After speaking with support it seems maybe python is the only way i am going to accomplish this. However i am at a loss as to how to get started.

Welcome to the roundup of FME news for this (and last) week... FME Conference and World TourPreparation for the FME user conference in August is proceeding well.   The presentation lineup is now decided, with folks like Frederic (Using FME to Study/Preserve Marine Mammals) and myself (Raster Algebra and FME) being informed of our acceptance. The training lineup will be published soon, though I can reveal that I'm working on a course on Dynamic Workspaces, including use of the SchemaScanner.  And one other thing I'm working on is an evening Hackathon event. In short, the whole conference is going to be great and there is still Early Bird pricing for a few weeks. As Frederic says, "I'm looking forward to seeing so many of my highly-missed fme-addict friends there." The Safe Software part of the FME World Tour (the Brunch and Learn) is now complete, but registrations are still open! Why? So that you can access all of the talks and presentations from the event.   Othe

how can import ADE in a CityGML LOD3 model

I'm running a workbench which contains several SQLExecutors that queries an Azure SQL database. When running the workbench we get an alert from Microsoft Defender for Cloud saying that "An application generated a faulty SQL statement on database XXX. This may indicate that the application is vulnerable to SQL injection". When looking into the case, I can see that the query raising this warning is from FME:  SELECT * INTO #fme_tempAdoDataTypeTable_spatialReader FROM ( select CustomerID, Name, PostAddress_Address1 from Customer where UPPER([Name]) = 'Hans Hansen' and UPPER(PostAddress_Address1) = 'Gates' vei 69' ) AS customQuery WHERE 1=0 Does anyone now why this warning occurs? Is it normal that FME triggers these?

Hello, I am trying to create a report using the HTMLReportGenerator, for this case I want to show some maps according to an attribute they have, so I use the Group Processing option in the transformer by that specific attribute, but the output is just one map and a bunch of errors in the console. They say that "Map container is already initialized." or if I change all the global variables (var) that the report creates for scoped variables (let) the error says "Identifier 'map' has already been declared". Any ideas on how I can use this transformer for plotting multiple maps on a single page? Thanks.

I have to read several shapefiles that are in a second level zipped file. As an example:C:\\compressed1.zip \\compressed2.zip\\ layer.shp I get to reach the first level but when I try to reach the second level, FME gives me failures.Any idea? Thank you very much

I am trying to write from Excel to Azure. The writer table has no primary key as it is just a staging table and doesn't need one. FME will not allow me to write to it unless I set a primary key. Azure lets me write to the table within the server so it seems like it is only FME requiring a primary key. How do I get FME to write to a writer with no primary key? This is the error message (I am not creating a new table):Microsoft SQL Server Non-Spatial Writer: Failed to create Azure table 'dbo.test_survey' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column And these are the settings

Hey There,I hope another set of eyes on this might help. I am having trouble with Python scripts and the Python Caller. I generate the error 000816, which I have tracked down to a possible conflict between 32 and 64 bit versions of Python conflicting with ESRI geoprocessing tools. I have attached a screen cap of the log. I have highlighted where I think FME is using 64 bit but I have set the Preferred Interpreter to the 32 bit in the Tools. Any thoughts? Many thanks and all the best!c.

Hello Experts,I have a file in which I have 2 columns id and distance. The distance corresponds to the ids. The issue is that some ids are duplicates and the distance is different. I want to identify the ID which has closet distance associated. See the image attached. Any help would be appreciated.

I tried to use WorkspaceRunner to perform a batch processing, but I didn't get the result I wanted.For example, I run 4 fme.exe at the same time in child workbrench and set the output result to same location. No matter the output location is Esri Geodatabase with 4 different names or with 1 same name, sometimes one or more fme.exe fail to write the correct result, some features will be missing.But when I set 4 different Esri Geodatabases as output locations, I can get the correct result. And this happens only when I use File Geodb Open API Writer, File Geodb didn't work either.I'am thinking maybe FME can't write to the same GDB at same time? Is there any solution to situation? Otherwise I have to do an additional Fanout processing.Thank you.

Trying this workspace, I get an error saying 'owner' feature type does not exist. The FeatureWriter output format is SpatiaLite and a template.sqlite database is used. For both feature types "Use existing" table handling is selected. Parcel geometry type is wkb_polygon and owner is wkb_none. The 'owner' table exists in the template. Could it be a FeatureWriter error managing SpatiaLite?  

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.