General

I have a FME worbench that is reading an excel file and merging it with data in a SDE geodatabase. For each record in the table I need to create an ID field that consists of a consistent initial 3 letters depending on the company, then a 2 digit year, and then 4 digits. It would need to be unique as well. I would need to find the last 4 digit number used by the company and add one to it.I would then need to put this all together into one ID field attribute. Any ideas of how to do this would be appreciated!

hello,   I have a workspace with 2 tables. these tables are automatically populated. in the translation is a FeatureJoiner (left join) which joins the data from these 2 tables and "moves" it further.. Is it any possibility to stop the translation after running it if one of the input tables is empty(no records)?   Thank you Nicu 

Where can I find FME 2021.x Technical Specifications?

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

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

 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

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 De

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.