Creating and organizing workspaces. How to use Workbench.
Recently active
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.
Has someone please done a file transfer migration from one Sharepoint Online location (Site) to another Sharepoint Online location (site) and also keeping the original file Metadata, including created date, etc.. Using FME Form?
Hi.Is there an authoritative list somewhere of which versions of FME uses which versions of Python ?So far I have: 2020=3.7, 2021=3.8, 2022=3.9+3.10, 2023=3.11, 2024=3.12I’m assuming that the Python executable is located in [FME_ROOT]\fmepython###\python3.exe (or the dll’s). Is this correct ?And where is this executable’s site-packages folder located ?Is it at [FME_ROOT]\python ? Or [FME_ROOT]\python\python312 ? Or somewhere entirely different ?And is this location the same in an FME Engine for Server/Flow ?I’m contemplating adding a special Python package for use in both desktop and server.Cheers.
Hi FME World,Anyone having this issue ? Every $%?&* time I open FME I have to replace the Navigator bar correctly through the right side. Kind of annoying.I’m using 2024.1.2 and Windows 10.
Hi,I have a workspace that reads a shapefile. My workspace has around 450 transformers. I defined published parameters for the user to insert the row quantities of the shapefile.How can I automatically get the number of features from my file and save it in a published parameter to use in the middle of my workspace, simulating the values inserted by the user?
I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯The data originates from JSON files, and I need to write it into several csv files.The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.Any help will be much appreciated.Stuart
Is there a way to turn on logging of the SQL statements that FME is issuing to Oracle in Workbench 2014?
Is there a way in FME to run a workflow similar to esri Intersect tool where a 1 line feature (1 route) could intersect a second line feature (roads) with multiple lines and get a point feature for each crossing point with the distance along the first line feature. Basically crossing point and stationing along a line?
I am looking to have a workspace run by a workspace runner to parse out some data to be grouped by individual tabs based on an attribute name.i have an excel workbook with a dozen or so sheets, each sheet is a type of mechanical system with 3 columns - Column A is BLD which is a string building name. Column B is System Type which had data validation in place with named table references and Column C is System Name which is a string value.i am using a feature reader with the read formulas checked:i want to have the workspace runner pass a value for BLD and search all of the sheets for matches - for instance, it looks something like this once run: The workspace is finished, except for the writer - i want to create a new workbook for each unique BLD feature and copy from an excel template that has the existing named ranges for the various data validation lists from the original read file - however, i can’t get the validation to copy, nor the sheet with the named ranges.my writer is set up
Hello everybody! some weeks ago I asked for help with our project: calculate the distance to all schools in the city having as input one address. (Server App - calculate shortest route to several schools | Community (safe.com)) I have done it using FME Desktop (2022.2) and the result looks pretty nice:In addition I get the shortest paths to each school (each school has more than one entry).Now I have uploaded the GDB with the streets and the Shapefile with the school entries to the FME Server Ressources.I have created a server app (workspace) and run the project.There I receive this error:2024-9-30 09:01:48 | Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more detailsWhy it works loc
Hi! I have a FME workspace using FeatureWriter to write record to some tables. When running it from desktop, it populates the tables as expected. However, if I look at the log after job is completed, the "Features Written Summary" section at the end seem to be misleading by show "0", while I know that there are actually features written.Do I need to do any change in my FME workspace to add the count to the summary? Thank you!Below is the summary part of the log:Below is the part of log for FeatureWriter, which does give the count:
Dear All, Could you please let me know is there any transformer to do Radiometric calibration and Atmospheric correction in FME? Kindly let me know the details. Thanks, Siva