FME Form

Hello Forum, I need to find the records from one dataset where the value in one of its attributes is the same as the value of an attribute in another dataset. For example, If I have two datasets (A and B) I want the output to show which records in A have shared value in B, based on a specified attribute. I want the output to be a selection of A. Something like this…  I’ve tried Matcher, but that didn’t work for me. Thanks,Stuart

I remember back in 2021 when this happened, someone from Safe was able to point me to where the “recover” file was saved. Please help me again as i have created a very robust workspace but have not saved it and it would take me 3 hrs to recreate this workspace

I’m a newby to FME.I’m about to write workspaces to refresh a list of AGOL feature services.  So far I’ve written a simple one that works on a small service.I’ve got a few questions.When I search for potential pitfalls in this forum, they are 5+ years ago and relate to AGOL time outs and also issues updating large datasets.  .  I’m on the latest release of Form & will use Flow (Hosted).  Are these issues still relevant these days ?My largest dataset is our Cadastre being about 140K features.  Am I safe to use the Writer ? I am doing truncate & inserts.  One might argue that I could use ChangeDetector beforehand, however, I reckon the processing required to compare 140K features would be greater than a simple truncate & insert. (am I right?) If an error is encountered, I would like to quickly restore the destination feature service back to what it was. Any tips on the best approach to doing that ?  My idea is to copy the destination service elsewhere in AGOL before commencin

I have an FME workbench that runs every 10 minutes that reads from an ESRI Feature class in a SQL database. Once in a blue moon I get the following warnings.Unable to retrieve feature from table/feature class 'xxx'. This feature, and any other feature from 'xxx' that cannot be read, will be skipped. The error number from ArcObjects is: '-2147154945'Unable to retrieve feature from table/feature class 'xxx'. Aborting reading from table 'xxx'. The error number from ArcObjects is: '-2147216010' Yet the next run 10 minutes later has no problems. When this occurs I want the workbench to stop rather than proceeding with the incomplete data set. Is there a way to force a termination when this happens?

Hi, I'm attempting to classify the ground from point cloud data using FME transformers, but I haven't been able to achieve the expected results. Could you please provide a detailed workflow for ground classification in FME? I specifically want to generate a Digital Terrain Model (DTM) of the ground, excluding other features. Thanks! Classification Point cloud Orthomosaic 

Hello everyone,I have the following data structure and I don’t know which solution would be the best in FME Form to get the required result:attribute1; attribute2; attribute3Kreuzberg; Rom; group 1Berlin; Kreuzberg; group 1England; London; group 4London; England; group 4Lissabon; Carrer; group 2Carrer; Lissabon; group 1Kreuzberg1; Rom; group 1Rom; Kreuzberg2; group 1I need to create a group_id attribute that has the same id where attribute1 values reappear in attribute 2 and vice versa + the features need to have the same attribute3 to get the same group_id. This is how the output should look like:attribute1; attribute2; attribute3;group_idKreuzberg; Rom; group 1;1Berlin; Kreuzberg; group 1;1England; London; group 4;2London; England; group 4;2Lissabon; Carrer; group 2;3Carrer; Lissabon; group 1;4Kreuzberg1; Rom; group 1;5Rom; Kreuzberg2; group 1;5Thanks for helping!

I’m following this API documentation to authenticate and can successfully do so in Postman.  However, with the HTTPCaller it keeps returning a 400 error:    "error": {        "code": "no_grant_type_provided",        "message": "Bad Request",        "status": 400    },I feel like I’m close but can’t crack this nut...what am I doing wrong?? Postman:Postman HTTPCaller:HTTPCaller 

I have several polygons. They follow a line pattern where tre long polygons should be one large, and by that i mean that there should be no space between them, and instead of three long polygons it should be one large. The following image shows three pairs, so these nine polygons should be three larger polygons.  Any idea how to do this? 

Hello, i have an api which i need to read on a daily basis.I use an httpcaller, this is what i get.{   "values" : [      {         "id" : "66d9f33fa4766fe73ac59fb9",         "start_time" : "2024-09-05T20:06:55+02:00",         "end_time" : "2024-09-05T20:07:54+02:00",         "vehicle" : {            "id" : "xxxxx",            "country_code" : "BE",            "id_type" : "licenseplate"         },         "price" : {            "amount" : 0,            "vat" : 0         },         "right_type" : {            "code" : "PAID_PARKING"         },         "area" : {            "code" : "xxxx",            "area_manager_id" : "611e58c434e393575bd3a064"         },         "registration_time" : "2024-09-05T20:06:55.593+02:00",         "registered_by_organization" : {            "code" : "xxxxx",            "name" : "xxxxx"         },         "external_user_reference" : "31358053",         "channel" : {            "medium" : "api"         },         "tariff" : {            "id" : "653ba7cd9c4bdbc

Hi,Using 2024.1 : not sure if I’m supposed to feel zen about that, but I don’t. Before I just had to click once to get into parameters.Now I have to click twice to get into parameters. I am more frustrated than zen.My personal feeling.

I need to find lines which are completely outside polygonsI am using the Spatialfilter with “Filter is OGC-Disjoint From Candidate”. All of them pass and I dont understand why?Current workflow This is my dummy data i am using. As you can see, the line highlighted with the red box is clearly the only line disjointed from the polygon. So why does all candidate pass, it make no sense to me? What form of transformer should i use if what I do is wrong? Its obvious to me that it qualifies os OGC disjoint?https://docs.safe.com/fme/2023.2/html/FME-Form-Documentation/FME-Transformers/Transformers/spatialrelations.htm

I’m working through a test case to pull a table data from one of our MS SQL databases into Google BigQuery. I’ve downloaded and installed the BigQuery package from FME Hub and setup the needed Clientid and secret to have it connect to our Google Cloud project. It tests successfully in the services setup, and if I use the GoogleBigQueryConnector, I’m able to select our cloud project and dataset for reading, so I know the connectivity part of it is working. The issue is trying to write something to BigQuery.If I go to create a writer and choose “Google BigQuery” as the format, the Format selection stays red, like it’s an invalid selection. What am I missing?Unable to select Google BigQuery as a Writer format 

I have a JSON template that I want to fill with values from two corresponding lists using xquery.The two lists look like this:keywords_thematic_en = ["test", "trial","error","datapool","API","REST"]keywords_thematic_de = ["Test", "Versuch","Fehler","Datenpool","API","REST"]keywords_thematic = {"en":keywords_thematic_en,"de":keywords_thematic_de} The JSON template I want to fill looks like this:{"keywords": [ { "value":keywords_thematic_en,"valueDE": keywords_thematic_de,"type": "THEMATIC" }]} In python, this looks like this:keywords_thematic_en = ["test", "trial","error","datapool","API","REST"]keywords_thematic_de = ["Test", "Versuch","Fehler","Datenpool","API","REST"]keywords_thematic = {"en":keywords_thematic_en,"de":keywords_thematic_de}jsonSnippet = '{"keywords": []}'jsonSnippetKW=''for keyword in keywords_thematic["en"]: jsonSnippetKW = jsonSnippetKW +'{ "value":'+ keyword + ',"valueDE": '+ keywords_thematic["de"][keywords_thematic["en"].index(keyword)]+',"type": "THEMATIC" }

Hi,  I’m working on automating our FME workspace deployment on Azure Devops using the functionality in pipelines. One thing I would like to automate is to extract metadata about every workspace pushed to the repository and write it to a README.md file. With such a file placed next to every workspace it would be easier to navigate our repo. I would like to see basic information like workspace name, description, number of transformers etc.What’s the best way to extract this data? I have tried using python to read the .fmw text directly and using the FME workspace reader with partial success.  Has anyone else done something similar or have ideas? 

HiWe need to allow users create a zipped shapefile with a single feature. The shapefile needs to be named as the reference for that feature (an attribute in the table)I can create a zipfile by clicking the zip icon in the dataset field of the writer. However, this just creates a zipfile which is named after the folder it is saved in.Is there a way to name the zipfile using an attribute? Or is there a way to automatically rename the zipfile? Thanks 

I have a giant spreadsheet that many people have added notes or comments to by right-clicking on the cell and saying "new comment" or "new note". Is there a way for fme to figure out which cells have comments?

I have a shapefile with sub areas and I want to create an FME workbench to assign the areas to 3 operators with the condition that the operators don't work on areas close to each other. which FME transformers can I use as I want the output to be 2 shapefiles one with a list of areas that can be assigned to the operators at a particular time and another one with a list of areas that cant be assigned at that time.

Hi everyone,I'm trying to check if polygons from Dataset A overlap with polygons from Dataset B in FME. I’ve attempted to use the SpatialFilter, but it only offers options like "intersects" or "touches." However, I specifically need to determine if the polygons are overlapping.Has anyone encountered this issue or found a way to achieve this in FME? Any suggestions would be appreciated!Thanks in advance!

Hi, I created a shapefile with line segments (roads).  This shapefile has to be loaded into a postgis database and the person who has to do that sends me that she gets this error  ERROR:  Column has M dimension but geometry does notCONTEXT:  COPY tmp_shp_crab_wegsegment, line 1, column geom: "01050000208A7A00000100000001020000000700000000F3BE9F41600A4180690B0048FD0941005FDD2623600A41008F7F97..."I did some searching on the forum and found some things like the Measure remover, and I also set the output dimension to 2D in the writer but she says she still gets it. Does anyone know what else it could be due to? Thx!Nathalie 

I am attempting to create a workbench to read, process, and convert IFC and 12dxml files into gdb files (multipatch and basic respectively. The output for the IFC/GDB Multipatch is working properly and is set to a dynamic filename without issue. However the output for the 12dxml only runs when targeting a specific location (can’t set filename dynamically) and even then it returns a message saying that 0 features were output. I am fairly new to FME and have not been able to determine why this is failing, short of the possibility that the writer is trying to write polylines and getting information in as polygons, which I am unsure how to fix. I have attached the rather voluminous log on the chance someone is able to point me at the particular error I need to fix.

Hi everyone! So I have some LAS files that I would like to filter. The flow is as follows:Everything seems to be working, but when I read the processed las-files into my program that I need to use, I can’t get it to work. The original files do work, so it’s something that happens along the way. Any ideas?

Hi,I keep going in circles and can’t think of an easy way to do this. Has anyone got any tipsBasically, I have an attribute such as “TEST_240829_MLS_5_316460_5816230”What I what to do is remove “_316460_5816230” from the end. I’m wanting it to adaptively remove this part of the string from several thousand inputs.Normally I would use the attribute trimmer however the length of this part of the string will change (not a constant thing I can remove). This part of the input string does always start at the second last occurrence on the “_” delimiter and go until the end. The amount of delimiters is not constant in the part of the string I want to keep though, so I also can’t use the attribute splitter and then rebuild the part I want from the parts of a listIs there an easy wany to do this?

Hiyas,I’m having an issue where I try to import data from a excel spreadsheet into a Choice user parameter.I only ever get the first row to import, even though it displays all data.Choice → Choice Configuration → Dropdown → Import from datasetDataset = My excel fileFormat = Microsoft excelParameters shows the valuesNextImport Mode - Import from: Attribute namesNext Import then results in only the heading being imported; Am I missing something really obvious? Thanks,

I have a workbench set up on a desktop PC that is reading numerous data sets from folders on that computer. The workbench is also saved locally.I have moved a copy of the data and workbench in the same folder structure onto our shared network where the start of the file path is different.eg. C:\\Data\\Workbench.fmw & C:\\Data\\Input\\Data.xlsbecomesP:\\Project\\Projectname\\Data\\Workbench.fmw & P:\\Project\\Projectname\\Data\\Input\\Data.xls How can I set up the workbench so I only need to change the folder path to data sources once, and all the others know that the relative path has changed? Thanks!

Hello,Could you please help with ideas how to implement the following: I run SQL query by SQL Executor that checks something in PostgreSQL DB and as a result provides set of SQL queries that should be executed in the database afterward. How to execute those newly generated queries? How can I run all those resulted queries after SQL Executor?