Transformers

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 function to convert in line but with no luck:"POSITION

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. 

from Standard timestamp example: 2019/03/12 20:18:04.600 to GPS seconds example: 245891.679754

I have a graded surface I've created (DEM file) and would like to visualize it in the App in the exact location it was designed in Civil3D . Is this possible?

Hi I have been using the NetworkTopologyCalculator in conjunction with the Aggregator to combine numerous individual lines segments into larger 'single merged' line segment with limited success.  I have noticed there are a few line segments that either fall short from touching and a gap can been seen or overlap. See image 1 below. The gaps are generally less than 0.2 meters.Image 1 Detail view of image 1 below:Image 2Having read a few threads on the forum I inserted the Snapper transformer, setting the parameters to Segment Snapping and the Snapping Distance to 0.2. When I inspect the data I can see that the gap has been closed.Image 3 I assumed that as the gap had been closed that the NetworkTopologyCalculater would have then included this 'connected' line segment into the 'single merged' line. Unfortunaltly it didn't. The image below shows that the majority (99 lines in total) of line sections have successfully been converted into a single line that all s

I've been using the GeoRSS reader to download data using FME Desktop.Once this task become a daily exercise, it was uploaded and scheduled on FME Server and worked fine. However, a couple of days ago it started to fail showing an XML parser error.54XML Parser error: 'Error at file:'C:\\Users\\P86357\\AppData\\Local\\Temp\\fmeengines\\VSW08446_Engine1\\FME_1580942504205_10336' line-1 column:13 message:attribute value expected'55attribute value expected56A fatal error has occurred. Check the logfile above for details While in FME Desktop, it provides warnings at the same point but continues and succeeds.2020-02-06 09:42:01| 1.4| 0.0|WARN |No extension handler could be found for an xml tag with prefix `' and namespace uri `http://www.w3.org/2005/Atom'2020-02-06 09:42:01| 1.4| 0.0|WARN |The GeoRSS specification only allows for one geometry per feed item. Items with more than one geometry will be returned with aggregate geometries I've tried using an

I have an input shapefile with many features that overlap between them. I need to create a new shapefile with many features as well, derived from this input shapefile, but without overlap features. For this, I need that the overlap features is converted to just one feature considering filtering by attributes of the overlap features. These attributes are related to the date inserted in a field, but should also be extracted accordingly . I mean, I need to extract a feature in overlap areas considering this order of priority (see path field): 201705, 201704.. ; if not exist, use 201807, 201805, 201806, If there are attributes equal (same month and year), use the most recent. An easy example in attachment to explain this better, Features of final shapefile should be merged if adjacent features are equal. IN the example final shapefile should have 3 features without overlap areas

Good morning,I am trying to come up with a way to generate lines where the starting locations are contained in one data set and the end points are contained in another data set. I have 19 "start" points and 4 "end" points; I need a line from each start point to each end point - So I should end up with 76 lines. Any guidance on how I should accomplish this would be greatly appreciated. I've been toying around with lists and trying to loop through them to create all the pairs of points that I need to feed into the LineBuilder, but I've been struggling with how to get it done. Thanks,Brian

Hello, I have a workspace that joins measures from lines to points using a neighborfinder, pointonlineoverlyer and measureextractor. The purpose of this is to identify the linear reference of each point along a line (ie distance along a line).Rather than do this separately for each point, is here a way of using a point cloud to append the measure for each point in one go and speed things up?Even though the points are in 3d im just interested in the perpendicular/plan reference.Thanks,Owen

Hi,I'm trying to convert 3D faces / meshes from DWG to Collada meshes to be used in 3D Studio Max. Moving data closer to origo with offsetter and 3D affiner both seem to work, but not quite. In collada all vertices reside in original coordinate system space (EPSG:3878) and only transformation matrix is being moved. Perfect situation would be that transformation matrices would be normalized to 0...1 space and each vertice would be near origo (few thousand units distance). Transformation matrices look like this in inspector; | 1 0 0 -24000000 || 0 1 0 -6800000 || 0 0 1 0 || 0 0 0 1 | and in collada;<node> <matrix>1 0 0 -24000000 0 1 0 -6800000 0 0 1 0 0.0 0.0 0.0 1.0</matrix> I'd guess normalizing transformation matrix to 0...1 range would solve this issue. Which translator is able to do that in FME? "Move to local coordinate system" in writer is not suitable in my use case.

Hi there,I use Python caller to run Python script in FME. Python caller reads the data and generates a new data frame (with more attributes) after performing calculations. Now I want to output the new data frame and do not display the old data (that is feeding as input to Python Caller). I am not sure how to do that. Any help would be really appreciated.

Hi,I am using FME 2019.1 and have encountered a strange issue with the Counter transformer.I am getting the below value being returned in the _count attribute for some but not all records. Just prior to the Counter transformer I reversed the orientation of a few records and I have found that for those records which are reversed, I get the below value output, but for those which are not reversed, I get a normal number output. However, when I pass only the reversed records through the counter, I get normal number outputs. It doesn't seem to like the combination of reversed and non-reversed records!@Value(__fme_ft_return_value112f8e69-4aa4-4f5f-9f81-f47c60797f64)Has anyone seen this before?

How would i use the RasterBandMinMaxExtractor to get the absolute min and max of multiple rasters? i see it writes it back to the raster, but I should already have this value, i think. It shows with gdal. I'm trying to normalize multiple rasters for subtraction and am very new to FME.

Hi there, I got crime data along with the date field. Now I want to calculate the Monthly average of crime data. For instance, Crime data for Janaury 2018, January 2019, and so on. Could anyone guide me how to do in FME?

I need to create a workspace that I can use to find groups (brands) that are wrong or do not fit with the majority of what is in my existing shapefile. For example: If 1000 Boston Pizza have group of 'Boston Pizza' and 5 have a group of 'Boston Pizza Restaurant and Bar' - then the logic should replace those 5 with the majority group.

I am trying to write to an Inspire GML writer using the Habitats and Biotopes xsd but I am not getting any geometry. If I preview the output from the last transformer I can see that the geometry is polygons:But the written GML just contains the attributes and no geometry.Does anyone have any clue what I am doing wrong?

Hi folks,This seems like a fairly simple operation, but for the life of me I can't seem to figure it out. All I need to do is move an existing excel file from one folder to a subfolder. (A subsequent workbench will run, regenerating a new excel spreadsheet in the original location.)I've read a few of the other answers, but none seem to have what I'm looking for. A few of them mention a 'Move' parameter in the filecopy transformer, but the only writer parameters available to me are 'Overwrite existing file' with options being 'yes' or 'no'. (Upon further investigation, the 'Move' parameter only becomes available as an option when file type 'FileCopy' is selected. If i select MS Excel as the filetype, then the 'Move' option is no longer available. Any ideas?

Hi there, I am trying to calculate the four date fields related to the start and end of the current and previous regulatory year based on the current date. The regulatory year starts from 1st of April and ends on 31 March of next year. So in this way current regulatory year starts from 1st April 2019 and ends on 31 March 2020. Here is my logic :Current_regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P9M),%Y%m)01,%Y%m%d)Current_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),P2M),%Y%m)31,%Y%m%d)Previous-regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P21M),%Y%m)01,%Y%m%d)Previous_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P10M),%Y%m)31,%Y%m%d) However, it does not produce the desired result. Current_reulatory_year_end and previous_regulatory_year_end produce null value, whereas the other two do not produce the right date. Could you please guid

I am working on a workspace that receives a list of previously unknown attributes and their values. They come as a list of attributes: '_list{}.Property' and '_list{}.Value'. These sets need to become GeometryTraits on an FMENull geometry. Usually I would use a GeometryPropertySetter to create those traits, but since it is unknown upfront how many features these lists contain, I want to use a PythonCaller to loop through the list and set the traits.  I seem neither to be able to create an FMENull feature, nor to set it's geometry name or traits. Can anyone help me with a working code snippit?