FME Form

Hi All,I have created a workbench that includes a few AreaOnAreaOverlayer transformers. For some reason one of the AreaOnAreaOverlayer takes hours and hours to union cadastral data (1,200,000 records) with some protected areas PHI (100,000 records). I have checked the log file and the AreaOnAreaOverlayer transformer always accomplishes the following 4 steps: Performing low-level intersection at phase #1 Performing low-level intersection at phase #2 Searching for topologically significant nodes Breaking curves at topologically significant nodesI have attached the log file as .TXT for reference. For some reason the AreaOnAreaOverlayer_3 slows the process at Breaking curves at topologically significant nodes. This transformer is at the middle of the workflow which means is being fed with data that comes from other transformers. here is an screenshot of the log file:...and here another screenshot of the settings of the problematic transformer:I have also run it with the quick translator an

We have several memory intensive workspaces that normally return log file entries like:INFORM|ResourceManager: Optimizing Memory Usage. Please wait…Recently our IT department was sourced to a MSP, and it seems many security settings have changed. Now when FME tries to ‘optimize memory usage’, we receive Windows warnings similar to the screen shot below for ArcGISIndexingServer.exe and FNPLicensingService.exe. There does not seem to be any adverse effects in FME otherwise.Should we be concerned with these warnings? Will the memory available to FME be lower since access is being blocked? What can I ask the MSP to fix if it is an issue? 

I have an .fmw that reads a series of SQL Server views then writes the returned values to a templated Excel spreadsheet and it worked while using our DEV SQL server (A). When I replace the existing database connection to verify it works on our Production SQL Server(B) the value in one cell is missing in the Excel spreadsheet. I get 0 errors, 0 warnings using (A) or (B) connection. All the remaining view results are there and correct. Verified that the SQL VIEWS exist on both servers and refreshed both just in case-same results. I can select the views via SSMS and get the correct data on (A) and (B). I tried deleting the one failed writer and re-adding it: same results.I tried deleting the reader supplying the view information and re-adding it: same results.Thoughts? Using FME Form Desktop Version 2023.1

Hello,I have an ortho image from a drone flight and looking into filling in the square in the middle of the pond (underestimated the correlation between the area of the pond and flight altitude). Photoshop is the last resort. I looked into using aerial images from the past as a background but the pond change dramatically so it's a no go.Cheers,   

How can I use FME parameters to fill gaps or holes in a raster image? Please explain best methods.  

My current FME job is showing a Completed Successfully message when I get the below error. How do I get it to FAIL the job?  Error retrieving next row from result set: 'Query execution was interrupted, maximum statement execution time exceeded'

Hi, I have a process that im unable to get working and wold like advice on the processesI have a dataset containing a number of records, each with a user and their email address. There are multiple records for each user,The requirement is to identify each unique user in the data and send them an email detailing all the records relating to them. The users could change each time the process is run so i havent set any filters with their names.My thoughts were to create a loop to go through a list of users, filtering their records out and sending the email before moving onto the next name on the list.This would keep going round until there are no names left in the list.I have used the statistic calculator to identify the users and have used the HTML report generator and emailer for the the end of the process but would like some help explaining how the loop should be set up (if this is the best way to do it) and how i can move to the next person in the list each time. Thanks

I have a starting easting and northing and from that I would like to build lines from a number decimal degrees and distances

1st file example:   2nd file example:dog                      dogcat                       birdbird                      cowhorse cowCompare and write what’s missing from file 2 to a 3rd file.  

Hi, I need help I have this table ID Année Logements 20 2024 120 20 2025 210 20 2026 340  I would like to obtain this :  ID Année_2024 Année_2025 Année_2026 20 120 210 340  Thank you so much for your help!

On 2023.1.0.0 i’m getting the following python error when uploading a local folder of dwg’s to projectwise. The files are uploaded, but i’d be keen to understand why this error is happening - i thought maybe it was a python version but based on this discussion, it might not be? Projectwise transformers gets 'NoneType' object has no attribute 'encode' error on upload | Community (safe.com) 2024-07-24 14:10:57|   5.9|  0.1|ERROR |Python Exception <TypeError>: WebserviceConnectorFactory.set_feature_attributes() missing 1 required positional argument: 'attr_dict'2024-07-24 14:10:57|   5.9|  0.0|ERROR |Traceback (most recent call last):2024-07-24 14:10:57|      |     |ERROR |  File "fme-webfs/src/webserviceconnectorfactory\webserviceconnectorfactory.py", line 253, in input2024-07-24 14:10:57|      |     |ERROR |  File "fme-webfs/src/webserviceconnectorfactory\webserviceconnectorfactory.py", line 1249, in _handleException2024-07-24 14:10:57|      |     |ERROR |  File "fme-webfs/src/web

Hi Team, Can we integrate FME flow and FME server with Azure Devops using pipelines?

I have and CSV address data file. There are address number ranges that I could expand it with the help of bruttino. Using Cloner and attribute manager transformers.I need to do another clone and need your assistance.I also have 2 fileds: “Street Address Number Suffix From Code” and “Street Address Number Suffix To Code”. For example, from A to D  I need to copy based on the number of suffix between From and To, then replace the current suffix. like A, B, C, and D for this example. I also have 2 fields: “Suite from Number” and “Suite To Number”, which are combination of number and letter. For example from 2A to 2D.I need to get a result like 2A, 2B, 2C, and 2D.Do you have any idea how to handle these fields?  I really appreciate your assistance.

The preview highlights the letters Op but the Regex only replaces the quotes (as expected): Result:‘Op. test ’ will become _Op. test _

Hello,I need to generate data by year (whereas I only have periods)To do this, I'll need to generate numbers between two values (typically years) to make a join with my existing data.I thought of using counter but I need input data, I just want to generate all the numbers between two values (for ex 1791 to 2024)thanks in advance for your help 

Hi  I have a shapefile representing image footprints with as attribute the image name.I have a shapefile containing multiple polygons with an attribute ‘name’ representing buffered lines. I have a workbench that selects all the image footprints per line and copies the images to a folder, fanned out with the line name. It does that perfectly, but some images exist in multiple lines and my wb only copies the image to the first line and doesn’t copy it to the other lines. How can I solve that?          

I have a client who is requesting a feature in a workbench that I am unsure how to implement for them.They have asked for an ability to select which data to run after it has been read into the workbench, preferably with a drop-down menu or a tick box. The data coming in would be a multi-site .IFC file, and they are wanting to be able to choose only a specific site and run only that data. I know that to enable that, all data would need to be read, but how do I make it so that they can then easily choose which data to run without having to modify something like a dynamic filter each time?

Hello, I have been trying to figure out how to embed a website in ArcGis Online popups but could not get it to work.I have tried the method to have an attribute with the Iframe code as some suggested in earlier version it was interpreted correctly but it seems this is not the case anymore.I have found that there’s a way to embed video for example but nothing for integrating a website. So if you have any suggestion that would be great. Thanks.Thomas 

In the 3D modeled buildings, some normal vectors on the exterior walls are pointing to the right while others are pointing to the left. How can I identify and reverse the vectors that are pointing to the right, so that they all point to the left?I attached sample buildings.

I have 2 datasets of roads, one is a whole of site polygon layer and the other layer is broken into segments for each section of road. I have manually edited the whole of site layer to match our property boundary layer. Now I would like to match the road segments to the whole of site possibly by snapping the segment layer to the whole of site layer. I really hope there is a way to do this as it would be a massive job to manually align each individual segment to the whole of site layer. It has taken me 3 weeks to do the whole of site layer alone.

Hello,I installed FME 2022.1.1 on my laptop and installed the Oracle client (11_2) but even after several reboots I cannot select any Oracle Database as reader. They are all greyed out. When I open a workbench that contains Oracle it says something about missing dependencies: ‘Oracle Non-Spatial’,Oracle Spatial Object’. When I want to run it, it fails and gives the error: ORACLE Home is not set.  Does anyone has a hint how to fix that?

Hi Guys, I have recently using FME and would like to know if anyone can help me explain how to extract the polygons from a JSON file. I intend to create a workspace, but it does not extract what I need. Also, I have read a few similar questions about this topic but still do not have a solution. The file is the following one:Also, I have attached my workspace with much of the work :( If there is anyone who can help me much appreciate it.

Using FME Desktop 2023.1 I am able to use a SQL Server Database Connection (None Spatial) and ETL from database with no issue. When I try to publish the same script to FME Server 2021 and attaching the database connection to the script I am getting this errors   Failed to add database type 'Microsoft SQL Server' - FME Flow encountered an error and reported the following message.Path not found I also tried to use an exiting same connection which I already published with FME Desktop 2021.1 and now I am getting this error message   49 2024-7-23 11:04:25 | SQLExecutor_<Rejected> (TeeFactory): Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLExecutor_<Rejected> INPUT FEATURE_TYPE SQLExecutor_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLExecutor<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>tr

My workspace is using ChangeDetector with two data sets original and revised. It appears that if the revised records contain two records with the same key and selected attribute and this key does not already exist in the original table then ChangeDetector will want to insert both records in the original table. This happens when the key is not already in the original table before the run. On subsequent runs, ChangeDetector finds the key and selected attribute in the original table, and it behaves as expected and does not insert a record. It treats it as an update or unchanged. How should I account for this? Attached is an image of my workspace. Thank you. 

I need help performing bulk feature service updates using FME.I would like to do what this blog post is doing, under the section "Updating AND Deleting Database Records with FME" but I can't recreate the steps with a feature service in Portal since there is no Row Selection option in these writers. The blog has steps to write to another geodatabase.Essentially, I need to update floorplans data by deleting the old version of the floor plan in the feature service and replacing it with the new floorplan data.The updated floorplans data exist in a geodatabase and it is used to update a feature service in Portal via ArcGIS Pro.Right now, I manually select all the floors that match the LevelID (unique ID we use for each floor in a building) in the update layers.Then, I delete all the features that match and insert the new features into the feature service, using the field mapper to populate necessary attributes.Any advice or help is appreciated. Thanks.