FME Form

We currently have an .asp script that builds a url/uri based on a selected prefix and document ID. When the OK button is clicked, the url/uri is opened in a new browser tab. The server where the asp script is located is being retired so we need to come up with an alternative. The parameters are Plan Type and Plan Number. The parameters are used to generate a path to the document to open. Eg. \\sample.file.path\resources\SCIMsPlans\pm12345.pdf I have converted the ASP to Python and made a self contained executable that works well but staff are used to accessing the plan search via a web link. I thought a FME web app may be suitable for this. Can anyone point me to the correct transformers to use for this or even better, a sample workspace. In case it helps, below is a snippet from the python script that builds the file path and opens the document. # The Plan document ID number name = self.plan_input.text().strip() # If 'dp' is selected, use 'DP_DepositedPlans' to build the path. folders

We just started integrating data to GCP BigQuery by adding a system environment variable called ‘GOOGLE_APPLICATION_CREDENTIALS’ and pointing that to the service account key file. I am anticipating a need to integrate with a different BigQuery and would like to know how to run parallel integrations to two different GCP accounts. Any thoughts? Thanks.

Hi everyone, I’m pretty new to FME and I’m using FME Workbench 2024.2 to move data from my sde gdb schema to an Esri Parks and Grounds solution fgdb schema. I’m having trouble with the SchemaMapper and moving my domains(attribute values) to the fgdb’s schema. Currently they are not mapping. Previous SchemaMapper parameter settings moved the source attribute value over to the target attribute, but kept the same source attribute value (MULTI-FEATURE STRUCTURE should’ve changed to Jungle Gym but instead it stayed as MULTI-FEATURE STRUCTURE). Can anyone help provide more instruction on how to get the source attribute values to move to the target attribute name and change to the target attribute value? Here’s the .xlsx I’m referencing Here’s my SchemaMapper Parameters

I’m stringing together a bunch of HTTPCallers, each of which has several query string parameters. From what I can see, you are only able to see two parameters at a time in an HTTPCaller transformer (see screenshot). Is there a way to enlarge/expand the dialog box so I can see all or most of them at once? Should be easy; I feel like I’m missing something. It would be so much easier, helpful, and efficient so see all query string parameters at a glance. (FME Desktop 2023.2.0.0, Build 20231201).

Hello everyone, We are encountering an issue when using the SharePointOnlineConnector. My colleague, who is a member of a SharePoint site, was able to retrieve all files from the site using the HTTPCaller. However, when attempting to retrieve the same files using the SharePointOnlineConnector, not all files are returned. We are unsure why the SharePointOnlineConnector does not return the complete list of files from the site. For further clarification pictures are added: My colleague can access a specific list in Sharepoint itself (Codes) In the SharePointOnlineConnector, after connecting to the same Site, the list Codes is not available to him. Codes is a List and not a Document. Maybe that might be the reason why Codes is not available? ---------------------------------------------------------------------------------------------------------------------------- On the Azure App Registration side, the settings are configured as follows: Permission Type: Delegated Permission app registrat

Is this a bug? I am trying to list and download several files (some have dependencies-- references-- and some don't) and noticed that I cant download files that have an associated reference file. Any thoughts or suggestions? Thanks

I have an ArcGIS Online hosted feature layer containing point features that have attachments enabled. Could someone help me with some advice for how to use the ArcGIS Online feature reader that will allow me to access the features and their associated attachments (if there are any-not all features have an attachment)? It is easy enough to get the features, but I can't see a way to access the attachments. Thank you!

Hello, I want to report a bug related to adding attachments to a feature in an ArcGIS Enterprise Feature Service using the ArcGISAttachmentConnector in the latest version. I receive the following error: (C:\Users\x\AppData\Roaming\Safe Software\FME\Packages\25606-win64\python\safe.esri-agol\fmepy_esri_agol\attachments\handler.py:104) add_attachment return AttachmentResult.from_dict(response.get("addAttachmentResult", {})) ^^^^^^^^^^^^910523 Python Exception <AttributeError>: 'generator' object has no attribute 'get' The problem is that the ArcGIS REST API addAttachment endpoint returns text/html instead of json. This appears to happen specifically for Enterprise Feature Services, as described here. As a result, the result cannot be decoded. However, the attachment is actually uploaded successfully. Bug fix: Change the line 43 from files = {"attachment": (filename, file_obj, mime_type))} to files = {"attachment": (filename, file_obj, mime_type), "f": (None, "json")} in C:\Users\x\AppDat

Hi, I am using a bufferer and a dissolver transformer to generate a buffer polygon from an aggregated set of 500+ geometries. The Inspector is showing the generated geometry but the Oracle Spatial writer is unable write the geom into the spatial table. I am getting the error "Bad geometry detected in the following feature; Geometry could not be encoded for Oracle". I have added a GeometryValidator after the Dissolver transformer. The generated geom comes through the PASSED output but still the error remains. FME Desktop 2013 is used. Regards, Ananda

Hi, I get the following error when attempting to publish a workbench from FME form to FME Flow: User is not authorized.The specified user credentials were not authorized to perform this action. Ensure with your server administrator that your user credentials are authorized to perform this action. Publish Failed (Not Authorized) - Ensure that credentials are correct, and that user has sufficient privileges. I’m publishing using an account with superuser access. I’ve also managed to upload the workbench directly to a the folder using the FME Flow interface FME Form: 2025.0.1.0 (20250327 - Build 25220 - WIN64) FME Flow: FME Flow 2025.0.1

I have an export of an MS Whiteboard in pdf form. (I also have the JSON and HTML. The JSON doesn’t store the note contents). PDF reader is spotting text, but I’m struggling to pull it out ‘per note’. Any ideas?

Hi, We are trying to use a FileCopy Transformer to transfer files from one location to our server (synology) / other computers (other computer). If we do it in Ubuntu GUI / SystemCaller command it works perfectly. But the file copy transformer always give error messages as we don’t have sufficient permission. Even if I put our NAS credential in the transformer (with a featureWriter), it give the error messages. The files are created in the server but there’s no content inside. Does somones already experienced it ? Thank’s Sam

I’ve got a weird problem where an Excel reader is reading an entire file correctly, except for one column where it is only getting part of the data. When I decode the XML of the Excel file (change extension to .zip and expand), I can look at sheet1.xml and I see the following data: <c s="12" t="inlineStr" r="AK10"> <is> <r> <rPr> <b val="0"></b> <i val="0"></i> <strike val="0"></strike> <u val="none"></u> <sz val="10"></sz> <color theme="1"></color> <rFont val="Courier New"></rFont> </rPr> <t xml:space="preserve"> </t> </r> <r> <rPr> <b val="0"></b> <i val="0"></i> <strike val="0"></strike> <u val="none"></u> <sz val="10"></sz> <color rgb="FF333333"></color> <rFont val="Arial"></rFont> </rPr> <t xml:space="preserve">Yes</t> </r> </is></c> This looks like two bits of text, one with several spaces formatted as Courier, then the word “Yes” formatted as Arial. FME is reading the first part of the text but not the second part and there doesn’t seem to be any way to convince it to extract th

I’m using FME 2021.WAL is possible pour SQLite since 2010, Geopackage is based on SQLite. I didn’t find any way to activate WAL on a Geopackage FeatureWriter in order to avoid lock problems. How can I use WAL on Geopackage ? Is it available in later release ?

I have a workspace that reads an excel spreadsheet that contains 20,000+ rows with file names and paths to DWG files which works 99.9% of the time. The simplified process is as follows: Filter the list of files from the spreadsheet to remove certain filename patterns Read the dwg model space, but only keep lines that are on layers that starts with BND Test to see that they fit in a polygon using spatialfilter clean up attributers and write the results to shp file For some reason when it hits a certain file, the process stops when it hits an error (even it is set to continue on rejected feature and ignore failed readers is set to Yes. I have attached a zip with the log file as well as a FFS file it create which contains a single line that doesn't appear to be anything unusual or unexpected. My work-around for now is to skip the offending file by using the “features to read” settings on the reader. Given that there are 20,000+ files, I tend to run 5000 at a time.

I have a workflow where I am creating a raster using SurfaceModeler. As documented, this transformer may output some NaN values when using PLANAR interpolation. I indeed have a few cells that come out with a NaN value. I am not certain what transformer can change my NaN values to NoData values (or any other values)? I read through this article: http://blog.safe.com/2013/11/fmeevangelist119/ and thought the NullAttributeMapper would be the answer, but it does not seem so.

Hello, I am using FME Form 2025 and looking to write shapefiles/ geodbs dynamically to an ArcSDE Geodb.My issue is that where my source data has the data type VARCHAR2 it is written into Oracle as NVARCHAR2.According to our database manager our preference is VARCHAR2 due to: “VARCHAR stores each character using a single byte, NVARCHAR columns typically consume twice as much storage space as equivalent VARCHAR columns.” I have tried multiple options of resetting the data types and writing out either using automatic attribute definition or dynamic (using the readers schema), but in any case the final table stores NVARCHAR2. Is it possible to change the data type from within FME? Many Thanks!

Upgraded from FME Desktop 2022.2 to FME Desktop 2025.1 (Build 25609) In FME 2022.2, I had a FeatureReader reading to a FeatureService URL with no issues. Perfectly was able to read it and extract its spatial content and attributes. Upgraded to FME Desktop 2025.1 and it no longer works. Could this be like an internal firewall blocking access to this or is it the way FME 2025 handles SSL certificates? If so, how can I remedy this? Any insight is much appreciated. SAMPLE Workbench I have the latest package installed Error message: ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services.arcgis.com', port=443): Max retries exceeded with url: /mMUesHYPkXjaFGfS/arcgis/rest/services/ROLL_ENTRY/FeatureServer?f=json (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Basic Constraints of

I want to change paths for readers in multiple FME workbench files and Ive been trying all day without success to do so without doing it manually. Does anyone know how to do this :) ? For example from \\192.168.221.35\ftp\hofn\Höfn-skolplagnir.shp to \\192.168.221.50\ftp\hofn\Höfn-skolplagnir.shp with the only change being the ip path from ending at 35 to ending with 50 but for multible at once :) I already tried changing in Notepad as suggested here with all the paths but it doesnt work for some reason. Also consulted chatgpt for Powershell scripts of different variety... Thank you for reading :)

Hello everyone! So I’ve had a workflow run fine for the past 2+ years. It involves using HTTPCaller to send a GET request to our OpenText ContentServer repository and download a csv document as an attribute for further processing. It appears that at some point in late June, the service credentials we’d been using all along are no longer working in FME or something because we’ve been consistently getting a 401 error in the rejected features port of the HTTPCaller. We’re seeing this behaviour in both FME 2022.2 and 2024.2. The thing is, the same credentials will work fine when the URL request is done manually through the browser. The setup has originally been NTLM, with the service username and password passed from User Defined Parameters. When I check ContentServer’s authorization settings through the browser’s Developer Tools it still shows up as NTLM too, so that hasn’t changed. I’m hoping for any ideas or leads that I can look into. Is it possible that something was done on the Conte

FME Form (Workbench) 2024.1.2.1 (20240906 - Build 24624 - WIN64) Oracle Spatial Database 19.27.0 (19c) Hello! When trying to read data in from an oracle spatial database, I receive the message that FME cannot query the metadata table. It's unclear to me which metadata table the reader is trying to use. This happens both with a FeatureReader and a SQLExecutor, the behaviour is the same. When switching logging to debug, there is no further logging of the query that is being executed. 2025-07-29 13:52:56| 0.3| 0.0|INFORM|ORACLE Reader: Executing SQL Statement `SELECT * FROM DINO_DBA.GDW_BLK_ARE_VW' to obtain features for feature type `'2025-07-29 13:52:56| 0.3| 0.0|WARN |Could not query Metadata table for dimension for geometry column 'GEOMETRY' of table '' -- geometry will be assumed to be 2D The FME documentation I could find (FME Support Center: Adding metadata entries for Oracle spatial tables or views) hasn't been updated since 2015.1, and refers to MDSYS.SDO_GEOM_METADATA which is a

Hi all, how do I easiest update change the field type in a GDB? Esri Introduced the BigInteger, which is giving me a lot of issues. It dosn’t work in all applications, and I can’t even do a relate or join on it. I need to get it into a integer. For some reason the data we get delivered now on a weekly basis has all the number fields in BigInteger. I need it to find the BigInteger Fields, and change the type, without loosing data. The data also fits an normal integer. Any thoughts would be much appreciated. Thanks

Hi, I'm having an issue with a Microsoft Access Reader. I have a script that reads a query from Access. This query is a subquery of two other queries. Until now, the script has always worked, but now the query reader doesn't show anything.

Morning All, Has anyone else identified an issue with all SQL transformers when specifying the connection via either deployment parameter or database connection? When run on Form it operates correctly but when run via Flow (either scheduled or manually submitted) the following error is returned: Error occurred while opening database reader with server type `MSSQL_ADO', server name `XXXXX', user name `', database name = `' : `Encryption Error: AES Decrypt finalization failed.' If the database connection is embedded into the transformers Flow is able to operate these transformers correctly, however this would then require each transformer to be reconfigured as we migrate between environments. Thanks in advance, Paul.

Hi All, I have a folder of csv files with the naming convention like this : Insp1.csv, Obsv1.csv, Insp2.csv, Obsv2.csv etc etc. I have written a workbench to read in Insp1.csv and Obsv1.csv and derive the outputs i want. These csv files are pairs and both are needed to create the output. I have a folder of many InspX.csv and ObsvX.csv files that I want to process. I have set up a Directory and File Pathnames reader than I think I want to pass into a workspace runner that calls the workbench to process the files with parameters. How to I get FME to iterate over my files and each time the runner is called iterate to the next pair of csv’s? ie first time is run use Insp1.csv and Obsv1.csv, the second time use Insp2.csv and Obsv2.cvs etc etc Many Thanks Goatboy