Authoring

Hello FME Community,I have point data with attributes for the X and Y coordinates of the top-right and bottom-left corners (e.g., X_TopRight, Y_TopRight, X_BottomLeft, Y_BottomLeft). I would like to create a rectangle based on these two corner points.Could anyone suggest the best approach or transformers to use in FME to accomplish this?Thanks for your help!

Hello,We are using FTPCaller to connect to our SFTP Server via OpenSSH Agent as per the instructions in this article:https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems The authentication is not a problem and we are able to log into the SFTP server, but we are having problems downloading files with spaces in their names, we are trying to download a file named:LB Daily Course Raitings_202409130404.csv the URL set up in the FTPCaller is:sftp://sftpip:2222/Test_Folder/LB Daily Course Raitings_202409130404.csvWe keep getting the error that the file does not exists, we know the issue is dealing with the spaces, and have tried downloading a files without spaces and it works fine. We’ve also tried all sorts of scape options to cancel the spaces in the URL but we get the same error indicating the file does not exists.We’ve also tried to use LB*.csv as the name but same e

When I update one of my destination folders for my writers, all of the writers are updated to run to the same folder. I don’t know why this is happening.When I try and run the workbench, it runs like normal but then as it’s writing it comes with an error: “CSV writer: Failed to open file 'C:\D_xxxxxxxx.csv' for writing.  Please ensure that you have sufficient privileges to write this file.  If the file already exists, please ensure it is not open in another application” after it has written the first file to the folder.This has only been happening since I upgraded my ArcGIS Pro to a newer version that isn’t supported by my current version of FME (which I need to maintain to match the clients version).Any help would be greatly appreciated. 

I simply want to create a .CSV reader that should read the following dataset: $(FME_MF_DIR)DIDOK\didok.csv My workbench is on a network disk P: let’s say P:/myworkbench.fmw so I expected that $(FME_MF_DIR) will be P:/. But instead $(FME_MF_DIR) is resolved to C:\Users\MyUsername\AppData\Local\Temp. So I guess that FME temporarily copy the workbench into C:\Users\MyUsername\AppData\Local\Temp ? How to prevent this behaviour ?

I have a workflow involving three readers (Reader 1, Reader 2, and Reader 3), and I need help setting up conditional logic based on feature counts for a given ID.Here's what I'm trying to achieve: All three readers are filtered by the same ID. Condition 1: If both Reader 1 and Reader 2 have at least one feature for the given ID, then do nothing—no features should be written to the writer. Condition 2: If Reader 1 has at least one feature, but Reader 2 has zero features for the given ID, then: Write the feature from Reader 3 that matches the given ID to the writer. I'm looking for the best way to implement this logic in FME.  Thanks for any advice or examples!

Hello,I am struggling with a similar problem as this post (I think?).  One of my attributes in the Workspace contains a 0 or 1 that is used as a Boolean.  The value has been assigned the datatype ‘buffer’ in AttributeCreator and ‘string’ in the FeatureWriter, which outputs an Excel file.  I am using a template, where the cell format is set to ‘General’.For some reason, the Excel file that is generated will give me inconsistent formatting of the attribute value:  What is going on here??? As you can see, even though they all should be interpreted as strings, some of the values become numbers.  The formula bar does not show anything different.   I started using the Excel template in hopes of making the data format consistently, but even when I changed the cell format to ‘Text’ it still gave me issues when being read by Python. I would like to solve this issue before reverting to a Yes/No or True/False format.  What could be causing this?  Any insight is appreciated. -Thanks  

Hello, All my data is in Excel spreadsheets. All the schemas are the same.I have two readers:The Updates Reader includes the 3 records that have been changed. These 3 records already exist in the Address Reader spreadsheet.The Address Reader is the original spreadsheet that includes these 3 records before they were updated. I would like these updates written to the Addresses Writer which creates a new excel spreadsheet with the 3 records updated but no new records added. In my workbench here, I run it, and the results are the 3 records are added to the 95,393 thus the new spreadsheet has 95,396 records in it. Having the 3 records added results in having 6 duplicate records whereas previously there were no duplicate records. I need the Addresses output to be 95,393 records with the 3 records I mention previously updated. I have tried changing all the parameters in the Writer with no success. The results are always the same, 95,396.I know I can use FeatureJoiner/FeatureMerger, but is the

Hi there I would like to scrape the data from this page. So want the lat/longs of the pins on the map and the background water outage data. I can't find an easy way to scrape the data and am just going around in circles trying to extract the data. https://www.ccc.govt.nz/services/water-and-drainage/water-supply/maintenance-and-repairs/water-status-map/#12  

Hello, I’m trying to dynamically add a suffix to selected attributes using BulkAttributeRenamer.  I want the suffix to be the day the script is run and expressed in YearMonthDay.Example: the attribute is “addresses_count_“ and using the BulkAttributeRenamer and running the script on the 24.10.2024 I want it to be “addresses_count_20241024”.I tried using UserParameters. The first parameter I made was a Text Type Parameter where before the script is run the User needs to input by hand the Date. It has a few flaws. For example, the user may enter the wrong date, the date is not entered automatically by the script and will not always be processed correctly by BulkAttributeRenamer.The second UserParameters I made and think it is the right way to do it is a Scripted Type Parameter. Below you can see what I made.I have not been able to get this to work using the BulkAttributeRenamer. Even when I select the string to be a UserParameter it doesn't seem to add and generate a correct date string.

Hey Folks.I’m trying to move files from one folder to another after execution but it’s not working properly.I have tried using filecopy writer by selecting move option, but copy is working properly but its not move.I have also created attributes - filecopy_source_dataset, filecopy_dest_dataset, filecopy_dest_filename. But I’m not getting what value should i give into these attributes.Kindly help. Thanks in advance

I need to connect to an api that requires a bearer token in the header for authentication.This token should be generated with a jwk. Example to request a token (there are public available examples from the service, so no secrets from my side):POST /op/v1/token HTTP/1.1Host: authenticatie.vlaanderen.beContent-Type: application/x-www-form-urlencoded grant_type=client_credentials& audience=8ed36a78-8443-11ec-b334-83e86b606670& audience=9e6a512c-8443-11ec-ae2c-8700eb2a0cde& scope=org_api_appread%20org_api_appwrite& client_assertion_type=urn%3Aietf%3Aparams%3Aoauth%3Aclient-assertion-type%3Ajwt-bearer& client_assertion=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJzdWIiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJhdWQiOiJodHRwczovL2F1dGhlbnRpY2F0aWUudmxhYW5kZXJlbi5iZS9vcCIsImV4cCI6MTU5MjIwODA2MCwianRpIjoiRGt6bmpzdTQzZHprZDN6amQ1IiwiaWF0IjoxNTkyMjA4MDAwfQ.3dPodaVhJ2d3cXWn0v2YGeZqs5XScJF2lm4MaweDnf4 the

Hi FME users, I have only been using FME for a short while, so please bear with me if this question is very basic. I remember seeing in several example screenshots of the workbench having multiple tabs open rather than just the default "Start" and "Main" tabs. I can imagine it would be very usefull to be able to toggle between different workspaces in the same workbench but couldn't find how to do this. Could anyone please share any experience on this?

We recently updated to 2024.1 (FME Form and Flow).We have some jobs, that run daily on FME Flow, that read features from an Oracle-db and write to a PostGIS-DB.I downloaded one of the workspaces to FME Form to change something. But in FMEForm I cannot connect to the Oracel-DB anymore. I get this error:Error connecting to Oracle database: message was `OCI_INVALID_HANDLE'. (serverType=`ORACLE_NONSPATIAL', serverName=`xy', userName=`xy', password=`***', dbname=`')I uploaded the workspace again to FME Flow and there it ran successfully.Any ideas, what could be the problem? Thanks in advance.Vera

Hi folks, I think this very useful article on the WorkspaceRunner could use some love:https://knowledge.safe.com/articles/1469/batch-processing-using-the-workspacerunner-1.html"Article created with FME Desktop 2013"I believe FME has evolved somewhat since those screenshots were made :-)

Hello Forum, I need to create a point layer of middle points of streets. I have a street network (lines) where each object is attributed with the name of the street. I tried coordinateExtractor, which does produces points on the line. However, in the vast majority of cases it selects the starting point. But I need the middle point of each line. So, I then used CentrePointReplacer to create the centre point of the each street’s bounding box. This works but it finds, unsurprisingly, the centre point of the bounding box. These bounding box centre points -unless rarely through extreme coincidence- are not actually on the street itself. I need them to be on the street. So, I now need to snap that point to the nearest street using the shared attribute value. For example, it look at the point record for Acacia Avenue in the bounding box centre points dataset and then snap to the nearest location in the street network where street name equals Acacia Avenue. I’ve looked at NeighborFinder and An

Hican you hlep me to understand if I can extract info from this webpage  https://viabilita.autostrade.it/it/viabilita/previsioniWhat I need is the info in the blue boxthxFrancesco 

I'm using an Aggregator transformer to group by an attribute and concatenate many attribute accordingly. I'm having a problem with the attribute column containing missing or null values. The Aggregator will populate the attribute containing missing or null values with the separator character when it should stay empty or null. Is this a bug? I've replicated the problem in the screenshot below

I am using FME 2024 - 0.3.0 (WIN64). When I try to write a raster data (*.jp2 or Geotiff) the writer changes the raster resolution and the projection, even if the EPSG - code remain the same. This happens only in FME 2024 (not in the older one). Waht ist the matter?

Hi I’ve got a bunch of points (1 to maybe 40+) that are changing regularly (live data), and I want to find out which polygons those points are intersecting.  They are big polygons with lots of vertices. What is the most efficient and/or fastest way to do that?Should I:Have a SQL Spatial Reader and read all those polygons and use a PointOnArea Overlayer transformer. Use a FeatureReader with a Spatial Filter Initiator OGC Intersection and use a PointOnArea Overlayer. Should I use a SQLExecutor and rely on the database?I’ve tried the first two and I’m not sure which is best.Thanks

fichier cadastre à fissionner dans FME hello ! j’ai 3 couches shapefile -bâtiments-parcelles-limites communesje veux les fusionner pour avoir un seul fichier dxf (Microstation).

j’ai deux couchesUne couche de points (ponctuel) et couche de lignes (linéaires).je veux vérifier les points isolés ou non connectés de ma couche ligne.solution svp.en pièce jointe les supports (points) à vérifier qui ne sont pas connectés aux lignes (tronçon). I have two layersA layer of points (point) and layer of lines (linear).I want to check isolated or unconnected points of my line layer.solution please.attached the supports (points) to check which are not connected to the lines (section). 

Today, when I opened FME, I was surprised to find that none of my recent progress had been saved. I’ve been working on this project daily, usually leaving my computer on standby overnight. Every day, the project would reload without any issues, and even when I manually closed FME, the recovery pop-up would appear, allowing me to restore any unsaved changes.However, today, FME didn’t offer the recovery option, and my workspace loaded without the latest changes. It was quite shocking. After some troubleshooting, I discovered that if you copy the workspace to a different directory and open it from there, the recovery option reappears. I did this and managed to recover my work, but I’m concerned that what I recovered might only be the most recent autosave, which was generated after I started investigating the issue.I'm wondering if there’s a solution to prevent this from happening again, or a way to retrieve the exact progress I lost.Additionally, is there a way to configure FME to automat

This is supposed to be a quality of life improvement when working with unreliable data providers or when you have unreliable internet connection. I hope this functionallity exists in FME already but I could not find it.I am trying to make a custom node that saves the data stream it intercepts locally and reads that data instead if the original source doesnt come through. There are two problems that I have been unable to solve. One is that i have to run the script with feature cashing to get it to save the files and there is an error upon saving, it does not seem to understande the grouping for some reason:localize_data_2_FeatureWriter (WriterFactory): Group 2 / 2: MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or localize_data_2_FeatureWriter_0_DATASET or FFS_DATASET So as the image suggests the custom transformer saves the data stream here at 3 points. It dynamically creates local files named by the customTransformer instance name and with dynamic schema.The second pr

HiI’ve been constructing http calls to download OSM data to a .OSM file, then reading the downloaded .OSM file via a FeatureReader to generate specific outputs (yes, I know there are downloadable OSM transformers but they don’t do what’s required here).The specific problem I’m having is, not returning way or relation items into the downloaded file (if this is possible).Looking for assistance regarding the http call syntax. Below is what I’ve tried but still only returning point features (same results for both).https://overpass-api.de/api/interpreter?data=[bbox];node[building];out;way[building];out;relation[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)https://overpass-api.de/api/interpreter?data=[bbox];nwr[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)

We have web application that triggers FME Workspace on FME Flow server. Sometimes (rare case) we receive an error in the application “Failed to access module”.Error in log files point to problem with FME saying:2024-09-11 02:53:36.7457|Warn||||Error occurred in FMERequestor Method RequestFMEJob: System.InvalidOperationException: Failed to fetch transformation: Status: Unauthorized, Url:http://XXXXX/fmerest/v3/transformations/jobs/id/546567I have no idea why it is not accessible, because in 99% cases it works fine.