Transformers

I have a polygon (shp or minfo format) assuming it has an area of 5 square miles. Need to reduce the area by 70% resulting to 3.5 square miles now but still keeping somewhat the outline but of a smaller size (like polygon output shrinks) due to the applied percentage. SCALER transformer is closed to what I need but it only applies the percentage to the total perimeter of the polygon and not the area. Any transformer that could do this?

Hi,I need to calculate the least-cost path from a destination point to a source. In ArcGIS I use COST PATH based on the least-cost distance raster (by Cost Distance tool in ArcGIS).is there a way to do something similar in FME? is the Network cost calculator transformer appropiate?Best regards,Felipe Verdú

But I cannot find the proper way to do it here. I am sure it shouldn't be complicated but I am new to FME with thousands of questions. This is just one of them 😅

I am working with two datasets and I am trying to use Spatial fuzzy matcher to find if there is a similar name nearby within the mentioned distance in this transformer but wherever the fuzzy ratio is 1 it is not there.EG : here I am tryimg to find if there is 'Heavy inlet' in another dataset or similar string, it has mentioned its fuzzy ratio as 1 but there is nothing similar to this near or in the entire dataset.:

Is there a way to easily pull all of the SQL statements out of all of the SQLExecutors in a workspace? I have several automations that I need to do this for and some of them have hundreds of SQLExecutors in them.

Hi FME, I have a dataset with date/time stamps where I need to retain only the first occurrence in each hour, on a given day. For example: 1/1/2000 12:05 --> Keep1/1/2000 12:10 --> Discard1/2/2000 12:05 --> Keep1/2/2000 12:15 --> Discard1/2/2000 12:59 --> Discard1/3/2000 12:00 --> Keep1/3/2000 12:12 --> Discard Thanks for taking a look!

Hi!I have an issue that I just don't understand.  Using a FeatureMerger that outputs the correct attributes från the supplier, but it's values are all wrong. First off, I have a TestFilter with output ports depending on if the attribute "Version" is 0, 1 or 2. In this case the output for Version 2 contains 4 points with relevant attributes according to the image below. They are all "Version" 2 and have missing values for "Avslut-datum".Next, I want to use a FeatureMerger to merge this with a bigger database with hundreds of points, to assign the attributes of Version 2 to those said points, if they match. I want to merge the points from the bigger database [requestor] to the output from my "Version 2" [supplier]. See the FeatureMerger parameters in the image below.However, the merged data does not contain the attributes from "Version 2". For example the attribute "Avslut-datum" should be <missing> and the "V

Hello,I'm using a customized projection system that is exported to other official projection (Lambert 93, Lambert zone 2...) and I would like to run these transformation within FME. For ex, here are the steps going from 2154 to my custo projection:Prime Meridian Paris to Greenwich then:{LambertConformalConic: a=6378249.2 f=293.4660212936269 lat0=46.799999999999955 lon0=2.337229169999998 k=0.99987742 (inv)}{GridShiftTransform(NTv2:rgf93_ntf.gsb (Inv))}{LambertConformalConic: a=6378137 f=298.257222101 lat0=46.49999999999996 lon0=2.999999999999997 k=1 }{AffineTransform2D(ScaleXY(1,1) Rotate(0) Translate(700000,6600000))}How to define this in FME?

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

I have authored a workspace that creates bills for a lot of customers. The item price on the bill has to be returned with 2 decimals, so I take the mean of all the item prices and ceil the number to 2 decimals. Because of an occasional outlier I can't rely on normal rounding function.In the case below I have 1.173 measurements with an item price of 0,43. The min and max is 0,43 and the range is 0. But the mean value is != 0,43. And since I have to use the ceil function the price changes to 0,44. I understand this must be caused by the internal handling of 32 to 64 bit conversion, but in this case a seemingly very simple operations doesn't work. Why can't I rely on the mean calculation?What can I do to rely on it in the future? 

Hi, I'm running a simple workbench that converts a single dwg to GeoJSON. when I start the process normally in FME it works fine. But when I make a bat+tcl I see that the path to the dwg file changes and there is a "\\" missing between the folder (Linjedata) and the dwg file (T_E6SL_P00_f_C_E6-Profillinje.dwg) (AutoCAD Reader: Error opening file 'C:LinjedataT_E6SL_P00_f_C_E6-Profillinje.dwg' during version check) Is this something I can change in the tcl file? However, I got around this by putting the dwg file on C:, but then I only get a new folder with the same name as the dwg file with an empty file called "C" inside as the result, instead of a GeoJSON file. What I'm trying to achieve is just the same as when I start the workbench in FME, but run as a bat file.

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

I would like to output an excel template with one of the columns having cells containing values from a pick list.  From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.  However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

I have a CAD layer of control points which have two labels around it. I'm trying to extract the neighboring labels and add them as attributes in the final geodatabase. I have tried using NeighborFinder but it captures the nearest label only. I have tried to use a Tester to differentiate between the two labels and then run NeighborFinder but it leads to multiple records. The red circled is the control point and orange circled are the labels.  How can I capture the attributes and have 5 points in the output rather than duplicating them? 

Hello every one,I have a cad file with lines and block on to on them.The block have some attributes, and one of the is Length.for some reason, there are a lot of blocks that instead of having the length properly, it have #### marks.I tried to fixit of course with FME, I managed to recover the length from the line which the block is belonging to, but- when i'm writing it to dwg, it is get mess again!I tried to use Attribute Output in the writer definition, 'Inserts' or 'Limited' got the right length number, but they destroy a lot of other definitions in the cad file.can someone please help me?I'm attaching here small sample..Thanks!

Hi, I am trying to asses assets that are in CAD and not in GIS. Using the Spatial filter or the SpatialRelator i am getting results of one to many. I.e. the results are relating one candidate to many filters. What transformer can i use that only spatial joins one candidate to only one filter? Please help!

I am trying to select a polygon located in between other polygons. All polygons are saved in the same layer. Either NeighborFinder or AreaOnAreaOverlayer do not provide the result I am after.

Hi, I'm encountering issues to connect to an sFTP server through a proxy.With my ftp client I'm able to connect with the following configuration.But I don't know how to configure my FME Desktop environnment and FTPCaller transformer to access to it.Here is how I tested it.Configure proxy settings on Windows Configure FME Desktop environnementConfigure FTP CallerI have the following error See log file attached.I alswo tried with pythonCaller but I didn't yet figure it out. Any tips to solve my case ?Thank you,

Please appreciate if you could let me know in details