Transformers

Hello All,I have 2 polygon MapInfo files - land classification and farms. I want to update columns in the Farms table with the classification/s in the Land Classification table where they overlap. I can't work out how to do this as there may be multiple (though not overlapping) classification polygon areas for each Farm, so I want to update the % overlap for each column - Grade 1, Grade 2 etc. I can produce separate files for each grade, but not then update columns in the master Farms table.Any help would be much appreciated.Thanks,Jane

Hello every one. I have a folder with 700 .tiff raster files (images) and a external orientation text file with 700 rows of ID (name of the raster file), X, Y and rotation of the center point of each raster file. How could I convert all these in to geotiff? How do y manage to relate each row of the text file to its raster file? After this is solved I gess it should be easy to georeference them with the rastergeoreferencer...

I have a huge set of polygons which I would like to group by connectivity in FME 2016. In the following is a simplified example with a set of polygons where I would like to end up with three groups:I would like each polygon to afterwards have a group_id or similar describing which group it belongs to.This is easily done using a Dissolver, but with an increasing number of polygons the dissolver seams like a very expensive process and I feel like this could be done in a less expensive fashion.

How to configure 2 engines one is with 32 bit and another with 64 bit in same fme server

Hello,we have some trouble running FME Server (2017) workbenches. Italian characters are interpreted using Server system configuration instead of the italian one. Is it enough to include in the "environment" section of the fmeCommonConfig.txt file the LOCALE=it_IT ? Other configuration needed? ThanksRoberto

See image below, my z value that I need to pull with the contours in this DWG are here (circled): How do I expose the Z value circled (and/or the rest of the coordinates XY) in my workspace from a DWG? I can see this in inspector. I'm converting the contours to GDB.  

Hi,  I want to do a geographic analysis on height. Some cell values however are filtered out because of trees, etc and set to No Data. For this reason I want to change the no data values(brown) to the average of surrounding band values (green). I tried using the rasterConvolver, without success. Also I tried all these steps (https://knowledge.safe.com/questions/3796/fill-raster-nodata-values-with-minmaxaverage-value.html ) , also without luck, since I guess it requires a more profound understanding of FME.   Any help much appreciated!

Hi, actually i have the data worked in tm that was converted into utm. i have created the projection https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Create_Form.fmw using this link.but i dont know how to assign coordinate system for my projection.i need to idea about how to create projection and how to import the coordinate system for the corresponding projection. here i had attached my prj file. i have my dat abased on this projection.i need to convert into utm. 

Hi there, I am calculating two new fields in Python caller. When I tried to set those attributes, I got an error message of "Python Exception <TypeError>: Could not convert attribute value to a supported attribute type." Here is the part of my code:self.df2['Normalized_SAIDI_DPP2'] = self.df2['SAIDI'].apply(self.normalized_SAIDI) self.df2['Normalized_SAIFI_DPP2'] = self.df2['SAIFI'].apply(self.normalized_SAIFI)newFeature = fmeobjects.FMEFeature()newFeature.setAttribute('Normalized_SAIDI_DPP2',self.df2['Normalized_SAIDI_DPP2'])Datatype of self.df2['Normalized_SAIDI_DPP2'] is string. I got an error message on the last line. Could anyone guide me where am I making the mistake? 

Hi! There are multiple tips on how to solve this issue. I think I have tried them all, but just to document and see if I have skipped some part.Challenge: You get the error message when trying to run an RCaller:2020-02-04 08:36:56|   0.6|  0.0|ERROR |RCaller_2 (InlineQueryFactory): Failed with exit code 1 when executing R script. Output was: Error in library("sqldf") : there is no package called 'sqldf' Solution1. Check if sqldf is installed correctly:Do:Start cmd.bat / command line in "ADMINISTRATOR MODE"Navigate to where R is installed and the 32 or 64-bit R. Same version as your FME (I have 64-bit): C:\Program Files\R\R-3.6.1\bin\x64run R.exeRun and select your closes mirrorinstall.packages("sqldf")The reply for my pat is:> install.packages("sqldf")Installing package into 'C:/Users/XXXX/Documents/R/win-library/3.6'(as 'lib' is unspecified)--- Please select a CRAN mirror for use in this session ---trying URL 'https://cran.uib.no/bin/windows/contrib/3.6/sqldf_0.4-11.zip'Content typ

Hi there!I'm trying to get a Regex search and replace going but my poor regex skills are letting me down. I'm trying to obtain the first 3 (or 4) digits in an existing attribute string and into a new attribute using the StringReplacer but can't get the right formula. I only want the first set of numeric values.PS. I'm sure this can be done in a single AttributeCreator transformer using a string function too? Any help would be appreciated!

Hi there, Is there any way to calculate which month to come between two dates. I am using the date time calculator to calculate the number of months between two dates. However, I am interested in finding which Months lies between two dates. For instance, between 20-2-2020 and 1-4-2020, March (03) comes. Is there any way of doing that in FME?

Hello all,We have a DWG that contains a dashed font I have been able to source a True Type Font that has been set-up as a dashed font but FME does not like it for some reason. The font reads fine in AutoCAD and MS Word but I get the error "INVALID_PARAMETER_FONT_NAME" when trying to process it through FME. FME is able to see it in the fonts list when using the PDFStyler Any ideas as to why FME is not liking the attached font.

I am new to FME and note that I can't see the display control window in FME Data Inspector 2019. How do I turn it on - thanks.

HelloI have four records in a workbench file with two column containing coordinates. They are of the type:(column 1): 56° 05.702(column 2): 012° 28.757When I try to use a VertexCreator (add point) on them they are rejected. How can I convert them to something usefull and/or how can I derive coordinates/points from themThanks

Hello everyone,I have a little problem with the densitycalculator transformer.Here are the details : - I want to have the density of a road network into a 1000m*1000m grid- I've followed the documentation of the densitycalculator transformer and I don't have any results (all the densities are set to 0 in my results)- I also made a "group by" into the densitycalculator to have the count of road density for each cell of my grid... Do you have any ideas to help me ? Thanks ! :)

I have a sphere geometry floating in the air. When using CE and CPE (both options Boundingbox and Gravity produce the same result), I end up with different XYZ coordinates, with CPE being apparently correct. Why does this happen?  Edit: furthermore, when I use the Offsetter with the CPE-Coordinates to offset the sphere as well as the coordinate to 0/0/0, the sphere doesn't move to the expected spot either. See screenshots:(transparent grid: Hub3DBufferer) 

Hi FMEUsers!I wanted to know if there is any transformer or workaround to switch/modify directly one or various pair of X,Y coordinates from a polygon with new ones, so, the polygon should be reshaped based on that change.Here is an example:  From the selected polygon, the current vertex from the Polygon (green arrow) would need to be changed, with the X,Y from the Point (red arrow).  I'm wondering what should be the smartest and less consuming way to build that?... Imagine launching for thousands of Polygons... Thanks!!Btw, I'm using FME2019

Hi there,I am trying to calculate cumulative sum of an attribute for each regulatory year. I am using a statistic calculator for calculating cumulative sum. However, I noticed that statistic calculator does not give the right result. It calculates the total sum of an attribute over the regulatory year and shows it on every row. For example, the value of the cumulative sum of an attribute on the first day of regulatory year is same as the value of the cumulative sum of an attribute on the last day of regulatory year. I am using FME 2019.1. Any help to fix the issue would be really appreciated.  

Encrypted PDF field in SQL Server table

Hi all, I'm working on an FME workbench for a client that will be run on their FME Server.Some background:They are running 32-bit Server Engine on a 64-bit Windows box, so I know that it's limited to 4GB RAMThe datasets we're using are pretty large, with around 3-3.5 million records being read in between the 5 different readers (the largest reader takes in 1.8 million)All but 63.5k of the total are Esri point geometries with some attributesAll datasets must be read in their entirety by nature of the workflow (we can't break it up into smaller datasets with sub callers)I have FME_TEMP set to a folder in a drive with 58GB of free spaceSpeed is secondary - we need it to run, fast can happen laterI don't have any user permissions on the FME Server box - I can't edit files, I can't rename files, delete files, move files, NOTHING, so I'll have to pass any recommended changes through my boss who does have full permissions.I'm getting two major problems (whe

My apologies for the confusing title. I'm looking for a way to have FME return an area that is covered by one polygon feature but not another. This is for checking coverage of collected data. I have included a screenshot for reference. I've tried a few transformers already but none of them return the void area. Any help is much appreciated. I'm looking to get a return area feature of the "triangle" seen above.

I Transform IFC Model to Shapefile using FME Workbench. After, I insert shapefile in ArcGIS Pro some of the features are lost and also I can not project my model in target location. Look in image I uploaded where walls and roof are missing. Please Help me.

I have text input that are comma seperated like this:1000,6617598.796,1468321.754,128.660,62And my desired output should be tab seperated but I dont succed doing that with StringConcatenator.It should be pretty easy =)I am attaching a zip with 3 files1. "Text_in" ( Input file)2. "Text_out" ( FME generated output file)3. Correct desired output "correct_output."4. A FME template with the input file with some annotations. 

Greetings, new to FME. Using UTMZoneDetector transformer on input point KML to extract the <utm.coordsys> attribute, Passing that attribute into a Reprojector <destination coordinate system> being used on a separate line feature class. Problem having is that, internally, a record from KML is being inserted into the table/1st row of the line feature. Input line FC starts with 573 features, after Reprojector 574 records, check in Inspector, and first record in table is ~OGCKML (but check FC in ESRI, still only 573 and successfully re-projected). Anyhow, that first record on the internal FC (if you will) wrecks the workflow later when trying to run a Clipper transformer and first record is a non exist ~OGCKML that reports in the Inside bin and the other 573 records end up in the Outside bin. . . Any insight would be greatly appreciated.