FME Form

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 obviou

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?

I’m attempting to use a Feature Reader and where clause to identify features in a Mobile Geodatabase with a “publish_date” (datetime) greater than the “LAST_UPDATE_TIME” (datetime) from an SDE Geodatabase. With help from the article below, I was able to accomplish this with a File Geodatabase and SDE Geodatabase, but I’ve now migrated my script to FME 2024 and need to use MGDB instead of FGDB. It seems the formatting is different (I validated in FME 2024 against the FGDB instead of MGDB - it works).Feature Reader from Esri FGDB with a where clause based on a last_updated (date/time) field | Community (safe.com)Below is my attempted logic, where the format of publish date and LAST_UPDATE_TIME, as far as FME is showing me, appears identical. 

I’m trying to read this wfs-service https://avoin.metsakeskus.fi/rajapinnat/v1/gridcell/wfs or alternatively https://avoin.metsakeskus.fi/rajapinnat/v1/gridcell/ows with FeatureReader and FME returns following error: 2024-09-11 10:32:43| 0.0| 0.0|ERROR |<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema=" xmlns:ows="http://www.opengis.net/ows=" xmlns:xsi="http://www.w3.org/2001

I have an Attribute with integer values (4 Digits) and have to extract the first two Digits and write them to a new Attribute.In RegEx I think it is ^\\d\\d. How can I do that in FME?I tried with ExpressionEvaluator and AttributeSplitter @FindRegEx(@Value(Attributename)^\\d\\d)but it does not working. Thanks for helping. 

 Dear FME community.I hoop you will help me with the question I have. It seems simple question, but I could not solve it. I want to find out overlapping pipelines in the same dataset with different owners. I want to have list of the piplines who overlap with each other and who have different owners.I used line on overlay transformer but I could not get what the result I wanted. Any help is apricated and thank you in advance 

At the FME Flow (we’re looking at 2022.2 specifically) level, many people will be familiar with the ability to set time outs for queuing and running  Through the API you can also specify these by using the Job Directives: https://docs.safe.com/fme/html/FME-Flow/ReferenceManual/Job_Directives.htmThe scenario that we’re facing is there is an external process (not FME) that is setup to call a bunch of different workspaces depending on what is passed through. This is a process not managed/administrated by us. Depending on the workspace called, we want to specify the running expiry at the workbench level, of course this could be doing with logic in the external proc

This has been bothering me for a long time. I keep avoiding it because I just end up using a SQL executor. to find errorsHow is the Writer transformer different than a SQLExecutor when performing MSSQL inserts? [or other functions]. Don’t they use the same driver?Here is an example: I recently inserted a row into a table where the string length was too long got the field. The Writer transformer just inserted the string successfully, but it truncated. The SQLExecutor threw a SQL error saying, ‘string or binary data would be truncated’ and then failed\rejected the insert. I have also run across other odd behavior in the past. Such as the writer having the ability to insert duplicate foreign keys, but the SQLExecutor will fail with error. Is there a good resource for this or a good explanation? Thanks!

Hi guys i been working on a “easy translator” type of app on Flow and really struggling to get it read shapefiles in a zipped file. Error message below.. have no idea why it add a “_0” after “.zip”.. can this be the reason it failed? Shapefile Reader: 'C:\Users\SVCAWS~1.SC\AppData\Local\Temp\fmeengines\AWSGISFME01_Dynamic_Engine1\TempFS_1725628283291_20936\dsGENERIC_1_0\Inputtt.zip_0' is not a valid Shapefile and cannot be read Thank guys!

Hi everyone, I am now doing data quality inspection to an esri personal geo database with multiple layers, and I have to calculate how many 0 or null values there are in every attribute of each layer(or table) in the database. I have tried to figure out some automation method with FME but in vain. Can anybody give some instructon or advice? 

I have a fileGDB with a single feature class, and that feature class has metadata.How do I export that metadata to an XML file?I am using FME Desktop (FME Form) 2022.1

Hello every oneI have workspace to read many files in SharePoint just to know which folder has updated with new dataAnd it’s taken to much time to read all files in SharePointMy question is : is there is any way to let SharePoint connecter read folders only without reading all file inside or read one file from every folder just to decries the time and speed the workspaceThanks for all your support

I have a dataset stored in Oracle Spatial, and I have metadata stored as an xml file (the xml is generated by ESRI software).I want to Write a fileGDB where the metadata is added to the feature layer.How do I accomplish this?

Hi,I haven’t been able to find this question asked anywhere, but I’m sure it has been. I’m at a lost though. I have a unique attribute in a group of features. I wish to find unique combinations of all possible pairs in my group of features.For example, if I have three features. Their ID’s are 1, 2, and 3. The result I want to find is a feature with a new ID of: 1-2, 1-3, and 2-3In reality my groups can be up to 20 features in size.I can’t work out how to accomplish this in FME. Though I’m sure its very easy.Does anyone know how I would do this?

A month ago, I generated an fmw (Build 24202) that read from Esri ArcGIS Server Feature Service, (url, user, pwd) correctly.today when opening the fmw gives error and is not able to read, I do not know why it can be, if everything is the same as a month ago.Thank you so much!  

Hello, I have recently upgraded FME Form 2024.1. I tried to run a project, but I immediately got the following error message: “FME failed to restore the process locale to UTF-8. A non-UTF-8 process locale may cause undefined behavior.” Is there any quic fix for this issue?