FME Form

Hi everyone, I am now doing data quality inspection to an esri personal geo database with multiple layers, and I have to calculate how many 0 or null values there are in every attribute of each layer(or table) in the database. I have tried to figure out some automation method with FME but in vain. Can anybody give some instructon or advice?

I have a fileGDB with a single feature class, and that feature class has metadata. How do I export that metadata to an XML file? I am using FME Desktop (FME Form) 2022.1

Hello every one I have workspace to read many files in SharePoint just to know which folder has updated with new data And it’s taken to much time to read all files in SharePoint My question is : is there is any way to let SharePoint connecter read folders only without reading all file inside or read one file from every folder just to decries the time and speed the workspace Thanks for all your support

I have a dataset stored in Oracle Spatial, and I have metadata stored as an xml file (the xml is generated by ESRI software). I want to Write a fileGDB where the metadata is added to the feature layer. How do I accomplish this?

Hi, I haven’t been able to find this question asked anywhere, but I’m sure it has been. I’m at a lost though. I have a unique attribute in a group of features. I wish to find unique combinations of all possible pairs in my group of features. For example, if I have three features. Their ID’s are 1, 2, and 3. The result I want to find is a feature with a new ID of: 1-2, 1-3, and 2-3 In reality my groups can be up to 20 features in size. I can’t work out how to accomplish this in FME. Though I’m sure its very easy. Does anyone know how I would do this?

A month ago, I generated an fmw (Build 24202) that read from Esri ArcGIS Server Feature Service, (url, user, pwd) correctly.today when opening the fmw gives error and is not able to read, I do not know why it can be, if everything is the same as a month ago.Thank you so much!

Hello, I have recently upgraded FME Form 2024.1. I tried to run a project, but I immediately got the following error message: “FME failed to restore the process locale to UTF-8. A non-UTF-8 process locale may cause undefined behavior.” Is there any quic fix for this issue?

Hi, Is it possible to rollback all the inserts been made to database through multiple writers(Oracle/Esri) if one of the writers fail?

I'm bringing in several multidimensional GRIB files with which I would like to separate out each band for subsequent analysis. The GRIB file has several bands with inconsistent resolutions (i.e. 2880x1441 or 1440x721). When I run the GRIB file through a RasterBandSeparator, I see the following warning in the log file: |WARN |GRIB reader: Band 17 of GRIB dataset is 1440x721, while the first band and dataset is 2880x1441. Georeferencing of band 17 may be incorrect, and data access may be incomplete. The inconsistency in resolution results in incorrect georeferencing of the grids, in which the bands that have a resolution that differs from the first band are truncated and stretched. Is there a way to prevent the system from using the resolution of the first band for georeferencing all other bands? Is there a known workflow for rectifying this behavior?

Posting these Custom Transformers that may be of use or further developed: FeatureCreator FeatureExecutor One thing that is tedious in FME is actually creating data within the workspace itself. FME’s use case is mainly aimed at transforming external data and so is not natively setup towards actually creating new rows of data from scratch within the workspace itself. Wouldn’t it be nice if instead, users could just copy/paste a table of values into tje workspace and it automatically convert these to Features for you? ie. Easily store a “table” of data within the Workspace? This is essentially what these Custom Transformers aim to do (and partially inspired by Eg. Power BI with its similar “Transfomer” / Power Query that gives an interface to just copy/paste a table of data from the Clipboard into the query definition) Probably most of us currently use any number of Creators, Cloners, AttributeCreators (often with Conditional Values), Testers etc. for what is a lot of effort just to crea

Hi all, Using FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and tested in 2024 also. When I write a KML that includes multipolygons (aka nested donuts, aka inner rings) the records display correctly in FME Inspector (correct outline and fill) but when opened in Google Earth the fill is missing for records that have polygons within polygons (ie a donut hole has polygons within it). Simple polygons and simple donuts have correct fill. I’ve tried reversing the orientation with Orientor. Also tried playing around with the DonutHoleExtractor without luck. Any good ideas for a fix?

Hello FME Community, I'm relatively new to FME and encountering some challenges with my current project. I’m working with a road centreline network where the road segments have varying lengths. Each segment includes start and end chainage attributes. A road may be made up multiple segments so chainages need to be sequential and based on the prior segments end chainage for the next segments start chainage. I'm also generating M-values for these segments. Following the linear referencing guide, I’ve managed to retrieve all necessary values. However, the process required me to use a LineCombiner to combine the segments and a PathSplitter to split them back into individual segments. The issue arises when I attempt to split the lines back into their original segments. Instead of restoring the original segments, the process results in an explosion of segments, increasing the count to around 16,000. I’m unsure how to maintain the integrity of the original segments while still achieving the de

Hi All, I have a json templater which i’m using to create a json that has ‘firstname’ and ‘lastname’ - there’s 3 rows of data. I created the following in the root template but it outputs the 3 separately: { "firstName" : fme:get-attribute("first_name"), "lastName" : fme:get-attribute("last_name")} I then tried creating a sub template -with the following settings: Here is the output I get: { "firstName" : "first2", "lastName" : "Last1" }{ "firstName" : "first2", "lastName" : "Last2" }{ "firstName" : "first3", "lastName" : "Last3" } I can see that it’s missing an extra set of curly brackets, and when trying to run this result through a JSON validator it fails and gives this message: “Unexpected non-whitespace characters were found after the JSON text” I’ve looked at the JSON templater documentation and the exercise but I can’t seem to get this working. Any help would be greatly appreciated Many thanks, Sam

So this is going to be a dumb (yes, really their are dumb questions) but I can't for the life of me find a way to simply "print" or export my workspace to PDF for documentation purposes. Sure, there are screenshots but a screenshot of a massive workbench is illegible. When I go to "print" it will let me choose a paper size... but all I want is the ability to a) choose a custom size or b) "print" or export the entire workbench at (say 300 dpi) or something of that nature. Currently the "best" I can do when using Adobe to "print to PDF" is 47 ANSI E sized pages on export! Seriously, there has to be a better way???? Any ideas or suggestions? Note, I've tried programs like "snagit" to do a rolling screencapture but that doesn't work either. Matt

Hello guys, i am a little desperate in my attempt to write data from our oracle spatial database to AIXM gml. I already watched the Overcoming the Complexities of AIXM with Model Based Data Integration - FME by Safe Software webinar and also read this artical https://support.safe.com/hc/en-us/articles/25407686750477-AIXM-4-5-and-5-1-Reading-Writing-and-Validation-EU-Airports-Demo. discussing the matter. I even downloaded the demo workspaces to try to figure out why exactly mine is not working but without any result yet. I will attach my workspace , a log-file of a successful translation and the resulting gml file to this post and i hope that someone can make out the issues. Dont wonder about the Geometry-Extracter and Geometry-Replacer transformer i use in the workspace, i have already tried it without them and thought they could help, but also with no result. Thank you guys for reading this and helping me out in advance, it is very much appreciated!

Hello , I would like to understand more about shortest path finder i know ,it requires start and end node As picture : I have start point and end point ,several lines . i need it (start from right of picture (start point) to left crossing all lines ,not only from start to end ,continue to the lines of square area and force the lines to order the direction from right to left Is there a good idea here to let the fme set the direction from right to left and implement it for all lines (lines crossing from start to end and also the lines of square area till end )

Hello Could not able to write “Esri Geodatabase (File Geodb Open API)” facing Error Geodatabase Error (-2147219884): this so frustrating form last 2 days i am suffering from this issue.

Team: I have been developing some processes in fme server 2018 and have an issue that I am not sure how to troubleshoot. The work bench is pretty simple, read access, sort some things, a couple of joins and then push the data into a clean database that has the same schema as the source data via a feature writer instead of an access writer in the workbench—this forces me to use a 2 step approach as I have some SQL executors port processing. The feature writer works in desktop but not on server. Initially, I thought it was a permissions issue, but then I broke the process—to a 2-step approach—each process worked fine independent of each other. The log below contains the information related to the issue that I had with the first approach—handling everything in 1 process. I was basically pushing records to a couple of clean preexisting tables. I don’t have a project number for support, I will be happy to talk to any of you later tonight to see if we can solve this to make sure its not a pe

Hi guys, im working on a data loading workbench for our sql sde database. when applying change detection before writting into database, is there a way it can be dynamic and detect changes in group? Like original dataset a comparing to update dataset a, and b to b with key and compare field listed in a sheet? Thanks guys!

Hello everyone, I'm fairly new to the world of FME, and I'm trying to do a rather complex manipulation, but which I'm sure is possible with FME. However, despite my research I can't find a solution and I need some expert advice. I have 2 types of input data: On the one hand, railway lines as output from a ‘LineBuilder’ transformer. Secondly, a digital terrain model in TIN format. The idea would be to be able to create tunnels under the terrain. In some places, railway lines run underground in tunnels. It would be necessary to be able to ‘punch holes’ in the digital terrain model at the point of intersection. My initial idea was to generate 3D data around each rail line with a rectangular cross-section (5x4m) and then to be able to create an intersection between this 3D data and my digital terrain model to perform a subtraction. I've already tried a few things on found the net, but nothing has really worked. Could you give me some advice? Thanks in advance, Nicolas

Hello, i have a problem with the stringconcatenator. i would like to combine several values of text attributes with the stringconcatenator as a new attribute. the values should be separated by a comma, empty attributes should be ignored and there must be no comma at the end. how can this be achieved? I always get two or more comms if the attribute is emtpy. Thanks a lot.

I have an “Extras” attribute that is XML-like with different number of attributes in different order within the attribute value.. When I use the , XMLXQueryExtractor* and configure a query, it only returns rows that has one tag only called <PAGE_TITLE>, like below. The query returns this query result in the list attribute. THe resr of the rows are rejected as invalid XML Queries. For the other failed queries, they have multiple tags, as shown below. What I’d like to do is aplit the tags into field::values regardless of number. This attribute value: <PAGE_LINKS>https://p3tips.com/community/</PAGE_LINKS><PAGE_PRECISEPUBTIMESTAMP>20240905151800</PAGE_PRECISEPUBTIMESTAMP><PAGE_TITLE>Lynchburg Police searching for suspect after armed robbery at Family Dollar</PAGE_TITLE> Woud look like below with all the attributes in the Extras value split into however many tagged attributes. PAGE_LINKS PAGE_PRECISEPUBTIMESTAMP PAGE_TITLE https://p3tips.com/community 20240905151800 Lynchburg Police searchi

Hi All, I am trying to reproject some .e57 files containing LiDAR scans and oriented imagery collected with a terrestrial scanner. Reprojecting the point cloud is straightforward, but I am having some trouble with the imagery. I can see in the Feature Information window that the image locations seems to be stored in the e57_translation_x, y, and z Geometry Traits (Geometry->Raster->Geometry Traits), here’s a screenshot from Data Inspector: I’m working from a local coordinate system, hence the low translation values. My goal (I think) is to extract these translation values, reproject them in the same way I’m reprojecting the point cloud, and then write the new values back in to these traits, but I’m not sure how to access these trait values, and was wondering if anyone had experience with this. Thanks for looking!

Hello everyone, I'm looking for a way to check if the ending character of a string attribute is an uppercase letter, and if so, convert it to lowercase. For example: Foo1K → Foo1k BAR4 → BAR4 BAZ → BAz What's the best way to accomplish this in FME? Are there any specific transformers or approaches that I should use to achieve this result?

Hello there, How can I read a tsv file in FME? Do we need to use csv format only:? Thanks, Siva