FME Form

Hi,I read an Oracle Database with "esri SDE" connection file. I need to update the reader. We now have a new Oracle table that contain a new column and the datatype of that column is "xmltype". With a Oracle Reader or SQLExecutor, I can read the "xmltype" data. But if I read the data with "SDE", the column is not there. Like SDE don't understand "xmltype". Any idea ?

I want to be able to read a list of PDFs from SharePoint and publish them on AGOL as PDF.

In QGIS I can open Google Street View coverage using this URL as XYZ tile:https://mts2.google.com/mapslt?lyrs%3Dsvv%26x%3D{x}%26y%3D{y}%26z%3D{z}%26w%3D256%26h%3D256%26hl%3Den&style%3D40,18 The result is following: I can't get it to read into FME Desktop. Any suggestions?

Hi everyone, I have some seismic cross sections that are in bitmap format. I would like to transform them into vertical georeferenced cross sections, something like this (https://gis.stackexchange.com/questions/295586/displaying-cross-sections-3d-volumes-in-qgis-3-x), and export them as 3D object if possible (I'm not sure wich format would be suited for that). I can create lines that represent the acquisition lines for those seismic images but I have no idea how to "hang" them vertically below the line. Does anyone has an idea if it's feasible in FME ? Thanks

Hello FME community, I would like to use batch file and FME to create a tool that is able to export an Excel file to a shapefile and transform the coordinate system at the same time.with batch file i get parameters from user. The sheet name and name of the columns can be different for each transformation. when I try to run the process for different file, Sheetname and Column name should be same as previous file and create shapefile without column or empty columns. I need my Read and Writer to automatically recognize new sheetname and Column name   

Hi all. I currently have a workspace that simply downloads some data from a SQL server, puts it threw some geometry checks and then finally uploads the .gdb to an S3 bucket. I would like the final output to be a zip file rather than the .gdb but cannot get it to work. If i change the final output in the S3 connector a zip file is created but it is blank. Any help would be greatly appreciated. Here is a screenshot of my process: 

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.