Transformers

Hellow. I just want to take a simple pointcloudxyz and transform it into a polygon. it will be 2D so the z value will always be zero. Has anyone got a simple example of tutorial I can follow?

Hello,I've a question about SQLExecutor and SQL statement. I'm upgrading workspace from FME 2017.1 to 2020.1 and in 2020.1 I'm getting an error in SQL WITH statement. In FME 2017.1 this code is not rejected and works.Error with example2020-07-22 14:35:49|   3.1|  0.0|WARN  |Error executing SQL command ('declare "public_custom_query_crsr" cursor for WITH something AS  (...)INSERT INTO table (a...'): 'ERROR:  DECLARE CURSOR must not contain data-modifying statements in WITH What has changed in SQL Executor from 2017 to 2020.1? The transformer version is the same as I see (version number 8). I use the same databaseHow can I change my SQL, is there a need to modify mine WITH statements? 

I want a more exact outline rather than a smoothed outline from a point cloud (2D) I have? See image attached at the moment I use HullReplacer which actually gives too smooth a resultCan you help

I am trying to follow the guide at this linkhttps://community.safe.com/s/article/how-to-read-all-feature-classes-from-multiple-esriBut I fail to set up the fileGDB writer 

Dear FME community,  perhaps there's an easy solution for this:  Is there a way to convert dataset of points to lines? The lines need only to be a few metres long, and the orientation is not of interest at first. Something of a PointToLine transformer...?  Kind regards Thomas

I have been trying to connect points to create lines but cannot seem to do it in either pointconnector or featuremerger.  My file has the following:  UTMX UTMY UNIQUE ID FROM NODE TO NODE  These records have duplicates where the From and To Node are reversed so you would have a duplicate going from to and to from.  I set the Feature Merger to Attributes and Geometry -build lines from points, the requestor is from the 2d point replacer as is the supplier (from same 2d point replacer transformer).  I also tried pointconnector using UNIQUEID as the break.  The former just produces points while the latter retrieves 0 records.  Any help would be appreciated.  KDMU   

HiI'm trying the tutorial / article about "How to create a WMS Service using FME Server". I've published the first workbench (GetCapabilities), but I'm having some problems with the last one (GetPNG). I've modified the FME_SERVER_REQUEST_URI to match the result from my FME Server.  When I try to run the GetPNG workbench, the FeatureReader only outputs Schema and Initiator, and not the Generic-port which are used later in the workspace. I've tried reading from ESRI Geodatabase (.sde) and from the corresponing Azure-database (Microsoft Azure SQL Database Spatial). If I try to manually select the feature types to read, I can select the ones that I've included in my URL and which is used in GetCapabilities. How do I get the generic-port to work?

Hi, I wounder what the best way could be to extract raster from geometry? In this case, extract an ortophoto from a terrain mesh. I have tried the AppearanceExtractor which works fine. The aim is to extract the ortophoto and write it as a jpeg, then read it in the workflow and replace it on the terrain via AppearanceSetter. Works fine, but I only need one feature (face) which contains the ortophoto to write to jpeg. In one test the terrain contains 62 faces, so I use the sampler to sample First N Features to get the first face and ortophoto. The problem I find is that all other 61 faces need to be processed to output "NotSampled". So depending on the terrain mesh and no. of faces this could take quite some time. I wounder if First N Feature is found, then stop processing rest of features? Hope it makes sense. Thanks!

I am new to FME and I am sorry if this question seam so basic but How can I use "CASE" statement like in SQL or "IFS /IFS" statements to do a validation logic on FME?

How we convert above mentioned format in to .las format​

I am new to fme. I have a citygml file of buildings with attribute codes such as 2100, 3400. The definition of this code is in another XML file so how do I setup the workbench so that the citygml file can access the attribute values from the XML file?

I have a large polygon SDE feature class (>3M features) from which I only need polygons intersecting a few Oracle polygon features.I've connected the Oracle features to the SDE FeatureReader's Initiator port and I'm using them to filter SDE data with the 'Initiator Intersects Result' spatial filter. I've realized it returns duplicates when there's an SDE feature intersecting more than one (non overlapping) Initiator feature. So if an SDE feature intersects 3 Initiator features I get 3 copies of the SDE feature.This is not what I would expect. My only option is to use a DuplicatFilter right after the FeatureReader but when reading thousands of features this will slow down my translation.Has anyone come across this same problem?

Hi All, Appreciate if someone in this forum let me know the process to transform Enghouse Cable Cad files to any OGC format with attribute data transformation. Thanks in advance. Vijai Gunalan

i have different points (A,B,C,D,E,F,G,H,I,K) . some points are connected together and some not in the network ,as example A connects to B connects to C D connects to E C connects to GF connects to I connects to K  if there are any connection between any point ,i want to use shortest path finder ,depend on the shortest length and the largest value in specific attribute .soi am not sure how could i let the shortest path finder pick only and choose the largest value of attribute if he has multiple path and the transformer should decide  FME 2018Thanks for help

I am trying to extract vertexes from a shape file that has 3D Lines with both a Z value and an M value. I am trying to extract the both the Z and M value but I don't see a way to do it. Vertex Extractor will only give me X,Y,Z

FME 2017.0 (17271).I have a polygon layer which consists of an area with buffer zones around it. The polygons do not overlap. I also have point data of address which covers a larger area and includes postal and non-postal addresses. I want to select only the postal addresses that fall within the polygons.The address data is stored in SQL Server using the Geometry data type to store the locations (WKB Geometry). So I've been comparing ways of doing the selection. In doing this I've found that using FeatureReader with both a WHERE Clause AND a Spatial Filter results in some address records being selected twice.I read in the polygons then send these to the FeatureReader. The FeatureReader connects to Microsoft SQL Server Spatial to read the point data. The Spatial Filter is set to "Contains".If I leave it like this and add a Tester to do "Postal NOT LIKE 'N'", I get 653,819 records. If, instead of the Tester, I add a WHERE Clause to the FeatureR

Hello there,I am trying to aggregat neighborhood polygones (they need to touch or intersect each other) grouped by their ID with the condition, that the value of a specific attribute from the neighbor polygone needs to be in the range of +-10% of the „motherpolygones" value. In addition, I need to use the „Attributes to Average, Weighted by Area“ attribute accumulation setting from the aggregator. This option isn’t available in the neighborhoodaggregator. Also the "Attributes to Concatenate" option is necessary. In words the Transformer should do this:"If the polygones has the same ID and touches or intersect each other and the value of the attribute AA is in range of +-10% aggregat them. Weight the BB attribute by area and concatenate the attribute CC." Does someone has an idea? best regards,knigge

The highlighted Polygons should form a larger polygon with the same attributes. Both have different IDs, so after merging only one should be retained. The same transformation needs to occur for other polygons in the screenshot also. Usage of Dissolver and FeatureMerger transformers has not yielded results. I hope some light can be shed on the right approach to take here.

I want to transform a polygon dataset into a raster using the NumericRasterizer where the new raster matches the dimensions of another raster in terms of dimensions so that they align perfectly (I assume extend and cell size is enough to achieve this). As you can see on the image below, I already have the rasterize part working. The problem is that I don't get it working that the dimensions (extend and cellsize) of the references raster (the geotiff reader in the image below) are used as extend and cellsize input of the numericRasterizer. I need the extend and cell size to be automatically extracted from the Geotiff because that can vary.  I already tried the RasterPropertyExtractor but then I am not able to extract the attributes. I somebody able to help me with this issue?  

Using a reader to consume a pretty basic spreadsheet, but loading it fails with the following message: Excel Reader: Failed to open the dataset 'C:\path\to\file.xlsx'. Error message was 'Length too short' A fatal error has occurred. Check the logfile above for detailsFailed to read schema features from dataset 'C:\path\to\file.xlsx' using the 'XLSXR' reader This file has ~450 rows. Other files generated by the same system work just fine. The only difference between this file and the last one that worked is row count, around 150.

 Maybe my question has already been addressed somewhere, but I can't find this topic so quickly. How can I combine a file with project shapes (SHP-file) with a map (WMS / WFS) and get a map (JPG / PNG / BMP / ... as output per project, where each map is given the name of the project (project name is an attribute in the shp file)?

Hi there,I was wondering if anybody can give some pointers on writing CityGML dynamically.I am using a Generic writer in combination with a referenced CityGML writer.The CityGML feature types have been imported as mentioned here to the referenced CityGML writer. The source data contains feature types that match exactly the CityGML schema specification (PlantCover, Road, LandUse, Building, WaterBody and GenericCityObject). The Generic writer schema definition is set to dynamic using the schema feature from the FeatureReader transformer. I am not very familiar with the CityGML schema specifications , but since the resulting CityGML LandUse feature type has all the original source attributes plus CityGML generated attributes, I imagine that it should be possible to have that for all the resulting CityGML feature types. Another issue it noticed is that the city_feature_role is set to cityObjectMember despite the fact that I am setting the value in the workspace to the corresponding feature

I have a shapefile with both points and multipoints (not produced by me) which I am reprojecting and then writing to shapefile again. The multipoints don't get written due to the writer expecting only point feature types. I would like to split the multipoints into single points before writing, similar to the PointCloudCoercer when splitting a point cloud to single points. Is there an easy way to do this in FME or should i just give up and fix it in ArcGIS? 

When my script comes to "Updating access token for 'zzzzz'" it stops. No errors or anything. When trying to make an new Onedrive Connection it just shows the OneDrive login briefly and stops. Has anyone experienced this?

Hi everyone.I want to find the difference between two tables. The first is a FGDB feature class. The second one is a XLSX files. I need to find if some value XLSX is absent in FGDB. I need to compare 4 different field, but not all fields.Thank for your help