Transformers

I am using an AffineWarper to translate some co-ordinates based on a series of control points. My control points are stored in a CSV file containing the following columns: Start_X, Start_Y, End_X, End_Y These are a series of control points representing start and end locations for the transformation. These are turned into vectors which are the vectors for the AffineWarper to perform it's transformation (see screenshot). This works fine on desktop FME, but when I upload the workspace to FME Server and upload the same CSV file, I do not get any features written. I get a warning in the logs saying the AffineWarper requires a minimum of 4 points, when the file does have at least 4 lines. I have written the outputs of the PointAdder and I can see the 4 vector lines being correctly created. However, it doesn't seem to be getting passed into the AffineWarper?  

I have a pointcloud.las and I would like to apply some R functions on it using the lidR package. I'm having some hard time figuring out on how the pointcloud should be formatted, or passed on to the data.frame within the R Caller?Same goes for grabbing the output.Any clues are much appreciated

I am reading from an Esri SDE GeoDB (ArcObjects) and use Archive Where Clause with GDB_FROM_DATE/GDB_TO_DATE to read archived data.... after processing the data, I write it to another SDE with mostly the same schema. This is my first migration step. After a while I want to do the same workflow for the data which were changed since the first migration. So I use GDB_FROM_DATE/GDB_TO_DATE in order to find the changed data in the source SDE. At the end of the second processing I need to update some of the features of the first migration (those which have been removed since the first round) and I try to use fme_db_operation UPDATE and a fme_db_operation_where clause attribute, where I try something like this:fme_db_operation_where=UUID='DEBE0707Hb000020' AND BEG='20170619110522' AND ENDE IS NULL BEG is a column of type timestamp (in the underlying Oracle DB) and needs to be compared to the

I have used snipper to get the starting points of the lines, then I used NeighbourFinder to find the nearest line to the starting point, but i want to exclude lines with same id as my point.. It is possible with Postgis, but know that I got a license I prefer FME if possible.

I am trying to merge two tables with no common key. How can I do this? 1 is from a select returning the database name (dbname) and server name (srvname). For example:BlueSpark, WINSQLPRD001 2 is from a function and returns database role information. Example:sa, sysadminNTSERVICE\\SQLWriter, sysadminNTSERVICE\\Winmgmt, sysadminNTSERVICE\\MSSQL$INST1, sysadmin I want to take the two items from 1 and add them to each row from 2 such as:BlueSpark, WINSQLPRD001, sa, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\SQLWriter, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\Winmgmt, sysadminBlueSpark, WINSQLPRD001, NTSERVICE\\MSSQL$INST1, sysadmin I've tried using various transformers and all require a common key. So I tried converting the results of 1 into attributes and using that to populate the columns of the output, but it creates separate rows with the results of 1 and 2

Hi,See attachments for my pipeline. In the pipeline I have a simple 3dmodel and a some amount of random generated points in a certain area where to populate that model to. The pipeline seems to work all the way to the end. If I inspect it in FME, everything is in correct place on the map, but once I send the obj to Cesium Ion, it no longer has the geolocation data, and it wants me to place it by hand in the Cesium Ion Portal. Any idea what might be wrong? If I open the obj that I just generated again in the FME Desktop, it shows the models on map correctly.     https://cesium.com/docs/tutorials/import-3d-models/

Hello! I am using NeighborFinder to match points from two different datasets. Once a point has been matched I would like to exclude it from the candidates. How would I do this?

Hoping someone could provide me with a comlplete example of how to use fmeobjects.FMEFactoryPipeline() in a PythonCaller Specifically I would like to take points as in input and use the SurfaceModelFactory with the undocumented parameter MAXIMUM_EDGE_CALC_LENGTH to hopefully produce a mesh with trimmed edges.   

Hi everyone,we have installed the 2021 Version already but now we don't know how to select multiple attributes in StatisticCalculator. In earlier versions i.e. 2019 it has been possible to select multiple attributes by clicking on the 3 points, unfortunately I can't find this option in 2021 Version. Do I have to select all my 100 attributes if I need a statistic about them? 😖  Is there any possibility? Kind regards,Sandra

Hi. Is there any way to create a plane or polygon of a set of pint cloud? I want to create roof surfaces from point clouds, but I have found no transformer.Thanks

I have a custom transformer to fit rectangles into a polygon. The inputs are the polygon, and the rectangles. They go into a spatial filter which checks for "contains within", failed features are rotated and looped back to the candidate rectangles port to see if they will pass the "contains" filter again. I set the "maximum number of iterations" parameter under advanced to equal 4. The issue is that the transformer will just spin the failed rectangles infinitely instead of just 4 times.

I have a 2D polygon shapefile representing buildings. I want to determine the distance to and from each building. I have tested the neighborfinder and think that may be strategy however I tested one building as the candidate and all other buildings as the base. However I do not want to create separate building polygons to use and rerun the transformer a couple hundred times. Is there a way to use the full building set as both the candidate and base?

HiI have a SQL table where I have cust no. = 1, Created date = 2020-02-01 and Last date = 2020-06-30.cust no. = 2, Created date = 2020-01-01 and Last date = 2020-07-30. I need to insert each month between Created date and Last date into a SQL table for each cust no.  Any ideas how do I do that? I tried Looper and Endless looper but I can't make it work and can't find any documentation 

We have a set of DWG files covering our geographical area. Sometimes we need to supply contractors with a subset of these files. The files are named by their map reference. We can generated a list of the required files using our GIS. So we have an Excel file with a list of these tiles in, which are also the file names of the DWGs. I have built a Workspace in FME 2020.1 to read the Excel file, construct the path and filename, and pass it to the FileCopy Writer. This successfully copies the files to a folder, but when I try to get it to ZIP the files, I only get some of them, and this message appears in the log: 2021-05-17 17:22:04| 13.4| 11.2|WARN |MULTI_WRITER: Skipped adding of some files to zip file 'X:\\SomeFolder\\selected_DWG_files.zip' because they already exist I don't understand the error because all the DWG file names are unique. I assume it's referring to the ZIP file, but I don't understand why I get varying numbers of DWG f

In my case there Parcel is who is supplier and building centroid is requestor in SpatialRelator of FME Script. You can see black round in one below picture. So even if centroid is falling on adjacent parcel boundary it got link of one parcel. How come ? why it's not gone for one to many matches ?  

Hi Everyone, Can you please assist if there is a way to enter bulk Test Filter Clauses into the TestFilter Transformer?  I have almost 100 test clauses that need to select points along a road by start and end in a spreadsheet. See belowThe TestFilter will filter out by these section to create a speed zone. Was wonder if there was an easier way to enter the test clauses instead of having to enter in 100 times?  Thank you so much for your help in advance

Hi all, I'm trying to write a fixed-length number to a SQL Server Non Spatial database, and most work fine, but this one doesn't - Microsoft SQL Server Non-Spatial Writer: Unable to format data '4411398' for column 'ciFloorArea' of type 'numeric(8,2)' The other numbers look like so, and must be the exact 8 and 2 parameters - 1305256844113988248072 I just wondered if there was anything I was missing with the one that's throwing the error up? Thanks

I have an identifier attribute which can take different forms.All contain a number, like 985 or B985 or 985aSome are preceded by a capital letter like B985Some are followed by a smallcaps letter or the character "*" like 985b or 985* I wantthe capital letters at the beginning of the string to go into attribute PREFIXthe numeric to go into attribute NUMBERthe smallcaps letter or the * to go into attribute SUFFIX I imagine using regex is the way. I have got the job partly done with a series of StringSearchers but I'd like to have advice from someone with experience. Thanks in advance !  

Identify identical geometries from two datasets I have two building datasets and I need to identify which buildings from dataset A exactly match the geometry of a building in dataset B. What's the best way to do this ?

I'm using FME 2020.2, connected to SQL Server 2014 as sa with a database specified using the non-spatial connector. I am trying to create automated Excel reports for SOX audits using three SQLExtractors running one of these each: sp_helpsrvrolemembersp_helprotectsp_helprolemember The results I am getting do not include all the rows I get with SQL Server Mgt Studio connected to the db specified in the FME connection. I also tried adding "Use DBNAME" as the pre-sql with no change. Help me to understand why this is, and how I can get the same results as SSMS (hopefully). Thanks...Bryan

I have a set of data, coming in from an sql database. I have a tester that then splits this into two streams - one stream contains details of all positive value transactions and the other contains details of all negative value transactions. Each transaction has a unique reference. I need to be able to say which DR transaction a CR transaction has been applied to but the kicker is that the CR transaction might not be for the full amount of a transaction and a later CR transaction might apply to the same DR transaction ie multiple CR transactions apply to same DR transaction. I also need to be able to assign a balance to both transactions but this needs to be the balance at the end of the transformation. The attached excel document might explain it better

Hi,I'm parsing text files - I'm using VertexCreator to take lat/lon columns to get a point. I have CoordinateSystemSetter going into it.I'm passing the VC into an ArcGIS Online Feature Writer for points (geometry is set to arcgisonline_point). I set the writer up with Import Writer Feature Types (as suggested)This process successfully creates the point in ArcGIS Online, but it always places it at 0,0. It writes properly if I used a writer to FC on disk and use that FC as input to the online feature service. I'd like to skip the unnecessary? writing to disk if possible. Is my workflow correct? Is there another step/setting I need with the VC?thanks

Hi guys, Is it possible to detect a plane from a point cloud. Specifically, I have a point cloud of a box (cube), and I want to detect one of the faces (e.g the top face). My cubes tend to be supported on an almost horizontal plane, that is Z direction of the box, is very close to the Z axis. The final challenge is to estimate the inclination of the top face, relative to the reference axis. Do you have any idea how to move forward here? Thank you very much!

Is there some setting that needs changed?​