FME Form

I have 2 feature types in my work space. One being a report from field staff that collects data on manholes and another being a shapefile containing a "master" set of manhole data. I want to match features from the report to the master manhole shapefile based on an asset number, then filter out the features that are outside the +/- 20cm e.g. if the master manhole data has a depth of 1.1m and the report has a depth of 1.05 i want to ignore it, but if the report had a depth of 1.3m i want it in my end result.  I currently have my 2 readers going into a FeatureMerger which compares the asset numbers and any matching are allowed through. I then have those merged results going to a ExpressionEvaluator which is subtracting the report depths from the Master manhole depths. All that is feeding into a .xlsx writer which produces a spreadsheet that i can look at and decide if i want to update the depth in the master manhole shapefile.  I hav

As you can see, when I extract the data, it's showing me all "advrnum" with "td". but when I merger them so I get only one recoder of Advr 8  I need all rows.  

 Hello Group, I manage a large directory of geospatial data, mostly in .tab. But times and needs are changing and I’d like to have the data available in other formats such as shp, geojson and gpkg. In an ideal world we’d have a PostGIS database, but that’s not about to happen any time soon. So, for the time being, and probably into the foreseeable, I will continue to maintain flat files.  In FME Form, I need a process where I can point a FeatureReader at a folder and, in as few steps as possible, write each one to .shp, for example. I need to maintain the name (done so through Accumulation Mode: Merge Initiator and Result, I believe). So, for example a folder may contain 20 tab files (Zones_A.tab, Zones_B.tab, Zones_C.tab etc. etc.). I would want to create Zones_A.gpkg, Zones_B.gpkg, Zones_C.gpkg, but do so in one go. I know I can read in files from a folder (via ‘Select Multiple folders/Files’ in the FeatureReader) and then pu

Dear all, Very simple question (sorry if it sounds naive, I am newbie to FME) : I would like to set to uppercase all attributes that start with a given prefix (or that match a given pattern). Is it possible to do that with the BulkAttributeRenamer ? Or what would be the ''cleanest'' way to do that without using custom transformers ? (NB : I know I could achieve this with a custom transformer (for example, inspired by this question), but I would like to avoid this kind of solution as then I face the tricky issue of having attributes that need to be dynamically exposed and I would like to avoid also the complicated things with schema mapping and so on...) I would

I would like some inputs if possible. I want to write several thousand of rows to a database (each of these rows represent a pdf file). I have created an attribute called 'status' that should have the value 1 or 0 based on whether the particular row has been written into the database. This should be a precaution if FME breaks down. Then it is possible to see which rows have been written into the database and which haven't.  I don't expect a complete answer at all but perhaps just some ideas on how to achieve this. Thanks in advance.

Using the AttributeManager, i understand that i could create a new attribute_alias for each attribute i want to update. However, since there are hundreds of attributes and they all need to be named the same as the existing attribute name - except in TitleCase without underscores > I wonder if there is an easy way to do this?

I have an FME workspace in which input from an DWG file is read and exported into an FGBD file. I am using a dynamic FeatureWriter. Whenever a Text feature is written to a layer whose name contains an Umlaut (i.e. ä/Ä, ö/Ö, ü/Ü), the translation fails with the following error message:"GEODATABASE_FILE writer: An unknown exception occurred" Very strangely, layer names with Umlauts are not a problem for any other feature type, i.e. Point, Line, and Area features all can be written to corresponding layers without a problem. (As another rather confusing side note, Text features can actually be written to layers whose names contain 'ß' which from a technical/encoding point of view should cause the same problems as 'ä', 'ö', 'ü'). Here is a screenshot of my workspace:

Hi,I have been using FME 2019.1 for some months now with no issues. But strangely now I can no longer view the cached features. I have 'Run' set with 'Enable Feature Caching' but when I click on the green magnifying glass and select 'Inspect Cached Features', nothing happens. There are definitely records going trough these ports... I have probably changed some setting but can't work out what it is!Thanks,

 <mdContact><rpOrgName>AAA</rpOrgName><rpPosName>BBB</rpPosName> rpOrgName is appearing at multiple locations in the XML file.How can I update its value from AAA to CCC for all of them in a single go without having to go to each element using Xpath.

I am trying to connect the odata Equipment API for SAP Hana https://api.sap.com/api/OP_API_EQUIPMENT/overviewbut i am getting authorisation errors - HTTP/1.1 401 UnauthorizedHere are the paremeters as i have set themAt this stage i am just trying to connect and get a token.I am using a HTTP caller as we will be using the odata services to create adn update Equipment and Functionla locations in SAP as an integration between our ESRi Utility Netowrk model and SAP. I have attached the log file.I have successfully connected to and run the get call from postman on

Hi, I have two polygons dataset. I would like to find the differents polygons between them. In other words, which polygons have in dataset A that do not have in dataset B. In opposite too. I used spatialrelator and PointOnAreaOverlayer already, but no success. Attached follow my datasets. Thank´s

What I want: I want to read a list of pdf files and write metadata of these files to a postgresql database. The attributes I want to export are number of pages, file name, file path and file id (which I create through the UUIDGenerator).  I start with a PATH reader to find all pdf files from this folder through all the subfolders. The problem is I also want to add the number of pages of each pdf file to the output table and I don't think I can find this with the PATH reader.  Therefore I included a PDF reader and have found the number of pages of each pdf. Now the problem is - how do I combine the output of these two readers? I have tried to use Featurejoiner and Featuremerger but both of these requires a common attribute to join on. But I can't find a format attribute in the two readers that is unique. Is there a way to index the attribute tables of each reader? Or is there some much easier way to perform this action?  I have includ

I have a very large 3D OBJ file and wanted to convert to 3D Cesium Tiles. The Cesium Writer only creates to tile outputs that are huge (650-900 MBytes). Is there a way of introducing LOD and enable more tiles to be created with smaller tile size?

 Been trying to get this working for a while, but I have to surrender... My XML:<?xml version="1.0" encoding="UTF-16"?><Surface name="Zone 101_01.01_A_020!" desc="" xmlns="http://www.landxml.org/schema/LandXML-1.2"> <SourceData/> <Definition surfType="TIN" area2DSurf="234921.542328654672" area3DSurf="238197.012906672346" elevMax="11.943587904916" elevMin="-3.839199295337"> <Pnts> <P id="2">214609.472108227172 150506.362479594914 5.162708941504</P> </Pnts> </Definition></Surface>The attribute I need is "Zone 101_01.01_A_020!". Queries I tried:/Surface/@name/string()for $c in /Surfacereturn data($c/@name)/Surface/@nameWhen I test

Does FME have the ability to export Milsoft's Windmil .gdb to an Esri .gdb?

I am trying to connect to a map service hosted on another organization's ArcGIS Server. I have the credential for the service and able to connect through the REST endpoint on a browser. When I try to connect using the ArcGIS Server Feature reader, I get the error that a token is required. I read on community blog that some people had to set up a web connection using a Portal template .It looks like this requires and AppID from the Portal, which I can't obtain since I am no admin and it is from a different organization. What are my options then?  Any input is appreciated! Thank you!

hello , i would like to know if all my data are Esri objects or not How could I do that ?i am using oracle developer , and FME 2021

I'm new here and need to filter data from a Odata feed. The feed contains open data so no need for credentials. When I add an Odata reader and paste below URL, I can choose several feeds. The main one is named: TypedDataSet​https://opendata.cbs.nl/ODataFeed/odata/82062NED​​The direct link to main Odata feed is: https://opendata.cbs.nl/ODataFeed/odata/82062NED/TypedDataSet​It contains data from 2012 tot 2023 April. I only need data from 2022 and higher. I found some tips for filtering like placing?$filter=Perioden gt 2021MM12 but this doesn't work. I think I'm almost there and only need to figure out the right syntax. Can anyone help m

I have several shapefiles in different UTM coordinate system. I want to:a. reproject each of them into LL84b. Then merge the re-projected feature into a single shapefile I need help in a. Merge features after reprojecting them.b. Find a better way to do it than the way I am trying to do it (see image below). As you can see, I am stuck and I do not know how to do the last part. 

I am working with a forest geopackage, in which small forest roads, rocky areas and other surfaces are not included in the forest layer. What I am looking to do is to make all these spaces part of the forest area. I tried with Area gap and overlap cleaner but I didn't get results, because the problem is that there are roads that I would like to keep as such or other surfaces that I don't want to be converted to forest. Any idea how to proceed?

I have a dynamic workflow that writes spatial data from a MS SQL Server to a postgis database. Since my inital data is not always restrictive on geometry types, I want to ensure that Geometry types are well defined in my destination database. I had an issue with mixed lines and multilines that I solved using an aggregator (destination geometry (multilinestring) ) but I had some geometry collections creating some issues when writing data so I added a GeometryFilter. Visually no feature is filtered (only lines) and the writing is doing great. Removing this filter will make the writing fail.  My question is then : Is the GeometryFilter altering the data or the way the data is presented to the writer? 

I thought I should have two lists, one with the current Xs and Ys and another with the same Xs and Ys and some defined heights as their Zs. And then make some lines between these two lists and after that make the cylinders. Can anybody help me to implement it?

Hi guysim trying to craete a workbench to backup my agol group content into local shapefiles. ideally i want to use _name (feature service name) as folder names so web layers (using fme_feature_type as dynamic shapefile name) goes into each folders by their service name.  however, for some reason the fanout option couldnt work. Also tried to create attribtue with the output file path then use it as destination esri shapefile folder on the writter - this solution doesnt work neither. wondering if anyone know a good practice for this? Thanks!

Hello, I'm currently working on .dgn files  I am using FME to make attribute changes and adjustments. However, I have the impression that FME automatically divides the objects or cells in my plan, as soon as I enter my .dgn data in the script, without any transformers being used...  Here's an overview of the data before and after FME: I also tried using an aggregator. But the objects and geometry in the output dgn file are still not aggregated as in the original dgn file (see the second photo).I would like the geometry of the objects not to be affected. Have you ever had this problem, and if so, do you have a solution to solve it? Thank you in advance.