Transformers

Hi,I will find how many different ID are for one GARDSNR and BRUKSNR.I've correct answer with Cumulative (3), but in Complete and Summary Count is 5 (sholud be 3):Parameters used for StatisticsCalculator:Group by: GARDSNR BRUKSNRAttribute to analyse: IDTotal Count attribute: CountThanks in advantage:)  

I've been working with the mapnik rasterizer tool looking to rasterize polygon geometry. Each time I try to create my output I get large blank areas on my raster. Please see image attached. When I inspect the vector data it appears fine with no missing data. Thanks for the help!!

Hi,One column has 4 values 2, 12 324, 56987 (data type is number)When I use filter in Inspector (Table View) to find records with value 2 I got 3 results (2, 12 and 324)Earlier versions of Fme gave me just one result: 2.Is it a method to find just records with value 2?Thanks in advantage:)

Hi guys,I have a lookup table contains values in different fields (column), example as below.Is there a way I can make the all values become field names then give yes/no in each fields of the feature class? Feature Class Field 1 Field 2 Field 3 contour_height_pts surveydate elevation vert_datum contour_minor surveydate elevation vert_datum contour_major surveydate elevation vert_datum Drainage feature linetype instaldate modifydate Culvert linetype instaldate modifydateThank you 

I am looking at translation the local government information model into Postgis.The local government information model is delivered as an XML workspace document.I will greatly appreciate any insights into how I might accomplish this.

I need to organise a number of point objects that represent various built features like fireplaces, campsites and such. In their raw format the points are stacked on top of each other and we have so far arranged them in a nice group and then moved that somewhere appropriate, like over a lake or so. Finaly we ad a pointer that poins to the actual location. I would like to see if it would be posible to use FME to automate part of this process.I picture a system where points that are within a certain distance from each other get grouped together and then placed in a grid of 2, 3 or 4. The final symbols are in set size so we know the distance between the points for the scales we work in. The main goal here is to align the final symbols nicesly verticaly and horisontaly. Is there a way to do this?In the next step I would like to ad a pointer that points to midpoint of the point cluster above. What it the recomended method to do this?

HiI have 2 feature class namely community and parcel . I need to find out the overlap polygon with some tolerance say 0.1 sq.m. Kindly let me know how to find the same.Regards,K.Jayakumar

When passing approx. 1.300.000 features to the statistics calculator for calculating max features within groups of features, I receive this error:StatisticsCalculator_InputProcessor(TeeFactory): Cloned 1282424 input feature(s) into 1282424 output feature(s)<br>StatisticsCalculator_UnneededInputNuker(TeeFactory): Cloned 1282424 input feature(s) into 0 output feature(s)StatisticsCalculator_CompleteOutputter(SortFactory): Output 0 feature(s) without doing any sortingPython Exception <TypeError>: Overflow error for setAttribute().@Python failed to execute function `StatisticsCalculator.summarizeStatistics'StatisticsCalculator_SummaryCreator(CreationFactory): StatisticsCalculator_SummaryExploder: @Python execution failedCould it be a memory failure? And if so, can I circumvent this be eg. dividing my features into the groups that I already am trying to fetch the max value for? And how would i do that?Edit: When I lower the features to, say 800.000, the statistics calculator runs

Hello,I want to make a FME model in which the slope along bicycle routes is determined, as well as the direction of the slope (uphill/downhill). My idea: - dividing the network in small parts of +/- 50 metres long (LineDivider)- define the elevation of the start- and endpoint of the lines, as well as the direction - calculate the slope in between these points + directionAnyone who can help me with this?

I'm extracting data nightly from JSON services of which have no validation. These datasets have over 100 columns. Is there way to import a schema into the attribute validator so for every column it would test data type and max length? It would take forever to test data type, structure and max length for every column in every dataset, but my fme processes keep failing.

Hi,Is there an easy way way to mange the configuration files path? We are migrating our network shared drives where resides these configuration and we want to avoid to re-install FME Server. Regards.Etienne

I have a workbench that works for 300k entries but seems to run out memory for 1500k entries. The problem happens at the StatisticsCalculator level where I ask to calculte a mean using a group by an attribute. Does someone have an idea on how I can proceed in order to move further.. Thanks.

Folks,This is a question of cleanup and an answer here will decide what technology is best for dealing with this issue.I have a number of Mapinfo tables that should contain typical simple multi-SEGMENT polylines.However due to some sort of conversion or creation error some of the objects are mutli-SECTION polylines. For those unfamiliar with this object type what I mean is a series of LINES that don't perfectly start/end at the next line in the chain have been aggregated into a single object. For Mapinfo's pupose this looks like a single polyline but doesn't have the same properties. Each SECTION maintains it's individual "sub-geometry" within the multi-SECTION polyline.Now what's happening is that when these objects are converted via FME to DWG the only aggregate type DWG supports is a thing called a block. Now what I'm getting is few 100 blocks mixed with a few 1000 true polylines.As an aside the recipient of the DWG didn't know what these oddly

Is there a function or method for returning the date of the last Saturday of any given month? Input attribute would be formatted 'April 2018' or 'September 2019'. I'm currently doing this by manually inputting the correct dates in an AttributeCreator conditional statement. I'm looking for a method that would not require conitinual maintenance.

Hello,I meet with the problem.After I convert the revit rvt to rvz format,and then using FME to convert rvz to cesium b3dm format.The result can be view in cesium but the components are not separated but joined together.When I selected one of components of the model,the more components be selected.Therefore I want to know how to resolve this problem.Thanks a lot!

I have buildings with very complicated roof structures which I need to extrude to the terrain level to create new models.During the process I need to use the GeometryCoercer to convert them to fmepolygons. The process was unsuccessful as many surfaces were missing.This error message was indicated..GeometryCoercer: Cannot coerce from IFMETriangleFan to fme_polygonHow can I overcome this ? Takashi, can you help me?

In FME Desktop I have had succes connecting to a Dynamics 365 test instance using the 'Microsoft Dynamics 365' Web Connection and a simple username/password (and client secret etc. of course). But now I need to connect to our production Dynamics 365 which is set up to use SSO. No matter what username/password I use i the connection I get this error:Updating access token for 'remu01 Microsoft Dynamics 365'HTTP Error: 400 - Bad RequestHTTP Error: 400 - {"error":"invalid_grant","error_description":"AADSTS70002: Error validating credentials. AADSTS50126: Invalid username or password\\r\\nTrace ID: fc59aa9f-ed03-4503-b7f6-2efc7aa24c00\\r\\nCorrelation ID: efcdd9b0-3969-4107-9645-2a69a762f4b6\\r\\nTimestamp: 2017-12-05 11:19:54Z","error_codes":[70002,50126],"timestamp":"2017-12-05 11:19:54Z","trace_id":"fc59aa9f-ed03-4503-b7f6-2efc7aa24c00","correlation_id":"efcdd9b0-3969-

I have many faces that I want to rotate around 3 axis to make them as flat as possible. See attached workspace. I get the SurfaceNormalCalculator and CenterPointExtractor. And planned to use the 3DRotator or the 3DAffiner to rotate around the centerpoint of the object to get it as "flat as possible. However I can not figure out the correct calculations!Any help?

I am writing a routine to check an incoming dataset before loading. The first step is to make sure the dataset has all the required attributes, the second step is to make sure the values in the attributes are valid. I am using the AttributeValidator for this second step. Unfortunately, when I am validating a value, I have to hardcode all the values in the Rule Configuration box. I would like to be able to read a table and get these values and populate it in the Rule Configuration box. How can I do this?

HelloI have 123 CSV files as input with geometries written in WKT format. However, the names of the geometry fields vary as well as the geometry types. E.g. most of the geometries have name 'D_Position' (can be point or line), but there are also some called 'Location' (point), 'Boundary' (polygon) etc. I tried to solve this with several GeometryReplacer (one for each geometry type) as shown on picture below. I thought that it will be like an 'if else' statement. Try create geometry for D_Position, if not possible (rejected) try Location, if not possible next one etc. But this doesn't seem to work. I get 121 tables going through the 'D_Position' geom replacer, even tables that don't have D_Position field. The remaining two are going to the second replacer because the value of D_position was null. Any tips please?

Hi, I am trying to do the following:I have a total number of n adresses (points) spatially divided over a given area. I want to group them into x clusters using y members per cluster. This has to be as spatially optimal as possible.As far as I know, it should be something in the lines of a k-means algorithm.Actually, the Neighbourhood Aggregator comes close, but I want to set a fixed number of members per cluster, not a minimal.Anyone got any ideas? I already tried working with the cluster modeller, to no avail. Thanks in advance!Flip