Transformers

Hello again, apologies for the questions, i am fairly new to FME and this one is baffling me. To me, this is a fundamental question, but through much research, I haven't found a solution as yet. I try to research before I post in forums.  IS there any way to write a bearing of my 3D Object on writing out to KML ?  Maybe I should rephrase this as I CAN actually rotate the object. What I would like to do as an option, is somehow have this parameter/attribute in the KML file so that when you click on the properties of the KML, you can input the Angle/HEading/Bearing at this point.  The ultimate goal would be to get all bearings from a CSV / External Data source, along with the model type to be used, and on writing to KML would have the correct model at the correct bearing. This is a big one actually and fundamental to a particular use case I'm looking at. 

Hello, I'm trying to extract a number out of my comments column. I'm not sure how to write the expression? or if I'm using the right transformer? I'm still new with FME. The number I am trying to extract is 8 digits and is put in comment field with this format "/ 12345678 /" an example of the format is below. VB BLVD / 59208085 / L06-514 / ATT 8547 Is there a way to extract this number?  Thank you!

How in FME would you check that two floats are "close", given testing floats for equality can be a challenge? e.g. "-23.123" as listed in an XLS compared to "-23.12300005" stored in a point feature class? In Python I use the math.isClose() or assertAlmostEqual() Thanks 

Has anyone experienced SMTP email simply not being sent using either the Emailer Transformer or the FME Server Automation Email External Action? I've had each of these things happen to me once, but the same Workspace or Automation run in most instances does send the email. The log file from a sent and not-sent email looks almost identical to me, I've attached both. These are workspace runs with the Emailer Transformer sending the email. I've asked our IT department if they can look into anything, but they can't say much since SMTP is just a relay. Also the fact that it works correctly most of the time makes it difficult to troubleshoot much further.Any thoughts or things to look into would be helpful.Thanks!

I have a SDE feature class that has a date field and another table that contains only 1 record with a date. I would like to query out the records from the feature class where the dates are greater than the date in the other table. The dates in the feature class and in the other table will change. I do not have a way to join the 1 record to the feature class records but I want to use the same 1 date to filter all records. The table with the 1 record could be text file or most other formats.Thanks, David

I convert input features to XML using XMLTemplater. Everything is fine as long it is done through the same sub-template. When I try to process some attributes (coordinates reading) by calling another sub-template it fails. This sub-template works properly **OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" ></object>} This one, calling another sub-template, doesn't work.**OBJECT Sub-Template**{<object  id="{fme:get-attribute("id")}"  visible="{fme:get-attribute("visible")}"  {fme:process-template("XY")} > Here is the syntax error: unexpected character "{" near line 4, column 5 .</object>} **XY Sub-Template**{ lon="{geom:get-y-coord()}"   lat="{geom:get-x-coord()}" } I did try a lot of things but I still don'

Hi, I would like to ask, does anyone know how to divide data into individual sets based on the same ID? For example, the result will be 5 groups of attributes with the same XOBJECTID.Thank you!!!

Hi everyone,  I have a simple workbench where I added a reader that reads 20+ featureclasses from a nationwide dataset from a file geodatabase.From there the workbench selects 11 featureclasses and uses the clip transform (clip polygon is a province) to clip out a certain area and saves it to a new file geodatabase. Problem with the workbench is that it has milions of features, and the machine I run it on will run out of memory after 5+ hours of processing.  Is there a way to split up the workbench so it will read/transform/write the workbench in 1 to 3 feature classes and waits till the memory is free again before starten the next 1-3 features classes? (maybe with embedding multiple workbenches?) thanks in advance! 

Hello!I'm trying to create a point layer from a set of photos in .heic format. I can see in the photo metadata via Windows 10 file explorer that the photos were taken with GPS on and the coordinates are stored in the EXIF data.I'm wondering how I can use FME in order to create a point layer (and save as a .shp for example) using the coordinates found in the photos, and then attach the photo to each point in the point layer.From what I can see, there is a transformer that can create such a point layer from .jpeg photos but there doesn't seem to be a similar one for .heic.Does anyone have any advice?Thanks!

I have multiple lines and corresponding two point for each line. I want to trim those lines by keeping segment between two points. I have tried pointOverLine which does segment the line but I am having difficulty eliminating remnant.

I need to create one list of user names that are in multiple attribute fields.

Hi All, I'd like to split our entire road network into 5 groups. Each group would cover approximately the same total length i.e. (Total length of all roads)/5The roads in each group would be spatially clustered/grouped togetherIdeally i would not be snipping any road segments I've tried to accomplish this by using the PointClusterer and feeding in the roads center points or 10m interval points but when merging the cluster points back to roads, the grouped distances are too varying.  Is there a better approach to this? Thanks

I have created a 3D model which shows a 'radiation zone' I created this from REVIT > FBX which will ultimately become a KML/KMZ. I have looked at Styling the edges within the Authoring software ie Revit, but that's a non starter.  Is there any way that FME can 'style' the edges of this 3D model on writing to KML ?  Many Thanks, please see my other question regarding the rotation of this object.  

Hi AllI Have the following datasets, DTM, DSM and Colour Infared, and am trying to extract trees over 3 metres in height from the data.I know that i can subtract the DTM from the DSM to give me the height difference but can not see how to have only the raster cells over 3m, nor can i see how to extract the polygons from the imagery.If anyone has any suggestions on how to do this then please comment.  

I have a dataset with attachments using ArcGIS online and would like to download the pictures associated to a certain Field in the spatial dataset. Each attribute(row) usually comes with 1 or 2 pictures and the bulk download in ArcGIS has meaningless filename for the pictures.I would to use one of the attribute field names for the photo filenames. E.g. UNITID_0001_photo1UNITID_0001_photo2UNITID_0002_photo1UNITID_0003_photo1

Hi. I'm trying to get a single output from these two sources:County Assessor Parcel BoundariesSurveyed Parcel Boundaries The goal is that, if the parcel is in the Surveyed Parcel Boundaries layer, we use its shape. If not, we keep the County Assessor layer shape. Only some of our records are in both sources. Some are in one and not the other. Which transformer would be best for this scenario, and how would I go about setting it up? Thanks!

Hi,Is it possible to have FME modify the schema of an existing table? Say I have a table with name mytable and attributes attr1, attr2 and attr3, coming from the import of an external dataset. A new version of the dataset contains a new attribute, or the data type of an attribute changes from char to int or so. We do not want to drop and recreate the table, since quite a load of triggers, user rights and stuff is dependent on the table. Basically we want to truncate the table to the new schema. Is that doable in FME, has anyone experimented with that?  I guess I could use something like SELECT   *FROM   information_schema.columnsWHERE   table_name = 'mytable' (we use Postgis), check the results and compare them to the new version of the dataset, and if differences, generate and execute the necessairy ddl statements by FME, but I'm not sure if we should go that way.

Hello, I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database. https://ometv.onl https://chatroulette.top https://omegle.wtf https://bazoocam.cam I have tried to find an example online doing something similar but I had no luck. I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it. thanksalexsunny

Hi everyone, I have set up a simple dynamic workspace that reads a shapefile, reproject coordinates and write a shapefile. This should be a general porpouse workspace indipendent of the source schema dataset, but the output dataset contains all the attributes of the input dataset plus the attributes of the dataset I used to develop the workspace (and I don't want them). Could it be a bug of the shapefile writer? If I use a geopackage writer, instead, everything works fine. Thanks.

I am trying to upload output geotiff files to a folder on a remote site via SFTP from a FME Desktop workspace. The FTPCaller transformer supports the SFTP protocol and I make the assumption that uploading files to an empty folder should work. My GeoTiff files are first written using a FeatureWriter. The FTPCaller comes next and fetches the GeoTiff file with the "Upload from a File" transfer type. The translation fails with "Login denied" probably because there is a missing piece of info.Actually the process works fine on the same machine using Filezilla. I just needed to provide the RSA key to Filezilla in a PEM file and the connection + file transfer work like a charm.Of course I would like to allow FME to take care of this upload step without depending on Filezilla.How should I set up the authentication parameter in order to make this possible?The info that I provided to Filezilla to make the connection work is the following:hostusernameportpem file containing RSA

For some reason, I can't read in a date such as 02-JUL-08using %d-%b-%yIt says that %y is output only.Surely there must be a way to read two digit years.

can anyone suggest me, how to recognise road edge using FME Transormers

I have created an FME workspace that return some validation messages in JSON. The output looks something like this:{  "Response" : {   "transaction" : {     "id" : "78234626376472399",     "transactionDetail" : {      "validationResult" : [        {         "testCode" : "1001",         "testResult" : "PASSED",        },        {         "testCode" : "1002",         "testResult" : "FAILED",  "failMessage" : "fail Message 1"        },        {         "testCode" : "1003",         "testResult" : "PASSED",        },        {         "testCode" : "1004",         "testResult" : "FAILED",  "failMessage" : "fail Message 2"        },   {         "testCode" : "1005",         "testResult" : "PASSED&

Hi Guys,I'm wondering how to set up a short list of coordinate systems by the new Manage attribute window. In fact I'm missing the Import-Button that has been there until FME 2020, when creating a Choice with Alias User Parameter. The Import-button now automatically opens up a reader defintion.  When I use the Coordinate Systems User Parameter type, no choice-list can be created.  Is it really impossible to complete this task or am I missing something obvious? (Hopefully the latter :-) ) Any hints are welcome! Thanks in advance

hello there w want to extract some features from the dataset randomlyex: we have 300 features coming in we want to get only 160 from them randomly we trayed to use the sample, but it did work since its working base on the N rate Any suggestion Thanks