Data

Dear users,I`m quite new to FME. I use FME Form 2025.2.I try to convert a poylgon-Shapefile to dxf.I show you the model attached in an image: The shapefile “rasternetz” gets a Coordinatesystem (EPSG: 25832) and is changed from poylgon to line (via GeometryCoercer). If I transport that file to a NEW Shapefile (Writer) everything is fine (it is a line-shapefile then, has a coodinate system, all the 5367 objects are well shown in QGIS). But: It I use a DXF-Writer the file is created (I can successfully open it in AutoCad Map), but I CAN`T open it in QGIS. And it`s very very weird: QGIS says: “That dxf has no coordinate system” (eventhough I defined one in the FME-Writer). And if I set a coordinate system in QGIS manually to that dxf, eventhough no geometry is shown at all ?? Has anybody an idea? One weird thing is: It is not possible to set the dxf-geometry to “Line”? (Is has only the attribute “all”)…   

I have a dwg file format exported from Autocad Architecture which contains 3D Wall type objects. I am using “Autocad Civil 3D Reader” in FME(2026.1) but I am having two issues:1. The geometry of the wall component (eg. hatches) is not being extracted by the reader. 2. Wall style properties are not being read (the wall geometry has properties like style or material). I have tried to expose them (style attribute and geometry) but I could not find them. Note: I don’t get any errors.Does anyone have suggestions how to deal with these issues?

Hello - a colleague has set up a table in an MS SQL Esri SDE and they are trying to use the FME Esri Geodatabase (ArcSDE Geodb) writer to truncate the table and insert new data.However, when the table was created (using ArcGIS Pro) they chose some long attribute names (e.g. 45 characters). This is now causing an issue as the FME ArcSDE writer enforces a 31 character limit for attribute names. This means that we cannot get the writer schema to match the schema of the database table.It seems that the FME Esri SDE writer is enforcing a character limit to attribute names that is stricter than the limits applied by the Esri SDE itself. Is there any way to override this limit on the FME writer?  I think we could use an MS SQL writer to truncate and insert the data but would prefer to use the Esri SDE specific writer if at all possible.Thanks in advance.

Unable to retrieve connection 'connection'. Error. It can't be recreated with edit connection context menu? How can be recreated with the same parameters, I already know those parameters, user password schema, host…. It can be asier to recreate if the edit connection menu, create a new one with the same name, and only fill the missing parameters kind, host, user, password, schema, etc… How this can be done I mean recreate the database connection with the same name?

Hello,I have a file with a .bag extension, and I would like to convert it into LAS format. Could you please assist me with this process?Thank you in advance for your support.

there is a feature service layer (i’m the owner) with a filter statement on it.when I view the layer’s properties on AGO, I can see the filter. When I add it to an arcpro project, I can see the filter in the definition query. Looking at the REST end point (the one that has the <organization>.maps.gis.com address), i see all records. When I add the layer into FME either by AGOL reader or feature Service reader, I only see the filtered records and I don’t know how to get all the records. AI is telling me to put 1=1 in the where statement to bypass, but it didnt. 

Hello all!I have a question regarding accessing data in an Enterprise Geodatabase in a branch-versioned Feature Service scenario:Using FME’s Esri Geodatabase (ArcSDE Geodb) Reader, can I read branch-versioned feature classes directly from my Enterprise Geodatabase (SDE connection) now that I have published a branch-versioned Feature Service? If I point it to the “sde.DEFAULT” version, will it access the features correctly?I would like to perform some heavy geoprocessing tasks, and my Feature Service performance isn’t keeping up, so the Esri ArcGIS Connector is a no-go. My Enterprise Geodatabase, on the other hand, is robust and more than capable of handling these tasks (e.g., DatabaseJoiners, FeatureReaders, FeatureMergers, etc.). Thanks. 

I'm quite new to CAD. I have an Oracle database with parcels. I would like to convert these to DGN (for users in Microstation) and DWG (for users in Autocad). The parcelnumbers should be a text field as the centroid of the parcels.  I have only a licence for Microstation to test the DWG's over there before I can sent them to the users using Autocad. I can create and convert the parcels and texts to DGN. These work fine.When converting the parcels to DWG I can see the number of features (elements) in Microstation, but not the geometry itself.What should I do get the geometry right?  

Hi FME Community,I came across this presentation from the 2017 FME User Conference on integrating GIS data into PSS®SINCAL:https://fme.safe.com/presentations/pss-sincal-network-modelling-from-gis-data-using-fme/From what I understand, the workflow relies on a custom FME process combined with a third-party DLL to generate and populate the SINCAL database schema.I’m currently exploring a similar use case (GIS → electrical network modeling in SINCAL), and I’d like to ask:Has anyone implemented a more recent workflow for integrating FME with PSS®SINCAL? Are there any newer approaches using FME (e.g., PythonCaller, APIs, CIM, etc.) instead of direct database writing? Is there any official or community-supported FME reader/writer for SINCAL available today?From what I’ve seen, recent SINCAL versions seem to favor API-based or CIM-based integration rather than direct database manipulation, but I’d be very interested to hear if anyone has practical experience using FME in this context.Thanks i

I have line features . When two lines really intersect, I would like to create a new vertex at the intersection point .My requirement is:if two lines intersect, create a vertex on the lines at the intersection location if it does not exist the new vertex should get a Z value that is 1 meter lower than the other existing vertices of the lineFor example, if the line vertices have Z = 145, then the new intersection vertex should have Z = 144.Currently I am using Insector, and to filter out the nodes that share a node between consecutive lines, I cobination of coordinate extractor and FeatureJoiner. Afterwards, I extract all coordinates of the lines and join them again with the remaining points from Insector to identify the real intersecting points, as well as the intersecting points that do not exist as vertices on the line.Then I gave new z values to this vertex candidate but how can i insert them onto line while preservin their z values which is different than rest of the line 

Hi,I have a strange issue when writing to excel. I have a feature writer to excel in dynamic mode. To prevent numbers being converted to a scientific notation I added a Excel Styler where I set the custom numer format to 0. This works perfect.The problem is that now my dates and datetimes are suddenly shown as number. When I change the cell format to date it shows the date, but I want it to directly show the date. When I remove the ExcelStyler, dates are shown as dates. Anyone any idea how to fix this?I use FME 2023.2.5.

I am trying to get the labels in this map to offset so that they “print” on their lines (two different labels, one is for pipes and the other one is for manholes).Manholes - is the label like 71100144 - the first row of this label should sit perfectly above the line there.The pipes are the values like KM_… - this one should offset entirely to sit on top of the pipe lines.I hope that makes sense.Is there an attribute I can set? I am using AtributeCreator + TextAdder + PDFStyler.Thanks a lot! 

I have a network of connected points and lines, and I’m looking for a way to create a selection set of points along the network, the key being I want to only select every other point. I tried modular selection counts (odd vs even numbering), network topology build for start and end node, but I can’t seem to get the results I’m looking for. Below is a screen capture - I want to eliminate the grey colored points in between. At intersections these points would be retained if necessary according to the ordering.  Select all points in Orange, skip points in Grey 

I have an AGOL feature layer with a DateOnly field that I am trying to filter out the last 365 days worth of data. Is there an easy way to complete this?The data is formatted in the following way:2021-01-01

Hello everybody,I am trying to build a flow app: The user has an Excel file with 3 columns.  the flow app must show the values of theses columns as one parameter (I want to have the chance to filter the list using one of the 3 columns). My Problem is to get the contents of the excel file. If I try it with the User Paramters Window, I can import from dataset or reader formats. But with these options I do not get the contents but the headers or the name of the readers.I can save the contents of the File in a SQL Database. But I do not know how I can read them and show them in the user parameter List. Has anyone any Idea, how I can get a List with a filter to show those values of the excel?Thanks in advance!Manuel

Hallo everyone,I copied and upgraded an ArcGIS Dimension Feature Class (File GDB) using ArcPy.However, when trying to read it in FME 2024 (FeatureReader / File Geodatabase Reader), I get this error:Unable to convert row to 'DimensionFeature'FME can see the schema, but fails when reading the features.Does FME support reading Dimension Feature Classes, or is there a known workaround?Thanks.

I have a COG with a scale factor (excerpt from GDALInfo)Band 1 Block=1024x1024 Type=Int32, ColorInterp=Gray  Min=-50313.000 Max=57304.000  Minimum=-50313.000, Maximum=57304.000, Mean=4745.177, StdDev=7550.452  NoData Value=-32767  Offset: 0,   Scale:0.1How do I apply this scale factor in FME?   If I clip the input and create a new tif,  the scale factor is dropped and the values are 10 times the expected.In this particular case I can just scale the value back down, but in general, is there a way to retrieve the scale factor and apply it? 

Hello Team,I have an Excel template with a single worksheet that includes predefined colours, formatting, etc.In version 2025.0, I’m trying to write my results into this template, but I want to output multiple worksheets within the same workbook using the same template. I’ve tried several approaches (both dynamic and manual), but they either fail or behave unexpectedly.What I’m seeing is that only the first worksheet shows the designed template but no results, while the subsequent worksheets contain the results but lose the template formatting. Even when I set Remove Template Sheet if Unchanged to Yes, the first worksheet (the template sheet) is still present with no results filled in.Does anyone know whether this is achievable in version 2025.0? If so, how should it be configured in the Excel Writer?Kind regardsThanks!

 Hi,I am using the Matcher transformer to find pairs of features with the same attribute value.Now I want to create a new attribute rel_obj that stores the ObjectID of the other feature in the matched pair as in the image. What is the best way to implement this in FME?Thanks 

Hi, I want to import the WFS service from Digitaal Vlaanderen, specifically the address registry, but my FME only imports a maximum of 10,000 features.I had found that it was possible via paging, but apparently that is no longer supported, or at least I can’t find it. It should then be done via loops, but I’m stuck. I found that it should be possible using an HTTP caller and JSON fragmenter, but I’m already stuck with my HTTP caller. Could someone help me set this up correctly? The URL is https://geo.api.vlaanderen.be/Adressenregister/wfs?REQUEST=GetCapabilities&SERVICE=WFS      

I have attempted to use the NeighborFinder transformer to achieve a one-to-many join; however, it is not producing the expected results.In my case, the base dataset contains values such as 30,511 and 55,867, and my expectation is to match all records where the base value is greater than 30,511.Since NeighborFinder does not seem suitable for this requirement, could you please suggest an alternative transformer or approach to achieve this condition-based matching?Thank you. 

Hi FME gurus. I am trying to extract values from a list to populate columns with the associated values in the fields.  In my list (called _columns) I have a caption field which has the name of the column I want to create and the date value I want to populate into the field so the example I have in the screenshot I want to look like this: Application ID Last Inspection Next Inspn Due 648343 2025-06-23 2026-06-16 15456.. 2025…. 2026….  The list exploding only brings out the name of the original column ‘caption’ but I am looking to use the values in the list itself to build the attributes and populate the values. There are records with more than 2 elements in the list and I still will need to figure out how to expose the attributes (schema scanner?) once it is done but this is the first step. Any suggestions would be amazing, Thank you.Michael.

When using ArcGIS Feature Service (reader, writer, featurereader, featurewriter) I am only able to reference items using Folder and then featureservice name + itemid (in paranthesis after the name). Is it possible to directly refer to a service using only itemid?(for my case the data is hosted on my institution’s AGOL)

I’m creating a workspace that reads 7-8 tables from a file geodatabase and then writes them into tables in a SQL database.  One of the tables is sometimes present and sometimes missing (that is expected).  I need to create a workflow where when the table is present we write the data into the SQL table and when it is not present we just truncate that same table in the SQL database.  I currently have a gdb reader connected to a tester that passes when fme_feature_type Like MSAG_To_RCL_Synchronization. This works when the table is there but when it’s missing the reader just closes and gives the message “The table name 'MSAG_To_RCL_Synchronization' could not be found in the Geodatabase as either a feature class or a table” and closes before any input gets to the tester. Any ideas on how to conditionally test if a table exist or not and then either write the data or truncate a SQL table. 

I have the exact same issue as is described here: That topic is closed, so I'm starting a new one over here. I got the error “Check the geometry of such feature is valid and is not too small for the resolution”, while updating a feature. I use FME Form and Flow 2025.1.2 and ArcGIS Pro 3.3.1 with ArcGIS Enterprise 11.3.At first I also thought the issue only occurred in FME Flow, not in FME Form. But now I'm checking the issue again and it is also in Form.In my case I use the ChangeDetector to check if the feature exists and if so if it is changed. If it existed and is changed, I'm also using the Update Mode in a FeatureWriter. I tested with not updating the spatial column, but that didn't make any difference. I still got the error. And I am positive the geometry didn't even change: setting the ChangeDetector to only check geometry sends the feature to the Unchanged port.I don't really understand the solution in the other topic, but it seems I have to delete some data. But that sort of d