FME Form

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!

Sometimes when reading various files I get different behaviour for the coordinate system the FME chooses. Sometimes I see 'NonEarth_Meter' while other times is something like XY-M. Seems to be somewhat random, however, it could be specific to the input formatDoes anyone know if there is a difference of why both these definitions exist?

I have 2 readers. I am trying to add new fields and values from the 2nd reader to the 1st reader if there is a match. There isn't always a match and I want to keep the order of the records in the output. I'm trying both featuremerger and feature joiner but neither are reproducing what I expect.The featurejoiner failed because not all job records have a lineID. I still want all jobs in the output. One note is there the Lines have a 1:M relationship with Jobs. There is only 1 line record that would populate the output new fields.Thanks!

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'm very, very new to FME and I'm working my way through the FME Academy. Everything has been going swimmingly until I've got to the point of publishing workflows to FME Server as part of the Publish a Self-Serve Workplace to the Web section of the Automate Workflows module in the Integrate Data with the FME Platform trail - https://safe.my.trailhead.com/content/safe/modules/automate-workflows/publish-a-self-serve-workspace-to-the-web The issue I have is that the module refers to a gdb file called CommunityMap.gdb and I can't see it anywhere. It doesn't appear to be a resource on any previous sections. Am I missing something obvious? I'd really appreciate it if someone could point me in the right direction to find this gdb file. Many thanks Brendon

I have exterior wall and balcony . I create area between two shapes.I attached example file and photo .

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.

Hello there Just wondering why intersector and lineOnlineOverlay transformer are not giving the expected resulteven when the 2 features are intersecting Attached is Data in shapefile format    

Hi, newish user here trying to figure out dwg to shp conversions. I've got the attached DWG file that has 31 feature types that I need to convert to SHP. But when I run the attached workbench it's projected to 0,0 what am I doing wrong? Thanks

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

I am using Intersector in FME Workbench 2022.0 Beta and it is resulting in unexpected nodes and segments in our data. We are running the beta because of issues with other transformers. Any ideas? Sample data attached in a ZIP.

Hi folks,Let's call this edition of What's Up Wednesday the "GIS Day Special" - although by the time I finished writing it's more like a "Meme Special"! 32-Bit DeprecationIn case you missed it, external factors mean that we've had to bring forward the deprecation of FME on Windows 32-bit. FME 2021.2 will be the last FME version to support 32-bit! FME 2022 onwards will be 64-bit only. Most formats already worked on both 32- and 64-bit platforms, including ones you might think of as mostly 32-bit, such as File Geodatabase, Microsoft Access, and Smallworld.  But some formats are 32-bit only and will therefore be missing from future FME versions. We will try and supply patches (to 2021) if necessary and where possible, but we really do encourage users to upgrade to 64-bit. For more information, read this article on our knowledge base. For similar reasons, the FME Integration Console tool is also being retired. This was the tool that searched out related

FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this  

FME Desktop 2020: Deaggregating the result of clipper tool produces extra unexpected polygons, I’m wondering why deaggregating the inside result of the clipper tool produces extra unexpected polygons. I’m expecting to have exactly 8 polygons while the result is 12 What could be the issue here? The workbench and the dwg file are attached          

FME 2020: How to join the none intersecting lines? In the screenshot below, I wanted first to break at intersection and then to join the none intersecting lines. How this can be performed in FME to end up with 4 lines?     

AttributePivoter has started failing with a "WARN |Python Exception <TypeError>: '<' not supported between instances of 'str' and 'float'".Prior to sending features into AttributePivoter I validate the features and they all pass as numeric .I am aware of numerous workarounds and custom transformers - I am just curious about this error.I hope the image is sufficient information - the Transformer Parameters are on the left hand side. PS: I tried numerous python installations - including my OSGEO4W 3.7 - and both FME 2020 and FME 2021.

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

I Run a job from FME server but it just ends up in the que and do not execute. I have published a workspace from the training environment so it should work? Why is it not starting to run?

The attached data has 164028 rows but only 134483 row are actually read. I can import using Excel and this has the correct amount of data but if I use FME I get less, anyway I can resolve this? I have also attached the parameters I used. Cheers

Hello,  I use one featureReader to load Oracle spatial data on my workspace. How can i choose my geometry like the oracle spatial reader ? By defaut fme read the first geometry field.  Thank you

Error message:ArcGIS Online Feature Service Writer: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services.arcgis.com', port=443): Max retries exceeded with url: /BLN4oKB0N1YSgvY8/arcgis/rest/services/CalOES_Evacs/FeatureServer/0/applyEdits?f=json&token=mL3ovIy1sDWEeKZf8I_hNgrP8RNVQ2LuK1AoOdpsOmPJQC3fwycVaePeFqqVF5juSz3eo9-OAgfgz8Po5I2J6OWUgjUz-V0Uw_OasaRYY2AQf3W1O1R0RjnpUoDIL9dFcXrP11eThAsyBkCQwo37gzZ6yGyPHuRfBc3rBd6ddxrdhmfSIjwBEfm0Ne1L_lalIOLytVjsalnqV5QzuE2VRZSLQwbHZM86QjYSc7esV-EZlRpxjI3bbjLwYLI0qMnQB4UZeKOmkhhviYwuqqJU-HPfpk8OuSgPTBLSSyodMSU. (Caused by ProtocolError('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None)))'ARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Che

As an example, in Excel you would use the filter function and select specific values from the drop down menu across multiple columns. How in FME do you filter rows of data based on attributes held in multiple columns? I've looked at the two SQL translators; SQLCreator and SQLExcuter but both need connecting directly to a database. In my case I need to use the transformer within my workflow. Thanks.

Hi FME Community,I have a column with number. I want to add a dot to the last three numbers.the pictures show what I expect as a result:what I have:Thanks in advance :)