Transformers

I would like to connect points without taking their order into account but instead their closeness.Basically, I tried to build a line with all trhe points and then looked for the shortest path finder.The algorithm seems corrects. However, It taking too much time when it has hundred of points to be treated.Any ideas on how to improve the efficiency of the shortestpathfinder in this case? 

Can SQLCreator/SQLExecutor create columns and alter values. I've completed all the left join I require and now wanting to create a new column with calculated values.Duplicate an existing column with new name / Select existingTable.existingColumn as newColumnCan I use if-then statements / If existingTable.existingValue = 'DI' then newColumn = '1234'

I'm trying to remove the hidden attributes fme_geometry and fme_type from the MSQQL_ADO reader before using the AttributeExploder, so that these attributes want be transposed, in order to speed up the process. If these attributes are exploded, I need a testfilter afterwards to remove these values. I've tried to expose the fme_gemetry and fme_type and then tried an AttributeRemover and BulkAttributeRemover to remove this values, without success. I was able to remove the default multi_* attributes with the BulkAttributeRemover, but not fme_attributes. Is there anyway to remove fme_geometry or fme_type. Thanks in advanced/Jonas

I have 2 shape files: firesmart and forest area. I want to clip firesmart according to forest area. The workspace fmw script do the clip and generate shape file and SDE feature class. The generated shape file are in the correct location, however, SDE feature class has shifted to a different location. What's the reason and how to solve it?

Hello everyone, I have a little problem. I have multiple and partially overlapping geotiffs and I have to clip some parts from every raster using multiple Polygon-Features. They are "connected" by one attribute, e.g. the raster is called xyz.tif and the clipper-polygons have this name as an attribute. The Polygon-Shapefile has a lot of different features. How can i group them, so that every raster is only clipped by the belonging Polygon-Features???I thought, it would be the "Group-By" argument in Clipper Transformer, but it's not working this way. Because of the overlapping I can't ignore the Pairing Raster <-> Polygons.Any idea please?   

Hello all,I am trying to create a HTML Report that has a table plus also a map image.The problem I am finding is that the Report is being created before the image is finished and then ends up with the image of the previous job.I have tried connecting the feature writer into the report generator, which works but I end up with an extra row in the table with a "none" record.Is there a way to force the image to be created before the report? 

Hi there,I have a workspace that is using the SystemCaller to run an encryption/decryption process (GnuPG ). It runs fine from Desktop and Server when I set the FME Server Engines to use my Admin account, but when I set the Server Engines to use a service account (and I'm logged into that account), FME Desktop runs fine but Server fails to execute. I think I've narrowed it down to the fact that I need to force the Command Prompt to run as Admin from FME, but I'm not sure of how to do that. Any ideas?Thanks!Sam

I have a file geodatabase that contains several feature datasets.Here is what I need to do......The AnswerAll point feature contains over 5000 rows, however I need to "select by attributes" using Comp_Name.......this yields me 376 results each with a varying number of rows for each Comp_Name.I then need to take the HCA Name from each of these rows and find the corresponding HCA polygon in my HCA's dataset.Once I have the HCA Names and there associated polygons for each Comp_Name, I need to create a Bounding Box Polygon around those Polygons, and export it out with the Comp_Name, HCANames, and HCATypesI can attach my geodatabase if anyone wants to take a crack at this!

where can i find what exloded attributes mean?

Hello there, I have a question regarding the AreaOnAreaOverlayer. When I use that transformer to clean my polygons I get some polygons with really sharp edges. Is there a way to avoid this? I guess it is random on how it decides which polygon to cut from another polygon when they overlap, right? Thanks very much in advance for your help!

Recently it occured to me, that I have to solve a set of seemingly similar control flow problems in FME quite often.Starting point is a workspace which is re-used for different scenarios. A generic approach to solve a family of similar tasks.Basic problem usually is the behaviour of transformers like Clipper, AppearanceSetter, and similar ones which need two (or more) different streams of features and produce a result which combines the data sets.Clippers clip Clippees, Geometry is textured with rasterdata, ... you get the ideaProblem starts whenever one of the necessary datasets is missing.E.g. the result stream of a processing may need clipping and goes into the Clippee port of the Clipper. If there are no Clippers available no output is produced.So as a workaround I need to fumble around with a FeatureMerger and several helper transformers to let the resulting stream pass by the Clipper whenever there happens to be no clipping feature.Or I need to avoid the AppearanceSetter if eithe

I have features with a structure with 3 geometries, point, line and area. I need to reproject the geometry, so I use the geometryreplacer to get each of the geometries, reproject them and put them back in the structure with an geometryextractor.Somehow the 3rd dimension is lost after using the geometryreplacer. The geometries I get are only 2d (>inspector). As GeometryEncoding I use HexEncoded OGC Well Known binary.How can I get the 3rd dimension back?Thanks, Vera

I have a grid with 16 polygons. I have an orthophoto and a contour dataset that covers the extent of the 16 polygons. I want to buffer each polygon by a set amount and clip to the extent of the buffered polygons to create an overlap. When I use the the bufferer and clipper transformer for imagery using the fanout expression to create 16 individual named folders it works fine but when I run the same unchanged routine on a contour shapefile it doesn't buffer to extent of the buffered polygons correctly. I've attached screenshots of the result using the shapefile. I've tried changing random settings but cannot achieve the expected result. Thanks in advance. Aaron The blue lines are my grid polygons. The darker shades are the overlaps of the surrounding polygons.You can see from this the routine seems to be using some of the surrounding polygons as a clipper and clipping contours from the left and top of the grid polygon. This does not happen when using the same routine on th

Hi,I’m using HttpCaller for a REST JSON get call.On the response I use JSONFlattener & JSON Fragmenter with query json["{data}"] giving the following 2 pages-(personal data redacted for this post) data{0}.applicationId (encoded: utf-8)data{0}.applicationStatus (encoded: utf-8)data{0}.applicationTypeCode (encoded: utf-8)data{0}.dob (encoded: utf-8)data{0}.eligibilityCode (encoded: utf-8)data{0}.name (encoded: utf-8)data{0}.nino (encoded: utf-8)data{0}.partyTypeCode (encoded: utf-8)data{0}.submissionDate (encoded: utf-8)data{1}.applicationId (encoded: utf-8)data{1}.applicationStatus (encoded: utf-8)data{1}.applicationTypeCode (encoded: utf-8)data{1}.dob (encoded: utf-8)data{1}.eligibilityCode (encoded: utf-8)data{1}.name (encoded: utf-8)data{1}.nino (encoded: utf-16)data{1}.partyTypeCode (encoded: utf-8)data{1}.submissionDate (encoded: utf-8) (Pagination set to max 50 pages) How can I process each page individually as I’ll be using the attributes from each page to then popu

I was wondering how to add Custom Symbols so that I could use it in FME workbench to style a MapInfo table. I have a folder with .bmp images that I want to use. I'm using FME 2019. I've tried copying the folder to Program Files/FME/mapinfo/Custom symbols but it didn't work. Any ideas?

I am creating an ECW raster mosaic from around 500 JPGs using the RasterMosaicker transformer, in FME 2015.1. The attached snapshot shows a test piece of the resulting mosaic, but ideally I would like the areas with no data to be transparent, not black. Is this possible? I have read some threads on a similar theme but I find the answers where bands are discussed difficult to understand as I don't have enough knowledge in this area. Is there a simple solution? Probably not! Many thanks.

A workbench that I've created has been set up on a Linux VM and I've been asked to list the workbench exit codes. What does this mean?

I am trying to LiDAR use data provided by the NYS Clearing House to improve a digital terrain model and to do so need to turn a xyzi file into a las. I can even open the xyzi file in arcmap or in qgis. Let me know if you know.

Basically I have a linear featureclass and a polygon featureclass that overlap in areas. Every line has a Name attribute. I'm trying to determine the best way to find all lines in a polygon and list the Name that occurs the most. I used a LineOnAreaOverlay along with StatisticsCalculator but I'm not getting the correct results. Any ideas to a better approach? thx 

Hi again!  New uissue. Concerning custom transformers.  I made a transformer doing some spatial operations. At the end i have a new attribute and a lot of the input attributes. I use a keeper to only pass the new attribute and a ID-type field.  The purpose is to use this customtransformer multiple times in a workbench.  What now happens is, as soon as i enter a second or more instance(s) of this transformer, it turns some fields to parameters. No problem yet..  But then i get a red eclamation mark, so i choose the parameters...then the excalmation mark moves to a transformer connected to the output of the customtransformers. It appears some attributes wont pass.  I found out that the problem was the attributekeeper in the custom transformer. If i remove that, and do the keeping outside the transformer, everything is AOK again.  Why is this?  Thanks for answering.  Greeting again, Gio But the weird thing is some key fields wont pass.

I want to put some things to discussion I ran across while testing SurfaceDissolver.I am using it on data coming from a PointCloud, which I send through a TINGenerator in order to get as view surfaces as possible. My sample data is relatively simple, representing the roof of a small house. The PointCloud data have point distance ~20cm and seem to be accurate in z to ~5-10cm.Remark: Before I started with TINGenerator I was not very successful with PointCloudSurfaceBuilder combined with MeshSimplifier. The mesh just didn't get simple enough :-( SurfaceDissolver:First I tried different settings for "Normal Tolerance" and "Offset Tolerance" and I was not really satisfied with the amount of simplification achieved. I ended up using Normal Tolerance=30 degress and Offset Tolerance=1mFinally I tried to use SurfaceDissolver repeatedly (with identical settings) and that really improved the result.example: starting with 129 surfacesrun 1: 129 -> 65 surfacesrun 2: 65

Hello,  I am trying to convert a DWG to GIS feature class (gdb) or Shapefile. I've done this previously with no issue.However, I am trying to bring through some of the extended data (In the DWG) into the attributes of the GIS output, but I cannot seem to get FME to read the extended data.I have "Read Interpreted Extended Entity Data" and "Read Extended Entity Data As List" parameters ticked, but the extended data under "format attributes" reads no values when selected and inspected.If someone could point me the right direction i'd fully appreciate it, or let me know if this is even possible or not?  Many thanks in advance.

Hello all,I have a DWG file that has distance labels (text) and lines that I need to attach the text to.I have figured out, mostly through assistance through this forum (thank you), how to get the closest features to match but what I am having trouble with is where the text label is not the closest feature.I have used the Neighbor Finder and then a feature merger but for the ones that don't merge I want to be able to do a second test to look through the list of the other lines that are in the closest lines list.I have done this by using a List Exploder, followed by a length calculator and then a tester. My issue is that if I have found the closest 5 features to the label and the test is successful on one of them, how do I ignore the other four in the test? In some cases no matches will be found, so in this case I need to keep the failed record. Any assistance or guidance into how to do this better is very much appreciated.Thanks Dean

i am trying to clip a shapefile using a polyline and / or a polygon and the clipper keeps failing by saying that the "clipper outputs a rejected feature"

I'm trying to rename .wld files to .jpw after an image has been processed but the following dos command is not working. Any idea?