Transformers

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

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

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.

How do I translate a folder containing multiple .mdb(s) to a new folder creating .dwg(s)? My problem is the translation I have setup merges mdb(s) into one output dwg. How do I change it to read multiple mdbs and write multiple dwgs?

Hi all,  I have been using a workbench to read in a geodatabase and clip the features to a particular extent then export out to a DWG. However the requirements have recently changed and we need to split the DWG output into multiple smaller files based on 1km tiles. So here is what I am trying to do essentially. Take the geodatabase, use a grid to split the geodatabase features into individual tiles and save each tile as a seperate DWG. So NZ4920, NZ4921 etc. I feel like this should be quite simple to do but I can't find how to do it. One long workaround would be to use the 'clipper' transformer for each individual tile, which would give me result I want but I would have to do this for about 100 tiles, and I am sure there is a more effecient way to do this.  Any help is appreciatedThanksDan

HiIt seemes to me that I Can't find "Format attribute set: powerpoint_hyperlink" under the powerpoint styler transformer.I need to add a hyperlink in a powerpoint slide. Under the help text, it states that is one of the parameters.I am using FME(R) 2019.1.3.1 (20191019 - Build 19643 - WIN64)Best regards,Felipe Verdú

Hi there, I am calculating cumulative sum using one of the existing posts (https://knowledge.safe.com/questions/104692/running-total.html?childToView=104693#answer-104693 ). However, the problem is that I wanted to calculate the cumulative sum based on the regulatory year (1-4-Year to 31-3-Next Year). The Problem With the approach I have been using is it started cumulative sum from the start of the dataset. Is there any way I could calculate the cumulative sum based on the regulatory year.

Hello !I'm looking for a way to spatially sample a set of points (not a point cloud) in FME.I want for the dataset on the following picture that all points must be a least a 10 meters from another one (by deleting the ones that are too close) because I have a too high density of geometry.There is the "sampler" but it works on random selection and not on spatial constraint rule...I've found a homemade technique to achieve that on the principle of the use of a succession of regular grids, spatial filter and counter to filter and delete some points. But the problem is that require a lot of time to run on large areas and it's not really optimized. I think there is an easy way to do the sampling operation on this type of data but I didn't found it (like we easily do it on point cloud). Do you have an idea of how can I proceed? Is there a specific transformer to do it ?

Hi There,I am using the JSON templater to create various JSON outputs. One of them is them is "Position" which consists of two decimal / float values - XCOORD and YCOORD. I can use either of the following to output the values:"POSITION":[fme:get-attribute("X_COORD"),fme:get-attribute("Y_COORD")] OR"POSITION":[fme:get-list-attribute("_XY_LIST{}.XY_List_Creator")] (this is a list I have created with the co-ord pair)The issue is, that my JSON schema expects the "POSITION" value to be a numeric JSON array, but no matter how I write out the XCOORD and YCOORD values, it always appears as a string eg."POSITION" : [ "515000.00", "188000.00" ]I've made sure the individual values are indeed numeric. Right before the templator they are coded as UTF-8 - not sure what it is doing to convert it to a string.i've even tried using a Math functio

Dear FME community,I have a CSV file containing points (longitude and latitude for properties) and a neighborhood shape file containing nested polygons. There are three types of the polygons from the smallest to the largest: Sub-neighborhood, Neighborhood and Macro-neighborhood.I would like to join the points to the polygons and append only one polygon ID to each property. If a property falls within multiple nested polygons, I would like to get the ID from the smallest polygon. For example, if a property is in a Sub-neighborhood which is nested in a Neighborhood, the Sub-neighborhood ID should be appended to the CSV file.Currently, I am using the PointOnAreaOverlayer, and I always get the IDs from the largest polygons when there are multiple polygons matched.Which transformers should I use to always get the IDs from the smallest polygons (based on the polygon type) when there are multiple polygons matched?I appreciate your help.Thao

Hello! I want to make a filter for those lines that intersect a point. The lines know which point they intersect, but some of the lines doesn't insersect physically the lines. For those I want to make a filter.

 I use the RasterGeoreferencer with the Option all 4 Corner Coordinates to Georeference. I export the map from ArcMap to PDF. The PDF has a part with Raster Data and a Part with Vector Data the same way as the Picture above. The Red Points are the Coordinates that i have (means i make a Bounding box and then a coordinate extractor list exploder) and after the RasterGeoreferencer the PDF has the shape of the Vector. Its squeezed together.Is there a better way i can automatically georeference the pdf?Can i export only the Vector Data from ArcMap?Any idea's would be helpful.