Data

I’m using an Excel Writer in FME Workbench 2024.2.  This is a workspace that will be run yearly and I have created an excel file to write to in the format that I need so that the end user gets the same output year after year.  I would like to use FME to clear any existing data in the excel file from row 5 on down, but still keep the data and formatting that exists in the rows above.  I tried Truncate Existing Sheet/Named Range: with my Start Row set to row 5, but cleared all of the existing data from the sheet and then wrote the new data starting at row 5.  In the below images, you can see what the sheet looks like before the writer is run, the writer parameters, and what the sheet looks like after the writer is run.  Is there a setting in the Writer Parameters that I need to change to ensure that the data and formatting in rows 1- 4 doesn’t get deleted?  Or is there another way that I need to approach this?  Any help would be greatly appreciated.  Thanks! Sheet view before writer is r

Hello !I want to extract files wich have everytime a different expression but  there is some text who would be everytime in the file name :Example : [200072692_ZONE_URBA_20220412] “ZONE_URBA” will be the text present everytime in my extract file.I want the String Searcher to download the files which only contains “ZONE_URBA”The numbers in the example before and after “ZONE_URBA” will change everytime because they are the number of the EPCI (french administrative numbers)After calling ZIP file from HTTP with HTTPCaller, I use the ZipExtractor to extract the zip file.Then I use the StringSearcher but I don’t know how to configure the parameters to recover only the ZONE_URBA files … Anyone got an idea ? I think it’s not something impossible but i’m beginner.Sorry for my english, I promised I’ll improve !!Thanks a lot Here my work chain : 

This is really strange—I’ve never seen this behavior before.After saving and closing my workbench, all other FMW files in the same folder disappeared automatically.At first, I thought I was imagining things, but other users have reported similar issues before. [Post link]Version: 2024.2.1 (Build 24801)OS: Windows 11 24H2 (26100.2894)The only change I can recall is that I recently uninstalled all old FME versions, but that shouldn’t somehow trigger file deletion, right?

Question:Is there a way to speedup the geocoding process or an alternative approach like a diifferent Geocoding service people got good results from?Background of question:I have a dataset of 21.000 adresses and want to geocode them using the Geocoder.Geocoding Service: OpenStreetMapMode: FowardTo run the first batch of 500 adresses took approx. 10 minute to run which is not that fast to be honest.  

Hi, I use a FeatureReader for two purposes: to clip features with a polygon, and to select some desired geodatabase layers (of several geometry types: point, line and polygon).After the “succesful translation” the new geodatabase has been created. However, this database seems to be empty.What could be possible causes? Wrong Schema/Data Features of the FeatureReader? In the Reader I have:In the Writer I have:Connectiefile is the file where the polygon for the clipping purpose can be found. Other schema sources are not available.Any ideas?

I was extracting tables from a PDF file by following the steps in  https://support.safe.com/hc/en-us/articles/25407564475277-Extracting-Text-and-Tabular-Data-from-PDF#h_01HW3Z9Z37Q33NQQ7R0XBGEVB0. However, I encountered a challenge some words are misspelled or broken when extracted, even though they appear correctly in the PDF viewer. I suspect this is because the PDF was exported from a graphic design app such as Adobe Illustrator. I realized this when I copied text from the PDF and pasted it into a Word document the same issue occurred (correct me if I’m wrong) is there a transformer can help fix or reconstruct the text?  

I need to transfer a PG table that has a geometry (line) field in below format, to another PG table on another database using FME. I know it’s already in the workable final format. If I just run queries as below and save results directly to the target database using DBeaver, it works fine.            geomfromewkt(comm_path_line_geo)::geometry as sp_geometry But somehow it’s not working on FME to transfer from one to the other. I tried SQLExecutor alone and also with GeometryReplacer.I tried queries inside SQLExecutor this way:select geomfromewkt(comm_path_line_geo)::geometry as geometry from my_table and this way:select comm_path_line_geo::text from my_table  and then to process with GeometryReplacer and also this way:select comm_path_line_geo as sp_geometry         with this, the FME transformer would convert automatically convert it to binary geometry format but it’s not usable at the end tool.  They all didn’t work. Can someone please help? I know this shouldn’t be that difficult be

Hello, so we regularly download the whole catalogue of polygons for England, seen here:Dataset Download - Use land and property dataI would very much want to automate this as its a tedious task to manually download them all one by one, so I’ve investigated the calls that my browser makes when calling this data and it first sends a very simple call to very simple URL’s containing the Zipped data, as seen here:https://use-land-property-data.service.gov.uk/datasets/inspire/download/Amber_Valley_Borough_Council.zipWhich in turn takes you onward to a Amazon service that just gives you 60seconds to fetch the data, as seen here:https://datapub-prd-s3-bucket.s3.amazonaws.com/inspire/Amber_Valley_Borough_Council.zip?response-content-type=application%2Fforce-download&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASNNJI2YGUWCWQTWF%2F20250522%2Feu-west-2%2Fs3%2Faws4_request&X-Amz-Date=20250522T125638Z&X-Amz-Expires=60&X-Amz-SignedHeaders=host&X-Amz-Signature=c8a03845

Hi, I have the following problem: a specific fmw file cannot be opened in the FME workspace. Clicking on it in the list in the FME Workbench tab “Start” gave no response at all. Hoving the mouse on the file in the list showed a popup with the contents of the file. Dragging and dropping the fmw file to the empty workspace did not work. Other files can be opened without issue. How can I restore the fmw file? I have FME Workbench 2024.0. 

Hi all, I am very much an FME rookie, so I’m hoping someone may have some insight as I’m at a loss. I’ve received a .JSON dataset of point locations with a number of attributes. It is not in a form of GeoJSON that I recognize, and so basic Esri/GIS toolsets won’t help with conversion. I’d like to use FME Form Workbench to help me clean up the data and ultimately convert it to Shapefile or Esri File Geodatabase Feature Class.Below is the format of the .json that I’m working with:[  {    "id": 1,    "address_number": "1234",    "street_name": "IMAGINARY",    "street_type": "WAY",    "unit_number": "",    "country": "CAN",    "province": "BC",    "region": "CVRD",    "locality": "Mill Bay",    "postal_code": "V8H 1B8",    "pid": "",    "administration": "",    "building_name": null,    "code": "Residential",    "comments": null,    "geom": {      "type": "Point",      "coordinates": [        -123,        48.6      ]    },    "created_at": "2024-03-27T17:00:00-07:00",    "updated_at": "202

Hi, I need to filter some ArcGIS Online Portal Readers based on a unique ID that exists also in another reader (file geodatabase). ExampleReader 1: ArcGIS Portal features w/ UID Reader 2: File Geodatabase features w/ UID Reader 1 should only load features that have a UID that match Reader 2. The UID fields are the same format. Is this possible? Please let me know if can provide further details. I am a beginner/intermediate FME user focused on GIS. Thank you!

Is there a way to read data from a PowerBI semantic model in FME Form?

I feel like I’ve seen this done before, but can’t put my finger on how to do it…..A warning, I’m working with 2020.2 so cast your mind back a few years….. Essentially I have a workspace that is taking data from MSSQL and writing it out to SQLite. In theory this is just a straight Reader to Writer.However, the SQLite file is being created fresh each time the process runs and it’s creating any number of tables based on relationships within the MSSQL database - these relationships need to be maintained. Therefore, the schema in the SQLite table is being created with an SQLExecutor and CREATE TABLE statements. Currently, I’m reading the schema from MSSQL and manually mapping each attributes data type from the MSSQL definition to SQLite using an AttributeValueMapper. Now it wouldn’t take too much effort to make this list exhaustive, but there is surely a better way. I initially thought of using a schema attribute and let FME do the MSSQL→ FME→ SQLite mapping with a dynamic writer, and that

Hi,I had a script that was running perfectly in FME 2024.1. I upgraded to 2025.0, encountered some issues, and my script stopped working. I then reverted to the previous version, 2024.1. However, my script still doesn't work. When I run it in PyCharm using Python 3.10, it runs perfectly, but in FME I get the following error:Message Type: fme::internal::_v0::py::ExceptionPython Exception <SyntaxError>: invalid syntax (functions.py, line 68)In the FME options, I have the same paths set as before: PYTHONHOME: C:\Users\XXXX\AppData\Local\Programs\Python\Python310 Interpreter: "C:\Users\xxxx\AppData\Local\Programs\Python\Python310\python310.dll" What could be the issue? Could you please help me? Thank´s

I have a DXF-file consisting of lines and surfaces. Is there any standard method on how I can convert such files in IFC?

I need to have a choice parameter offering all the database tables of a specific database for the user to choose from before running the workspace.I do have the Python code ready, and created a scripted parameter, returning a list of all table names.I referenced the scripted parameter as input for the choice parameter, but that only gives me a dropdownbox with the name of the parameter linked to it. Is it possible to populate a choice parameter from a Python script (scripted parameter), and if so how?

Anyone come across .nt files (N-Triples) files? Their doesnt seem to be a native FME reader for it.

How can i extract data from this line?  {"sl:stand": {"sl-bag-extract:bagObject": {"Objecten:Pand": {"Objecten:status": "Pand in gebruik", "Objecten:geometrie": {"gml:Polygon": {"@srsName": "urn:ogc:def:crs:EPSG::28992", "gml:exterior": {"gml:LinearRing": {"gml:posList": {"#text": "114062.419 542728.035 0.0 114067.343 542726.792 0.0 114067.637 542728.082 0.0 114068.445 542728.468 0.0 114069.011 542730.438 0.0 114068.36 542731.246 0.0 114068.639 542732.471 0.0 114063.762 542733.793 0.0 114064.204 542735.512 0.0 114057.619 542737.161 0.0 114055.721 542729.372 0.0 114055.572 542729.428 0.0 114053.081 542719.589 0.0 114059.937 542717.727 0.0 114062.353 542727.763 0.0 114062.419 542728.035 0.0", "@count": "16"}}}, "@srsDimension": "3"}}, "Objecten:voorkomen": {"Historie:Voorkomen": {"Historie:BeschikbaarLV": {"Historie:tijdstipRegistratieLV": "2010-11-26T12:31:16.436", "Historie:tijdstipEindRegistratieLV": "2014-10-27T12:32:20.904"}, "Historie:eindGeldigheid": "2014-09-25", "Historie:beginG

Hello,I am trying to write 3D Geometries (Points and Linestrings) to an Oracle-Database (21c Express). In the process all z-Coordinates get lost and SDO_GTYPE is wrongly written as 2001 or 2002 (2-Dimensional Geometries) instead of 3001 and 3002.Multiple Geometries are entering the writer as an aggregate (example below).  Apart from the z-Coordinate missing these are written and interpreted correctly when writing to Oracle. I have checked the “Contains Z Ordinate” Option in the Writer-Parameters.Does anyone have anymore ideas what I could try?

Hi there, I am working on a data clean up model. Many thin areas and remnants have been cleaned up but I can't figure out how to this last thing.There are some thin areas that connect on both sides to a large and very complex polygon. (See image)Does anyone have a suggestion for how to remove these type of areas? So only the thin parts have to be removed.

Hi,I was wondering if there are some best practices and or style guides / examples on for workspaces. Some questions that I have about this (besides the obvious: avoid crossing as much as possible, annotation, clear transformer names etc) Like is there an agreed style for public and private parameters (casing, under scores, ...)Is there an advise on how many transformers can be put in the main part and how many in a custom transformer?How many custom transformers can be nested into each other or is it advised to not do this to deep (performance impact)Any other good to implement styles?

Hello everyone,At our organization we work on a virtual machine. When you log on into a virtual machine, you share the virtual machine with other users. Since a few weeks we encounter sometimes black screens when trying to use FME form 2023 or FME form 2024. I googled and the problem is quite similar to Known Issue: FME Workbench 2023 Opens as a Blank Window on a Virtual Machine – FME Support Center, instead it's a black screen. The article mentions about OpenGL versions, however the specs for all our virtual machines should be the same, so I think the cause is different.When you encounter the black screen, you can only hover over the black screen and can't do much else. When you close FME Form and try to open a new FME Form sesssion, you still get a black screen. The only workaround is to log off and log into a new virtual machine where this problem doesn't occur. We already did some troubleshooting and we know one thing for sureIt's possible that fme form 2023/2024 initially worked f

Hi, I am using the attribute creator to populate a new field. I want to fill in the blank rows with the previous master property number from the master prop no field. I have enabled the adjacent features but no matter what I try it still only populates just the 1 record after a value and not all the blanks. I thought I would only need 1 based on what I’ve found on the forums.What am I doing wrong here?I also tried to do that same thing via the attribute manager but get the same result.The end result would also have row 3 (FME row id not the xlsx one) with ‘932590’ and row 6 with ‘933123’ and rows 9-11 with ‘933796’ etc with the number of blank rows varying from 1 to potentially hundreds.The settings I have for the transformers are below.I am using FME 2022.2. Thank you! Belinda

I am trying to fill in the rows of my table with the previous values. I saw this thread and I am following the instructions but for some reason I am only getting the first empty row to be filled but not any subsequent rows.  I tried to change the Subsequent Features to another value other than 0 and even tried to change the number of Prior Features but I always get the same results.I am on FME Form 2024.2.0.0 if that helps. Any suggestions as to what I am doing wrong?  

Hi, I am trying to replicate the V-Lookup formulas in FME that I currently have in my excel. Also the current excel formulas refers to a different sheet named Limits and I am looking to create the same sheet in the FME and finally when the writer generates the output the file should have 2 sheets - 1st one where the data is written and the 2nd will be Limits. Writing to the existing template is not an option due to complexities involved