Transformers

Hi, Is there a way of being able to replicate excel's sumifs/Averageifs functions in FME?I have two tables, the first table has unique ID's and the second table contains data which I need to aggregate. Is there a transformer where I can use the unique values in table 1 to match against the data in table 2 to perform a Sumifs?Thanks in advance.

After geolocate in my SketchUp 2017 when I am trying to convert SketchUp file into GML file with epsg 24370 crs it cannot properly convert bounds that's why I lost my location I almost try with every crs of my country I usually face this problem. Please have a look at my fme skp to gml conversition file and direct me for further changesThanks.

Hi,I have a image folder (.TIF) which the structure MODIS_2017001.tif, MODIS_2017009.tif, MODIS_2017017.tif,...My target want to convert julian calender to YYYYMMDD.For example : MODIS_2017001 -> MODIS_20170101; MODIS_2017009 -> MODIS_20170109; MODIS_2017017 -> MODIS_20170117Could you tell me how to the way to make it?Thank you

I am trying to copy the data from our staging database to our production, but it hanging at this stage forever (more than 12 hours now). 35.9| 0.1|INFORM|Geodatabase Writer: Truncating table/feature class `GEODBMGR.Assess_Parcels'I don't see any error message. It used to work. This is first time I run it after I clicked the 'Update writer'. I don't know if that has anything to do with this.Thank you in advance for any of your help!

My goal is to create a JSON file that matches the following template. I've been struggling getting the coordinates in the linestring geometry property properly formatted. Note the addition of the "tippecanoe" property.{    "type" : "Feature",    "tippecanoe" : { "maxzoom" : 9, "minzoom" : 4 },    "properties" : { "FULLNAME" : "N Vasco Rd" },    "geometry" : {        "type" : "LineString",        "coordinates" : [ [ -121.733350, 37.767671 ], [ -121.733600, 37.767483 ], [ -121.733131, 37.766952 ] ]    }}Things I tried:Basic geojson writer - Writes the maxoom/minzoom property under "properties" instead of "tippecanoe".JSONTemplater - concat('[[',geom:get-points('xy', ', ', '],['),']]')This method works, but feels hackish; it adds quotation marks (") which I remove later. geom:get-text-data(geom:get-name())The second method returns null values. I give the geometry a name with the GeometryPropertySetter, but still returns a null value. If someone can post a working example, I can go from th

I'm writing line and polygon data to an OSGB-file and need color info to be preserved and written correctly. At the moment I can't seem to get a written file with color data in it. Everything else however works and is represented as expected. Am I missing something in order to get the writer to write color data? As textures and diffuse color values are supported according to the quick facts page I figured that simple color values would be as well, but maybe this isn't the case?

We have a new server (windows server 2016) on which we have installed FME2018. Before that, we had FME2016 installed on a server with an older operating system (WindowsServer 2007). On the old server, the names of the open workbenches and whether they were runnig were displayed in the taskbar, which was very handy. But now on the new server, only FME symbols are displayed and I have to do something to get to those informations. I guess this is rather a windows than a FME2018 issue, but is there a possibility to display the name and the running-status of the open workbenches?Thanks, Vera

Hi,I am writing out to KML using a FeatureWriter from a File Geodatabase and want to set the geometry of the polygons to not tessellate (default is for tessellation).I have found the geometry tag but I am unable to figure out how to insert it into the workflow. I need to optimize a large dataset in google earth for less than ideal computers.Thanks!

Hi,I'm trying to create a shortest path from point A to B, yet FME is not outputting any path. I've looked at similar questions asked on here, and I've adapted my workbench accordinly, but still no luck.I'm using an OpenStreetMap highway layer as input. I've explicitely set my snapping tolerance as relatively high in the shortespathfinder, just so that I could just get some output. But it didn't work either.Printscreen of my workbench: 

I am really a neophyte at SQL so could use some help. I have 2 tables, my primary data is a dgn file and the table to update from is an Excel spreadsheet.dgn file: excel:I want to join the excel to the dgn file when the first 12 characters of igds_level_name contains the NameCode in the Excel file. I will then update the dgn.Category from the excel.Category. My output should only be the dgn file.The last attempt at making this work:SELECT * FROM Output    LEFT JOIN "US36_dgn_Categories00" ON (SUBSTR("igds_level_name",1,12) LIKE "US36_dgn_Categories00"."NameCode")    SET "Output"."Category" = "US36_dgn_Categories00"."Category"

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?