FME Form

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Co

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?

I'm working with some large DTM datasets and am killing my machine with the clients requested settings. I wanted to see if this "Surface Model" file could somehow help me process the data in batch. The documentation looks promising, however, I've not really had much luck when testing it and there are no examples anywhere I can find of how to actually use it properly.

how generator snowflake id, use FME desktop,  uuid generator result is long 

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?

I am trying to read in two separate .dwg files, make changes, assign layer names with Feature Writer inputs, and then output to a single .dwg file. But, the data is not combined and it outputs two files from their respective reader instead.My hunch is that the Feature Writer is seeing different schemas coming in, but I can't figure out how to combine. This is one of those "seems easy, what am I missing" issues..I guess?

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 De

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 PointOnRasterValueExtr