Transformers

Since last couple of versions this really annoying message pop's up.As soon as one or more merge keys has duplicates. Even if the combined keys are unique. I am forced to put a (disabled) inspector on the rejected features output port.PCNLTSTRAATNAAM2324HG702Bachstraat2324HG704Bachstraat2324HG706Bachstraat In the example above I use both fields as merge keys. The "straatname" causes the extra_ref._feature rejection.This gets worse if I merge on more fields, which I do in this workbench the example is from, up to 7 fields. (setting ignore nulls or empty will cause everything to not merge, as all of them have 1 or more with value null) There is no setting to "ignore rejection" afaik.Of course I can concatenate first into a merge_key to emulate oracle's "coalesce". But shouldn't be necessary I think.Anyone knows why? Or is there a setting to stop this behavior.Is there a "ignore rejection" option?

Hi everyone, I use an XMLTemplater (FME Desktop 2015), where I want to add text that includes special characters. So I want to wrap <![CDATA[]]> around the text, when I add it to the String itself, it gets automatically resolved by fme. XML Templater:<adv:localFlightRestrictions><![CDATA[@Value(localFlightRestrictions)]]></adv:localFlightRestrictions>So the XML output does not contain the CDATA term, is it somehow possible to stop fme resolving the term itself, and write it to the xml as a simple string?Thanks, best regardsMel

Hi FMErs,I have an AutoCAD dxf of 2D contours with elevations at 1m increments in an attribute.When trying to create a surface DEM and points with the surface modeller, the tolerance parameter needs to be tuned to an appropriate value to reduce the number of vertices. Question is, what are the units of the tolerance parameter ?Thanks in advance

So I try to update my profile, but I continuesly encounter this problem:Failed to load profile.Since the report a bug only contains category issues about the software, I though I should post it here if anyone else is encountering the same problem.So what can I do to fix this?

Is there abilities to itierate through mutliple datasets in a folder? EG; I want to convert the format of multiple grid datasets so want to be able to build a simple FME process that runs for the first dataset, then runs for the seond, then third, etc.I don't want to have to duplicate the simple FME process for each dataset I want converted.

I have a couple of annotation features. They have all the same attributes. But in the DWG file some text pieces are offset for no apparent reason at all.

We are using FME 2017. We have a new data migration project. We are trying to see pros and cons of using FME tool for spatial data migration and loading the data to SalesForce. This would be one time data load. Does anyone has experience loading spatial data to SalesForce using FME? Can you share the pros and cons based on your experience? Also in particular pro and cons of using SalesForce connectors.

Hello,After upgrading to FME2018, I have this strange error on featureMerger:2018-05-09 07:00:21| 2.3| 0.1|ERROR |FeatureMerger(ReferenceFactory): The clause 'REJECT_INVALID_GEOM YES CLEANING_TOLERANCE NONE' within 'FACTORY_DEF {*} ReferenceFactory FACTORY_NAME FeatureMerger INPUT REFERENCER FEATURE_TYPE StringReplacer_OUTPUT INPUT REFERENCEE FEATURE_TYPE StringReplacer_2_OUTPUT REFERENCE_INFO ATTRIBUTES REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>TEXT<closeparen>,FeatureMerger) @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>TEXT<closeparen>,FeatureMerger) AUTO ATTR_ACCUM_MODE HANDLE_CONFLICT ATTR_CONFLICT_RES REQUESTOR_IF_CONFLICT IGNORE_NULLS No HANDLE_NULL_MISSING_KEYS_LIKE_FME2013 No LIST_ATTRS_TO_INCLUDE <Unused> LIST_ATTRS_TO_INCLUDE_MODE <Unused> MERGE_ATTRIBUTES Yes MANAGE_FME_TYPE Yes MODE COMPLETE PROCESS_DUPLICATE_REFERENCEES No REFERENCEES_FIRST No REJECT_INVALID_GEOM

Hi folks, This may be an easy question but it's been stumping me for a little while now. I have an excel sheet with the following format (this is just a test dataset but with a similar format to a larger excel file I have):AnimalTypeYearAmountDeerIndem2001100DeerClaim2003200ElkIndem2001111ElkIndem2004222WaterfowlClaim2005333WaterfowlIndem2007444And what I want as a final table is the following:AnimalType2001200220032004200520062007DeerIndem100000000DeerClaim002000000ElkIndem11100222000ElkClaim0000000WaterfowlIndem000000444WaterfowlClaim000033300I've used an AttributePivoter and everything seems to work ok, but instead of the zeroes in the final table, I am just left with blanks where there was no data in the original table. But I can't seem to figure out how to edit any of the data that is getting output after the AttributePivoter. My workspace screenshot is below, I hope someone might be able to help me out!!

I have a ESRI REST API and using HTTP caller to get the response in an attribute. Now I need to pass the ESRI JSON response body to the feature reader and get the geometry out of it. But, when I tried passing the response body all the features are getting rejected. May I know a possible way to get the features out of the HTTP caller response body stored in an attribute?

Hi,I am trying to concatenate a string. The attribute I am using in the concatenation has been extracted from JSON into a list then exploded into an attribute. However, the string concatenator is not ignoring the attribute, the result just has the other string values concatenated together without the attribute value.Any pointers would be much appreciated. Example workbench is here; Thanks

I'm using the TINGenerator-transformer to calculate slope and aspect for triangles. This works most of the time, but I sometimes get the following error:Surface Model cannot be constructed. Either all points are linear or initial set of points did not consist of 3 non NAN elevations.I've attached a workbench which creates such a geometry. The points are not linear nor do they consist of NAN elevations...If there is a better way to calculate slope and aspect for geometries, then I would of course be more than happy to use that approach instead...

For those who didn't have the opportunity to upgrade to FME Server 2018+ yet and are getting addicted to work into darkness, like me, I suggest to use an extension with Firefox or Chrome.It's call the Dark Reader : Dark Reader appI could not work without this extension anymore.

Hi,I have a .tif file that I convert from .nc format to .tif. I opend in ArcGis, I saw them multiples band.When I open it in FME, I don't display band name. I want to extract some bands and rename bands it.Could you please share me how the way to make it?Thank you

I need to use a transformer so I can have as output the attributes all together, the points that are inside a polygon, which ones I may be using?

I have FileGeoDataBase (FGDB) polygons. It's easy to convert them to DWG lines. BUT: I want want to take one polygon attribute and turn it into DWG text. Here is the workbench: FGDB polygon reader -> LabelPointReplacer -> DWG writer. At every insertion point in the DWG file there are now two text pieces: one at the correct scale, another 180 degrees rotated (upside down), huge (humongous), why?

Is there a way to actively monitor FME Cloud data transfer amounts? The dashboard allows transfer rates (Kb/sec) to be viewed but not amounts. Can a report be run to show data transfer amounts broken down into hourly, daily or other intervals?As data transfer and storage is billed as an additional cost to the per hour usage amount, it would be nice to be able to track this.

Hi,We've just recently begun to adopt the MBTiles format for offline map viewing.What I expect is a TMS setup, with every tile level at its optimal resolution, i.e. w/o undue pixellation.I've made some test, but it seems that the MBTiler writer only accepts a raster image, i.e. an already fixed resolution. This results in a pixellated lowest (or highest?) level.How do I create an MBTiles dataset from my vector map data, with full resolution on all levels ?The WebMapTiler also expects raster input, so that's not immidiatedly an option.Any insights are appriciated. Using 2018.1.Cheers

I am sure this is a simple fix for this, but I've been testing this for hours now and going nowhere!In AttributeValidator, I want to FAIL an attribute which contains a certain string. The most logical thing I could think of is to use the Contains Regex validation rule. Let's say I want to 'Fail' every attribute where it contains a string which = FME. I have trawled the internet and got the following expression to work within the Regex Editor:\\b(?!FME)\\b\\S+However, when it runs in the AttributeValidator, attributes which i have engineered to contain FME, appears from the Passed output port.1. Is there a much simpler way within the AttributeValidator to fail any attribute which contains a certain string, rather than regex?2. If not, am I doing something fundamentally wrong with the Regex or validation rule?Thanks

I can get the XY coordinates for a leader line from a Line Callout annotation using the anchor point and the WKT string. But the WKT text string is empty for a leader line of a Simple Line Callout features. Similarly, the "geodb_text_lc_textbox_x1" values are not available. So, how can I get at the XY coordinate values of the leader line?Thanks,Gido

HelloI am trying to clean up some GPS line work before it is loaded into our database. THe lines need to be free of self intersections. I have come close to accomplishing this by buffering the line and then using the centreline replacer to create a smoothed line. The problem is that the centreline replacer is creating short dangles along the length of the line. The actual centreline it is creating is good enough for my purposes I just need to remove the dangles. If anyone has any ideas on how to do this it would be much appreciated.In this screen shot the Green line is the original line with self intersections and the red line is the result of the centreline replacer.

FME 2018 doesn't seem to include the pluginbuilder files for c++. Does anyone know where to get these from?

Hi all,For some reason an application is storing a date/time field as 'Double' - ''201805241214'' in this format, but the Date converter function does not recognise this as its a double field type, any help is greatly appreciated, 

Hi everyone,Is it possible to specify the max number of features to be read when using the Data Inspector directly? Currently I use the Workbench to add a reader and then view the selected number of rows by connecting an Inspector.

I have a problem to calculate the heading of 2 points in a line in my template. In the 2 pictures you can see the template itself there i tried to take the start y-value.I used atan2 and also just a simple number. I tried with just 2 and 1 and i get a solution, but not if i use the attribute with "{geom:get-start-y()}".Hope i get some help.