FME Form

Hello every oneI have workspace to read many files in SharePoint just to know which folder has updated with new dataAnd it’s taken to much time to read all files in SharePointMy 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 workspaceThanks 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-3In 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, AttributeCr

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 in

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

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 so

Hello , I would like to understand more about shortest path finderi 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 )  

HelloCould 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

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

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_PRECISEPUBTI

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. 

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 → BAzWhat'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

Hi All,Anyone could help me with this specific question  in FME? I want to remove the repeated words in each row, e.g. A,B,C,A,B in a row, the A, B have been repeated twice, I would like to remove the repeated A and B only. please see attached the  sample data. many thanks. 

I have created a workbench to detect schema different.I am using two ChangeDector Transformer in this workbench which is producing output as I intend. Figure below shows that part.Workbench for that part This is output data (in csv file) based on that workbench.Output by FME Workbench 2023.1 (FME Form 2023.1)However, when I used the same workbench with the same data, the following output were produced. It got extra error. For error code E302, those not bold should not be there.