Recently active posts

Hi everyone,I just started using FME and am already getting stuck. In my workspace, I import an excel sheet that contains a list of column names in one of it's cells. The list is in the following format: [“Column1”,“Column2,”Column3”].I also import a larger dataframe from a .csv file that contains a lot of columns, more than there are in the list of column names.Now I’d like to have a transformer completely remove all the columns in the larger dataframe that aren’t also in the list of names. I’ve already worked with AttributeKeepers and AttributeMappers, yet these can’t seem to receive a dynamic input.If anyone has an idea on how to solve this problem (Preferably using solely transformers and without PythonCallers) I'd love to know! 

I have very big IFC file in GB, what i  would like to do is just keep Attributes and export it as IFC file without loosing any order or level etc.  Only remove Geometry , below is what i am doing but not getting it right . Any support would be highly appreciated.   

/fmerest/v3/transformations/jobs/completed?limit=1000&offset=0&sourceID=41f3j459-5560-4bb3-90fj-3j2673b2b91f&sourceType=AutomationsThe above V3 rest api call used to include a lot more information about jobs, including job directives/fmeapiv4/jobs?status=success&sourceType=automations&sourceID=41f3j459-5560-4bb3-90fj-3j2673b2b91f&limit=100&offset=0The V4 equivalent above returns far less information, specifically the NM Directives aren’t included. These are included in the /jobs/{id} call but i don’t really want to query each job individually.Does anyone know of anyway to return jobs and their directives (i’m specifically interested in the event id) en masse? 

https://support.safe.com/hc/en-us/articles/25407427123597-Reading-and-Writing-SharePoint-Lists-with-FMEGuidance states: “1. Add the SharePoint List ReaderAdd the SharePoint List Reader to your Canvas, in the Dataset parameter enter the domain of your SharePoint site (for example, https://safesoftware.sharepoint.com). Click Parameters. Select your desired Authentication Method. In this tutorial we are using the Microsoft SharePoint Online (Template) Web Service configured to Safe Software’s SharePoint. You can choose either Basic, Web Connection, NTLM, and Kerberos. “However, I get error message when selecting The Microsoft SharePoint Online (Template) option; doesn’t this need to be configured in a certain way..?  

Hello Everyone, I have an FME Flow 2025.2.4 automation that contains nineteen individual FME Form 2025.2.4  jobs. In addition to those nineteen jobs, I have two separate FME Form jobs that are used only for email notifications. One notification job is intended to run when jobs succeed, and the other is intended to run when jobs fail. Both of these notification jobs contain an FME Form 2025.2.4 Emailer transformer in their build. All nineteen FME jobs in my automation are connected to the Success notification job through their success ports, and those same nineteen FME jobs are connected to the Failure notification job through their failure ports. This wiring ensures that the appropriate notification workflow is triggered depending on the outcome of each job. The goal is not to send an email for every individual job result. Instead, the goal is to send a single consolidated email per outcome type of Succeed and/or Failure. For example, if nine jobs succeed and ten jobs fail during an au

Hey there,I tried to pass on the wfs url as well as the feature types to read both as an attribute value in order to get fetched via a FeatureReader-transformer. Although the output contains the geometry, it contains a lot of unexposed features. So far so good.My question is if there is a simple way to generically expose these attributes and assign it to the geometry again? I do not want to manually expose them in the aftermath.Many thanks! 

I need to change the ownership of some workspace apps to another user. The reason is that the user has left the company, the user does not exist in EntraID anymore and the ownership has to be transfered to another user.Through the UI I cannot alter the ownership, so I have been trying to do it through REST.using {{baseUrl}}/fmeapiv4/apps/workspaces/{{appId}}I can execute a PUT with adjustments to “owner” and “ownerID”. The request executes with code 204 (No Content).However, a subsequent GET request using the same url as I used for the PUT request returns the data for the app untouched and the old owner remains. So does the ownerID.Is there any possibility for me to transfer ownership of a workspace app to another user?

Hello everyone,I want to create hosted feature view layers on arcgis enterprise with REST API, httpcaller in FME. Although a new hosted view item is successfully created, the resulting view layer always remains empty (no layers inside it), and all attempts to attach the source layer fail.Below is a clear explanation of what i am doing, what works, and where the process fails. 1. EnvironmentArcGIS Enterprise 11.5 Hosted feature layer (source) Attempting to create hosted feature layer views programmatically The account performing the request is now: Owner of the hosted feature layer Administrator  2. What worksI successfully create a hosted feature layer view item using:content/users/<owner>/createServicewith parameters including:isView=truesourceItemId=<item_id_of_hosted_feature_layer>The REST response confirms:"success": true,"isView": trueA new view item appears in the Enterprise Content page.However:The created view contains zero layers, every time.Even though the source

Hello,I seem to be outputting multiple folders when I run my app through data stream or data download.Tried connecting all connections to one feature writer but it seems to be limiting me to one excel file if I do that so I did multiple feature writers for each excel file that I want.Tested running my app through data download and data stream and it outputs multiple folders - one folder per feature writer.Was wondering if I am able to simply download all excel files right away without putting them into a folder or just output them all into one folder.Screenshot below.Feature writers under Microsoft excel format. Basically 2 sheet type. 1 is based on a value and other is count sheetNot much configuring except the name of the excel, sheet names, and drop/truncate both yesHere’s an example of what it outputs - 4 Folders(I suppose 1 folder for a specific feature writer) 

Hi everyone,While reviewing one of our workspaces, I noticed that one of my developers used the SystemCaller to launch a Python script as an external process instead of using the PythonCaller transformer. The workspace runs fine today, but I'm worried about unforeseen consequences down the road, and I'd like to hear from people who have run both approaches in production.I'm wondering about maintainability (the scripts live outside of FME), Error handling and logging and versioning.If you've dealt with this situation, I'd really appreciate hearing how it played out.

Is there any other alternative OCR software OR workaround of TESSERACT.exe which is not allowed by my IT Department for security reason.  So if there is any alternative OCR s/w that is recommended, please let me know. Note from IT Security Team:All software, including freeware, must:• Come from a reputable source/supplier• Be supported by the supplier with vulnerability updates• Be fully licensed for enterprise use and not limited to individual use

I have 400 rasters i would like to convert to a single combined pointcloud for more efficient processing. Each raster has a specific piece of information about the hydrology of the subsoil (horizontal resistance, top of geologic layer, bottom of geologic layer, top of aquifer, bottom of aquifer, etc). To preserve the meaning of the individual values i would like to keep the name and type of the source raster as component values. This is where my problem/challenge lies. I can rename the original rater bands to a meaningful name, but because each raster only has a single band, the band value is by default used as the z-value. If I set the attributes to keep as component to an attribute containing the layer name, these are not kept on the pointcloud. I think this is because they contain string values and components in a pointcloud usually only contain numeric values , but then why can i configure it as being a string datatype? The rasters are 2800 x 3250 Pixels with each pixel 100 x 100 m

Hello everyone,I have an FME script that processes various data. Upon output, everything goes to a feature service. So far, so good; I have no problems during processing.My issue is very simple to solve, I think, but I can't find the solution.I'm working with agricultural data. For example, when using my script, I might request to use data labeled "18/19/11". Everything works fine, and everything displays perfectly.The problem arises when I only want to work with data labeled "18". The script works perfectly again, and the data is correct up to the last transformer before the writer. However, the data in the writer isn't replaced by the new dataset, and I still get the "18/19/11" data when I only want "11"!What type should I choose in "Feature operation" (insert/update/upsert/etc.) and in "feature type handling"?Do I need to integrate a transformerbefore the writer that will update the datar, or is this problem solved solely within the writer? I'm a bit lost and frustrated...Thank you

Hi everyone,I have a JSON file that represents a line geometry containing 5 vertices (points). I would like to create a separate feature (record) for each vertex so that I can then generate vertices and rebuild the line geometry from them.I tried using the ListExplorer to extract the X and Y coordinates as attributes. However, the issue is that X and Y are only extracted for a single feature, and the other vertices are not created as separate records.Could you please take a look at the attached image for better understanding of my workflow?Any suggestions on how to correctly create a feature for each vertex would be greatly appreciated.Thank you

Hello all,I’m quite impressed by the descriptions AI assist can give for a workspace. Trivial things like input- and output-schema and even some description on the transformations on attribute-level.Now, I would like to ask these kinds of questions to a bunch of workspaces, and use the results in an automated way.Giving me access to the model behind AI assist could end up quite costly for Safe, so is there another way to get these answers?Kind regards,Martin

I notice that when writing GIS to CAD, in this case a KMZ to DGN using FME, that the output often tends to have mismatched units and the scaling is often much smaller in the output. I know that a seed file is ideal but I often find that this doesn’t always solve the problem in FME. Is there any way to make sure that the units are not mismatched when going from GIS to CAD?

Hi there, has anyone upgraded the previously community provided workspaces that bring additional dashboards to Flow?From REST v3ToREST v4Workspaces can be found from the article from V3 Monitoring FME Flow Job Activity using the REST API – FME Support Center which is a different article to Submitting a Job through the FME Flow REST API V3 – FME Support Center and ultimately the latest article Submitting a Job through the FME Flow REST API V4 – FME Support Center could do with have version 4 fo the statistics workspaces edited last in 2021 

I am currently working with the new DocumentPDFStyler to create a individual feature reports.  Instead of the table reading across the page, I am creating a vertical transposed table with the attribute exploder.Table input However this seems to have limits with the styling as both fields are in the ‘column value’ so any styling done, including conditional options, are performed on the entire table instead of just the second value column. Output PDFIs there a different way to do this or is it possible to have an other documentPDFStyler element for vertical tables?