Transformers

Hello FME community, I have a long number (see the picture). I want only up to 3 decimal places to be displayed. Thanks in advance for your help 

Hi folks, When working with XML files, often I find it really usefull to be able to use the XSD reader to directly structurize the XML in FME feature types, AND to be able to use the known XML schema to generate the correct schema (attribute names, list elements, data types etc). However, when working with the XSD reader, I noticed something peculiar, which I think might be a bit of a bug.  The thing is, when you select a feature path, FME will generate a feature type with all attributes/lists that are contained at that path.What I think is quite nice and usefull, is that when you select both a feature path and a subpath of that feature path, the attributes/lists that belong to the subpath, are not included in the feature type of the parent path.  So in my case, when I select only 'msg:GMW_PPO' for the feature path, the feature type contains all contents of that feature path, including a list attribute for the subpath 'msg:GMW_PPO/msg:monitoringTube'.If however I select

I have a layer with 75 parks. I need to buffer all of them with 300 meters. But after this I need to clip the buffers with roads and railways(barriers). When I done this I only want to keep the polygon that are on the right side of the road. Sometimes these areas intersect an other park. So if I go for spatialfilter areas are kept even though they should not be. On the pictures below I only want to keep the selected polygon(yellow) because that polygon are intersected of the orgianal park. I've tried group by i spatialfilter but get no success. Is it possiable to solve this? Have attached my workbench with orginal data.  best regardsJesper

I have a SQLExecutor that runs fine on Desktop but does not output any results on FME Server. The Server log file indicates that the SQLExecutor created results but that they are not being output to the downstream workspace. Any idea why Server might be behaving like this? Here's some log output from Desktop:2021-11-02 12:06:53| 492.3|  0.2|STATS |SQLExecutor_4_RESULT Feature Counter -1 361 (TeeFactory): Cloned 132885 input feature(s) into 132885 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_INITIATOR Feature Counter -1 2147680433 (TeeFactory): Cloned 1 input feature(s) into 0 output feature(s)2021-11-02 12:06:53| 492.3|  0.0|STATS |SQLExecutor_4_<REJECTED> Feature Counter -1 2147745969 (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)Note that it says "Cloned 132885 input feature(s) into 132885 output feature(s)" And here's the equivalent section from the Server log:806 2021-11-2 04:10:34 | SQLExecutor_4 RESULT Transformer Output Nuker (Te

How to calculate lat long of this lines corner vertex points in FME with help of any transformer or any other useful method with any projection of the shapfile.Anybody can help in getting this Lat long or XY co-ordinated for this four corner positions of any randomn area with any projection.Just need to extract XY Co-ordinates. how can we generate or extract it. Please find below snapshot for reference to understand it better.

Hi, I have a postgresql database I am writing to it has the following fields:    changedetect_date timestamp without time zone NOT NULL DEFAULT now(),    changedetect_uuid character varying(36) COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(),    pk_index integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), All these fields do not need to be inserted into by FME but FME is trying to insert NULL's into them even through the fields are not explicitly set in my feature writer (set to automatic and does not have these fields). When it inserts postgres gives an error 'ERROR: null value in column "pk_index" violates not-null constraint DETAIL: Failing row contains (...'POSTGIS writer: A fatal error has occurred. Check the logfile above for detailsSuccessfully closed POSTGIS database writer=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- What can I do to get around this? I tried using ma

Is it possible to resample a raster so the values left are one of the existing band values? If I use the raster re-sampler with the average 16 interpolation type, I get an average of the 16 cells but what I need is the value that occurs the most in these 16 cells.

Hi folks, I started using the Tygron API, which I used to extract building information for a specific location/site. However, when I request the building information, the response body is a JSON Array with JSON Objects of which only approximately 1/3 of the JSON Objects are actually about buildings. To determine if a JSON Object is about a building, I'm checking if it contains a "BAG_ID" attribute. Below is some a sample_json Array that illustrates the data structure I'm working with:[ { "id": 1, "name": null, "attributes": { "type": "Bridge" } }, { "id": 2, "name": "just a shed", "attributes": { "type": "Shed" } }, { "id": 3, "name": "just a house", "attributes": { "type": "Building", "BAG_ID": 1.5010000000035E14 } }]In the real world data, the JSON Array contains a lot more features and data.  Initially I queried out the JSON Objects on buildings using the following steps;JSONFragmenter (create features for individual JSON Objects),JSONExtractor (Extract BAG_ID at

When dealing with JSON data, I sometimes like to use the JSONiq XQuery extension to manipulate JSON data a bit more directly. For example to be able to directly query for only relevant data (see e.g. this question), or directly setting list attributes for portions JSON without the overhead of fragmenting/flattening the entire JSON structure (see e.g. this question). I've been quite happy with the flexibility that the JSONiq XQuery extension seems to bring me, but as I'm using an XMLXQueryExtractor for this, this seems like a bit of a hack, and thus it might be that JSNOiq is not officially/fully supported. For example, I also came across the situation where I wanted to check if a JSON value was equal to null or not. At first I had a look at the JSONiq specification page. There in the Revision History (at the end), I found this line below Revision 1-1;Removed the function jn:is-null() because it is redundant with the "eq" and "instance of" operators which sup

Hello,I am using Aggregator with FME 2018.I restricted my data to only one feature. So literally there no aggregation but the transformer is taking 10 min to proceed.Is this normal? Is there a way to optimise it?

I have created one text attribute using the AttributeCreator transformer and by default, its length is 50, there is no option to change this length in FME. This attribute is created for the feature class to save filename which is over 50 characters.

While converting Ecw the following error will appear ECW writer: The ECWJP2 SDK only has 200.0 MB of memory allocated to it and this is not enough to compress this dataset. Please set the SDK's memory limit above 304.7 MB

My input has a lot of Ring looking objects in it, when viewed from Autodesk everything is smooth but the FeatureReader doesn't see them as rings, but some dumbed down rectangular shape. Reader: How it should look:How it looks: What I've tried was extracting coordinates and rebuilding with Python and Scipy and it seems that for some reason it has ~380 coordinates in it but 12 duplicates of each exactly at the points where the ring seems to 'break'(coordinates only appear there, nowhere else), could this be source of the issue? Or where should I look? I'm trying to write these to a Cesium Tileset but I don't think that should be relevant since the rings show up like that the moment they get read and not just in the output. Thanks in advance!

I want to read all features in the mxd or gdb and write to gdb. How can I do this with only one reader and one writer

Hi guys,just wondering when using AreaOnAreaOverlay on single input, can it add attribute to show which records's overlap which? Currently i only get the overlap count option but ideally I'd like each record to be added as an attribute field and with a return value so i can see. Thanks in advance 🙂 

How would one create a new line that lies right in the middle between two existing lines? Imagine that we have the blue and pink lines below, they are parallel but not identical, and we want to find the centre (doted) line between them.  I was thinking one could AreaBuild the lines and then chop the resulting polygon into shorter segments, use a CentrePointReplacer on the segments and then finally connect the points. But before I dive down that rabbit hole I was wondering if there was a more efficient method to achieve this? 

I want to write some 50000 features to Excel with fanout enabled by some attributes.One of the fanouts contains 23487 features and fails the workspace with the message Error running translation with 8179 features inputted to the writer. If I filter it out the remaining 118 fanout files get written to disk.I tried both normal writer and FeatureWriter. I have attached the workspace.I started with FME 2021.1.3 and updated to 2021.2.0.1

Attached is a testkit with a raster (geotiff 10mx10m), 3 overlayered polygons and workspace. I would expect that if I clip the given raster with the smaller polygon the raster sum would be smaller. Clipping with a larger polygon (which contains the smaller polygon) would yield a larger rastersum. The polygon named T20 in contained within T100 - but the rastersum is larger for T20 than for T100 - if the cellsize is 7 or 10m.The last transformer calculates the ratio on the rastersums between the different clips, and there doesn't seem to be any pattern.   

I have a dataset containing fields representing year and shape length and would like to know how to sum the shape length based on different ranges of years. For example, if I had years 2010- 2020 how would I get the following? 2010 = sum of shape length 2010 2011 = sum of shape length for 2010 and 2011 2012 = sum of shape length for 2010,2011, and 2012and so on up to 2020.  For reference, please see the attached image of my data set.  I've attempted to work this out using test filter using the "IN RANGE" operator but it seems to filter out the values for each consecutive year. Would creating a new field using a combination of math functions and string functions within Text editor in attribute manager be a better method?

Hello everyone, So I have many points and lines in my data set. I would like to extract those points that are not on/touch the lines.  May I ask how I can do that? Thank you and sorry for all the questions. 

Hello there,​So I have a list of data - Floor and units. For the units, it could have more than one categories (with space to seperate different categories). And I have a excel list that shows all the categories.What I can ​to do is to check all the Units are within the excel table categories. Might I ask how to do it? Since there could be several cateogries in one unit, I am not sure how what transformer I should use to solve my problem. Data:Floor UnitsG/F Lobby1/F Office Toliet Excel:TypeLobbyOfficeTolietBathroom Thank you for your help!

Hi, I am new to FME. I have a Mapinfo TAB file from UK Mastermaps which contains the map text ( housenumber, streets etc). I would like to conert it to gdb annotations to be used in arcgis.

Hi, I have a polygon layer that represents the building footprint (attribute: building id). In .csv I have a list of apartments (attributes: building id, Apartman id). One building consists of x apartments. So, I need to x duplicates of the building footprint and each clone needs to have a different apartment id. I used the FeatureMerger to join shp and csv and clon to create duplicates of geometry but all duplicates have the same apartment id.

Hi everyone. I have 2 gml files and want to replace some buildings from one of them in the other one using their gml id. I tried feature joiner, but it doesn't work. Can somebody helps me with that? Many thanks in advance

convert Using XML hierarcy(parent-child id) to relational database(postgresql) tables