FME Form

I have 2 PointClouds I want to merge their components using PointCloudMerger, however their x,y,z and coord values differ. They both represent scan of same building, but one has been set with global coordinates. I have applied Reprojector/CommonLocalReprojector but their location still differ. How do I change one of the PointCloud x y z values to be same other than forcefully changing it? And if I must change them by force what type are their in (Real64, Uint64, Int64, ...) ? Alternatively, how can I pass the component value from each point to other point cloud through an index method as both Point Cloud have same number of points and should have same index.   

Hello fellow forum members, I am currently facing an installation issue with FME Desktop on my Intel Evo laptop [https://www.lenovo.com/ca/en/faqs/intel-evo/] running Ubuntu 20.04.1, and I am reaching out to seek your valuable insights and assistance. I have been trying to install FME Desktop, a powerful data integration and transformation tool, but I have encountered some challenges in the process. Here's a brief overview of the problem: After downloading the FME Desktop installer for Linux from the official website and following the installation instructions, I am unable to launch the application. Whenever I try to run FME Desktop, nothing happens, and there are no error messages or indications of what might be causing the issue. I have checked the system requirements and ensured that my Intel Evo laptop meets all the necessary specifications for running FME Desktop. I have also made sure that my Ubuntu 20.04.1 is up to date with the latest patches and updates. I have attempted t

I need to take serial tabular data and join or pivot it to columns joined on the common field UniqueID. I've been reviewing joins and mergers but cannot determine how to create this transformation.The resulting data columns should be UniqueID, longitude, latitude, Cat1,...Cat9 Thank you,Gilbert

Hi Is it possible to read a portion of a Cloud Optimised GeoTiff using a bounding box? I'm trying to use the GeoTiff reader with the search envelope set but just get an "Error occured during translation" message after the Geotiff is opened.  Thanks Tom

We have a workspace in our cloud that pulls data from our own api.We do one get call per table/api endpoint in parallel, and have about 10 httpcallers that run at once. We are finding that when we reach about 750mb of data in transfer, we get failures. The last table before failing looks like it has a very small amount of data, when in reality it has a significant amount more (see Containers in the logfile).Is there a limit on transfer size in FME? We figured we could try offsetting each call but it's strange that it just fails. I can provide more details but thought I'd start here. Message is "An error occurred while accessing the url"...Note, pulling any table individually through the api is perfectly fine...Pulling all at once through the API causes this error when we reach about 770mb + of data being transferred.... 

The output needs to be a horizontally flat line that is built on the values from the measure field. I would also like to insert a vertex at every measure change.

As the directions in this topic detail: https://community.safe.com/s/article/Using-a-private-SSH-key-with-FTPCaller-to-authenticate-an-SFTP-Connection-on-FME-Server-and-FME-Desktop I am using a SystemCaller to launch Pageant and load the private keys so the FTPCaller can successfully authenticate a SFTP connection. This is working great in FME Desktop. However, when I load the workspace to FME Server, the SystemCaller just hangs. I have gone the extra step of even loading the keys in Pageant on the server, but still didn't help. Is there something extra that I must do to get this process to work on FME Server? I am using FME Desktop and Server 2022.1 Build 22618.

I am trying to create Mbtiles Raster layers with specific coloured layers and also labels and popups. Is there any way of doing this within FME as I can't find a way to?

My question is quite simple but I am a new user in FME. Well, I am going through this process in FME workbench to find percentage of land cover classes excluding water bodies.​General process:1- Using selected land cover Shapefile and only consider Grassland (class 30) and cropland (class 40) classes​2- Using selected tiles to extract the percent of targeted vegetation (grassland+cropland) referred to the whole classes except water(class 80)​3- Select tiles having at least 1% or 0.5% of the targeted vegetation. For info, 1% corresponds to 10 000 ha​Below, you can find my fme workflow that it does not work for percentage calculation.​I thank you in advance for your guide and feedback.

Hi,I think the best FME Transfomer for such type of extractions is the "XMLXQueryExtractor", but I do not know how to build the query.The XML is contained within an attribute and could be something like this: "<?xml version="1.0" encoding="UTF-16"?><value xmlns="http://spec.tn-its.eu/schemas/"> <gml:measure uom="kph" xmlns:gml="http://www.opengis.net/gml/3.2">50</gml:measure> </value>" For that particular case, I wanted to extract that "50" value from that XML.Thanks!   

I have a model that has to select rows(points) out of a large collection of large csv files. To encrease performance I want to go throught them one by one. What is the best way to do this?

Hi Guys,I am not familiar with Land XML files .....but i need to get a geometry out of this files...i attached a screenshot of my xml format structure...there should be lines in it....but i don't know to do it....i did it with this xml_fragment attribute and Geometry Replacer or GeometryExtractor but nothing happened Thx for helpFranco

I am reading several GeoTif and line features from a PostGIS table. To make life easy I added the RasterMosaicker and linked the mosaic to the PointOnRasterValueExtractor. The line features from the PostGIS table get their vertices densified, and I extract those using the PointVertexReplacer from FME Hub. Since the coordinate systems of the data do not match I use the EsriReprojector for the points to have them as well as the mosaic in EPSG: 4326.Now, when I run the PointOnRasterValueExtractor the output points do have _band{}.value and _band{}.palette{}.value. I expose _band{0}.value since the mosaic only has one band, but each and every point is missing the value. I used the Data Inspector to visualize the points on top of the mosaic, and everything lines up. Why do I not get any values from the PointOnRasterValueExtractor? I am using theData Interoperability workbench with FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64) RasterMosaicker in version 7PointVertexReplacer in version 2

I have got data as below  AssetID X Y Z A. 0 0 1B. 1 0 0C. 0 1 0D. 1 0 1E. 4 5. 6F. 9. 8. 7G. 6. 9. 5  am able to extract max of each row min of each row  how to obtain medium of each row as simple as possible ?  am using @max ( value of x , value of y, value z)@min ( value of x , value of y, value z)  medium ?????( plz note it’s not average or median of 3 value ) It’s exactly absolutely value the same as it is in excel files.   

Hi, fellow FME:ers, this is an urgent matter! We just upgraded FME Desktop and FME Server to 2022.1.2. We have 100+ solutions in our consultancy firm building on the use of excel template files - *.xlsx and *.xlsm.  After the upgrade the output becomes corrupt.  Is this a know issue? Is there anything we can try to avoid corrupt files? Or do we need to go back to previous FME versions…I attach two example template files we’re using.Any help will be appreciated!Peter

Hi, this question has been asked previously in the old forum but I couldn't find any answer.  I have a workspace that writes an Excel file. The destination dataset uses the value of a published parameter to set the output filename. e.g. DEST_DATASET = $(PROSPECT).xls  When running the workspace on the desktop the replacement works as expected. e.g. the output filename becomes "my_prospect.xls".  When the workspace is published up to FME Server (2013 sp2) as a data download service the workspace runs but the XLS file returned inside the .zip file is called "$(PROSPECT).xls". ie. no parameter substitution is occuring.  Does anyone know how to do this?  thanks, Nic

Hello,I have a point cloud and I would like to get a buffer around each point (to apply an intersection with another mesh)I have placed the following transformers: PointCloudToPointCoercer to separate each point (output geometry: individual points) and then a buffer (buffer type: solid)The workbench works fine, only in the operation, somehow, I lose the georeferencingDoes anyone have a solution? Thanks

How to let this arcpy code in Python caller work my input type is ArcSDE Esri the target here to get the list of relationships of classes between eachother and save the output in csv  i am not familiar with Python ,what should I add and change here to let the code work in pythoncaller and write the  output in csv fileimport os, pprint all_rs = listRelationshipClasses("path/to/your/database.sde")  # see above pprint.pprint(all_rs[0]) # filter by namers = [r for r in all_rs if r["name"] == "FilterName"]rs = [r for r in all_rs if "PartOfTheName" in rs["name"]] # filter by cardinalityrs = [r for r in all_rs if r["cardinality"] == "OneToOne"] # filter by origin or destination tablers = [r for r in all_rs if "OriginTableName" in r["originClassNames"]]rs = [r for r in all_rs if "DestinationTableName" in r["destinationClassNames"]]rs = [r for r in all_rs if "OriginTableName" in r["originClassNames"] and "DestinationTableName" in r["destinationClassNames"]] # filter by datasetrs = [r for r in a

The FME ASPRS las file format 1.4 reader seems to omit withheld points. How do i import all points (including the withheld points ) and then use classification_flag to filter the withheld points in and out? The point cloud splitter doesnt give me classification_flag as an option, and the withheld points dont import via the reader (withheld points verified by lastools), and cant see a parameter to control whether withheld points are imported. Advice welcomed. Thanks in advance.

Hi All, I am using FME Desktop 2022.1; We have some GML files that FME does not read. I don't know why. Please help me out here. File is attached.

I have a workbench that creates points from coordinates then generates lines. I am only getting three sides of the polygon and I have not found a transformer that will close the forth side. Can you suggest a solution?

I ran a workbench that reads data from .xlsx spreadsheet into a MS Access database (.mdb) table. I got this single error message:"Failed to read the metadata for 2D rendering" I have never seen this before, any ideas on what it means and a fix? I am using FME Desktop Version 2021.2.6 (Build 21821).

Hi, I would like to do something very simple. I guess. I have one feature in Oracle spatial with differents locations. The cities have one set of the code. Example: Paris (345) with 500 features, after Mumbai (346) with 4335 features. I want basicaly no have duplicated cities by code. I need even run again with Paris and delete all features with ID 345, and put the new features. Even like this, delete all stored line and insert the new lines if the ID is equal. Thank´s  

Hi there! I have about 30 different very long workbenches that we use for one very complex process. Every time we have a change, we want to be able to search in our list of transformers from each bench. Is there a way to generate or map out or investigate workbenches and have that list of all transformers from all of those benches?  Python, xml, anything will do. Need some ideas guys please.

Is there a shortcut to creating the connections automatically instead of dragging and connecting readers to writers one by one?