FME Form

Hi everybody!I wrote some weeks ago about a new solution for our education department in order to get the nearest routes between one Adress and all the schools of the city.thans your answers we could make a first version of it!Now that we get more and more users we have seen 2 problems in our solution.We have a point with the adress of the student and the lines of the streets (including the way from the door of the houses to the street). Usually you have some distance between the point and the vertex of the line. To get the point to the vertex of the line we use the AnchoredSnapper (snappint type: end point snapping; snapping distance 15, Add Additional vertex: never). And hier we get 2 problems.If the point is on the line we get the result as “Untouched” instead of “Snapped” If the point is too far away we get the same problem. Is there any posibility to standarize it? I mean we want to cover all

Hi All,I have a feature class with 351 columns and need to know which columns contains ALL the records as <Null>. I have tried the AttributeValidator transformer but it doesn’t seem to do what I want as all the records go to Failed and there’s definetly columns with all records as <Null>, see below: The ‘Attributes to Validate’ have been included the 351 columns,Any ideas how to approach this issue?Thanks :)

I have several types of rasters in my folders (ecw, png, tiff..). Not all folders i want to process contain all of the types. In my workspace i created one reader for each type, but when one type is not available, i can not launch the workspace. How can i make a reader optional so it will accept no input data?

Hello dear communityI am a real beginner when it comes to PythonCaller. I need the syntax to create a group processing with this transformer. My problem: Persons on an address belong to a group. A new attribute should be created based on another attribute in the group.I have already generated a basic program with Copilot, but I always get an errorPython Exception <TypeError>: process_group() missing 1 required positional argument: 'group'The code reads:import fmeobjectsclass FME_PythonCaller:    def __init__(self):        self.data = []        self.log = fmeobjects.FMELogFile()        self.log.logMessageString("FME_PythonCaller initialisiert", fmeobjects.FME_INFORM)    def input(self, feature):        self.data.append(feature)        self.log.logMessageString(f"Feature eingelesen", fmeobjects.FME_INFORM)    def close(self):        try:            self.log.logMessageString(

Hi,I am struggling to read the content of a layer published to ESRI portal. I have a  _website_urlhttps://gis-eu.xxx.com/arcgis/rest/services/LayerTest_Pt_01/FeatureServer/0for ESRI portal layer. For example I need to get Item Id HTTP_Caller does not get this info in _response_body

Hi, I have created a gdb with 2 feature classes, strings and points. But it only works the first time. Every time I make changes to the model and run it again I get errors. I have tried changing every setting but nothing helps. The only thing I can do is create a new gdb every time but that is not the intention.I usually use the Insert and drop and create settings   

Postman connects easily to Veoci (emergency management software) via a two-step process:1) Get a private token;2) Submit query using the private token. These is done in two separate steps:Step 1 (https) returns five new or updated Veoci cookies in the headers, two of which are APIALB and APIALBCORS.  Their values are identicalStep 2 (https) returns two more new or updated Veoci cookies: APIWALB and APIWALBCORS.  These two values are identical (to each other).These four cookies appear to be related to Amazon.I want FME to combine the two steps into one (and let me store the results in a relational database).Step 1 works fine in FME.  In fact, the pattern of packets matches exactly.Step 2 unfortunately returns the message “Authsession not found in cookie” no matter what I try.  I know conversation contains a permanent redirect (looks like Amazon) and I think this is the problem.Even running Step 2 alone in FME always fails

Hi everyone,We have floating licenses and installed FME Form in a server, and the users will login to that server to use FME. So, my question is How many users can run the same workspace using FME Form in a same server at the same time? My user has different username and password to access the server. Please advise. Thank you.  

Hi, I have a html content in _response_body. I am struggling to get only specific text from it. I would like to get only the text highlighted in red. <b>Layers: </b><ul><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/0">2014/02/20</a> (0)</li><li><a href="/arcgis/rest/services/Imagery_Wayback_Ardstaw/MapServer/1">2016/12/07</a> (1) How can I do it? I assume I should use XTMLFragmenter but I am struggling to get the result I want

Hey everyone, I’m currently trying to get a workspace on FME Flow that makes use of the AutodeskDocsConnector. This single transformer would make my worksapace a lot smaller and easier to manage. Problem is that it just won’t work FME Flow! On Form it works without a hitch. On Flow accessing the same project and folder on Autodesk Construction Cloud also works when using the HTTPCaller. It’s only the AutodeskDocsConnector on Flow combo that seems to be failing me. This is the error message I get on Flow:  Anyone have experience with this or know how to help me out on this one?

Hi, Is it possible to read all content of Esri Portal not just one group or a user?I tried to use * but it does not work 

Hi everyone,I’m encountering an issue with the migration of Smallworld collection records to MSSQL using FME. I perform a differential migration of Smallworld records daily, and I need a way to identify and log any failed records during this process.In a previous migration project, I handled this situation using a post-validation Magik script, which compared the migrated objects in the external database. This database had a version control mechanism managed by an additional date column, making it easy to track if records were inserted, updated, or deleted.However, in the current case, there is no such versioning column in the MSSQL database, making it challenging to track failed records.I’ve decided to log the failed records directly in FME. After exploring various resources, most suggestions point to using the Logger transformer, custom transformers, or Python scripts to read the FME log

Hi, I’m using FME 2024.1.I want to write xls files out where my field names appear in Column A (with their corresponding value pair in Column B) instead of in rows. Sounds simple, right?!Writing the data out with an Excel Writer produces a default output like this:Field Names in Row 1, values in the corresponding column....this doesn’t make for a particularly human-readable output when you have 250+ fields in the output dataset.This is the style I would like the output to be in:Field Names in Column A with matching values in Column B.I have tried using an AttributeExploder to create n

Hello : ) I have a Form workbench that first deletes some records from two tables in a geodatabase and then inserts new records into these tables in the geodatabase. This worked fine in FME 2021 but after upgrading to FME 2024 the delete creates a lock on the geodatabase and causes the process to fail: An error occurred while attempting to open an insert cursor on the table 'Total'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.} Any advice on how to fix this problem would be great. 

I am new to using FME and am currently facing an issue. Here's the situation: I want to use a FeatureWriter to create a new file of type Esri Geodatabase (File Geodatabase), and I want to include the value domains of certain attributes when creating the Geodatabase. Thank you!

Hi FME Community!Does anyone know how to create a web service in FME form to connect to ArcGIS Portal?i see this article (https://support.safe.com/hc/en-us/articles/25407635174285-Web-Connections-and-FME#h_01J0S3JP9A7W1TX5B2GG56ZX8S) but could not figure how to properly fill all the parameters to get it working. my goal is to create a token based web connection to authenticate requests to endpoints stored in ArcGIS portal.Thanks in advance!

We have two different buffer results from the same road network and I’m doing some work on identifying what is differentThese are large multipart polygons and I wanted to chop them up to give common parts (overlay > 1) and individual parts. In the picture I want to separate the red hatched bit and the solid blue bits from  the combined data. Running the area on area overlayer with no grouping but creating a list of parts results in…Where the orange hatching has created a fill in on the closed triangle  and the roundabout. This is not what I was expecting but I cannot find a setting on the transformer to avoid this.Help!!!! ThanksRob

Hello FME Community,I am trying to convert annotations from a CAD (.DWG) file to a GIS (.GDB) file in the form of points, in such a way that each line of annotation text is a separate point with an attribute of this text. Everything seems to work fine in my workbench, however, after attaching to GIS programming and loading the resulting points, it turns out that in many cases additional points have been created in each line of text, which prevents me from using them correctly.Has anyone encountered something like this and would be able to help.I attach screenshots of sample annotations in AutoCAD and after conversion in GIS software.FME version: FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) 

I’m fairly new to FME and I’m not sure this is possible. I’m attempting to add a MS Word doc. to multiple zip folders (from a fanout) that contain shapefiles. It’s basically a data dictionary that needs to accompany the shapefiles.  Is this possible?

Does anyone have a sample Workbench (WB) for creating a replica using the ArcGIS REST API?

Hi, I cannot convert Epoch time 1717500804837 to 20241210. I have change the format using @Evaluate(@Value(_created)/1000)and run DateTimeConverter but it failed Null, empty, or missing datetime was found. Enable the passthrough parameter to disable this What am I doing wrong?

After spending all morning trying to set up a Data Stream example in FME I think I’ve got it. It’s a basic geofencing setup:I have a GPX file of one of my bike commutes and use a WebSocketConnector in a sending workspace to send one location per second to a websocket.In a second, listening, workspace, that I’m running as a Stream, I’m using a WebSocketConnector to listen to that websocket and compare the locations coming out of that with a polygon. If it falls inside the polygon I then use a HTTPCaller to send me a message via Whatsapp.This is working fine:However, some of the documentation / tutorials I found, such as Websockets and FME Server, seem to imply that

UPDATE 06/01/25:  It does indeed appear that once created, the index is automatically rebuilt on writing to the GDB with truncate existing.Steps to recreate:Add SQL statement to create attribute index after writeCREATE INDEX <name_INDEX> ON <table_name> (<attribute_name>)Run the writer either to create new GDB or update existing GDB Remove SQL statement Continue to run writer as normal going forwards-----------------------------Hi all,This is driving me crazy trying to figure out. I have a GDB writer that builds an attribute index after write.CREATE INDEX <name_INDEX> ON <table_name> (<attribute_name>)Unbeknownst to me, each time I updated the data, an additional index was being created instead of overwritten which led to a bloated GDB and blown out write times. Note: The GDB table handling is set to truncate bef

Hello, unfortunately I have repeatedly problem with exporting to Excel in Workspace. I checked log, there is following message: 2016-11-24 10:05:57| 67.6| 0.2|ERROR |Excel Writer: Failed to save changes to the spreadsheet 'D:\\XXX\\XXX\\XXX\\new.xlsx'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'It looks, that there is error on Excel side, right? I just want to create new Excel file...

I have 501 polygons of various shapes and sizes. I want to split it up in clusters of roughly 20 polygons each. But I wan the clusters to be located together. I have tried the spatialsorter, which gives good results. But not quite what I’m looking for. Is this possible? Any help would be greatly appreciated.  ThanksB