Transformers

Dear altruist, I have a datasets of soil moisture values in array system. So, for each grid cell, I have values for each day for certain years (image 1 shows the structure of array). However, for some cells we have consistently a constant value ( e.g. 1). For these cells I have to recalculate the soil moisture based on the average of neighboring cells as per the formula in the second image. I have tried with Attribute manager and conditional statement in setting values, which is not sufficient to do this job. Can anyone kindly suggest and explain how conveniently it can be done in FME? 

I'm not sure whether this is a bug or not. I have a number parameter configured like this - However, there seems to be some sort of floating point issue when accepting a value at input -A few weeks ago this was working fine on the same machine running the same FME server version. Not sure if anyone knows what could be causing this?Thanks

I'm creating a cruciform for biodiversity monitoring and I'm having trouble setting the distances from the centre. I need to do this for 50+ areas so it would be good to get some batch processing going.The inner nodes start at 5m from the centre. From then onwards, they are set at 10m intervals. Each arm of the cruciform is 45m long. So there are five nodes on each arm resulting in a 90m total length on the x & y axis.Node labels are as follows: 5m, 15m, 25m, 35m, 45m.The problem is, the southern, eastern and western arms are showing the distances backwards i.e. 45m label starts at the inner node and the 5m label is at the outer node.The workbench works as follows:Calculate centre point of areaCreate vertices around centre point so LineBuilder can create 4 x arms of cruciform( N,S,E,W)Create points on lines using DistanceMarkerLabel points based on Counter The northern arm always seems to come out correct so it must be something to do with line/point orientation. I have tri

I have got 8 coordinates and I wanted to extract mid-point / center point that has XYZ of EACH side of surface of 3dCube .  Please highly obliged with your help or input  

I would like to select only tables with certain strings in their table names when running a FeatureReader. So something akin to:WHERE TABLE_NAME LIKE '%searchstring%'Is this doable? And if so, how?

I have a large data set that has been read from multiple autocad drawing files. At the current stage each feature has an attribute "project_num". There are many feautres (usually lines) for each project_num. I would like to get this down to a single "centroid coordinate" (preferably center of gravity) for all of the lines from each project_num.  CentrePointReplacer will generate a single point for every feature.I tried FeatureMerger but am having problems. Both the Supplier and Requestor are set to "project_num". I have set the Feature Merge Type to geometry and checked "process Duplicate Suppliers" (build polygons) but get the same number of merged features as the input. If I use the "group processing" option, I still get the same number of merged features. My current workaround is to use the DuplicateFilter before sending it to CenterPointReplacer. I have also tried creating a point cloud from all the resulting CenterPoints and

Hello, See picture below for example, I wish to remove the green vertex while ensuring that the end point vertexes remain.  I need to remove these as they are treated as being stacked, which is causing major issues with my ESRI Utility Network Model.  These points are within < 0.001m of each other. I have tried using a generalizer, which is not appropriate for this situation, as the lines become much too generalised. I wish to only remove these vertexes that are treated as being stacked upon each other.  I have also tried using the geometryValidator -> issue to detect: remove consecutive points without success.  What other ways can I remove these points? I have thought about creating a custom set of transformers that could do the job, i.e. Find all vertexes -> identify any vertexes that are connected to other Line st/end points or any devices (as I want to keep these) -> find vertexes that are within 0.001m of each other -> single match these -> output. Although with

I'm currently using the 'change detector' transformer to compare incoming data with an existing database, and my challenge is that the comparison always seems to spit out the features as being 'updated', even though I am testing by comparing essentially the same exact datasets, so I expect it should be exiting out as 'unchanged' instead. The inputs are coming from a Portal feature service and a geodatabase When I toggle the 'Check geometry' off, it seems to work correctly and detect the features were 'unchanged', so I'm guessing it's some slight changes to the geometry that may be causing features to be seen as 'updated'.  I'm already using the 'coordinate rounder' to alleviate some slight variations, but are there other approaches I can try to help figure this out? Thanks!

I have a network of (electricity) lines (306 in total) and with Neigbourhoudfinder i determined what line is collest for all 800 proporties in a small village. It gave me and x and y coordinate on the line. Now I want to determine a total value per line (values of all properties that have an x and y coordinate) on the line. How can i achieve this?

Is there anyway to configure the StatisticsCalculator on a dynamic set of attributes?I would like to generate a histogram of attribute values, where the attribute name is determined at runtime. Bonus if I can process multiple attributes at once.

Hello FME'rs,  What I'd like to do is intersect two line feature classes to produce an intersection POINT output feature class.    This is a relatively simple task to perform in the Arc geoprocessor (overlay->intersect).  However, my first few attempts with FME (using lineonline overlay) doesn't quite yield the results I want as it appears the give me the intersection points as well as ALL the start/end points of the intersecting line segments.  Can someone kindly point me in the right direction?  Thank you :) JP

For a school assignment I am trying to make a functional FME model. As topic I chose the electrical grid. I chose a village were there are 8 transformation stations and about 300 different line segments. For alle 300 lines I determent which transformation station is closest.  I know want to number the line segments that "belong" to the same line. e.g. a1 to a10. Is that possible?

How do I set the coordinate system of a dynamically created empty feature class (polygon) in a file geodatabase? I store dynamic attribute names and data types in a spreadsheet, import those into an AttributeCreator > then create the empty feature class using a FeatureWriter, but the output feature class says coordinate system is 'Unknown' when I open it in Data Inspector. 

hi everybody... I'm doing 3d visibility analysis. I have points data and dem data as in the screen image. I need to do an analysis for each point and I need to save all visible areas as a single shp...can you help me please

I'm interested in using FME to connect to a number of remote hosts to run a few command line commands, and returning the results back to the workflow for further processing. The remote host devices are network elements running an abbreviated version of Linux. Can PythonCaller be used for this purpose? The SSH connection must be completed through an intermediary "jump box". Any ideas will be appreciated.

I have hunted through docs but am struggling with dates. I can't do date comparisons in the InlineQuerier (see q linked below) so need to change dates to integers to compare using SQL, but can't figure out how to do that. I also want to be able to convert dates to months for comparison e.g. testing 15 September 2022 vs 30 September 2022 should return TRUE. Still new on the FME journey and any help much appreciated - or a pointer to docs. Thanks, Philip Q. on dates in InlineQuerier using SQLLitehttps://community.safe.com/s/question/0D54Q000080hMJ7SAM/testing-for-between-dates-supplied-by-external-file

Hi, at the FME UC last year there was discussion about a the potential to create a Custom Transformer and in the process consume a swagger/OpenAPI definition. I've been looking at the FME Transformer Designer in the FME 2023 beta and so far I can't see anything which would indicate that this is doable.  Am I missing something? anyone else know anything more about this?

I am going through a list of CAD files, how to keep running the workspace even if it hits an error?

Dear Sir/ Madam, I have two indoor map data. One is the indoor network for the entire floor. Another one is the POI (My interested points A & B). I would like to use ShortestPathFinder to see if the network is routable.  However, I am not sure why I am not able to use the "ShortestPathFinder".  My ultimate goal is to check all my POI points are routable. Could someone please give me a hand? Since I cannot upload the zip file in this forum. I have upload my data on Google drive. https://drive.google.com/file/d/1nYZaHHyXM6DhMzfH_abuBgPPtc55Jpkk/view?usp=sharing Thank you and I am really appreciate your help.  

Hello,is it possible to write an Excel file to a SharePoint site? I don't believe I wish to create a SharePoint list or a lookup but simply overwrite an existing file in a folder sat in SharePoint.I can read a file from SharePoint in just fine using a Reader and just need the equivalent to 'write' I have tried the SharePointOnlineConnector but it's not outputting a file like I would expect.Thanks.

I was surprised using FME 2021 in BATCH mode to find, that DataInspectors (which were active by mistake) wrote all their data to FME_TEMP, and to make it worse the data was NOT removed afterwards. This way my FME_TEMP got filled up with 250 GB of trash and broke my workflow due to lack of disc space. Is this supposed to be normal behaviour lately, or is it a BUG ?Remark: I use Windows 10

Wondering how the schemaMapper can replace the field name for 165 Census fields within the Attribute Manager environment? Seems the examples require remapping the entire list? Is this kind of like a tabular Join in GIS?

I'm trying to load a vector tiles from the URL below but keep getting workspace generation errors. Can anyone tell me if this is possible please? I'd like to load at z=14 for the area of England and then merge the tiles into a single file to save locally.https:\\t1.mapstack.org\tilesets\trees-lidar-2022-ds\tiles\{z}\{x}\{y}.pbfMany thanksRob

For a studie assignment I was free to choose a topic and I chose this. At the moment I have (shp) files with:Property data (e.g. how much solar panels per property with how much WP)Electrical Grid (for the area of interest I have all grid lines - like a road network. Not included are the lines to the properties themselves, but the lines that run under the sidewalk in a neighbourhoud).Transformation Stations (on the gridlines there are a number of transformation stations that are connected). For each property I want to determine a point on the grid lines where the would be connected. And If I have that point I want to determine which transformation station is closest. I thought about LRS and Network Service Area, but after a few night looking for clues on the Internet and trying I have been able to figure out how to start.  Is there someone who can give me tips on how to start en proceed? I have only had a basic leasson in FME and I am having a hard time finding my way. Any help is app