FME Form

Hello all, Complete FME newbie hereI need to transform the data compiled by a different department as an excel spreadsheet to look like this:From Initial structure To Final structureBasically the idea is to pair each of the projects with each of the areas in order to then join the final table to a different spatial table on the ‘AREA’ attribute, ideally without manual input into transformers. The project attribute will have new entries added to it, with corresponding counts, the areas will remain the same.Thank you.

I’m having an FME workspace that has a custom transformer that is set to parallel running.when running the workspace from FME form there is no issue, everything runs smoothly.If I want to schedule this workspace (due to lack of FME flow) using Windows task scheduler the workspace terminates because none of the cild processes run succesfully.They all crash with the message ‘Access is denied’. This is the commandline for a child process:When not running in parallel, there is no issue.anyone an idea what can cause this issue? it’s really fustrating on how to solve this?

I have a very basic workbench that includes one section reads from an SDE and writes to a hosted AGOL layer. It is set to truncate existing. The script writes all the polygons as expected but none of the attribution for the polygons comes through.  I have confirmed the attributes are correctly named. I have tried removing and re-adding the hosted writer. Weirdly, the script also writes different data to a separate hosted layer and that functions fine. Has anyone else had this happen? Any ideas on solutions? 

Hello everyone, I’m not sure, but I think I encountered a bug in FME 2025.0? Some days ago I had to change the web connections because I had to change the Google Authorisation accounts. I had to replace the Web Connections with the new IDs and the configuration looks fine. But when I try to add any web connection (be it in user parameters or in a transformer itself) it just doesn’t appear on the dropdown menu. Is this problem known? Has anyone experienced something similar?   

I can click on the desktop and add a transformer but when I double-click the title bar of the transformer, nothing happens.  I can’t click and move a transformer either.  I can edit a transformer in the left Navigator.  I can’t add connectors between transformers.Reinstalled same version (2023.1.1.1) because that’s the version we use.  Still same problem.  I can run an existing workspace but the transformers seem to be unselectable.I don't have this problem when FME Workbench is on my laptop screen and not my external monitor.  I've built dozens of workspaces on this external monitor without issue.  Problem started last week.  In Display Settings I extended the laptop display to the external monitor.>>>>It turns out if I change Display Settings to Show only on 2 and back to Extend Displays the FME workspace is fine.

Hi - I’m trying to create polygon geometry from the GeoJSON in the attached file. This is a string attribute returned from an API.I was thinking I could use a GeometryReplacer with the encoding set to GeoJSON. However when I do this the record is rejected with an ‘INVALID_PARAMETER_GEOMETRY_SOURCE’  message.I have passed the GeoJSON attribute through a JSONValidator and this doesn’t flag up any issues.Any suggestions for what I’m doing wrong, or alternative approaches would be very welcome.Thanks in advance.

I'm trying to join two Excel files that share a common column called "ID".File (A), which I consider the main file, has 7 columns. File (B) has 16 columns, but I only need one column from it, called "NON", to be added to file (A).I tried using the FeatureJoiner, but it didn’t work. I also used the AttributeKeeper to filter the data, but the result is always null.Note: The column titles in both Excel files are written in Arabic. is this could be the reason? 

I have always tried to use the databaseupdater but have always had issues with it.Why if i have a unique column with GFID values and i want to match that it gives the error.Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.COGO_23' to the database. Provider error `(-2147217900) The data types text and text are incompatible in the equal to operator.'. SQL Command `UPDATE [dbo].[COGO_23] SET [GFID]=?, BLAHBLAHBLAHWHERE [GFID]=?'this is a flat mssql table with no geometry. 

I am trying to create a workflow that will update a feature layer on ArcGIS Online that is powering a dashboard but keep running into several roadblocks regarding updating the layer. The points themselves are being updated from two sources (other AGOL feature layers) and I am using FME to combine them. First they go through an attribute manager to get the schema matching (They are similar, but different attribute names and one is significantly longer because it just has more data. This longer one is the base for the "master layer"), then those two go through an Update Detector transformer with both of those being compared to the "mater" feature layer. That update detector finds which existing records have been updated (I hope) and then those updated or new records are linked to the master feature layer writer in Update mode. The problem I am running into is when I hit run, an error occurs and says "your layer is missing the ID attribute 'OBJECTID' neede

I have a list containing 93 different WFS URLs, my goal is to be able to read these in one workbench without clutter and for the workflow to handle changes in the URLs for example, a new WFS is released and gets added to the list, I want it to work without having to change or add more to the workbench.Im using FeatureReader to read the format OGC WFS (Web Feature Service) but it wont accept an attribute value as the Dataset, I mean I can put one in there put it does not know what to do with it. If I put the URL directly as the Dataset it knows exactly what to do and I can use the Feature Types to Read and select all an they end up as text separated by a space between each Feature Type. This theoretically means that I could just write a list of every Feature Type I need, use the Attribute Value as Dataset and get results. However, what I really need now is a way to get every Feature Type from the WFS List so that I can ad it in place of Feature Types to Read.Dataset = Attribute ValueFea

Hello ,I have four tables. Each table includes an attribute called result, which contains fields value  string string number. (Hello Community 30 ) ,all tables share a common attribute id I would like to combine the output from all four tables into a single attribute called result  String                String                    String             StringString number  String number   String number.  String no.  I would like the first string from each table to always appear above and the second string  and number written on the next line and All values should be combined into the same field.Thanks on advance 

Curious if the new version of Form, 2023.2.1.0 will support ESRI's new Date (only) or Time (only) formats? They are not appearing for me when connecting AGOL, but they appear when I connect to a FILEGEODATABASE.

Hello all, We have previously showcased the FME-QGIS Connector Plugin. We have just released the QGIS-FME Connector Algorithm Plugin. What is the difference between the two? The first being a tool can just be opened and used to process some layers on the fly and load the results into QGIS back as a temporary or physical GeoJSON file, whereas the second is used a a QGIS provider or an algorithm; in QGIS terms it is a tool that processes the data.    Think of it as having the WorkspaceRunner inside QGIS. Yes, you can select a layer in QGIS, rotate the data using the QGIS Model Designer, run the data in FME Form to save it in DGN format then proceed with some process inside FME get back you data create convex hull then end back the data to FME to process it via the HTTPCaller in FME Flow then get back the results and load it back as a layer in QGIS. The user’s imagination is really the limit.  Once the model created, it can be saved and loaded as a tool in QGIS Toolbox, Other things you c

Hey FME Lizard!In the HTTPCaller the Multipart Upload window is only showing two rows. Would be great to see more lines!So difficult to see the line I want when I have twenty. I have to click the narrows too many times...Thanks :)

Hi,I have a very complex KML file with many folders and subfolders. I would like to save the folder name or full folder path where each placemark is located — something similar to the "FolderPath" field when converting KML to GDB in ArcGIS Pro.How can I achieve this?

I am using SystemCaller to run a pyton script (uses conda env) that creates a bunch of files and I am trying to figure out how I can get FME to then read the folder location and serve that to the user as a .zip file. The folder location is an attribute that I use to pass to SystemCaller but I cant figure out how to pass this attribute value to say a FileCopy or even a FeatureReader. The output folder is a concatonated path $(FME_WORKSPACE_DIR) + _output that I made as a new attribute value (_output_folder).In the pic below, I tried to connect the Logger to FileCopy but that doesnt seem to do anythinghere is the FileCopy settings i am using. Am I doing this correctly or any other suggestions?

Hello ,Is it possible to control the position of Upper left x and Upper left  y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly?I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .

Has anyone been using AI to write documentation for a workspace? I’ve found that some models are really good a looking over a codebase and putting together a readme for example. I’ve been experimenting with with workspaces and have also had pretty good results with copilot inside visual studio. would be great to have an AI Assist button inside the Help section in workbench.   

Hi all, I am querying an API to download a large number of tables (50+) as CSVs that will be written into a DB. I have automated the process of downloading the tables and dynamically writing them to the DB, but the default/source attributes the tables come with when downloaded are messy/poor quality.One attempt at this I’ve tried is to set up a mapping spreadsheet for each table with an example shown below. I have been able to use a SchemaMapper and dynamic CSV writer to write a single table with the updated attribute names, but I am wanting to do this dynamically using a WorkspaceRunner to automate updating the attribute names for all the tables, while also reading and writing records to the DB.Does anyone have any advice for this? The SchemaMapper is not able to take parameters/attributes to read the mapping spreadsheets so it does not seem like an option.

Hello all,We have developed a QGIS Plug in to allow QGIS users to select a specific layer in their project, process it in FME then get it back as a temporary layer or a normal layer in QGIS. Trust me, we usually say that the sky is the limit, but really there is no limit in what you can process. The plugin is still marked as experimental and wish to get some feedback through our support channel. You need to use our FME Workspace template (not an fmwt file, just a sample) and try experimenting. The workspace was developed using FME2024.2.0 .Some would say that QGIS already has a great number of tools which I agree, however FME has a lot more to offer in other areas.Before downloading the plugin, make sure you allow viewing the experimental plugins in the plugin manager on QGIS: The FME example looks something like this:  The official plugin page is available here: https://plugins.qgis.org/plugins/qgisfmeformconnector/I hope this will bring ease in your data transfer and data integration

I would like to open and read a .accdb file which contains multiple named tables. Instead of reading all tables I just want to select the ones which names match the ID criteria.The example below works fine by using a Microsoft Access reader which compiles all tables into one single merged feature type. After that I compare the source CSV file name against one of the listed attributes and pass forward only the matched lines.  That method worked well and served its purpose, but the downside is that it is way too slow since it is reading the whole accdb and this file is constantly growing because we keep on adding tables over time.I have tried to use the Feature Reader with an initiator which provides the route ID as a key to search an open table if name contains the ID but with no luck. I have tried to add a SQL WHERE statement but still no luck. Once again, my simple aim is to pull out tables from a accdb which names meet the ID criteria.

Hi,I have error while running the workbench from How to Expose Feature Attributes from KML Tags or HTML Tables – FME Support Center It failes at point Method 2: XML> 2. Fragment XML Any idea why it does not work. I have not changed any of the settings in that workbench

Hello,I am using a Sharepoint List reader to expose all hidden fields and show all fields. This usually works for me but not for this specific list. This list is very large, has views and hidden fields.  The errors:1) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <…..>' returned from SharePoint. Error message was: '' 2) 2025-04-17 09:48:51|   1.8|  0.0|ERROR |Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: <.….> returned from SharePoint. Error message was: '' The query (url) generated by FME (which I’ve removed from the errors above), is 2300 characters long. When I click this URL it takes me to a blank page with the message:I have found this:https://learn.microsoft.com/en-us/dotnet/api/system.web.configuration.httpruntimesection.maxquerystringlength?view=netframework-4.8.1which I b

would like to know if FME can read annotation classes and text symbol information that are defined in the Feature Class properties (e.g., in a File Geodatabase or Enterprise Geodatabase).Specifically: Can FME access Annotation Class Names? Is it possible to read text symbol properties like font, size, color, or placement defined in the annotation feature class?    

I have a zipped File GDB that I have uploaded to AGOL using the ArcGISOnlineConnector.  The next step is for me to update the data. See 2nd screencapture in red circle, “Update Data”. Is it possible to update data in AGOL using FME? if yes, what transformer do I need to use?