FME Form

Hello there I have a 20K features each feature has an attribute with Long text content each text with diffirent word count , we need to compare features to each other and extract the text features that have similarity ,Any way to do this with FME Thanks

Hello, I have a lot of attributes that need to be input into specfic cells in an excel template. Some of these cells are merged and some are not. How would i write each individual attribute into seperate cells based on the template? Many thanks,@Takashi Iijima​ @Mark Stoakes​ @nielsgerrits​  @ebygomm​  @jkr_da​ @mark2atsafe​ @jdh​ 

Hi everyone,Here's a post for sharing ideas and activities, for organizing social events, or for just passing on messages during the 2022 User Conference. Note: I can't guarantee to be monitoring this page. Best to tweet me on FMEEvangelist to get a more reliable response. Here's some information that I have: Things to Do In VancouverHere is a Safe webpage with some suggestions. This includes restaurants, activities, and similar. There is also the community page from 2017 that also has some suggestions. Official Event ActivitiesOfficial activities include: Socce

Hello everyone,I'm looking for an easy way to extract domain value from a gdb for validation.I know that you can use ArcGIS Pro to export a XML schema from a GDB, but I want to skip that step. I tried to use Schema Reader, but it doesn't give me the full domain values in the attributs.Anyone have an idea ? Thanks

I've an ArcGIS geodatabase feature class with some attributes. I do some attribute mapping and export data in a new geodatabase feature class.Everything works fine but some of the original attributes are not transferred in the output data. I don't know why......I've used the Attribute Manager to remove and rename some attributes, then I've used the Attribute Creator and the Attribute Keeper, the last step is with a final Schema Mapper and finally the new feature class: but there are some attributes (not interested by any transformation during the process) that are missing (the fields in yellow).Any idea? Thank you  

The obvious transformers (Rasterselector, RasterBandRemover, RasterBandKeeper) do not give the desired output. No errors are generated but all bands of the CSAR raster file are still present after processing. The bands seem to be hidden but I can not find a way to make them available for processing.

I have 2 different (postgis) writers (A and B), one of which is sometimes temporary not accessible. FME checks at the start if all writers (A and B) are accessible, and if not, fails to execute the workbench.So I wonder if it is possible (e.g. by the use of a parameter specifying which (only) writer to use) to bypass the "accessibility-check" of e.g. writer A so that only writer B is being used and the workbench is still being executed? I use this in a batch-script where I "ping" to A and B, and therefore know at the start whether A and/or B are accessible.

Is there a way to write custom key-value metadata to the output parquet files?

Hi I am trying to merge about 15 sets containing information about green infrastructure in to one singular dissolved, multipart polygon. In ArcGIS I would use the Merge geoprocessing tool to all the the layers into one, select all the features and merge them. Finally I would do a dissolve. In FME I have fed all the input layers into a Dissolve transformer (dropping attibutes), fed the area output port to an aggregator. I am unsure what to do with remnants - I have fed Unused Areas from the remnants port to the Aggregator but not interior lines (I presume these are the dividing lines that have been removed in the dissolve?) - is this correct? Many thanks

It's a simple workflow: connect to AGOL, check for data, copy the new features to a service on internal Portal. But it's tripping me up every which way. I got the basic workflow going nicely, but it fails when I try running it via a batch file through Task Scheduler. Keeps returning an error message that it can't find the service. Same thing happened with Python which is why I'm trying FME now.I'm connecting to Portal using a OAuth2.0 web service connection but it doesn't seem to like working through Scheduler.So I thought I'd try a different authentication (tokens) and found a recently released 'ESRI Portal Token Getter' but there's no documentation to really help.Anyone have any success with it?

I've been trying to work out how the light source definition is actually used within the SurfaceFootprointReplacer (with shadow mode set to perpendicular) transformer without luck. My end goal would be to extract an estimated surface of a 3D shape for a hydraulic radius calculation. If I know the shape's rotation from the horizontal axis, how does this get defined by the vector parameters?Defining a point along the face didn't appear to be the right answer, nor was offsetting a point... A simplified workflow showing a cube rotated 45° is attached to illustrate the issue.

Hello,Recently, we have installed FME Destkop 2022.1.We are aware of the fact that FME Desktop 2022 only supports Python 64-bit. On the same machine, ArcGIS Pro 2.8 is installed.Although Esri ArcIS Python 3.7 is selected as parameter and as preferred Python Interpreter, it seems to be impossible to use ArcPy. After many attempts, still the same error appears: "Python Exception <OSError>: [WinError 193] %1 is not a valid Win32 application." What could be wrong?  Kind regards,Pim van der Zwaag.

Hi there, Thanks in advance for any help. I have a point cloud that is in XY-MT format. My goal is to figure out where the openings are on a 'flat surface'. I have taken the point cloud and filtered it so only the data I care about is being used (PointCloudFilter). I am now left with a point cloud that clearly shows my openings. I am looking to show the XY coordinates of the 7 openings shown on the attachment. I have tried a few of the transformations, but I am not having much luck.   Can someone point me in a direction where I may find the positions of these openings?

I have 2 files: dgn1 (main data) dgn2 (reference) The two files should be checked against each other for duplicates. In the end, the dgn2 should be recreated without the duplicates contained in dgn1. Please help. Thanks.

Suppose I am reading 3 files through Feature Reader and setting maximum features to read = 10. Then it is reading 10 features from 1st file and doesn't read any data from other 2 files.

I really try to keep things nice and organized, but apparently all it takes is opening one bookmark and all heck breaks loose!!! This happens all the time and it's really straining my relationship with FME. I was working on another part of the workspace before noticing the chaos. I can't just hit undo. If anybody has any tips, it would be much appreciated. With Dynamo, I don't have this problem. Devs, are you listening?

I just upgraded to ArcGIS Pro 3.0 and upgraded Data Interoperability (FME(R) 2022.0.0.2 (20220518 - Build 22343 - WIN64) . I have several tools built in the previous version that are now failing. The only error message I get is literally: "Error running translation". That's it. Not very helpful. Has anyone else experienced this with the Pro upgrade to 3.0?

i have seen a lot of write ups with this heading but none actually do what the title says. i have been able to read a kmz and get it to a writer but the .json file is empty. there is no error message, just no data when i inspect the json. i have attached the workbench. i want the user to select a kmz and the workbench write it as a json, i am using ESRI JSON because the GeoJSON will error out.

I have two datasets with polygons that I would like to connect with the linebuilder in order to show the distances. One with adresses, the other with corresponding numbered objects.  For each object for each adress there should be a line (or a point when these are identical) For this I would like to use a centerpointreplacer for both followed by a linebuilder (and lengthcalculator). However the linebuilder generates polygons when there are multiple objects with one adress that have the same xy as the adresses and one or more objects that have a different xy.  I tried using a sorter with both datasets (the adresses on adress, the objects on adress and number). The sorter for the objects has a group by on the adresses. However:Grouping the objects in the linebuilder by adress I get polygons. Grouping in the linebuilder by adress and number generates points only. Any thoughts?

FME Desktop version 2022.1 (64-bit) How to find the source data (a feature class from Personal Geodatabase or File Geodatabase) geometry type is annotation (ArcMap or ArcGIS Pro based) or not?

I have tried using the excel reader to get my file in, then httpcaller with the URL as my column of google drive shared hyperlinks. Renaming the output to a column which identifies the name that I want. I'm obviously not getting the settings right in the httpcaller or missing something entirely. New to using this and really no idea what I should be doing. For now I have only focussed on trying to download the Report but ultimately there is also a video avi to be downloaded. My input excel file looks like the following: Newname for the report and then the report google drive hyperlink.

I am reading the polygon and Lines dataset in FME. I need to select lines that are intersecting a polygon and populate the polygon name in Lines. I have used tester after feature to filter one polygon and select intersecting lines using a spatial filter. Is there a way to loop through a polygon feature and select one polygon at a time in FME, Instead of entering the Polygon name in a tester every time.  

I am attempting to offset all lines that intersect each other by increments of 5. Some lines have duplicate/stacked lines on top of them, as well as standard intersections with other lines. My intent is to assign all lines that intersect a differing offset (which is where the increment of 5 comes into play). I have tried creating a list on the Spatial Relator, but I am not getting my desired results. I don't have any trouble with creating the offsets through the Offsetter or 3D Forcer transformers, but I am stumped on trying to assign all intersecting lines a different offset (so they won't intersect in Z space).  I would appreciate any help or ideas that can be passed along, thank you!

We have been working with a user of FME ESRI Edition to repoint the connections to a SQL server Always on listener in a multi subnet environment. The connection string has been configured with the Multi-Subnet Failover check box enabled (see attached) however the connection does not appear to resolve, to the multiple IP addresses registered, in parallel as I would expect for this parameter. As a result, connections are occasionally timing out.  Can you advise if there are any relevant known issues with the FME release currently being used (FME ESRI Edition, 2021.1.3.0 build 21631). Also are there any additional configuration changes required to ensure the multisubnet parameter is set correctly within the connection? Any assistance with the above would be greatly appreciated.