Unanswered questions

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..?  

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! 

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?

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? 

I have a database of spatial information (points, lines and areas), this database needs to become all points, the issue is that there is a big overlap in data. What I am trying to do, is see if any lines are already matched by Project nr and location (can be not exactly the same location) to existing points. If this is the case, then I want to copy missing information to the points and disregard the line after. For the other lines I will turn them into points after. The issue is that I tried to match them using a NeighborFinder, when using the lines as base and points as candidate, I was unable to extract the points after with the missing info filled in. However when I used them with points as base and lines as candidates, I had a lot more lines left over. With a manual loop this amount decreased, so I am trying to do a loop transformer. As this is the first time I am unsure of where I am going wrong. I added a counter to see how many features are left and the tester is than to compare

Hi :)I’m trying to add the vector map from basemap.de as my background map for exports in FME 2026.2. However, I cannot make it work. I used the following link and MVT as my feature reader.I get an error regarding a missing API key. Has anyone ever used basemap.de as their background map and can tell me if there’s a simpler way to add it (and also be able to crop the data to my AOI before reading all of it, which covers the entire country), or if I need to somehow request an API code to use this map?Here’s the link (which I am also not sure if it’s the correct one):https://sgx.geodatenzentrum.de/gdz_basemapde_vektor/tiles/v2/bm_web_de_3857/bm_web_de_3857.jsonThanks!

I’m experiencing a discrepancy between LMTOOLS and the FME Form License Assistant, and I’d appreciate any insight or guidance.EnvironmentFME Form (floating license) License server managed via LMTOOLS (FlexNet)IssueLMTOOLS shows:Feature usage info: Users of FME:  (Total of 3 licenses issued;  Total of 0 licenses in use)Users of FME_GUI:  (Total of 3 licenses issued;  Total of 0 licenses in use) FME License Assistant shows: 3 total seats 1 license in use 2 licenses available What I’ve already triedRestarted the license server via LMTOOLS (Stop/Start) Confirmed via Server Status Enquiry that no users are consuming licenses Closed all FME applications Ensured no FME processes are running on client machines Despite the server reporting zero usage, the License Assistant still shows one license in use, which suggests a possible:Client-side cache issue Stale session Delay in license usage synchronizationQuestionsHas anyone encountered a mismatch like this between LMTOOLS and FME License Assi

Hi team,I’ve noticed a bug within FME 2024.2.1 (Build 24801)… When I’m building out a workspace and reference a Password Deployment Parameter in a reader. If I edit that or any other Reader or Writer under the Navigator (i.e. Right Click, Update Reader, make changes and click OK), it will drop the Password Deployment Parameter, anywhere they are referenced.Text based Deployment parameters remain, but it just drops the Password based Deployment Parameters. Has anyone else seen this issue? Once they’re all set and we publish, it seems to retain them, but it’s only after we update the Reader and Feature Types.

Hello there,The coordinate system Irish National Grid TM65 (EPSG 29902 previously 29900) is not depreciated. It is also not the same CRS as TM75, there are mathematical differences which can effect the coordinate locations. They are both Irish National Grid. The southern Irish Ordnance Survey has moved to using Irish Traverse Mercator (EPSG 2157) but the Northern Ireland state mapping agency is still serving basemapping in TM65. There has been previous posts on this issue but the suggested fix has not worked. I followed the instructions in this post but I could not select EPSG 29902/29903.The only way we can get the translations to work in a workbench is by not setting the CRS on the Reader or the Writer. If we set try to set the CRS in the Reader or try to apply a projection using the ESRIReprojector it won't work.  

Recently been working on a process that uses the sharepoint online connector (package 1.7.1) to download, list, upload and delete files.This is working as expected in FME Form (tested on both 2024.1 and 2025.1)However, when this is deployed to FME Flow 2025.1 the sharepoint online connector that should download a file returns an error (but doesn’t cause the workspace to fail)Error: SharepointOnlineConnector: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections.(Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate chain (_ssl.c:1028)')))'The workspace continues and the sharepoint online connectors that are listing and uploading items work as expected.It’s been tested on another similar FME Flow environment that has not yet been upgraded to FME 2025 and the error does not exist and the file is downloaded.I’m not sure wher

Hello everyone,I have a question in regards to naming the filename of the datadownload output.I was wondering whether it's possible to change the name instead of having a name such as FME_55460769_1764252272631_14296.zip for example.I found a post with a workaround, but he post is already 7 years old and I don't manage to use the workaround succesfully. Does anyone know if there is a different and easier way to change the name of the zip file?

In earlier versions of FME desktop/form i was able to filter log messages from options → translation → log settings. I know i can disable them in traslation log but we used those settings to control if server/flow logged warning messages. We have process that creates massive amounts of unnecessary warning messages that generates gigabytes of logs. Log message filter option doesn’t seem to be available anymore? Is it moved some other place?FME 2024FME 2022  

I am not able to understand where and why the Output FILESIZE is NOT the SAME as Input file ? Any idea or suggestion is helpful  INPUT FILESIZEOUTPUT FILESIZE 

I've found not documentation around any name formatting limitations for Attributes for the Hyper file Writer. When I work in Tableau Prep, I have no issues writing a file with a field name like "Budget$" to a hyper file. I've found in FME that when writing to an Excel file, it also takes such a name, but when using the Hyper writer, it drops the "$" and replaces it with underscore "_". Why is it doing this? Is this a mistake in creating the code for the Writer or is it a Necessity and if it is a necessity, shouldn't this be documented?