Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
mark2atsafe
Safer
mark2atsafeSafer
asked in General
What's Up Wednesday (13-Apr-2022): FME User Conference and World Tour News, Hub Updates, an Historic Resources Project, and Lots of Partner News.

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

130
mark2atsafe
Safer
E
estudy000
asked in General
how can import ADE in a CityGML LOD3 model

how can import ADE in a CityGML LOD3 model

260
keziaatsafe
Safer
torbjornd
Contributor
torbjorndContributor
asked in General
Why does Microsoft Defender for Cloud raise a warning when an SQLExecutor is run on an Azure SQL-database?

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?

930
geomancer
Evangelist
J
juandiegoboh
asked in General
How can I use HTMLReportGenerator for multiple maps?

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.

1627
deanhowell
Influencer
A
acanivano
asked in General
How to read a shapefile inside a zip file (in two levels)

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

1310
A
C
clare123
asked in General
FME won't write to Azure writer with no primary key

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

760
rahulsharma
Safer
crutledge
Influencer
crutledgeInfluencer
asked in General
Python Caller 64 verses 32 bit setting PYTHONHOME and ESRI

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.

110
david_r
Celebrity
mukhtarg
Contributor
mukhtargContributor
asked in General
same Id and different distance

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.

110
mukhtarg
Contributor
bobo
Contributor
boboContributor
asked in General
Batch Processing didn't output the expecting result.

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.

60
dustin
Influencer
jorge_rosales
Contributor
jorge_rosalesContributor
asked in General
Use existing SpatiaLite non-geometry feature in FeatureWriter problem

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?  

250
andreaatsafe
Safer
lorinda
Contributor
lorindaContributor
asked in General
SDE feature class doesn't exist? Very visible though.

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

660
lorinda
Contributor
C
cstelow
asked in General
How do I configure HTTPCaller (GET) to wait for a 200 response before continuing the workbench?

 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.

2140
takashi
Celebrity
C
callumt
asked in General
How can I count the number of concave interior angles in a polygon?

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

1067
K
mazenaldaas
Contributor
mazenaldaasContributor
asked in General
Conditional Clipping.

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.

200
mazenaldaas
Contributor
benvk
Contributor
benvkContributor
asked in General
How to trigger 'emailer' AFTER the Writer has finished?

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? 

1010
benvk
Contributor
D
david_lyons
asked in General
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

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

50
D
liaotaofan
liaotaofan
asked in General
how to remove plug-in when I used c++ to recompile code in sample and want to add some function on this plug-in?

80
daveatsafe
Safer
A
astuart
asked in General
How do I pass parameters from FME Server to FME Workspace 2021 if special characters are no longer allowed?

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

2050
keziaatsafe
Safer
fme_hans
Contributor
fme_hansContributor
asked in General
Clip with multiple overlaps

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.    

1950
fme_hans
Contributor
ienesaglam60
Contributor
ienesaglam60Contributor
asked in General
Create stereo model from aerial photos midpoints

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.

140
ienesaglam60
Contributor
benvk
Contributor
benvkContributor
asked in General
Accumulating attributes on a point from multiple input polygon sources

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.  

860
benvk
Contributor
jamal
jamal
asked in General
The FME is upgraded to Build 22311: How to align points converted from texts as per their (texts) alignment in AutoCAD table?

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           

290
jamal
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in General
Create a User Parameter to add database connection.

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. 

2641
chrisatsafe
Contributor
jamal
jamal
asked in General
FME Desktop 2022 Build 22311: The AutoCAD “island detection style” property appears not to be available in FME,

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

140
jamal
benvk
Contributor
benvkContributor
asked in General
PointOnAreaOverlayer not working

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.  

1370
benvk
Contributor

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,396
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.