Transformers

I was told the data  "44821.76657" is the elapsed days and time since "1 Jan 1900"

I'm attempting to use relative dates, however I want to exclude data that was modified "Last Friday" where today is "Monday", however I can't see any documentation at what acceptable relative dates there are and what they actually mean (i.e. if today is Monday, does "Last Monday" return as today or the week before? Or does "next Monday" return as today?)?

Hi,i read a postgis table with the feature reader. As a WHERE clause i want to filter on a certain criteria, say: name_community IN ('Comm1','Comm2','Comm3') I would like to allow multiple selection. Therfore I have choosen the type of parameter "choice" and a list with multiple selection. The name of the parameter is "_community". Now , I thought: name_community IN (%(_community)) However, this does not work. Any support would be appreciated.

I have a workspace where I gather the data from the web and upload on data base whenever data available my script run and load the data on the database with truncate.  now the issue is on the source table remove the data until new data is not availableso when I run the script the feature reader shows me nothing. so how can I truncate as well until new data is not available?   as you can see Advisory Wind don't have records from source so if there is record i need to truncate my table  

I'm struggling with a date that I want to extrapolate based on a frequency. The maximum latest date is the end of the year.My columns are:routefrequency_daysdate_startHow can i realize this in the right way?

I am able to use a python scripted parameter to get the list of field names/attributes and they do populate with the scripted parameter as expected, however, when the scripted parameter is plugged into a FeatureReader to expose attributes, it fails. Example:Scripted Parameter Name: $(scriptedParameter)Returns the value of:OBJECTID COMPONENT SITE_NAME JOINT_BASE STATE_TERR COUNTRY OPER_STAT IS_FIRRMA SE_ANNO_CAD_DATA SHAPE_LENG Shape_Length Shape_Area However, when using the same scripted parameter in the FeatureReader Transformer - Generic Port - Attributes to Expose, the result is missing values in an attribute called $(scriptedParamter) (the same name as the parameter). If I hardcode the value of the parameter to my list of attributes, things work fine. Is this a bug with the FeatureReader transformer, or do scripted parameters not work in the FeatureReader Transformer - Generic Port - Attributes to Expose?

I have thousands of JSON files, containing metadata. Although these all metadata are not relevant, hence tried to filter out only relevant data using test conditions. The problem is that the JSON file structure is a bit inconsistent.For example- I want to extract "Roll" data from JSONs and when exposing the attribute through the "Attribute Exploder" transformer, it shows data varies widely from one JSON to another (see the below example)metadata{20}.metadata.rollmetadata{43}.metadata.rollmetadata{45}.metadata.rollmetadata{52}.metadata.rollmetadata{106}.metadata.rollmetadata{844}.metadata.roll etc. etc. Now I am trying to find the "Roll" data using test condition within the "Tester" transformer (see below example) I know, this is challenging to find the desired value if the JSON structure changes from one to another. I am trying to find out an easy way to use the test condition. Not sure which expression can show a range of the values within cur

Hi forum Looking for a bit of help with the using the HTTPCaller to query a polygon area on an Image Service. PointsI’ve got the DTM image service from the Environment agency, which I’ve been using to extract the DTM height value for certain points. I’ve been using the “identify” function through the HTTPCaller in FME, and then some JSON extraction to get out the height value. All great and working. PolygonsI’ve now got some polygons, and I want to find the lowest height within the polygon footprint (added bonus, maybe also the lowest point on the perimeter too. Not essential).Looking at the ESRI documentation you can do Identity with a point or a polygon, but I’m getting a bit stuck on the polygon.For the points data I tested in service identify window, and then copied and pasted the query from the URL into my HTTPCaller and then amended it to take XY attributes etc in FME.I tried to test for a polygon by inputting a list of coordinates in here and swapped the type to polygon, but I g

I need to remove duplicates from varying sized datasets. Would it be more efficient to use a sorter with a sampler or a statistical calculator with a tester?

Looking at this article writing using the XSD XML Writer: https://community.safe.com/s/article/XSD-Driven-XML It seems that it is not possible to nest features together using xml_id and xml_parentid and having multiple features to write. For that example I want to be able to have two featurewriters as shown below, the cap:alert and the cap:info. The way they are grouped together is that the cap:info has an xml_id and xml_parent_id which links it to the correct cap:info. I thought that woudl work, but no.... Is there no way to write complex nested xml-features other than "merging them in the workspace"?

I would like to replace the content of one node in XML fragments (SLD/SE), which I import into FME. I merge these fragments to other features with the values for the replacement and want to do the replacement for each feature.With the XMLUpdater that seemed to be an easy task. Nevertheless, using the configuration as shown in the attached workspace, the contents of the node allways gets replaced by the value of the last incoming feature, not the value of the feature with the corresponding XML fragment. I read a lot of articles here in the FME community but could not find out what I am doing wrong. Do I missunderstand the function of the updater?

The tolerance in TINGenerator does not seem to do anything? I have a workspace where a geotiff gets converted to a pointcloud for some processing before running through a TINGenerator. I have tried values between 1 and 1000 but it always outputs the same amount of VertexPoints. Only thing that makes any difference is if I set the value to 0, then the amount of vertexpoints get multiplied by a million. In the same workspace I also use a PointCloudCombiner. Where the value of the point interval does not seem to make any difference. Does the workspace need to be set up in a specific way in order for the above to work? Or have I just missunderstood what the values are supposed to do?

I have a pretty complicated model which has many input data sets, transformers and lots of intermediatary data. I need to write a summary of the statistics at the end of the procedure including total area of results, proportions and ratios taken from the data. Which Transformers could I use to select or create statistical summaries and write them to text?

I have stumbled across a raster size problem in RasterExpressionEvaluator whereas two input rasters are clipped using Clipper to the exact same shape, however some of them upon arriving for raster calculation differ by one pixel.The problem is that although all input rasters are of different sizes only some in several hundred will result in this error quite randomly despite use of clipping that should cut them precisely to same size.|ERROR |RasterExpressionEvaluator_2(RasterEvaluationFactory): Raster A has '2119' rows and '2042' columns, whereas raster B has '2120' rows and '2042' columns. Paired rasters must have the same dimensions

Hello, I have a line file that I need to divide into 5 mile sections. At each 5 mile point, I need to create a perpendicular line off to the left side of the line. I need this line to be certain lengths or be able to divide the line into sections afterwards. I need to then export the coordinates of each vertex along the perpendicular line. Please see my drawing what I'm looking to create. I need the coordinates of each location where there is a home placed on the drawing. Thanks!  

Hello Somehow there seems to be a problem with the WorkspaceRunner and privateParameters in the Workspace, that should be run. .. (I use FMEDesktop 2022.1) I get this error-message:Undefined macro `Pfad_MGDM_Files' dereferenced in file `I:\\AGI\\Geoinformation\\Produkte\\GDI\\Themen\\A021 Laermempfindlichkeitsstufen\\c\\etl\\wb-xlate-1668001125589_14180' > the Parameter `Pfad_MGDM_Files' is a private parameter in the Workspace to be run, and I use it, to concat a filepath. A private parameter should be of no interest to the workspace with the WSRunner...? I attach the workspace below. Thanks in advanceVera

I am using the attribute manager to remove fields from my schema that I am writing into an Esri file geodatabase. I am finding that the fields are still present in the new feature class that is being generated but now have null values.  Is there a way to do this?    

Hello,I have the following command ""\\folder\python.exe" "\\filepath\test.py""that run perfectly with FME desktop.When I try to run that ETL on FME server, I have the following errorSystemCaller: Failed to Execute `""\\folder_path\python.exe" "\\folder_path\test.py""'I check and FME Server has the read/write permission on the folder folder_path.How should I proceed to fix this?

Hello, can you help me? I have .las format cloud point as input and I want to get buildings with roofs?

Hi, I wanna test if geometries are within an given area, I found the Spatialfilter transformer, but it doesn't work as expected. Geometries that i'd like to test were set as Candidate, the area as Filter and Tests to perform to Within. But it does not test for candidates within the filter, instead it tests if the filter is within the candidate, which is not what i want to achieve. Do you have an idea what I am doing wrong, or what I can change to make it work? I am using FME Desktop 2015 thx & br,mel

I've created a functional workspace based on the wonderful ArcGIS Indoors to IMDF template; Even got a reasonable IMDF dataset successfully written!  In my ArcGIS Indoors model, I don't have any data in the "Sites" feature class (IMDF: venue.geojson) but it's handled in the workspace (thanks!). A little massaging of my source data solved that problem! Unfortunately, I have address data in the ArcGIS Indoors "Facilities" feature class. Since the venue.geojson and building.geojson both originate from "Facilities", and there were two rows in Facilities, this results in multiple (3) entries of the same address (okay, they have unique address_ids). I'm new to FME -- so, I tried a few things (i.e. adding a "DuplicateFilter" but then realized I don't know how to get the respective address_id further downstream).I was thinking of "FeatureMerger" (?) but it seems really magical and I can't quite figure out how/why it work

I want to get the Start, Mid and End point from: 1. A line dataset (Roads)2. A polygon dataset (Roads) What is the easiest way to process this? (The polygon dataset is in the shape of roads, so looking at the start, mid and end point of the road as we see it!)

Ok, I know this is something dumb, but rather than beating my head against a wall I figured I'd ask for some help! I have a vector data set that I am converting to a raster. No problems there. The issue I am having is each vector polygon has a value set. I want to pass the value to each raster pixel (30X30). When I use any of the vector to raster converters (mapnik, image, or numeric) rasterizers I am getting the same single raster without the values being passed. I attempted to group the features by a GUID, and value but that just created 700+ separate rasters. Any ideas on how to pass the value field to each single pixel would be appreciated. I've attached a sample of the clipped vector data.

I have 10 long/lat coordinates, 1 in each column of a CSV file, with the headers listed as follows: Y1, X1, Y2, X2, Y3, X3, etc. The final two coordinates mirror the first two coordinates, so that the shape is closed. I am new to FME and am attempting to create a polygon from this CSV file and would love any guidance offered. Thank you.

Example  Name | Try 1 | Try 2 | Try 3 | Try 4|  Tom| 3  |  6  |  0  |  2 | Bob | 2  |  7  |  1  |  6 | Kat | 1  |  8  |  1  |  3 | Export  Name | Try | Highest Score Tom | Try 2 | 6Bob  | Try 3 | 7Kat  | Try 2 | 8 Much appreciated