FME Form

Have to execute a procedure in FME, doing that but its giving an error in SQL executor 'ORA-00900 - invalid SQL statement' however working fine in Oracle Toad, any leads how to do in FME?

Hi Altruist, I would like to bulk reproject on a number of database table in SQL spatial server and write (update) the tables into same database after the reprojection. All tables are in same CRS currently but obviously schema are different. Can anyone kindly suggest a tutorial/workspace of same sort?  best regards and thanks in advance.

I have dynamically reprojected tables from MSSQL database and then written into another MSSQL database) with same table schema. I can see the new tables exist in the SQL server. Also When I am checking the tables on FME workspace by using CoordinateSystemExtractor, I can see the tables are reprojected. But the data is not displayed on QGIS, though attribute table can be seen. Also in QGIS layer property option, the CRS system is still showing the old one. Can anyone kindly tell me what could be the likely reason/s?

hi fellas,I'm trying to translate a dgn file, but it fails to load correctly. when i open the file with Bentley Microstation Connect edition I can see the design, but when i try to open it with fme data inspector it fails to load the design (it loads all the features but they are not shown graphically).attached are pictures to illustrate what I get when trying to open the design with Bentley Connect, and with FME Data Inspector (using v7, v8 and xfm v8 readers).can you help me with the issue? best regards,Sharbel

I am trying to generate CESIUM terrain files to be able to serve files locally offline. I am currently testing with data from maps Canadas HRDEM (https://open.canada.ca/data/en/dataset/957782bf-847c-4644-a757-e383c0057995) they provide a index file and directory of GeoTiff files. I need to convert this to CESIUM terrain tiles. Can FME do this or does it only do visualization for things "on" the terrain such as buildings etc.

I am updating multiple Workspaces to the newest version of FME Workbench 2022.1. Updating the transformers has proceeded well except for the Clipper transformer. I found that v14 takes substantially longer to process the data than v13 in all workspaces tested. In one example, v13 took 22 seconds and v14 was stopped after 10 minutes. Any suggestions? One item noted, when using v13 all 16,076 values are received from the PointOnArea transformer before Clipper starts processing; whereas, v14 appears to process one at a timev13v14 Update Settings

I have a file that has been converted from .ifc format to citygml format and I want to convert it to a shapefile. There is a problem with the coordinates and dimensions of the building. If the modeling is done, as shown in the following figure...Suggest me a set of solutions, please.?

Hello,I am trying to set up a simple flow to automatically copy new or changed data from multiple excel sheets into the master Excel sheet that lot of PowerBi dashboards feed from. The flow is simple as follows:-Read from sheets -> Attribute Manager (rename to match main excel) -> Change Detector -> Attribute Creator (fme_db_operation (UPDATE)) -> NullAttributeMapper -> Writer. Problem is at the last stage, the writer is not updating the main sheet and could not find the correct setting messing around with the writer parameters. Any help would be appreciated, I have attached the screenshots below.

In the conversion process of using the same educational model note that using the system Epsg4326 The examination is correct When adding the converter as it is in the lesson, converting from the canvas and using the reader and writer’s coordinate syste

i am trying to get the data from https://www.nhc.noaa.gov/gis/ website which working fine but problem is that if on the website there is no current storm then in over ARCgis data also delete I m sharing the was can you check for me as I am new

I am just looking into the idea of using desktop instead of a 32-bit engine and if someone has experience with this, good or bad.

I have a dataset which contain null/non-null values in a particular column, I have to segregate it in the way that if any null value exists, all null/non-null values will go in 1 direction else only the non-null values will go in 2 direction (port), help?

Has safe adopted the standard for related tables in geopackage (writing/reading)?If so, how do I go about it?

Good morning,I’m trying to transfer data from ESRI to PostGis.Unfortunately, I encounter the following error:Error was 'ERROR: value too long for type character varying(50)I understand that the created field is too short but I can’t change it...Thank you for your help.

I'm having trouble pivoting a table. Here is what I am trying to accomplish: Is the AttributePivoter the correct transformer to use? Thanks in advance, M

Hi, I have a question as I'd like to use a tool based on ArcGIS Pro: Integrate (Data Management) with FME environment but can't find it - is this tool available with FME? Thank you.

Good day, I would like to ask. I am currently solving the tracks in the WS in the attachment. I ran into a data "loss" issue happening on featureMerger. Points from the polygon of interest go to the Requestor's input, and points with the same ID as the requestor's input go to the Supplier's input - these points are part of the RouteSegment. Now to my problem. I believe that I don't have all the data on the FeatureMerger output because I only have each point once on the requestor input, however, I can have a point multiple times on the suplier input and it can be part of different routeSegments. At the moment when a point at the requestor input is "reserved" by the first point of the same ID on the supplier, at that moment the rest of the data goes to the Rejected output. I can think of creating X featuremergers, where I would send the rejected data to the input of the supplier and the original polygon_selection_topsky source to the requestor. But I f

Hi,I have two line shape files. File 1 is the duct layer and file 2 is cable layer. When cable layer is drawn on duct, cable vertices must be coincident ( snap) to duct vertices. How to find the cable vertices that are not coincident with duct? Thank you for the help

Is it possible to sort by multiple columns with the Inspector? Don't need the Sorter. I'm looking to take a quick peek at the output in a few different way, not push final output to a writer. Using FME 2020.1.2.1 (b20624).

I have tried the RasterDEMgenerator and the ImageRasterizer but both give errors regarding the input features or geometry. I have tried different feature settings but to no avail.

I'm new to FME and impressed by what can be done with it. However, I got stuck regarding some details. I have a PointOnAreaOverlayer transformer and I wonder why the Point output port let's me use all attributes, whereas the Area output port generates no output for some attributes that I need to use. What is the solution here? Thank you!

I am using 'AGOL Feature service reader' to fetch data from Survey123 survey results feature service. When I export to excel using Survey123 the labels are being shown as headings, but while writing using FME displays the attribute names instead of Label. Is there any way by which I can export with Labels as headers using FME?

Is there a possibility to iterate trough attribute values in a shapefile. I want to pass each value trough a WFS query.

I am creating texture atlas (using FME 2022) from cityGML files at the time of tileset (cesiumjs) creation. But I am not able to find the texture atlas. I want to know where it gets stored?