FME Form

I need to make an inventory of the GIS data my organization has. As a first step, I need to make a list of the names of the Feature Classes in each of our File Geodatabases.  Is there a way to extract a list of the Feature Class names (not the attributes or schema) from a File Geodatabase(s) to Excel using FME?  I know how to do this in python in ArcGIS Pro, but given I am relatively new to FME, I thought I would try it in FME.

Hello , i would like to remove the arrow symbol from the lines how could I test in data which lines has arrow then remove it .as info :arrow symbol and line connects to has the same id FME 2021 

I have a file of polygons and need to generate a list of which are adjacent to each other. I tried the spatialrelator tool and selected the 'touch' parameter but that didn't work for me. I then read a few posts on this forum and decided to buffer those polygons (only 10 ft) and then run the AreaOnAreaOverlayer to generate a list of overlapping polygons. I selected the Merge Attributes option and the UID column within the transformer so that the output included the UID of the main polygon and the UID of each polygon that is adjacent/overlaps that polygon.  The tool works with one exception: the formatting of the merged UID column. It keeps adding brackets { } in the column name. I can't find a way to remove those from the default name value within the transformer itself. I can change the column name in my output file to remove them, but then the transformer will not allow me to manually connect the transformer column to the new name column in my output f

Hi, I have 2 sets of data one line and one point set. I have snapped the point set to my lines and aggregated them by their highway name. I need to remove the first and last point that falls on each highway. Unfortunately, this is where I come up short on ideas. I have tried using a Neighbor finder and snapping the last points to their closest neighbor, but as my road data overlaps, this causes an issue of points snapping to points on other roads.   Any recommendations would be appreciated.

I have two FME Flow servers and I'd like to be able to change this color to easily be able to tell them apart when I have multiple tabs open.

i need to extract the Geometry traits that are in the picture. any clue how?

Are there any specific coordinate strings or bounding boxes to be created for the ImageFetcher to understand where to fetch from a URL? I.e. I tried to fetch from a XYZ tile server and it works flawless in QGIS. The same URL doesn't work with the ImageFetcher for some reason.

Hello everyone According to the rule, when digitizing objects, we need to place the object 0.50 cm above the red line. My question is: How can I find objects that are not 0.50 cm above the red line? Thank you in advance for your help 

Hello ,Could I create tables (Feature classes ) in Arcmap by using Arcsde writer even if there is no content ( empty content )my problem : I have to export the data required monthly from Fme .sometimes ,no data output .sometimes there are new data .in case no data ,i would like to have always feature class , when I show the table of content in arcmap ,I see it is empty .even if there is output or not ,i would like to have monthly feature class has the same name . How could I achieve it ?fme 2021

Morning, I have two FME Form 2023.1 workspaces. one requires Use System proxy settings in FME options to be on, the other to be off.Other than use two different installs of FME Form (.1 / .0.2) with this set, is it possible to parameterise this setting in the workflow at all?

Does FME support moving data from an on-premise database (MySQL or SQL Server) to Databricks? We're looking to potentially replace StreamSets.

This is an FME Server that has recently begun to cause problems. One of the scheduled jobs fails but there is no information in the log. Any leads on how to proceed and solve this problem? FME Server 2022.2Build 22765 - win64

Hi everyone. I've a folder with JPEG. I have a XLSX file with the name of the JPEG name and the new name that i need. It's possible to remane the JPEG in Batch ? Thank for help.

Hi All, Does anyone have experience installing ArcGIS Server with ArcGIS Server Basic license on the same Windows Server hosting FME Server? Do I need to complete our ArcGIS server Setup Wizard? Or as long as I have ArcGIS Server installed with ArcGIS Server Basic license...I am ready to have automations accessing enterprise level SDE and read/write data from our enterprise GDB without creating a new site? or do I need to "Join Existing Site"? Please help :)  Many thanks,Reno 

Looking for ideas on geocoding from text blocks. Each feature has a block of text (~50 to 100 words) describing an incident. More than one place could be mentioned so results would likely include more than one place. But in any case the goal is to geocode based on places mentioned in the text. An example might look like this: "...Something happed in Streetsville and people were walking toward Placeville." And we would want geocoding results from Streetsville and Placeville.

Hi guys i just need to find a way to identify the areas on a dataset which is not covered by each of the field values from another dataset..  I also need this inspection to be done by one of the fields. e.g. my input layer A needs to get scanned through to find out areas not covered by Layer B. but on layer B there is a field and each field value will need to be scanned separately and identified at the output.. Im trying clipper - outside - group by attribute but doesnt seem can give me the output i need.. Thanks!

I've 6 SQL statements in SQL executor. I'm trying to execute these 6 statements only when name_<1-6> value exists. If any of this value is NULL or missing, then that corresponding SQL statement needs to be skipped to avoid error. insert into demo.lu_test values (@Value(id), '@Value(name_1)', 1);insert into demo.lu_test values (@Value(id), '@Value(name_2)', 2);insert into demo.lu_test values (@Value(id), '@Value(name_3)', 3);insert into demo.lu_test values (@Value(id), '@Value(name_4)', 4);insert into demo.lu_test values (@Value(id), '@Value(name_5)', 5);insert into demo.lu_test values (@Value(id), '@Value(name_6)', 6);  @david_r​ Please suggest. Thanks!

Our customer has data located in Romania, and has provided a proj string that includes non default correction and datum shift grids. I have tried to install these in FME Form (2021.2.4), yet the workbench complains it cannot locate the grid file (“PROJ: proj_create: Error -38 (failed to load datum shift file): hgridshift: could not find required grid(s).”). I have found some links in the docs (also related to install this in FME Flow), however I'm not yet able to run this transformation in my local FME Form.  Any help is appreciated. For reference, I have included the example proj string, grids, test data and workbench. Run it with the following parameters:

I'm using the feature caching Run option.I'm reading a postgresql table (no geometry) not a postGIS table. Unfortunately it is rather lengthy. For each record, I'm getting Adding to Spatial Index (paraphrasing) and after the last record a rather long pause before the processing progresses.This might be fine for small record sizes but it is crippling for larger ones.The bottom line is shouldn't there be no spatial index created as long as the reader has no geometry in any case - feature caching or not?Here are my details:Edition: FME Database Edition (node locked-crc) Version: FME(R) 2019.1.0.0 (20190704 - Build 19604 - WIN64) Locale: en_US Codepage: 1252 (ANSI - Latin I) Registration Key: 1-542-353-546 Customer Number:  Home Folder: C:\\Program Files\\FME\\Beta\\ Operating System: Microsoft Windows 10 64-bit (Build 17763) Thanks for any assistance or bug fixing.

I wanna be able to define a global python function (perhaps in the startup scirpt?) like this:def dosomething(number)new_number = number + ... doing something with itreturn new_number then, en would like to reuse this global function many times at different moment in my workspace on many different attributes that has to go through the same treatment. During the workflow of data_a, I'd call a pythoncaller this way:newNumber = dosomething(feature.getAttribute('num_1'))feature.setAttribute('num_1',newNumber)newNumber = dosomething(feature.getAttribute('num_2'))feature.setAttribute('num_2',newNumber) During the workflow of data_b, I'd call a pythoncaller this way too:newNumber = dosomething(feature.getAttribute('num_a'))feature.setAttrivute('num_a',newNumber)newNumber = dosomething(feature.getAttribut

HI all, does someone have (or has someone had experience with this):JPEG reader: `C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972' exists but could not be opened. File contents may be invalid, or the file format may not be supportedJPEG reader: Failed to open the dataset 'C:\\Users\\USER1\\AppData\\Local\\Temp\\wbrun_1699971545629_16788\\fmetmp_4\\ImageFetcher1699971789428_20972'. Please ensure source data is valid and correct reader is selected.The funny thing is I never had an issue with that and it was working perfectly.Any ideas?

Hi All, This post is primarily seeking guidance, or advice rather than answering a definite question. I am trying to figure out the best method to automate 2D files into 3D buildings and load them into an SDE database buildings table. Though possibly also receiving 3D files from said developers.  These files would be received by planning from developers and planning would share them with GIS (me). Would an FME App work better? Can it be dynamic and recognize all sorts of 2d or 3d files? Do I need a separate FME app for each file type? I created a PDF document that I want to share to my planning team so that developers can abide to for my future automated process. from my understanding, it should work, but I've noticed the tutorials (that use CAD) have an accompanying CSV with the building info. This has casted doubt on how i envisioned on using FME. I am very open to criticism as I am very green with FME still.   

Hi, I have a CAD file with 1000 polygon, 500 out 1000 are shifted 0.2m. I want to keep only 500 regardless of the shifting. please advice. thanks

I have a long workflow that transforms some DWG (for buildings), GeoTIFF (for terrain) and FBX (for trees) in 3D datasets (IFC, OBJ, FBX, glTF). The whole process takes a bit more than a day because it's on a quite huge input dataset. The output is fanned out based on a 500m x 500m grid.When I was testing my workflow on a smaller dataset, it worked fine on the four different file formats. Now that I tested it on a bigger dataset, it only works on the file based datasets (IFC and OBJ). The workflow is still able to write the first part (terrain) in the folder based datasets (FBX and glTF), but as soon as it starts writing the buildings in the all ready created fanned out folders, I get an Access Denied (that I didn't get when I was working on smaller datasets).Does anybody have any idea why ?

We have a custom python package project sitting in an azure repo, with build pipelines. This python package can be built on multiple python versions 3.8, 3.9, 3.10 with the help of the Hatch third party package. One of the pipelines produces an .whl artifact for the project, can this be used to install the python package locally on any machine, and simply point FME to this package? I don't really know all the intricacies associated with this approach, if it is possible can you please take me through the steps to achieve this or point me in the direction of a detailed article, any help will be appreciated