FME Form

I have a large number of spatial tables, each potentially having dozens of date fields. I need to check the dates in each of these fields to check they are greater than a certain data (01/01/1900?). These tables are being taken from Oracle and uploaded to AGOL. If there are any dodgy dates, it appears to break AGOL and no spatial data appears for the whole dataset!Is there a way to automatically select fields with a type of date or date time and check validate each row for each date field is above that date? That way I could investigate and correct before the data is transferred. There doesnt seem to be any kind of filter for attribute type.Once I have done this, I will need to do something similar with varchar fields as AGOL doesnt like certain characters.Many thanks  

I have provided a consultant with the URL to one of my geocoder services. In order for them to access it, I need to issue a token. The token is issued in the Portal, which means it is valid for a maximum of two weeks. Currently, I have to issue a token every two weeks, a manual process. I would like FME to issue a token and then email it to the recipient. I know how to do the email part, but is it possible for FME to contact the Portal and issue a token?My ultimate goal would be to add this workbench to an Automation and have the token automatically issued every two weeks.

Good morning, I want to read the points the created the curve in DWG civil 3D fileso the reader will draw the  curve with the same accuracy.

Since upgrading to FME Flow 2024.1, we see these warning messages in the log files. Is there a way to get rid of them?

Hi,I have a GDB with different layers with 3D multipatch data. I want to analyze the layers between each others and find the nearest neighbor. Like a NeighborFinder in 3D mode.How can I do that? NeighborFinder only supports 2D mode.Thanks.

I want to use the StringReplacer to edit a couple of attributes, but their names are not known in advance. Can I save a list of attribute names in an attribute and tell the StringReplacer to work on these attributes?

Hello everyone,I am looking to linearize hedge polygons generated by AI. Since linearization is an iterative process, I need to cut the godzillas into smaller polygons to reduce computation time.I have already tried using the Chopper transformer to make cuts, but unfortunately, at the cut points, the linear features lose their continuity, as you can see in the screenshot below.The offsets are several meters, so I don’t think post-processing to reconnect the linear features afterward is a good solution—I might end up connecting the wrong ones.I am therefore looking to cut my polygons along lines perpendicular to the median axis of the polygons.Below, I have attached my current FME workflow. I believe what I’m missing is the creation of the perpendicular lines and the interval at which to create them.

How can split polygon into branch like this image?Each branch showed by a number. And the split positions are yellow lines like this Everyone has any ideas to solve this my issue, please show with me! Thank you so much!

So I made a previous post this week asking about CustomTransformers For most of the time I’ve been working with FME I’ve always seen linked CustomTransformers as tools where Global. That it they should live in Resources>Engine>Transformers on FME Server.I’ve always wanted to keep this clean and so most of the time I try to embed transformers wherever I can.But silly me, I just noticed that when publishing a linked transformer from workbench you’re prompted for a repository to choose…How have I not realised this before. This makes so much sense - it means that I can create linked CustomTransfomer that are project specific and keep them in their respective project.I never got this in I think in part because FME Desktop/Form doesn’t support this. The Transformers always nee

How can calculate width of polygon in case rivers or roads?I have a road data and I need to know how minimum width of each segment of roads. I tried with some steps such as below:- First: from road polygon I generate centerline by CenterLineReplacer Transformer- After that: I used Chopper Transformer to chopped the Centerline into segments with mode "by vertex". - Next: I rotate all vertex with 90 degree and I extend line with a length (my problem is here). With road data which have more branch, and each branch have width difference, some case the range between minimum and maximum is so big (e.g. minimum is 0.5 met but maximum is 200 m). So when set the length parameter it not right for all branch. - Next: I

@takashiHi all I'm splitting buffered road polygons into chunks using the BoundSplitter transformer and it works very well for straight polygons, but it does not serve my needs for polygons that have a higher degree of curvature/angularity.I need the split to be approx every 100 m and perpendicular (or close to perpendicular) to the road that is being buffered. When the road has a lot of curves this does not work. I am using "Oriented bounding box, longer side direction"Example of curvy polygon: BoundSplitter strip polygon oriented to buffer polygon.Curvy polygon after boundsplitter:Because of the difference in

I have a first shapefile with points indicating the number of inhabitants. I have a second shapefile with surfaces. I would like to know the number of inhabitants for each surface in FME. What is the process?

Every week I have to update a File Geodatabase in AGOL using “Update Data”. What transformer would I use in FME Form to automatically update the data without me having to sign into AGOL and drag/drop the zipped file? My ultimate goal is to add this to an existing workbench and create an Automation in FME Flow where this is done automatically each week.    

Hi FME teachers and users, I have files in (.fme) formats, how convert them to (.fmw) formats?

I'm trying to update an IFC file by assigning it a coordinate system. However, FME doesn't seem to recognize the coordinate system used by the IFC2x3 file.I understand that the IFC file operates with a local coordinate system, but I don’t have information on which specific system it uses.I've attempted the following approaches:CoordinateSystemSetter Reprojector Setting the Writer’s coordinate system to WGS84 UTM33Despite these efforts, the file always ends up with the coordinate system IFC_COORDSYS_0.Does anyone have a solution or a recommended approach to resolve this?

The main idea:I have this combination of transformers that are meant to clip a raster and from the result of that clip extract the values for every point using the RasterCellCoercer. This way I can do some statistics with the values of the raster that fall inside some polygons. The problem:I started realizing that the results coming out of the clipper were not consistent. I thought I was losing my mind. Sometimes when I use the clipper using multiple polygons the clipper clips as expected, tight and beautiful (what I need), some other times the clipper clips using the bounding box of every polygon feature that is supposed to be clipping. Also I get way more points, which is a pain bc I am working with big numbers here.Case 1 (Expected):Case 1, its clipped tight

Hi,I have HTML content stored in a table's html_content attribute, and file names in a file_name attribute. How can I upload these directly to Azure Blob Storage using the FME Azure Storage connector without writing local files or using the HTTPCaller? Is it possible to provide the HTML content directly to the connector as an attribute? I need to dynamically set the blob name using the file_name attribute. Any help is appreciated!

I have a number of workspaces, lets say 5, but this could expand.Each of these workspaces is like a validation check / test. There is a lot or duplication between the tests and I’m thinking about creating some linked customer transformers in order to not have to make changes 5 times in a row. I know this is usually good practice in programming in general.I’m a little hesitant though because adding linked custom transformers can add complexity (passing attributes 7 parameters etc etc) and makes testing/edits kind of annoying.  I’m interested to hear others experience with working with linked customer transformers -pain points, whats great, when you use them over when you don’t 

Hi there,I’m using the ChangeDetector to update some point data in a ESRI enterprise geodatabase (SDE).  I’ve set up the CHangeDetector to check geometry as well as attributes.  I have 3 points out of 1224 that seems to being updated due to a geometry difference.  I think it’s just that typical geometry change you get between FME and SDE so I have set the vector tolerance to 0.001 which is very generous. I’ve try all the various settings 2D, Lenient Geometry even changing the tolerance to 0.01 but these still come up as being updated.  Below are my setting for the ChangeDetector:I’ve specified a change list and it used to be that you could see the original coordinates and the revised coordinates so you could tell if it was a real change or just a artifact but I can’t for the life of me see where to find these coordinates anymore

Hi! I am currently writing data into an Excel spreadsheet. I have added two feature types that are configured to truncate existing data and overwrite it in the spreadsheet. Now, I need to add another feature type that includes charts and some formulas. These formulas have been set in Excel to sum data from one of the tabs I created in the spreadsheet, and I made a chart based on that data. Is there a way to keep the third tab intact when I overwrite and truncate the data in the first two sheets? Thank you!

Hello,  I’m using Feature Writer to save my output in mdb format. I want to name the output file by User Parameter. When I run the workflow in FME Form, the file named by my input user parameter is generated correctly. When publishing to FME Flow, the user parameter is ignored and the output file is named randomly (e.g. “FME_5C2B2C70_1739440402445_7677.mdb”). In the log I can see that the parameter is not read, so the output name is empty. This is how it looks like when publishing the workflow:  I’m using FME 2024.2.2 Do you know if this can be fixed? Thank you for your replies!

Hi everyone,I am new to FME and need some assistance with a project. I am trying to create clusters based on a point layer, using one of the parameters where the total hours equal to 'n' and a spatial parameter. The objective is to find clusters where the total hours equal 'n' and ultimately demarcate boundaries for these clusters to optimal coverage. I have been using the NeighborFinder transformer, but I am having trouble moving forward. Could anyone provide guidance or suggest a better approach to achieve this?Thank you in advance for your help!Sahan

The Coordinate Systems Gallery is missing EPSG spatial references we use all the time. How to update the gallery list so that more EPSG codes are available? (e.g. anything on https://epsg.io/)

Hey. Does anybody know how to solve the situation where I need zipextractor to not preserve the tree structure of the archive ( if it contains subfolders ) and save the file itself?Thank you

A user is supposed to use FME Server's web interface for running a FME workspace that has been published on it. That FME workspace takes a file geodatabase as input. The user should upload his/her file geodatabase at runtime in the web interface for that workspace. The problem is that the browser will not let the user select the folder defining the file geodatabase. Furthermore selecting all subfiles of that geodatabase will lead to a failed run. What is it that I am overlooking? Thanks in advance!