FME Form

As is stated in the title. However I need column names to be created exactly as they are, for example I have incoming attribute "OGC_ANGLE.uom" and even though I have Lower Case Attribute Names unchecked,tables in database have column names are created lowercase ("OGC_ANGLE.uom" becomes ogc_angle_uom) - this is a problem, if I read those tables and try to use xsd to create gml again, as these attributes are unknown to the xsd, therefore failing creation of the gml. I could manually rename those columns, however I would need to rename those columns every time xsd file changes, which is why I need to do this dynamically in the first place, as those xsd files are going to be updated quite often... And it seems that the dynamic PostGIS writer ignores Table Qualifier, it always creates tables in default schema, unless I specify schema in

Hi Community,I am encountering an issue when attempting to connect to Azure IoT Hub using the AzureIOTConnect transformer in FME. Despite successfully generating an X.509 certificate using OpenSSL and being able to connect to Azure IoT Hub through a Python script, I am unable to establish a connection using FME. Here are the steps I followed:Generated the device key and certificate using the OpenSSL;The generated certificate includes the following relevant details:X509v3 Basic Constraints: CA:FALSE X509v3 Extended Key Usage: TLS Web Client AuthenticationThe connection works perfectly when tested through a Python script, but fails when using the AzureIOTConnect transformer in FME. The error message returned by FME is as follows:Failed to connect to the broker. The reason given is '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)'

Y’all.I’m trying to create a connection to a customer Sharepoint for the first time. And I’m confused.I got something to work in 2020.2, but would rather it ran in 2022.2 (same as our servers). But I’ve also tried it in 2024.1There seems to be two web service templates, (Template) and (safe.microsoft-sharepoint).According to this article they are each designated for use with Sharepoint List r/w and SharepointOnlineConnector respectively.But apparently I can’t create a new web service based on the latter in 2022.2, and the latter isn’t even available in 2020.2So when did this change, i.e. in which FME version ?CheersLars I.

My first “proper” Custom Transformer for maybe public consumption is AttributeTruncationChecker (attached)I’m not sure I have totally debugged it, but it seems to work now in most samples I throw at it.  Will leave it here for the Community to possibly use it and improve it.This is trying to address possibly one of the more common headaches we run into, in getting the dreaded Truncated Values warnings in the Translation Logs when a Feature Attribute string is too long for the Writer destination field.  At the moment, it is very time-consuming to track these down in large Feature datasets/Multiple Feature Datasets being written simultaneously, to design and run some Transformations to try to find the offending Features and which Attributes.This Transformer aims to detect these in the Workspace, by comparin

Hi Everyone, I have recently started with FME. I have a case where I have to format an XML from a list. I am using XMLTemplater Transformer to build a request xml which looks like below<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wnb="http://sample.com.au">   <soapenv:Header/>   <soapenv:Body>      <wnb:fetchNotificationDetails>         <!--1 or more repetitions:-->         <notificationNo>121</notificationNo>         <notificationNo>131</notificationNo>     <notificationNo>141</notificationNo>      </wnb:fetchNotificationDetails>   </soapenv:Body></soapenv:Envelope>   I am passing some ten notification numbers to a XML templater and they are coming out individually like below     <soapenv:Header/>   <s

I am attempting to write out data using a schema scanner and dynamic featurewriter.It is simply not working. I always get "Unknown feature type 'BOUNDS' passed to the JSON writer.It doesn't matter what I do, always the same.BOUNDS is my fme_feature_type and fme_feature_type_name.I will eventually use group by attribute but it doesn't even work with just one typeI believe I am following the standard practice but I have always been stumped when trying to write dynamically.  Please could someone outline the boiler plate method (with the steps ordered) to use a SchemaScanner and Dynamic FeatureWriter in the scenario where one would need to create or overwrite fme_feature_type and fme_feature_type_name or use a custom names for these. As I understand it, I should only need to make sure I have an attribute on the data with the same name as the Schema Definition Name.THANKS! NOTE below, feature_type_name is not available to choose,

I have streets with LEFT and RIGHT address ranges assigned. In some cases, I need to break the segment into 2 or more segments (for example, when a railway track is crossing the street). How do I re-calculate the NEW address ranges for the NEWly created segments? For example, as shown in the image, parent segment has address ranges of 0-100 and 1-99. After braking it up into 2 segments, I am expecting to calculate and assign address ranges of 0-28, 1-29 and 30-100, 31-99 to the child segments.Which transformers can I use to calculate the address ranges for the new segments? 

Hi,I’m experiencing issues with searching for a path for a PDF. Unfortunately, the process is extremely slow and seems to be stuck at this message. Could you please advise on how to proceed? 

I want to display a list of tables/views that a specific ROLE has access to. I can do this in SQL with the command SHOW GRANTS TO ROLE TESTROLE. However, putting this SHOW command directly into a Snowflake Reader WHERE Clause generates an error (syntax error line 1 at position 270 unexpected 'GRANTS'.) and returns nothing in a SQL Executor transformer.  Is anyone please able to advise either what the correct syntax is or if there is another approach/transformer that should be used? Thanks. 

Hi everyone,I'm facing an issue with the AttributeValueMapper transformer in FME. My goal is to remap all values in the "abbreviazione" field using values I want to input manually. However, I've noticed that I'm unable to set the distinct values of the "abbreviazione" field as input values because the transformer doesn't seem to offer the option to read cached values.The only option I'm given is to import the values from an external dataset, but I'd like to avoid adding too many steps, especially since in other cases, I was able to select the distinct values directly from the layer I'm working on (or at least I think so...).Has anyone encountered a similar issue or have any suggestions on how to proceed? It would be really helpful to understand how I can retrieve and manage these distinct values within the workflow to use them in the remapping.Thanks in advance for your help! 

Hello,I have several featureclasses to convert from EPSG:4326 TO EPSG:3847. Almost all of the input featureclasses got reprojected and got saved as a new output featureclass . But, for few, I receive the below error ,An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.} I'm not sure what is the reason and how to resolve it. When tried using Arcgis pro it worked well but not in fme desktop. I used ESRI reprojector for this operation and even I tried using other reprojection transformers too and I get the same issue. Can any one provide some guidance or solution to this problem? Do I need to change any writer parameters ? Thanks.

Hi, my workspace reads WFS and gives me the warning“CS-MAP: Coordinate (approx) 3E:47N outside grid file coverage; fallback used”It seems to run fine any further, just I like to know where this message comes from, since this coordinate nowhere pops up on neither GetFeature nor GetCapabilities request. Indeed the approx coordinate does not fit within the dutch Grid, but it does not seem to come from the WFS source? My FME version is 2022.2.4

Hi all,is it possible to use the NeighborFinder so that it tries to find the closest feature with a matching attribute inside the maximum distance area first?My goal is to find for my base features the closest feature from the candidate features which has the same attribute, but inside the maximum distance of lets say 20 meters. And only if there is no candidate feature with the same attribute inside those 20m, find the closest feature no matter the attribute inside 20m.What would be the best way to accomplish this in FME? 

I’m converting geotagged mobile photos to dwg format. Inserting them at correct photo location.All works fine except that FME automatically converts my jpeg images to png files.This results in image files (png) which are many timmes bigger then the jpeg files. Is there a way to make FME write jpeg images instead of png with the dwg writer?

Hi there. I have encountered a problem with ProjReprojector and FME Form 2024.1.1. Source data is PostGIS and source coordinate system is EPSG:4258. With the <Read from feature> option, only the first object that arrives the transformer is reprojected. Then it fails. I have carefully checked that all features that arrives the transformer is properly tagged with coordinate system EPSG:4258. When I set the source coordinate system explicitely to EPSG:4258, everything works perfectly. Any others that have seen this behaviour? With earlier versions og FME (FME 2020), everything works perfectly. Is this another issue with FME 2024?

I have a table of 1600 polygons (featureset A) with most of those polygons overlapping ; they represent distance discs from a point of origin. I want to relate those polygons to another feature set (B) and calculate the %area of the intersection for each input polygon.I can’t use the AreaonAreaOverlay as is since it explicitly states in the documentation that it doesn’t expect the input features to self intersect, and this is not true for A.When I filter for a single polygon, The AreaonAreaOverlay generally gets me there, but, the problem is I want the output of all polygons. Spatial relate doesn’t give me the intersection of the features, so I can’t calculate the % area overlap. My preference would be to use geopandas.overlay and iterate over each polygon from A, but, my input data is stored in arc.SDE so converting them to gdf objects is more hassle than it seems worth to then convert back out into an FME feature object to then write to an

The functionality works in workbench but not when creating a server app on FME Flow. The goal is to have the user select the file path to the file geodatabase and enter/select the feature class name. The schema will remain the same but the file geodatabase and the feature class name are unknown. In workbench, I can click on the three ellipses and the feature types to read pop up and I can select one. Then the process runs as expected. New feature classes will be added over time so being able to select the one you want is important. Workbench - clicking the ellipses to then select the feature type/feature class to read  In the server app I am not able to click on the ellipses to select the feature class I want but instead need to type the feature class name in. When doing that, the process c

I am having issues running workspaces on FME Server that contain Python 3 (using Esri GIS Python module). This is the error I am getting: The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.6+', which requires an appropriate version of ArcGIS Pro or ArcGIS Server. If ArcGIS is not required by this workspace, then update Python Compatibility to a non-Esri-ArcGIS Python. Otherwise, please install the required ArcGIS product, or if ArcGIS Desktop already installed, update Python Compatibility to 'Esri ArcGIS Python 2.7'. To update this setting, go to: Navigator -> Workspace Parameters -> Scripting -> Python Compatibility Environment Details: FME Desktop/Server 2021.2.5.0, ArcGIS Pro 2.8 and ArcMap 10.8.1 Per the compatibility page (

The FME Python environment is a bit weird, to say the least, which makes it difficult to use in various contexts. It's a Windows Python embedded installation, with the bundled and user-installed libraries in non-standard paths. As stated by the Python doc linked above, this installation doesn't officially support using Pip for package installation (due to the sysconfig paths likely being invalid). For dependency management, I would honestly much prefer using a virtual environment, but the python311 installation bundled with FME 2023 doesn't include the ven

Hello everyone,I am reading a google sheet with Google Sheets v4. The reader runs but it does not read some of the columns. I do not get any errors. how is that possible? I thought maybe because those columns cells are empty they can be read and then I added values in some cells but that was not the case. it still does not read them. in the workbench when I view the source data they are there in the sheet.  

Hi All,Novice, here.   I am trying to work with two different layers where I want one set of data to overlie another set of data.  I don’t know how to move the lines, adjusting them so they will match the sister layer.  I have tried Neighborfinder, anchored snapper, was looking at affiner, orientator and geometry coercer, and any other transformer I thought might work.  I suspect there are many steps involved in this process, but I really don’t know where to begin.    Below is an example of my data set.  I would like the black lines to match the red lines.  Is this doable in FME? Please let me know if more information needs to be provided.   Thanks for any help.  It is greatly appreciated! Version: ME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)   

Hi,Is it possible to add a map of a feature/layer in an HTML report using the HTMLReportGenerator? Thank you in advance

Hello there, How can I clip a Raster image using FME ? Thanks, Siva  

As a beginner, Can you give or help me very very detailed step by step process guiding me to build FME workbench for this geometry and attributes gap findings with line shapefile feature in FME ? Please help with any logical approach or steps or solution to find attribute name continuity gaps finding in a line features as with existing roads names or street names on it. For more details you can mail me on my mail id : actual.abhijeet@gmail.com

Hi, I am in need to convert an attribute with “188-195” as value (Wich means 188up to and including195) in “188;189;190;191;192;193;194;195”.How can this be done in FME workbench 2024.1.0.0.With a  combination of transformers AttributeCreator, AtributeSplitter, ListElementCounter, ListExploder and AttributeManager I am be able to produce the 8 new features. THNX.