FME Form

There appears to be a change in message recorded in _reader_error that gets added to data coming out of the rejected port of either the SQLExecutor or SQLCreator when connecting to an Oracle DB. Previously (in 2019.2) a failed connection to the database resulted in a single error in the translation log and the following sort of text in the _reader_error attributeError connecting to Oracle database: message was `ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'....orError connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'.  orAn error occurred while accessing a table result for feature type `'; message was `Execution of statement In 2021.2, I now get two errors in the log. One which contains the useful information above and a second that seems to always readError connecti

Hi, I created shape files from spatial database for the use of our corporate software using fme. And I scheduled in Task manager to run this task daily to keep the files updated. But now I needed to keep them up-to-date checking database table for every half-an-hour. I'm looking for some help to update existing shape files (similar to update detector used in case to update database table) rather than delete and create each time. your help with is greatly appreciated.

Hey there,following my issue with clothoids I now have a problem with writing geometry properly into LandXML.While the geometry is proper within FME Desktop, it gets worse as soon as it's written to LandXML.Any ideas?A sample workspace is attached. Cheers,MariaKa

Hi, I read that safe is building a way to generate custom transformers from OpenAPI description. Could anyone tell me if the plan is to make it compatible with 3.0 or only 3.1 specs?

I'm hoping this is fairly straightforward, I've searched a number of examples but I cannot quite find what I am looking for yet. 2 datasets:1dataset is a table with LRS and Milepoint (no geom)1dataset is a highway network with LRS and Beginning_Milepoint and Ending_Milepoint (polyline)ObjectiveIs to place points along the linear feature based on LRS and MP from the table (the table contains assets located on the highway network). This is often referred to as Make Route Events Layer in other software. Are there any recommended workflows to consider?  Thank you in advance!

My parameter says this.$(FME_MF_DIR)\\CF\\PNM.sdeBut I want it to say this.C:\\Users\\USERNAME\\Desktop\\CF\\PNM.sde Can this be done? This is a problem because it breaks the connection when the workbench is put in different folder.

I have a LAS dataset representing the groundsurface (also available in a point feature class) and a polyline Z feature class. Is it possible to determine where the polyline z is above the ground surface also taking into account in between the vertices?

I have two polyline features. One which is on the ground surface and one below the ground surface on the exact same location. I want to generate height lines for each Vertex generated by the differences in Z-coordinates of the corresponding vertices of the 2 polyline features.

Hello,I try to create polygon from osm like cemeteries. For now, I'm stuck after the XML Fragmenter and Vertex Creator. I don't know how to build lines between points because there isn't an unique value. I didn't find anything on the FME community so I post this question. If someone could give me an orientation, if would be very nice !Thank you !  

Hello There I need to remove the duplicate point along each segment,the goal is in every 5 m of the segment we need only one point, we should start with the recent point based on the date, then the missing segment will be completed by the next date ...etcthe idea is to have one point in every 5m of the segment line  I have attached a sample of the data  

I was thinking I can use an attribute filter to filter the different asset types and subsequently use a 3Dforcer to lay the different polylines on their correct depth. As an example I used the following parameters in the 3Dforcer for 1 attribute of the field asset type:  Elevation: @ZValue()-1Preserve Z-values: No The result was as follows:1 polyline features has 3 vertices:Before translation:  1stvertex Z: 0,62ndvertex Z: 0,83th vertex Z: 1,0 After translation: 1stvertex Z: -0,22ndvertex Z: -0,23th vertex Z: -0,2 What I would like to have: 1stvertex Z: -0,42ndvertex Z: -0,23th vertex Z: 0 This translation provides a constant Zvalue based on some average of mutliple vertices. I want it to take intoaccount each individual Z and then substract the ammount sp

Hi, I would like to crop image according to shapefile boundaries, similar to arcgis extract by mask. Currently I have this result after clipper transformer, but is bad for me.   Thank´s 

I got un expected location from pdf page formatter .Iam not sure , why .i have added the cables and the polygon to pdf page formatter .when I add only polygon ,output as expected but when I add cables and polygon .the position for polygon border changed.then write the output in Feature writer Pdf(Geo spatial )the location of ouput as unexpected fme 2021

I'm currently working on a high-voltage network, which relies on pressurized oil being forced into cables to insulate them, through a pressure gauge. The pressure gauge (node) is connected to an oil line (line), the other side of which is connected to a connector (node), which is then connected to a cable (line). I'm looking to add attributes of the connector and the cable to the pressure gauge, but can't seem to figure out how to get it to work. Main issue with SpatialRelator seems to be that from 1 pressure gauge there are 3 oil lines, going to 3 connectors, going to 3 cables, over which a single connection runs in 3 phases, where the connection has no geometry.

I want to transfer the sum of all attributes from a given vector-layer (risikokort.tab in this case) to a tiled map, and export as raster. An overlap-analysis basically.When I pass my tiles through rastermosaicker, a resampling occurs which changes the output. To test it I ran the rastermap through RasterCellCoercer, which clearly shows output-raster and the input tiles are very different.I would expect the input tiles and the output tiles to be the same. Am I wrong in that assumption?I hope the workspace is self-explanatory, and if some of the gurus open it, all feedback is appreciated.

With the list of transformers growing ,I would love a list of all available transformers - ordered by the date they were created/implemented.I'm not interested in the modification/upgraded date, and it is not related to a specific task or workspace. Just the entire transformer package :) Is that possible?

Hello, I have an error on using SurfaceNormalCalculator:  

Hello I want to give the location and Id of the points that follow the path of the line to simulate asset movement I am soring Y descending and X ascending But it's not working  Any suggestion please 

I have an HTTPCaller that fetches all the source rows in one call however the downstream transformers make the caller run again for each row. How to tell the transformers they already have all the data and to loop only within? 

Screenshots attached when I had the issue initially (FME1) and the other after login into ArcPro - Error is now gone (FME2)

We have tried using the Cesium 3dtile writer in Safe FME but have found that the generated tilejson and tiles are invalid when testing the data with Cesiums 3dtile validator. The primary issues are that the tilejson has the wrong version number, should be "1.0", but is "0.0". Additionally, none of the tiles have geometric error values in their metadata (its in the tilejson, but not in the individual tiles). Cesiums web SDK is pretty forgiving, but their Unreal Engine SDK is not, and won't load tiles created using this writer. Any ideas on how to resolve this? I followed this guide to create the tiles: Tutorial_FME_Cesium_3D_Tiles.pdf (ethz.ch)

Hi, I am just exploring some of the standard dashboard features of FME Server 2021.2.3.0 (20220131 - Build 21812 - WIN64), I have got a couple working without any issues, and now I am unable to get the "DailyAverageQueuedTime.fmw" workspace to run, each time I get a warning: Path Reader: No files found in folder 'C:\ProgramData\Safe Software\FME Server\resources\dashboards\temp' using glob pattern '*.csv' with glob filter 'FILE'. No features will be readI have attached the full log file, has anyone seen this before, or do you know how to resolve? I am not sure what I should be looking for. Cheers

I have used RasterMosaicker to mosaic 4 ECW images into a single ECW image. Prior to mosaicking none of the images had black areas around the edges. After mosaicking my output shows two locations that are black on the edge of the image.  I checked and these black areas have data, various values of 1,0,1; 0, 1, 0; 1, 2, 1; and several other values. Any suggestions on how to remove the black areas? I have tried Clipper and it does not clip the black areas, they remain in the output.

I am trying to dynamically read all the gdb's in a folder then write all features out into an SDE with the same schema. Unfortnetly it is giving me errors when running it. I am reading both the schema and the features but the SDE writer does not like it.  Also, if I am sucsessful, I assume it will count the 10 schema features are actual features, but they arn't really features at all. Is there any way to remove these from the output while still keeping the schema?

I have a very badly formed csv that I want to transfer to a table. I have managed to get a basic output to work on. But the step to keep the value of 2 identifiers (file_date, id_name) if null and transpose to the next rows till they get new values, I don't know how to do.