FME Form

I am trying to read in non-spatial data from Microsoft SQL Server. I need to read in three Tables and three derived Views. I have set up a connection using the Microsoft SQL Server Spatial (JDBC) format, and I have the connection to the main folder in the database working fine. In the Parameters > Constraints, I am only offered the option of ‘Tables’, and this does allow me to read in the three tables in the database perfectly. However I cannot find a way to access the Views which are in a different folder in SQL. Is Reader limited to just reading Tables? The FME documentation says “The Microsoft SQL Server Spatial (JDBC) reader and writer modules provide FME with access to spatial and attribute data held in Microsoft SQL Server database tables.” - with ‘tables'; being specifically mentioned, rather than all folders within a database.Is there another way of reading in Views? Or do I need to go back to the database creator and get him to do something else.

Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:Translated DGN shows the correct line style in properties but not in the display:Re-importing line styles warns of duplicates:But afterwards the line style is correct:

Hi,I am new to FME.My question is simple and easy.I have a field that has multiple lines, FME is not able to read it.FME Version: 2025.1.1.0Data set has 5500 records, of those 300 gets rejected as it has multiple lines.I am trying to create lines.  Sample:LINESTRING (-122.47510883224778 37.72569214605437, -122.47549442640992 37.72569240767212, -122.47591818521782 37.72543361304484, -122.47615044826871 37.725435814791524, -122.47635018879221 37.72551472908074, -122.4768917047572 37.72596114891507, -122.47722446641976 37.72606220923341, -122.47809062309513 37.726088801447176, -122.47840706343166 37.72604796879034, -122.4788330330602 37.72589235538119, -122.47914970916452 37.72593694003075, -122.47935639456331 37.72605991382738, -122.47998774607001 37.72692786951861, -122.4801298766873 37.727219718364864, -122.4800482518362 37.72746956663917, -122.47983883659106 37.72763905162748, -122.47914598242949 37.72796883327165, -122.47869796921809 37.72821056418619) LINESTRING (-122.49346993299433

We recently migrated to FME 2025.1.2 / ArcGIS Pro 3.5.3Now I need to update some records in a point featureclass in SDE so I created a new workspace with a Creator, a FeatureReader, an AttributeCreator and a FeatureWriter.Reading the data from SDE works as expected. But when I try to write the data, I get the following errors:2025-10-22 13:12:21|   2.0|  0.0|ERROR |Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support2025-10-22 13:12:21|   2.0|  0.0|ERROR |GEODATABASE_SDE writer: An error has occurred. Check the logfile above for detailsNot writing anything dynamic. Just point to the correct featureclass and go.I think I’m now pretty much out of options, because I upgraded my ArcGIS Pro.The only way to get it to work again is to remove ArcGIS Pro 3.5 and install a version which does work with an older version. I came from 2021.2.6 so I know that works, but I would prefer a more recent version.So my question is

I have a Geopackage, 458.761 polygons. Using a FeatureWriter, type Geopackage, I tried to store this. Unfortunately I get this error and could not found any logic behind this one:OGCGEOPACKAGE writer: Feature type 'Road' has geometry type 'geopackage_multipolygon' and cannot accept the current feature with a geometry of type 'geopackage_multisurface'.  Skipping feature FME 2025.1.2.0

Hi All,I’ve got what should be a simple issue but I’ve not been able to find and answer for my exact query.I’d like to take a feature class, containing photo attachments, stored in a file geodatabase and write it to another file geodatabase. Essentially copying the data from one file gdb to another.I’ve seen lots of posts about reading and writing as separate processes. In both instances the photo’s are imported and attached or extracted from the data.Is it possible to essentially copy a feature class with attachments between file geodatabases, without having to extract the photo attachments and then reattach them?Thanks for your time.

Hello, the workspace is close to “Creating CityGML Solitary Vegetation Object | Community” but without the issues. I would like to randomly rotate the instances along the Z axis. Dimensions are set as in the first matrix shown below. When I use the last row to rotate, as shown in the second matrix below, the rotation is ignored and dimensions change. I tried the rotators, and the 3D affiner after defining the matrix to no good results. It seems that CityGML only looks at the transformation matrix.  Any advise or workaround to force instance’s rotation is appreciated. I have a random rotation value stored in an attribute brought as an attribute of the location point. +++++ Matrix withOUT rotation +++++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.00.0 0.0 0.0 1.0+++++ Matrix “WITH” rotation? +++++++++@Value(width) 0.0 0.0 0.00.0 @Value(width2) 0.0 0.00.0 0.0 @Value(height) 0.00.0 0.0 0.0 @Value(rotation) 

Hello,I’m using FME 2024.2 to read ORD DGN files stored in ProjectWise.The DGN files have a local coordinate system (LCC) defined in ORD, but when I read them into FME, the detected GCS appears incorrect — particularly the ORG_LAT value. Because of that, when I try to set the coordinate system and reproject to State Plane, the transformation doesn’t work properly.Has anyone encountered this issue before?Does the GCS definition in ORD need to follow a specific format or standard to be recognized correctly by FME?Any insight or suggestions would be greatly appreciated!GCS shown for features in FME 

Hi Long time user, havent posted as not been hands on in a long time but here goesWe are looking to add new extensions into GPX files Something like: <trk>    <extensions>      <htrk:HemaTrack>        <htrk:difficulty>          very_difficult        </htrk:difficulty>      </htrk:HemaTrack>    </extensions>  </trk> We have an XSD definition for the namespace as well <?xml version="1.0" encoding="UTF-8"?><xsd:schema targetNamespace="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" elementFormDefault="qualified" xmlns="http://hema-ota-test.s3.ap-southeast-2.amazonaws.com/gpx/extension-schema/v1" xmlns:xsd="http://www.w3.org/2001/XMLSchema">        <xsd:annotation><xsd:documentation>    This schema defines the Hema Maps extensions to be used with the GPX 1.1 schema.    The root elements defined by this schema are intended to be used as child    elements of the "extensions" elements in the

I am looking for guidance on how to create this interactive map..  We have FME and ArcGIS…  From time to time, we are given maps and we have to change the counties based on new staff.  Most of the time the counties are adjacent.  Other times not.  We have a shapefile of the counties. I am looking for a solution where we can select the counties in the shape file/FME and output the selection for the update query.I believe I have all the pieces Just not sure how to attach the transformers together… or what the logic is to create this… TIA (Thank you in advance) 

FME Form (Workbench) 2024.1.2.1 (20240906 - Build 24624 - WIN64)Oracle Spatial Database 19.27.0 (19c) Hello!When trying to read data in from an oracle spatial database, I receive the message that FME cannot query the metadata table. It's unclear to me which metadata table the reader is trying to use. This happens both with a FeatureReader and a SQLExecutor, the behaviour is the same. When switching logging to debug, there is no further logging of the query that is being executed.2025-07-29 13:52:56| 0.3| 0.0|INFORM|ORACLE Reader: Executing SQL Statement `SELECT * FROM DINO_DBA.GDW_BLK_ARE_VW' to obtain features for feature type `'2025-07-29 13:52:56| 0.3| 0.0|WARN |Could not query Metadata table for dimension for geometry column 'GEOMETRY' of table '' -- geometry will be assumed to be 2DThe FME documentation I could find (FME Support Center: Adding metadata entries for Oracle spatial tables or views) hasn't been updated since 2015.1, and refers to MDSYS.SDO_GEOM_METADATA which i

Hi,  I am trying to manipulate the dates based on the logic.  If the effective date falls between 06/01/2025 - 06/31/2025, then the date of inception should be 06/01/2025 and the similar rule applies for the month of july, aug, sept.And if the effective date is anywhere between 10/01/2025 - 10/01/2026, then the date of inception should be 10/01/2025. The issue here is :If the effective date is 08/20/2026 → Inception becomes 08/01/2025 ( Expected is 10/01/2025)The similar issue is observed for months of june, july, aug, sept  for year 2026.               I am surprised here why FME would not pick up the year from the date

I have a point feature class at each road intersection. And have a line feature class of these roads. I would like to determine the direction each line is oriented at each intersection.For example, I have one point at a four line (4 streets) intersection. The result would show the line ID along with the 4 IDs and orientation (N S E W). Or would show an angle? Something to determine which way the line is oriented in relation to the point.  Thanks for any help. Steve

When writing 3-point arcs to Oracle Spatial with a projected coordinate system, FME 2020 (64-bit) can maintain their geometries as arcs. When writing arcs to Oracle Spatial with a geographic coordinate system, however, FME strokes the arcs into lines. Is it possible to write the arcs to a geographic coordinate system without converting them to lines?

Hello, new to FME here and am looking for some advice on which transformers might work for a workbench that I am trying to create. I have 2 road line feature classes stored in an SDE geodatabase. The lines store similar information but are created and maintained by two different departments (they have different road name standards and the geometry does not match). I would like to compare the lines and identify which ones from Roads_A are missing from Roads_B.  My main concern at this point is identifying missing subdivisions like the one in the screen capture below. 

I am currently using FME 2025.1.1 (Build 25615) and have had some issues with inspector crashing. I have tried multiple different ArcGIS Online provided background maps and they seem to be causing both Data Inspector and occasionally Form (when using Data Preview) to crash. I have tried with multiple different types of data, of various feature counts, sometimes it crashes on initial load of background map, other times when it reloads it after zooming in. Wondering if anyone else has run into this?

I have an orthometric DEM that I need to convert to WGS84 Ellipsoid.   I know the CSMAP reprojector treats all raster data as 2D.I tried converting the raster to a point cloud, reprojecting it and then re-rasterizing, but I am getting a weird striping effect I don’t know how to deal with.  

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.I can read the full table with no problem using the ArcGIS Portal Feature Service reader. How can I get the FeatureReader to run and read the required features?  

Hallo , How to Color the first column  at table in PDF ?I used the PDFPageFormatter but  I faced a problem that i want to color the first column at table in  PDF output, which contains the attribute names,that i have created a table by pdf page formatterCould someone advise me on how to color the first column? FME 2021

I’ve got some JSON data where the key/value pairs are separated so the keys are in one JSON block and the values in another (see the example below). I’m using:A JSONExtractor to get the "columns" fragment and then a StringReplacer and AttributeSplitter to convert it to a list. A JSONFragmenter to convert the "values" to a list. A PythonCaller to loop through the two lists and create the attributes.Is there a way to do this without python? I’ve attached a zipped file of my workbench, Example JSON============{    "columns": [        "sub_organisation",        "system_id",        "type",        "mounted",        "location",        "road_id",        "offset",        "side",        "geometry"    ],    "rows": [        {            "message": null,            "values": [                24,                8,                "1840",                "Path",                8,                997,                10.9,                "L",                "POINT (1748664.55420184 5427732.02625559)"    

I have a WFS that has over 500K features. I want to retrieve just those that intersect my area of interest. If I have a polygon of my AOI and send it to a FeatureReader, with no spatial filter, then I get 30K features (or whatever the Max Features is set to on the WFS connection).  If I set the Spatial Filter to Bounding Boxes OGC-Intersect or Initiator OGC-Intersects results, I get the schema, but no actual features. My aoi and the WFS data are in the same projection. If I use a boundsExtractor and HTTPCaller and manually create the call, {redacted}/ows?service=wfs&version=2.0.0&request=GetFeature&typeNames={redacted}&bbox=@Value(_ymin),@Value(_xmin),@Value(_ymax),@Value(_xmax) Then I get just the subset of features I'm interested in. I would much rather use a FeatureReader. What am I missing to get a spatial constraint working?

My company does SSL inspection/interception which is causing errors when trying to view background maps in FME Form.  I have seen ways to fix this for the FME Flow (Server) side, but is there any way to change any configurations for FME Form to handle this?  The CA certificate for our authority is in the Trusted Root Certification Authorities certificate store on machines so I’m not sure why it isn’t trusted if FME is using the machine’s certificate store for trust.  Below is an example of error seeing from FME Flow 2025.0.1 (but have seen on previous versions as well).Stadia Maps Reader: Failed to load 'https://tiles.stadiamaps.com/tiles/alidade_smooth/5/19/14.png'. Error: 'HTTPSConnectionPool(host='tiles.stadiamaps.com', port=443): Max retries exceeded with url: /tiles/alidade_smooth/5/19/14.png (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1018)')))'Python Exception <FMEExcepti

Hi there,I tried to write some data to a ArcGIS Portal feature service using the new writer.  It skipped my feature as globalid was NULL, missing or empty:So i fell back to the old writer and this writes features fine. It sees that globalids are read-only and ignores them, along with the other ArcGIS server managed fields:I imported the same layer from the feature service using the writer - import layer approach, and fed the same data into both of them in the same workspace.  One works, one doesn’t.Am I missing something?Thanks,Marc

When using the FeatureWriter, it wants me to provide a subfolder. I cannot leave it blank. I need to be able to write the file to the root of the file share. I am doing a move and not a copy. any thoughts?

Hello,I’m converting DWG to DWG using FME and I’m wondering if it’s possible to style the XREF data within the DWG. Specifically, I’d like to set it to True Colors with certain grey values.Any guidance on how to achieve this would be greatly appreciated.Thank you in advance!