FME Form

Hi all, I would like to trim the first 7 characters from all the columns in my dataset. I think this can be accomplished with the BulkAttributeRenamer. But I'm struggling with the String Parameter. Any ideas?

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?

Hello,I would like to present for you new approach for testing data in FME :). The prototype is on FME Hub or just ping me for more details via michpil@gmail.com. Thanks,Michal Pilarski

I am creating a process that is going to move 3.5 million records from a SQL server db to a destination. The target can only be interacted with over SOAP. I am using a python caller to make the SOAP call because the HTTPCaller could not handle the challenge authentication method the target enforces. I am batching the rows into groups of 20,000, creating the XML and passing that to the python caller as a single feature per batch. The calls become progressively slower throughout the run of the job. They start out around 4 seconds between batches and after 130 calls the time to process is around 130 seconds.  

I am trying to use a HTTPCaller to call a website.The problem is that the website first is showing a loading-page while it's loading some data and after up to 8 seconds the new page is showing.The problem is that the HTTPCaller just gets the loading-page. Is there a way to let the HTTPCaller to wait until the new page is retrieved?

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

I have an AGOL reader that I read many attributes from. This works great but, I also need to read the latitude and longitude for each record. I've done searches and read documentation but can't find the answer. Can someone help me? I've attached the Parameters tab from my AGOL Reader if that's relevant. Thanks.

i have different data and i would like to have all data in one view at FME inspector to show all of them together .How could i achieve that ? Thanks in advanced .FME 2021  

Currently we hardcoded the ‘URL’ & ‘Target File’ attributes in our FTPCaller parameters:Is there a way to specific them in a more dynamic way? For example, ‘Operating Account Structure - Export Budget 2022-09-22_13_27_55_PDT.csv’, the '‘Operating Account Structure - Export Budget ' part is static and '2022-09-22_13_27_55_PDT' part is dynamic date/time. How can we specific the dynamic part with wildcard something like ‘Operating Account Structure - Export Budget%.csv'? Thanks. 

i am trying to get the data in api but its only showing me the file name not shoing thw data http://40.76.139.235/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/resttraining/Test.json?token=93c5c6c2-2025-411a-955a-cb481cf01c40 Output should be like this  https://www.nhc.noaa.gov/CurrentStorms.json

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!  

I have a large FME desktop workspace that works great. It reads an ArcGIS Online feature service (2 tables), joins the 2 tables, makes many, many changes (new attributes, etc.), then writes to a different ArcGIS Online feature service (1 table). I plan to run this daily with a batch file using the Task Scheduler. The destination table is published to a group of people. My issue/question is that I need 1 to 3 attributes to be reviewed. Usually a few records (out of several hundred) need to be modified. I'm sorry my question is vague. I'm thinking that there may be way to write (publish) a few attributes to a software solution to facilitate approval records after reviewing a few attributes. The few records that aren't approved would be flagged then I would manually make the change in the ArcGIS source. An example would be removing PII such as a person's name.

I have a street centerline Feature Class in a File GDB. I did a topology check in ArcGIS Desktop and it identified two streets that are overlapping one on top of the other (each street is identical in length). In FME, I set up a workbench with the SpatialFilter Transformer and two Inspectors to do a topology check. In the SpatialFilter I have tried using all the Spatial Predicates to test one at a time. FME does not call out these two overlapping street segments as does ArcGIS Desktop and ArcGIS Pro.  Maybe if I set a Parameter Condition Definition based on Shape_Length attribute field it might work?  Fyi, I am using this data as a test to help me improve my FME skills. Any ideas on how to get FME to call out these two streets?  Here is a screen capture of the two streets highlighted in red as seen in ArcGIS Desktop.

Im trying to understand how to extract properties/radius from Oriented arcs. The ArcPropertyExtractor only works on "normal" arcs so a workaround could be to coerce the the oriented arcs to normal arcs, but can find a transformer for that. The properties exists in the geometry so cant be that difficult to extract it. Any ideas?

Hi!I got a problem with my app... I think!I got the same error message for anything that I read or transform.From a single simple shapefile polygon to LiDAR point cloud (las) i can't seem to do anything Here's the log:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string: UTF-8): `fme_geometry' has value `fme_point'Attribute(string: UTF-8): `fme_type' has value `fme_point'Coordinate System: `_FME_0'Geometry Type: IFMEPointCoordinate Dimension: 3(301381.02734451834,5038785.402441637,0)===============================================================Unknown coordinate system '_FME_0' specified - aborting I've tried geometry coercer and to reproject in simple epsg's but it doesnt help I'm far from good on this app... hope someone can help! Thanks your time!

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?

Version of FME Desktop: 2022.1Transformer: HTMLExtractorIssue: Return format - List attribute does not behave correctlyDetails: When chosen List Attribute as return format, the results always show up as missing and no list can be exploded. Last known version that works is 2021.2.

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

I know the issue of dynamically exposing attributes in a feature reader from the Generic port comes up often, but I thought I would ask anyway. I have two issues with the FeatureReader regarding scripted parameters. Firstly, I have a text file which contains a list of feature classes to read. As feature classes are added to the database, the name will be added to the text file. I have a Python Scripted Parameter which is called "FeatureTypes" with the following code:f = open(r"D:\Scripts\DEV\List of Feature Classes.txt", 'r')featureTypes = ''for line in f.read().split('\n'):    featureTypes += (line + " ")f.closereturn featureTypesThis returns a nice list of all feature classes to read. In my FeatureReader, I set the Feature Types to Read paramter, to this $(FeatureTypes) parameter. However, when the database tries to read it, it's reading the literal string "$(FeatureTypes)" instead of the list. I got around

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 magi