FME Form

Good morning yall, Im banging my head trying to find the issue as to why I cannot read this.I have TemppathnameCreator before my google drive connector. google drive is saving a folder to that temp locationfeature reader is supposed to grab that drive folder and read a csv out of it.Ill paste some screenshots below. Hopefully is some setting in the feature reader. Much help is appreciated!

Trying to understand how the AreaGapAndOverlapCleaner works. Set to Fill All Gaps No and Repair Method Priority (Edge Preserving) with a tolerance of 1mSo why does it change the boundary of this polygon where it neither overlaps or is a gap (it’s the edge of coverage) 

Hi there!I get tons of these messages from some workspaces created with FME 2020 (in Norway) and now  migrated to FME 2024: The Startup Python Script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleErrorI have read the post http://fme.ly/PythonLocaleError carefully, but it does not give me anything. I have nothing such as import arcpy or locale.setlocale() in my Python-code. The example message above is particulary strange, I don’

Hello,I am creating PDF files using FME and am experiencing a serious performance issue (the process is very slow).I have a PDF template that I read and merge with my data so that each ID gets its own template. I use specific X,Y coordinates to write text at the correct positions in the PDF, and then I use the ID in the PDF writer to generate one PDF document per ID that includes both the data and the template.The output is correct and matches my expectations; however, exporting all records with the template takes a very long time.I was thinking to use  the PDF Page Transformer, but rebuilding the pages also takes a significant amount of time.Is there any way to improve performance and make my current solution faster without completely rebuilding the workflow? thanks in advance FME 2021

I’m having trouble finding examples for JSONTemplater when working with a JSON array input attribute.The incoming data looks like this:{"layers": [ { "defaultVisibility": true, "geometryType": "esriGeometryPolygon", "id": 1, "maxScale": 0, "minScale": 0, "name": "Parcels", "parentLayerId": -1, "subLayerIds": null, "type": "Feature Layer" } ]}I’m interested in extracting the first array member id value into an object like this:{"layers": [{"id": 1}]}I can almost get the data into what I want in two steps, first extracting the value with a query json["layers"][0]["id"] and then using the JSONTemplater to use the id value, but bizarrely the value 1 is cast to string “1” byt the templater, which is invalid for downstream work.Anyone know how to make what I want

I have rasters with one alpha channel and one grey channel. I need to ensure that the grey band is grey8. How do I coerce only the grey band and leave the alpha band untouched?The RasterInterpretationCoercer will change both bands and I have not found any other transformer that fits my requirements.  

Ever since the merging of SQLServer spatial and SQL Server non-spatial Reader types, my SQLCreators and SQLExecutors generate a warning:Microsoft SQL Server Reader: Table `___FME_Custom_SQL_Statement___' does not include a spatial column. Geometry will not be read In Form this is easily ignored, but it really messes up my Jobs overview dashboard on Flow, because it results in quite a lot of listings with warnings that do not need checking. And I can’t seem to find a way to tell FME that yes, I know, there is no geometry coming through in this sql, don’t worry about it because I did not select it - on purpose (or because it does not exist).I really do not want to turn off all warnings generically, I am just searching for a way to stop this particular warning. Before the merge it was easy: just use the non-spatial type, and the warning would go away. But that is not an option anymore unfortunately...  

I’m trying to run some workspace through Task scheduler with FME Form. I’m using an Emailer package and when I run the task as my user, everything is fine. But When I run it as local system it always fails as it can’t find the package. I tried defining Shared folder and setting up environment variables, but couldn’t make it work.As for setting up shared connections it works fine, but not with packages.What would be the right setup for this?

Can FME create a pg database tables with attribute names that have upper cases? I know that this is possible in postgres - column names are case-sensitive when double-quoted. But no matter which parameters of PostgreSQL writer I select (standard/dynamic writing, with checked or unchecked option to Lowe Case Attribute Names in Table Creation Parameter), FME keeps replacing double-quotes with underscores and output is always folded to lowercase.  Is it something that can be bypassed? 

Before I file a bug report, I thought I would post here.  I used to be able to right-click in the Data Preview and get the ‘Zoom to Selected Feature’ for the CAD geometry.  The last few versions of FME have not had that available.  What gives?Please see the attached.Currently using the latest build:  FME(R) 2025.2.2.0 (20260106 - Build 25827 - WIN64)

I’m trying to convert those attribute values whichever has comma into an array.Attribute A has values - "ABC" and "ABC","DEF" and "ABC","DEF","GHI".Desired output -“ABC”["ABC", "DEF"]["ABC", "DEF",”GHI”]Any inputs are appreciated. Thanks very much!Tagging ​@danilo_fme , ​@david_r 

I am trying to create a single ArcGIS Enterprise Feature Service that contains multiple layers using the Feature Writer transformer using the ‘Esri ArcGIS Feature Service’If I run it for a single layer, it works fine but as soon as I try for multiple layers, it fails with an error message.“No layers/tables are found matching the name ...” Are there settings that need to be enabled to allow it to write multiple layers or does it only work for a single layer? 

Hi I’m clipping point clouds with a polygon (1km x 1km), the inside result goes through a rasterdemgenerator with a cell spacing of 0.5m and I write it away as a geotif. When I compare the result with the polygon I see that the geotif is 0.25m bigger than the polygon. I know it has something to do with how a pixel is considered. As a polygon or as point in the center or something, but it doesn’t make any sense to me as you can divide 1km perfectly by 0.5m… It should be 2000 pixels by 2000 pixels right? How do I solve this? I tried playing with the clipper settings. Like changing “determine cell location by” to bounds and some other things. I got a result that’s 0.25cm smaller, but never an exact fit. 

FME 2025.1.3.0 Build 25643I downloaded the new ArcGIS Feature Service Package and set up a connection using the Esri ArcGIS Online OAuth Web service. When I attempt to insert a new feature into an existing AGOL feature service using the default values of the Esri ArcGIS Feature Service format, I get a warningWARN  |ArcGISFeatureServiceWriter: The field 'GlobalID' has a NotNull constraint, but it is NULL, missing, or empty. Skipping feature...The feature is not committed but the FeatureWriter or Writer (I tested both) shows success and the number of features written as 1. Without reading through the warnings, I wouldn’t know there was a problem.Since I’m inserting a feature I don’t have a globalid! And the field is noneditable in the feature service, so it seems like an odd error.Messing around with the settings I found that if I made sure the GlobalID field was exposed in the User Attributes and in the Advanced Parameters “Use GlobalID” was

Ya, tokopedia memiliki WhatsApp resmi yang bisa langsung di hubungi di Nomor +62859^3460^8879.

Hi all,I am fairly new to FME. What I wanted to implement I was able to figure out with the community here or the trainings at the Safe academy. But now I struggle as I do not understand, where my mistake is.Goal: I need to write features with a dynamic schema. So, I added via Readers a “Reader as Resource”. It is an Excel file from where I want to use a specific sheet. There a added my columns which shall be written to my target source. Writing a FFS file works as expected by using the following configuration.One important note: a sheet in excel has a limitation for the name. As I need to create a dynamic workbench which can read different source files and handle a different amount of dynamic columns per source file, I want to name it like the feature type - but shortened to what Excel can handle.Dynamic Schema De

Hi all!I’m looking for some possible help with my FME workflow (dwg to geodatabase). I have a DWG reader followed by several geometry transformers, and the geometry is working well. Where I’m stuck is the attribute schema.I have a CSV/Excel file that defines my target schema. it’s structured row-by-row. each row represents a single attribute, not a feature. All the attribute fields are under the same "attribute_value" column. So, each feature class is represented by many rows. For example, electrical pole has 8 rows—one row each for pole_id, owner, project#, etc.—all sharing the same source layer, output feature class, and dataset. Another feature class (vegetation) follows the same pattern but with fewer rows because it has fewer attribute fields.I need the geodatabase to have each feature class only contain the attributes listed for it in the CSV, and nothing extra. I understand this requires a dynamic writer, but I haven’t had success yet. I

Hi, I am writing data to Esri ArcSDE in FME Form and have tested using both CoordinateSystemSetter and Reprojector to define the coordinate system. However, when I open the feature class in ArcGIS Pro I get a message that the coordinate system is missing. Has anyone had similar experiences?

In the answer to this questionEsri ArcGIS Feature Service - Reads Dates as Epoch Milliseconds | Communitya URL is given to the FME hub which doesn’t match the address I’m used to seeing for FME Hub, crucially the info on this package is all quite different too This is what i’m familiar withhub.safe.com/publishers/safe/packages/esri-agolEsri ArcGIS Connector - FME Hub and this is the link providedhub.fme.co/publishers/safe/packages/esri-agolEsri ArcGIS Connector - FME Hub

Oh no, I put my question into the wrong Category (Community Q+A). I cant move the thread.Sorry for the double posting, but it seemed, that in the Q+A category is nobody who can move my thread (or?).So I post this one here with the link to my wrong settet Post.  

We have multiple workspaces that write to ArcGIS Online with multipart geometries. The old ARCGISONLINEFEATURES writer works and correctly writes the geometries. The new (2025) Esri ArcGIS Feature Service Writer returns an error rejecting the features and the following warning:ArcGISFeatureServiceWriter: INSERT error for a feature in Project Stats by State. The error code from the server was '1000' and the message was 'Adding/updating geometries that result in SQL GeometryCollections is currently not supported (SQL Server performance).' Using a Deaggregator seems to fix this in most cases. However, we want to retain the multipart geometries. In other cases, I see a similar warning and the following error after using a Deaggregator:ArcGISFeatureServiceWriter: INSERT error for a feature in Terracon Offices Closest Areas. The error code from the server was '1000' and the message was 'Data is Null.

Hello,I am testing out the Esri ArcGIS Feature Service writer that is in the Esri ArcGIS Online Connector package (Esri ArcGIS Connector v3.13.2). I’m using Form 2024.2.2.0 (20250114 - Build 24820 - WIN64). Screenshots are edited to remove confidential information. I have noticed that the “Target WKID” cannot be left blank even if you have selected “Feature Service Handling: Use Existing” If I am understanding the documentation correctly, this parameter is only needed if the writer is creating a Feature Service. However, as the default is set to WKID 102100, if you don’t change this to the correct WKID, it will write the data out to the wrong location. I initially made this mistake before I realized I had to input my data’s WKID.

Hi everyone I have been having some issues with the new ArcGIS feature service writer. When using this writer in combination with a change detector, it doesn't seem to update or insert any of my changed records and i have been getting weird behaviour all over the place. Let me preface this by saying that everything works as expected on the old portal feature service writer, it's when switching to the new feature service writer that weird things start to happen.  Under the advanced parameters I have enabled the following fields to adress the first problem I encountered (namely that the writer no longer seems to care that global id is a read only field and skips it for writing):  Af

Hi,I’d like to read a folder of documents and a set of points (say from a csv) and then join these together (filename of documents might match an attribute on the points), then write them all to an ArcGIS Online feature service with the documents as attachments.  I would ideally like to do this in one workspace and not have to hardcode anything.I don’t think this is possible without using one workspace to write the CSV to feature service, and then another to read it and add attachments using the ArcGISAttachmentCOnnector, as that requires the feature service URL, which may not be known at the time of creating the feature service.Thanks,Marc

hi everyone! some of my line features (pipes) have text features floating above (top left) of the line, describing what type of pipe it is. I want to add that text as an attribute field to that feature. but also not all of the lines have one and I want it to only match if it's describing that feature (not grabbing a random text field nearby). I'll also note that everytime I've tried to use neighborfinder, the autocad_text_string AND fme_text_string values of lines show numbers (ex. 356.77, 623.44) instead of the descriptive text it should have shown. I've been trying this for hours and would appreciate any help given. thanks in advance!my workflow is: DWG Reader →  Attribute exposer →  Feature joiner1 CSV Reader →  Duplicate filter →  Feature joiner1 Feature joiner1 →  Deaggregator → 2D forcer → G