FME Form

Hi Everyone, Looking for some assistance, I’m using FME 2023.1.0.0 trying to migrate some existing Survey-123 forms and data with attachments from ArcGIS On-Line to our new Enterprise portal. Our survey-123 form has a singular photos field for tracking a picture of the bus stop, it also has a repeatable photo’s field (table) where the inspector is able to take and attach multiple deficiency photos to the stop if one exists. In FME, I’m able to read in the AGOL feature service that hosts all of the survey information, I’m also able to write out the tabular information from the point layer to the new Enterprise feature layer that was created when I saved the Survey-123 form in Enterprise. The part that I’m currently struggling with is getting the singular photos to attach when writing the tabular information out to the Enterprise feature service so when I view the points in ArcGIS Pro, they appear in the attachments tab of the attributes editor like they currently do with my AGOL service

Hello all, I am working on the generation of SolitaryVegetationObject with a workbench referring to https://hub.safe.com/publishers/con-terra-lab/templates/citygml-create-solitaryvegetationobject-with-implicit-representation. The conversion details could be reference to my last post below. As you could see from the FBX and CityGML file below, some texture went missing in the CityGML model. I have only one PNG as texture and my model has two parts, one is the crown (130 surfaces) and another is the trunk (2700 surfaces). My findings are that the <app:X3DMaterial> part referenced to both parts of the model separately while the <app:ParameterizedTexture> part only referenced to half of crown part of the model (65 surfaces), leading to an incomplete texture. Is there any potential cause to this problem as observed from my workflow and is there any way to fix the issue? Thanks! FBX texture CityGML appearance Workflow for FBX to CityGML

Hello all, I am currently working on the conversion of FBX tree model to CityGML SolitaryVegetationObject. I have made reference to the template workflow for creating SolitaryVegetationObject (ref: https://hub.safe.com/publishers/con-terra-lab/templates/citygml-create-solitaryvegetationobject-with-implicit-representation). However, my case is slightly different from the template. First of all, what I current have, is a CSV file containing the tree information (XYZ, DBH, etc) and an FBX file containing one 3D tree model with correct transformation and dimensions (DBH). This FBX file was originally a prototype in FBX format and was transformed into a correct XYZ and DBH. Since not all my data contain crown spread and tree height, they would be estimated by scaling from the prototype with reference to DBH. This estimation would not generate a value for the crown spread and tree height but only a dimension change. What I want to do is to convert this FBX into a CityGML file, appending the

I am using the OGC WFS Reader to try and connect to my site in the TreePlotter App (cloud based app by PlanIT Geo). I have the API Key and other parameters. When I run the Reader, I get these errors (from log file). Does anyone have an idea on what could be causing this? (I followed the instructions from their website: https://support.treeplotter.com/knowledge-base/wfs/) 2025-04-28 16:32:25| 0.8| 0.0|ERROR |<ows:ExceptionReport version="2.0.0=" xmlns:ows=" http://www.opengis.net/ows/1.1= " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance= " xmlns:planit="planit: https://pg-cloud.com/planit= " xmlns:wfs=" http://www.opengis.net/wfs/2.0= " xmlns:gml=" http://www.opengis.net/gml/3.2= " schemaLocation=" http://www.opengis.net/ows/1.1 http://schemas.opengis.net/ows/1.1.0/owsAll.xsd= "> <Exception exceptionCode="CODE WILL GO HERE=" locator="FeatureInPolygon">="> <ExceptionText> https://pg-cloud.com </ExceptionText> </Exception> </ows:ExceptionReport> 2025-04-28 16:32:25| 0.8| 0.0|ERROR

Context : The reader file has 14 attributes ( No formulas ) and the format is Excel File. For the writer file, I am trying to leverage an existing template file (with 2 sheets - Standard & Limits) and the final output should be written to the Standard sheet of the template file. The template file has 80 attributes in total. The value for some attributes are based on the value from the reader attributes, some attributes are hardcoded in the template itself and the remaining attributes will be populated based on the formulas from the existing sheet i.e Standard and the Limit Sheet. What is the ideal approach to achieve the result ensuring no formulas are overwritten in the template file - standard sheet in the process and that my final writer output has the exact same sheets ?

Hi, Pretty new to FME, so hopefully I have all the terminology right and I’m asking the right sort of questions. I have a feature set from Freshservice API of the available products in their asset system.It’s mostly the Latitude and OptiPlex products I need to work with so the solution can work just for them. I need to match the freshservice_product_name to a feature set that I don’t control and isn’t consistent. As you can see the tesma-description is a bit of a mess but it’s all I have to try match up the freshservice_product_name to. Can someone point me in the right track of how they would tackle this? Thanks,

Hello everyone, I need help with polygons and multipolygons with my geometry, i read shape file if that is important1. Which transformer should i use, or how can i see if my geometry is polygon or multipolyon ?2. How can i change type from polygon to multipolygon, what should i use for that change?

Hello all, Complete FME newbie here I need to transform the data compiled by a different department as an excel spreadsheet to look like this: From Initial structure To Final structure Basically 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' needed to update/delete". However I ca

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 ValueF

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 String String 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 can d

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 anything here 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.