FME Form

Hi, I have a list of attributes "A_x1" to "A_x20" and I want to sum them up with the attributes "B_x1" to "B_x20 based on the name of the attribute name. Like if part of the attributename = _x1 then sum.  See table below as example. Thanks!

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

Hello,  I would like to download a jpg file from my FME server and save it to my local drive with an API call.  Using FME desktop, I am not sure which transformer/writer to use, and I can't seem to find my REST API call to work. There are a few API documentations in the web, but what I tried was a GET call, but it doesn't seem to download anything.https://<fmeserver.example.com>/fmerest/v3/resources/connections/<MY_SHARED_SOURCE>/filessys/<file_directory/filename.jpg>I am pretty sure my auth and permission is file. Can someone please guide me how to achieve my goal? Kind regards,Tae

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.

Im hoping im posting this in the right category..  Im trying to connect to ArcGIS online portal using these instructions: https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0 Everyhing is filled in correctly but when trying to authenticate I get a window called Web Service Authentication that stays grey. What could be happening here?

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.

Hi guys, I have one more question. I've got task to generalize railroads in fme but I don't have any idea how to start (example data in screenshot).  On the screen you can see a lot of railroads with gap between around 5meters, I would extend the gap to 15 meters at least. I tried with bufferer but there is no result. Any ideas?

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

Hi FME-Experts,I'm trying to read features from an Oracle Spatial Table by the corresponding reader. Although reader option "Max Features to Read per Feature Type" has been set to 20, FME didn't stop reading. (See Screenshot) Does anybody have an explanation why this behaviour occurs? Actually I'm not reading only one table but three, so switching over to "Max Features to Read" is not really an option. With this option, reading would really stop after the given number of features has been reached. (but only for one Feature Type) Looking forward to your answers!(FME Desktop 2022.1.1 Build 20220728, identical behaviour in FME 2021.2)

Ok, reach way back into those 30 year old neurons and long un-electrified bits: is there anything in FME today that can read PAMAP GIS data files?  I have a stash of Pamap data from the 1990s to convert to a modern format such as GeoPKG or shapefiles and geoTIFF. Pamap and Safe are both BC born and raised, have overlapping time spans, and were heavily involved with BC government spatial data operations. Surely there was some interaction? Perhaps there's a SAIF v1 or FME v0.3b or in the archives somewhere that can be resurrected for this single task? (This is personal project and not associated with my day job at Yukon government. My personal google account is mistakenly tied to my work credentials on the Safe Community site. Please use maphew@gmail.com if not following up via this forum. Thanks.)

Hi, excuse me for the interruption. I have one problem and maybe you can give me some advice.I have .las format cloud point where buildings are filtered and I want to get 3d roofs (or building and roofs) as output. output:

Hello, We are experiencing strange memory limits messages in job log: 2022-10-26 16:31:36 | System Status: 20.00 GB of physical memory available2022-10-26 16:31:36 | System Status: 30.00 GB of virtual memory available2022-10-26 16:31:37 | FME Configuration: Start freeing memory when the process exceeds 60.00 GB2022-10-26 16:31:37 | FME Configuration: Stop freeing memory when the process is below 45.00 GB How are these limits calculated, because start and stop freeing memory limits are greater in size than the available physical/virtual memory? 

What is the equivalent FME Transformer(s) of this ArcGIS Pro Geoprocessing Tool: Join Features (GeoAnalytics)—ArcGIS Pro | Documentation Including JoinFeatures by geometry (intersect).

I am building transformations that send data to Azure Table Storage. When the attribute value is missing there is a blank string inserted into the table. Due to the nature of the feature, there will only be one row of data but different columns may have missing or null values. These values we do not want written to the table. I have tried using Python and NullAttributeMappers, but these still leave the <missing> value which is causing issues. Is there a way to dynamically remove these columns? The reason for wanting to remove the attribute columns before the Azure Table Storage writer is that "Automatic" Attribute definition appears to be required in order to dynamically pass different columns to Azure.

$ curl -X POST --noproxy “*” -k "https://server_name/connect/token" -H "Content-Type: application/x-www-form-urlencoded" -d "username=asdfg" -d "password=ghjkl" -d "client_id=CLIENT_ID" -d "client_secret=CLIENT_SECRET" -d "scopes=openid profile role" -d "grant_type=password"  

Hey All, I am trialing FME currently to see if this software is going to be able to simplify my life, and it is looking good so far! One thing I am hoping to do is a very simple "Download all attachments from AGOL feature layer".I have seen dozens of posts on this site about various processes involving AGOL features and generating reports etc with the attachments, but they are a little advanced for me at the moment. I am hoping someone can provide me with a simple workspace that I provide my AGOL feature layer, then provide an output folder location, and FME will download all attachments for me.I have had a few cracks at this but I cannot work out the attachment part, the attributes are all I can get at this stage.Can someone show me a screenshot or something showing the simplest solution to carry out this task? I got to this point but it doesn't write anything to the output folder:  

How does fanout work for dwg files with FeatureWriter in FME Server. Hundreds of postgis tables are read in my workspace with Feature Reader and they should be written as DWG files by object category. The process works as desired on Workbench. Separate dwg-files from each table with the desired filenames ja layer names will come out. But when I publish my workspace on the FME server, in download zip everything comes out in one and the same file with all feature types on its own layers and filename with a generically generated filename. When publishing, you can only specify the folder path. I would want to use FeatureWriters because I don't wanna create a hundred writers with few transformers each.

Hi i need to extract only text inside spanI used this css string for this website http://sac5.halleysac.it/c038007/mc/mc_p_ricerca.php?multiente=c038007&pag=0tbody > tr:nth-child(-n+20) > td.break-all   thxFrancesco

We are on FME Desktop 2021.2.2Currently have a FeatureWriter that can insert new records (Account ID with their correspondence amounts) into SQL table from a source CSV file. See below:For each import, the CSV file could have same Account ID with different amounts. Therefore, we'd need to truncate any existing matching Account IDs rows and replace with new data. Changed Table Handling to 'Truncate Existing' but the amount still doesn't change. Heard you can change Feature Operation to 'upsert' but don't have that optionThanks.

Hello, I am new in the FME community but with a great experience of FME Desktop which I would like to share with you. I don't know and I do not understand how to make and publish the article on the page. Could you help me, please?

I have a table of street names in a single field in this format:George StAdeline WayParker Blvd I want to split this into two fields that include, for example: FIELD1 = GeorgeFIELD 2 = St I think I need to use the SubString Extractor Transformer? any ideas on the best way to go about this?

I have a single band raster (DEM raster) I want to create polygons which represent ranges. For example I have pixels with a range from 100 - 500 and I want to create polygons where values are in the range 100-105, or 105-110. I've tried to contourGenerator and building areas from those but contours aren't close so it's not really an option. RasterToPolygonCoercer I think would work but I need to first get my raster values to be grouped by the interval - this is where I'm having trouble. any ideas?

I am able to convert Autocad dimensions to “Arcmap” dimensions following the response of @Mark Stoakes​  : https://community.safe.com/s/question/0D54Q000080hgppSAA/migrating-dimensions-from-autocad-to-esriHowever if I try to write dimensions to a geodatabase with an ArcGIS Pro geodatabase template, I get this error : |FATAL |GEODATABASE_FILE writer: An unknown exception occurredI read that is not yet supported to read “ArcGIS Pro dimensions” with FME : https://community.safe.com/s/question/0D54Q00008wRTK3SAO/getting-error-like-unable-to-convert-row-to-dimensionfeature-while-reading-a-dimesions-fileIs it also impossible to write dimensions to an esri geodatabase with an ArcGIS Pro geodatabase template ? You’ll find my fmwt in attachment.Any advices is welcome 😊Laurent