Transformers

I have a few hundreds of points and I'm trying to:1) 'Cluster' them spatially (max distance 25cm) and based on one common attribute while the number of neighbors can vary from 0 to 52) Calculate average position for each 'cluster' of points and replace their geometry so that all aggregated points have the same position (of course keeping the original attributes).I would be grateful for a hint, I've been trying different transformers and I can't find a solution.

I have 1 area Featureclass with 700.000 square of 5mX5m and 1 featureclass with 70.000 lines. I want to know for each square how many times it is touched bij a line. I have tryed [SpatialRelator] but after 14 hours FME was stil comparing, amd i tryed [LineOnAreaOverlayer] but FME gives a memory error. Is there maybe another way? Someone suggested [InLineQuerier] but i see no options to check if square is touched by a line.Thanks for your time.

Hi guys,  I've got an issue with the JSONFragmenter in FME Server 2017.1 (Build 17539 - win64). Well, I think I have... maybe I'm missing something!   Any non-JSON input seems to cause the workspace to finish with an error rather than carry on : "A fatal error has occurred. Check the logfile above for details". But there's no further clues in the log :Loaded module 'JSONQueryFactory' from file 'C:\Program Files\FMEServer\Server\fme\plugins/JSONQueryFactory.dll'FME API version of module 'JSONQueryFactory' matches current internal version (3.8 20170315).Emptying factory pipeline.A fatal error has occurred. Check the logfile above for details The same workspace runs fine in FME Desktop where any non-JSON inputs come out of the "Rejected" port and the workspace happily carries on (I've got "Rejected Feature Handling" set to "Continue Translation" in FME Desktop). I've added in a Tester before the JSONFragmenter in my workspace for now, but I'm curious as to why this is behaving differently

Trying to write from SQL server to MongoDB.It has a below structure:Geometry Type  Coords  [  [  [  [long, late], (pt 1)  [long, late], (pt 2)  ]  ]  ]  Can we store all the polygon data like the following:  Geometry:  Cords:  [  [long, late], (pt 1)  [long, late], (pt 2)  ]

Hi all,I'm new to FME and am trying to deal with a datset that has duplicates in. However each duplicate contains some information that I need to preserve into new columns. A simplified version is something like this: PropertyIDAddressContact nameContact details00011 High StreetMr Smith0121232800000011 High StreetMr Jones0121232800100022 Low StreetMr Birmingham0121232800200022 Low StreetMr Warwick01212328003 And what I need to end up with is more like this:  PropertyIDAddressContact nameContact detailsContact name 2Contact details 200011 High StreetMr Smith01212328000Mr Jones0121232800100022 Low StreetMr Birmingham01212328002Mr Warwick01212328003 It's been suggested to me to use FeatureMerger after multiple DuplicateFilters, but I can't figure out how to bring each set of filtered duplicates back in to a single dataset whilst preserving the data out of the duplicate entries.Any help, pointers or example workspaces would be greatly appreciated.Cheers, Mark

Hi,I want feature count in a variable, I am using statistic calculator for this purpose but it ask me for attribute to analyze but i want count for all features.I guess the below links are explaining my requirement.https://knowledge.safe.com/idea/45903/add-a-count-attribute-to-the-featureholder.htmlhttps://knowledge.safe.com/idea/48591/save-feature-count.htmlRegards,Dheeraj

Hi guys,i am trying to import some surveying data into a file geodatabase which requireds to have some standardised schema and unique identifiers.Because there are about 200 feature classes to read and 30 feature classes to write it's not very realistic to set up tester for each of them.. I have created a lookup table which include the feature classes names for the both source (from surveyed data) and final dataset. as well as the required field name and value for unique identifierBecause there are other fields required in the final dataset, i have created a fie geodatabase with all reuqired schema so hopefully there is a way i can just import the source data into it.Thanks in advance and a late happy new year to everyone :)

I have a workspace where I am trying to read and write to a SQL table (ArcGIS line feature class). The reader is an abandoned line feature class that contains a length column (double, 38 precision, 8 scale). The writer is an active line feature class that contains the same length attribute set to the parameters listed above. When trying to write features from one to the other I get the message "Column 'length' of type 'double' specified in mapping file but not defined in existing table". There is an older post regarding this topic but it did not provide an answer, it dealt with creating a new feature class. My workspace is simple, it contains two readers one is the abandoned lines and the other is a cad file; I use a NeighborFinder to select only the abandoned lines that match the cad file; I have a TimeStamper and AttributeManager after the NeighborFinder; then the writer. I have tried using the length calculator and setting the value to that in the attribut

Salesforce Reader/Writer in FME don't support read type base-64 data from Salesforce. So except salesforce reader, is there any way to read type base-64 data from salesforce by FME?

Hi, I'm fairly new to FME and am hoping to tap into your knowledge! I'm trying to score roads depending on their safety record. The criteria is 4 KSI (Killed or seriously injured) collisions within a 1000 metre stretch of road in a rural environment, and over 500 metres within in urban area, over the previous three-year period. I have a dataset containing collisions across the county over five years, which includes coordinates, severity and date (so i can easily filter out those that are too old or not serious or fatal - 820 collisions after filtering). I have a Mitab file containing the roads (with a unique reference and a field for urban / rural) - but the lines indicate the centre line of the road and as such they do not join at junctions. We're talking about 27,570 links so I can't change this. I can conjure up a way of seeing how many collision points have another 3 points within a 500 or 1000m cluster, but I'm stumped as to how I can link it to stretches of

Hi,I need to find the gaps between two polygons (not auto - correction). Kindly let me know which transformer I have to use?Thanks in advanceRegards,K.Jayakumar

How do I get the version of the transformers in my FME-Version?I'm using FME(R) 2016.0.1.1 (20160224 - Build 16177 - WIN32) and I just got a workbench that someone else made. When I try to open it, I get the following errors: Found transformers in this workspace that are not on your system: 'Dissolver (version 13)' and 'AreaOnAreaOverlayer (version 5)'Both this transformers do exist in my FME-version, but they are probably of an older version. So how do I know, what versions I'm using? What version of FME are the transformers with the above versions part of?thanks, Vera

Hi there,I am trying to write text values imported as attributes to a PDF, and want my text within the 'description' attribute to wrap when it reaches the edge of the page. I have tried to use the TextWrapper transformer, using the bounds extractor values, but no luck. Screenshot below shows the resultant PDF from the above workbench, with title text (Site Diary) and the description as per the transformer below. I've tried adding in the PDFPageFormatter but this doesn't seem to make any differenceAny suggestions?Many thanks

def processFeature(feature):    roleList = feature.getAttribute("tag{}.k")    print(roleList)    if roleList!=None:        for feat in roleList:            print(feat)Above is my quite simple python code that successfully prints all key-values for the tag-list of OSM features. This works the same way in 2.7 and 3.4, as expected. However, if I change the attribute to print the member list instead, I get different behaviors between the two.With the following code:def processFeature(feature):    roleList = feature.getAttribute("member{}.ref")    print(roleList)    if roleList!=None:        for feat in roleList:            print(feat)It prints nothing in Python 3.4 compat-mode, but does in 2.7 mode.How come this happens? My initial thought was that since the member-list only contained one member, it would not treat it as a proper list, but even on features with several members, the behavior is the same.My current workaround is to quite simply use Python 2.7, but this might not always be a 

Hi,We want to capture a view or clip contents (just like clipper tool works for 2D objects) inside a 3D solid object of an 3D AutoCAD file. That's way, we want to take screenshots or directly copy objects individually (they are generally made by block references) to visualize every office department with its floor plans. I tried to read DWG file and then support clipper tool with a geometry extractor, which is extracting 3D solids from same DWG file. Somehow, clipper tool rejects 7 of 8 individual parts and extract only one.Do you suggest any other solutions or workflows for my issue? Floor Plan made by block references inside a 3D solid geometry:A part from my workflow in FME:Also i added clipper log below:Clipper_Vector(ClippingFactory): Processed 1 input feature(s), of which 1 feature(s) were clipped, 0 feature(s) were totally inside and 0 feature(s) were totally outsideClipper_Nuker(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)Clipper INSIDE Splitter(TeeFactory): 

While reading arc geometry from smallworld, FME converting geometry as a linear, Could any one help us to resolve the issue ? The conversion of the geometry is done by FME internally?

Hi,I would like to create a csv file and set that to Schema mapper.. cause I have a requirement which will generate data dynamically from the folder which contains multiple zip files..Looping through Folder --> FeatureReader(Merging all shape files)-- > Generic --> Schema Mapper (My idea is to create a schema mapper dynamically and setting here)--> Dynamic writer or Featurewriter ..At the same time i have to run through all the folders and then through zip files and set the data to one fgdb.Requirement is.. Here shape files don't have consistent names..1.zip Folder-->1.shp-->Point2.shp-->Polyline3.shp-->Polygon2.zip Folder-->2.shp-->Point2.shp-->Polyline2.shp-->PolygonWill go the FGDB.XXXFeatureClass(Point)XXXFeatureClass(Polyline)XXXFeatureClass(Polygon)Please help me on this...Cheers,Srikanth Dasari

I'm working on a workflow that uses the PythonCaller to extract coordinates from a source file of my choice and puts them in a results attribute. My plan is to replace the existing geometry with the one extracted using the GeometryReplacer with the OGC WKT encoding.As an example:This format needs to go into the GeometryReplacerLINESTRING(161274.467 453784.372,161277.253 453785.924,161279.958 453787.131,161280.921 453787.508)What i got is something like this, but it could be longer or shorter but always has a x and y coordinate but rounding after the comma could be different:161274.467 453784.372 161277.253 453785.924 161279.958 453787.131 161280.921 453787.508 How can you replace every second space with a comma without making it too static?This example contains four coordinates but it could have 8, 100 or more. After this stap i use LINESTRING(@Value(result)) to add the linestring text.

Hi, I have a table with values that I would like to map to different values via an external file. I can kind of make the AttributeValueMapper work the way I want, but only on one "source attribute" at a time. I've been trying to read about the SchemaMapper but the documentation is a little confusing and I'm not sure how to relate the help files to my example. So if I have a table with multiple names and "M" columns like below:And an external file with related values like below:What is the easiest way to map the number values to the letter values of the external file to result like below?Is the SchemaMapper the correct transformer for this? It seemed like it would need the attribute column names to match between the table and the external file, but I cannot rename the table headers. Seems like there should be an easy way to do this that I'm missing. Hopefully I've explained this well enough, any help would be appreciated thanks!

As all we are know there is two type of raster: 1) color raster (e.g. satellite Image) and 2) numeric raster (e.g. DEM). I am find in FME, there is tutorial available for converting numeric raster (DEM) to polygon but I want to precisely converting agriculture crops field which is almost rectangle shape from satellite Image to polygon.Until here, i am segmented NIR image by using new tools in ArcMap Segment Mean Shift. out put of that 8 bit RGB image which has mean value of input RGB NIR image based on spatial and spectral parameter. Now in FME, i want to make pure shapefile of natural rectangle shapes like field in image. i think there is fme raster expression which can done my job. Now in FME i have to design expression based on segmented raster value RGB and once again they marge apropriyetly and make pure one rectangle segment.. Last using RasterToPolygonCoercer we should achieve our goal.Attached file “Sample_Data.rar” has 2 sample file: 1. Originals Image (NIR_Originals.tif)

Hi, I have a work space that creates an error report for a dataset, that I would like to amend. The current error report brings back the error "Area of Outstanding Natural Beauty (AONB)' fails check for case is 'FULL_TITLE", however this isn't an error as the of being lower case is to be expected. In FME, for strings like the above, how can I allow 'of' to be lower case and not be included in the error report please?I think it might be require a regular expression of some sort, but not sure if \\bof\\b would do the trick.Would really appreciate your help. Thanks,JB