Transformers

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.

I am trying to establish a connection to a MS SQL Server through FME Workbench installed on a Unix and/or Linux box - that uses Microsoft AD credentials. I have downloaded and placed the lastest MS SQL Server JDBC from https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017#available-downloads-of-jdbc-driver-for-sql-serverAnd I placed the driver v10 jar in the /User/<user>/Library/Application Supper/FME/Plugins/Java directory. As suggested in the "Getting Started with JDBC" article. https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/jdbc/getting_started_jdbc.htmWhen I create a new Database Connection within FME Workbench using the JDBC driver. But when I click "Test" I keep getting an error either that my user login did not authenticate or that is could not pull back the database schema. Not sure if I have setup everything right for FME Workbench to use the MS JDBC driver correctly. I also see a

So this is a problem that keeps coming up...we need to report text differences between two versions of reports. I can access the before and after fields and read them into FME, but I am searching for ways to analyze the strings and report the differences (additions and deletions).The ultimate goal is to format a report with additions (green) and deletions (red) clearly marked. As a start though, I have to find some method to analyze the two strings and perhaps break things down enough to be able to re-assemble a properly formatted string, perhaps with HTML. Nothing is jumping out right now as a simple answer, so I suspect it is not as easy :)I have looked into the custom workspaces "FuzzyStringComparer" and "FuzzyStringCompareFrom2Datasets", but I don't think they will help me much with the above. I thought about a process of chopping a string into individual words and do some repetitive looping using Regular Expressions to determine which chunks existed before

hello. FME tells me that the Command-line to run this workspace isfme.exe abc.fmw --SourceDataset_DGNV8 "abc.dgn" ^--SourceDataset_LAS """"""10.las"" ""11.las"" ""12.las"""""" When executing in dos window only the first las file is processed.any help would be greatly appreciated.

Hallo guys!I have a good question about the if statement (pls look on the pictures). I wanna check if the line is the first one (with Count) then i set my s1=0, after that i want that the next s-value is s2=lenght(first line) and on the next line i need s3= length(first line)+lenght(second line). Its just a straight road so i just have straight lines. I have now the question how can i get the lenght from the last object to fill up the s-value from the next one? My next question is if i try the "if Statement" it include the word "xmlns" into the file and i have no idea why. I hope anyone have a answer for me. Thanks !

I have one line that express one bus route and would find the bus station within 375 meters. There is other transformer besides NeighborFinder should I use?