FME Form

Yes he does have hallucinations ! This transformer doesn’t exist. I wish it would though. 

I’ve been needing to identify leading and trailing spaces across many attributes, with a significant number of features. I don’t need to trim them, but rather identify their existence.The only solution I’ve been able to come up with so far is to use AttributeValidators - this way, I can set it to run against the 50 or so fields that need to be validated. I’m using Regex and the rule “^ +” for leading spaces, and a second AttributeValidator with the rule “ +$” (double quotation marks only for readability here, not used in the Rule Configuration) for trailing spaces.This works, but it is very slow. Is there a better way to do this within FME, without resorting to some Python?Thanks in advance for any thoughts on alternative approaches!

Hi I am uploading data to S3 using the S3 connector. However, empty folders are not being uploaded, even though I have selected “Contents only” as No. I need to upload some projects that contain empty folders and subfolders as well.!--startfragment>  Many thanksNasir

Is FME able to read the MicroStation DGN file geographical coordinate and use this information when creating esri geodatabase features?  I see several tutorials and methods that seem to suggest CAD data such as DGN (MicroStation Design Files) do not contain geographic Coordinate systems but is not totally true.  Design files do or can have coordinate systems, and most do when relative to Transportation Civil Engineering Design. 

HiI have a a workflow exracting data from an API. I have got almsot everything I need from the JSON but need to get as single description field. The JSON structures breaks the description into sever parts all nested within the description part. The number of parts varies by feature.I essentially need all the text elements in the image below  When I use a JSON exposer it asks me to specificy each indexed element, but I do not know how many there will be in any given feature  I imagine there is something really obvious I am missing hereClosest I have got is adding another JSON extractor using the query:json["fields"]["description"]["content"][*] is giving me:{"type":"paragraph","content":[{"type":"text","text":"This Jira ticket is for all activities related to the implementation of 365 – "},{"type":"text","text":"Office.com","marks":[{"type":"link","attrs":{"href":"http://Office.com"}}]},{"type":"text","text":" rollout."}]}Or using:json["fields"]["description"]["content"][*]["content"][*

I have two tables where I have to compare rows against columns. First table (excel) contain Analytes as columns, but the second table (sql) has analyte column which contains all the analytes as values. I have to compare the values from the Excel table (which has analytes as columns) with the corresponding limits from second table.Example of first table:Example of second table:  I have tried couple of methods such as attributepivoter ,doing it via the pythoncaller but was not successful

Hi FME users,I am creating an automatic workflow to download GTFS (Transport Data) by HTTP caller. The zip file contains few CSV files which I need to read them separately for my workspace. The issue is I cannot reach each file through the zip folder by using Feature Reader. I want to avoid unzipping manually as I want to create an automatic workspace. Can you please advise on how to solve this issue? Appreciate your help.  

I am reading data from SQL Server that is in the default dbo schema. I want to write the data into a specific schema in postGIS.But i struggle to make to do this as a dynamic workbench.The setting is to Always create tables. The table is created as expected (dbo. is replaced with correct postgis schema name in StringReplacer).But i get an error trying to write featurePOSTGIS Writer: Fanout for feature type '' failed to find feature type template ''Seem to be a missmatch between the schema feature and the feature itself?  

I have an odd problem. I have suddenly lost the ability to view the lists on my objects in the “feature information” pane. They are indeed there, I can search and explode them, but for some reason -mid working on this workbench- I have suddenly lost the ability to see my lists.I am in version 2024.2. I havent found anything helpful or related online yet so thank you if anyone is able to assist. created list ^ no list visible ^ I am ONLY able to see the lists in the “Found” port of a list searcher, but in NO other occasions can I see them.  

Hi,I've been trying too use autocad_xref_path and autocad_xref_name to insert file (another dwg) into REALDWG writer feature type. It should be basic. But it's not working. No warnings, no errors.Did anyone succesfully managed to do that? Can you explain me what am I doing wrongRegards,Želimir

Hi, Has anyone had any issues placing in 3D symbols via cell file into FME DGN styler? It seems as soon as a solid or surface is involved the symbol dies not show correctly i.e these elements are missing. any advice thanks?

Hi,HELP. experiencing issues with cells in dgn styler.Can FME dgn v8 writer output solids? I am using dgn styler to input graphic cells from .cel file but seems like data is lost on output. When lines are used within the .cel file lines change colour within the output also. Please advise. I read about named and unnamed cells what is the difference? When I add the cel file to dgn writer elements go missing and colour of symbol is altered! In the writer I am using v8 seed file as provided in fme install. Am I missing anything had anyone wise have cell dgn styler experience?

I’m running FME 2024 soon to be 2025.My workflow is reading tables from SQL Server and writing them to Snowflake.Can someone please advise if it is possible to have the workflow automatically handle new columns being created on the source table?I don’t want to have to publish a new version of a workflow just because a source table has a new column added to it.Thanks in advance.

Hi,I have 3 raster’s that I wish to merge into one. Two of the 3 are of the exact same extent, cell size and CRS. The third has a larger extent (but overlapping the first two) and a smaller cell size. The issue I am having is that once I have resampled and clipped the 3rd raster to the extent of the other two they are mis-aligned, and I can’t figure out how to fix it. I need them to be exactly aligned so I can merge them. So far this is my method:Read in all 3 raster’s and ensure their CRS is the same (Using ... Resample the 3rd raster to the cell spacing of the other two (5000 x 5000) Raster 1Raster 2Resampled Raster 3Clip the 3rd raster to the extent of the other two:I use RasterExtentsCoercer for one of the first two raster’s (as they have identical extents). Set extents type to ‘Data Extents’. As I want the data extent clipping not the outer extent rectangle. Then using clipper with the output of RasterExtentsCoercer as ‘Clipper’ and resampled 3rd raster as the ‘Candidate’. It is t

Is it possible to map an AUTOCAD Attribute prompt rather than the AUTOCAD attribute Tag to the FME Input Attribute for the purpose of extracting AutoCAD block data. I am trying to gab the following data from AutoCAD. All the properties have a tag name of - so only the last one (SCALE) is able to be mapped currently. Can this be done please? Thanks.

 I am trying to set the annotation scale options for a block in CAD but I cannot seem to find the proper attribute or setting. I want to be able to set the available annotative scales similar to how its done for text below in the DWG styler. I want to have these scales preloaded for my block as seen below.  

I'm running into a small issue in the canvas. When I start typing "AS" in the transformer search bar, I expect AttributeSplitter to pop up, but it doesn't show in the suggestions. 

Is it possible to generate a separate log file or configure the existing log file to display metadata for the reconciliation purposes. The field that I am looking to display is the feature count in input file, feature count in both output file, who executed the workspace with timestamp, the amount field totals in the input file and the amount field totals in the 2 output files ( I have a workspace where there is 1 input file and 2 output files) . Also I have noticed that FME overwrites to the same log file every time the workspace is executed, is it possible to create a unique log file at every run? Thank you for the support. 

Hello,Does FME has some kind of DefaultCoordinateSystemSetter? I've created an FME workspace that dynamically transforms FileGDB layers into an Oracle SDE database. For this, I need the Oracle SRID and ESRI WKT coordinate system descriptions. To get these, I use the CoordinateSystemDescriptionConverter transformer (handy tool!). However, there are tables without geometry (which crash the ESRI WKT conversion, luckily a TestFilter or something similar fixes that). But it gets worse when geometries enter the workspace that DO have coordinates, but NO coordinate system. Setting the coordinate system on the reader doesn't work because I expect multiple coordinate systems in the data, and setting one of them as the default on the reader will incorrectly overwrite data with a different coordinate system.So here's what I need to do:Extract the existing one (CoordinateSystemExtractor) Test if it resulted in an empty value (Tester) Set the "default" coordinate system (CoordinateSystemSetter) Re-

Hi, Has anyone went through issue with the Value doesn't fall within the Domain” in a File Geodatabase ?Even though the description is already there   See screenshotI am currently dealing with it and it is a lot of work…Is there a workaround to fix the error ?The reason I am asking is because I have to go back to the Recreation.gov website and re-do again and reviw to ensure I choose the right one.I am using ArcGIS Pro 3.3.6 in a Citrix envirnoment 

Earlier I asked about writing out DGN files with coordinate system.That's apparently not possible until now. But I would like to know how I can use seed files to get at least the symbology of a seed file into the DGNV8 writer. I referenced the seed file in the settings part of the DGNV8I reference a cell file in the settings as well I read my data in, define the level names in an AttributeManager based on the input data, use the PROJReprojector, to adjust the input data to the coordinate system of the seed file, and connect to a dynamic DGNV8 writer. In the DGNV8 writer I am missing the possibility to state that colour, style and weight will be used on the level, and not the individual object in the level. The level and level overrides section in the writer I cannot understand. My output dgn consists of multiple levels, yet the settings seem to point at one level only.Hence, I do not know how to configure the writer correctly.Leaving the level settings part undefined, but setting

Hi all.I just ran into a curious problem. I tried to generate a buffer around my data, exporting it to GML. The problem is that QGIS won’t open the generated GML.I found that the GML data contained geometry errors (OGC Simple), and that these in part was made by the Bufferer transformer !??When I debug run a GeometryValidator->Bufferer->GeometryValidator setup, only running passed+repaired features into the Bufferer, the second GeometryValidator outputs failed geometries, i.e. output by the Bufferer..Is this a known problem ?CheersUsing 2025.2 beta

Hi all,I’m trying to read a shapefile that is stored inside a ZIP file which itself is embedded inside another ZIP. I want FME to read it directly from the download URLI tried with https://url/data.zip[shp.zip] but did’nt work. any idea if its possible?Thanks

 Hello, I use FME Forms 2024 and I have a very basic workbench just to test the emailer transformer and the configuration of our email system.The Emailer is the following version When I run I have this error and it fails: <class 'socket.gaierror'>: [Errno 11001] getaddrinfo failed Any Idea ?Is it a probleme of mail smtp mail server accessibility. What is the configuration to adapt ?RegardsFred ​​   

Do you know the best way to convert a Raster.gdb (with 31 records and no Length or Area fields) to Vector .gdb (would have probably around 5 million records)  in FME ? The only unique field is OBJECTIDI used RasterToPolygonCoercer but it is not bringing any of the attributes from the Raster dataset to the vector dataset- everything is blank Also I want the new vector data to be smoothed if possible.