Transformers

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  

I have have been through my whole dataset and manually closed the lines in the hope that I could do a simple AreaBuilder but some areas are not being created. The yellow areas are the 'area' output port and the blue lines are the 'incomplete'. I want an area created for the section from the blue line to the edge of the yellow area. My workbench is shown below. The snapper has a distance of 1. TIA

am using Arcgis Pro and i have few feature classes with different symbologies for them. i want to see those data in cad with same symbologies.i saved the feature class to layer file and added in to fme . when i am writing it in to dwg i am not getting any symbology.Can any one help on this

Hi.I'm working on a project where I need to find points within a distance of each other and assign a value to each neighbor. I'm using a neighborfinder with "candidates only", blank number of neighbors to find, given max distance and the ID of each point is added to a list. The points are close together, so the same points will be found for each candidate.  What I'd like is to add a value to each of the closest candidates based on a attribute value on the feature. Do you have any a ideas on how to solve this? Torbjørn 

We have the following stack:FME reads XML, inserts in and deletes from SDE.Data in non versioned SDE on Azure SQL Server.ArcGIS Enterprise serving MapService based on SDE.Interal WebGIS using MapService.Most of this works fine but when we clean up large datasets it takes a long time to complete. What I know is mostly self-taught so I wonder if I missed something vital. The task is to delete records from 20ish quite big featureclasses where projectname = 'projectname'.What I do now:Using a FeatureReader, I read from all featureclasses using a where statement, reading only one feature.Now I know which featureclasses contain data from this specific project. Next I can use these features in a FeatureWriter, where I Row Selection = Columns ProjectName.I think this is the right thing to do, let the database do the work. I expect it does delete from featureclass where projectname = 'projectname'.  The thing is, the column 'projectname' has an attributeindex to acceler

I'm using the excelstyler writing to excel feature writer. Its applying the formatting (highlight full row) except to some date cells it only applies it to those cells in first row rather than those in every row that meets the condition.

My situation is this. I have a number of lines in a gdp on top of which I have some points (with a unique id called nodename). I want to rotate these points based on the angle of the lines. What I have done so far to achieve this is to make a buffer around the points, clip the lines using the buffer. Use the horizontalanglecalculator to calculate the azimuth of the lines. However some points have 3 lines coming through them meaning I have 3 angles for 1 point. I need to calculate the average of the x number of angles for each nodename.  Can anyone help me with this? See the picture below.  Regards Rasmus

I have tried to use LineExtender and Snapper but results are not correct, not sure what I am doing wrong. Workspace (FilterGeoJSON) and Geodata (LineArea) are attached.

I have created a User Parameter of type Choice. I am trying to transfer control to a workspace runner based on what is selected. So far, I am having no success. When I run the workspace, the value is showing as 0 instead of my actual choice.

Hi, just learning FME.I would like to know what transformers to use when I need the ff: Identify points that are near each other (points within 30m buffer)Identify the similar attributes of the points within that 30m buffer The goal is to know the potential duplicate points based on XY and other attributes. Thank you!

Sometimes one ends up with tables that contain empty columns. Is there a way to detect if an attribute is not being used, if it is "empty", and then remove it from the table? A automatic table cleaner of sorts. This would make the management of data "creep" a lot easier.

Hi,i want the start and endpoint of a line. So I use a Coordinateextractor and with coordinate index 0 I get the start and with -1 the endpoint. Normally it works fine but I have a line and suddenly the endpoint is somewhere in the line. I found out that the line was aggregated with FME and this somehow mixes the parts and the indexes of the line, so the endpoint is now in the line. In the help of the aggregator is listed: If the order of individual geometry parts within the resulting aggregate is important, you can first route the features through a Sorter. But I don’t have attributes to sort the line.If I use the dissolve function of Arcmap the line is dissolved correctly. So is there a way with FME to get a aggregated line where the coordinate index of start is 0 and coordinate index -1 is the end at the correct position?

Hello, I am passing in a list of values to a user parameter (eg: LGA LGATYPE ABBNAME). The user parameter is assigned to a parameter of ChangeDetector (Selected Attributes).  If I open the FME workbench and run it, the ChangeDetector recognises the parameter value passed as a list of attributes. It then uses those attributes to check for any differences between 2 datasets. That is as expected. However, if I run the tool from the command line and pass in the attribute list as a parameter, (eg: LGA LGATYPE ABBNAME), ChangeDetector does not recognise it as a list and does not find any attribute based changes.  If I reduce the command line parameter down to just one attribute (eg: LGA) then it works. The parameter is a list parameter:  Any thoughts on what might be going wrong?

Hi everyone. I am new to XML and am having some difficulties using the XMLUpdater and XQuery. My issue is around updating 3 attributes within an xml element from 3 attributes in an FME list to create multiple children. When I do this for a record which has say 2 items in the list it’s producing 9 children instead of 2, do I need to group my data somewhere in my XQuery? I’ve attached a sample workbench and data. I am reading an Excel document, then creating a list of all LCS_Codes and their measures per TAC_Code. I then want this list to form the children of a location element within my XML. So I’d hope to go from something like this: Input table:To this output XML text: <tractionCurrentSection id="M58"><location> <part idEl="B077/MSBFA" startPos="0" endPos="149.302"></part> <part idEl="B077/MSBLO" startPos="0" endPos="133.761"></part>

We have certain coordinate system transfomation requirements for LLH to grid coordinate conversions that are difficult to satisfy using the available reprojectors.I would like to understand how to build and provide a custom projector to be used in our FME transformation pipelines.

Hi FME Guys I'm struggling with a data situation that occurs frequently in my daily work. When I have a polygon feature it may occur that this polygon is composed from "thin" and "thick" sections. See below a screenshot of such a situation.I'm now looking for a way toidentify affected polygon featuresidentify "thin" sections from this featureremove the thin sections or at least cut them from the "thick" parts.Each solution should keep existing Z-values as I'm dealing with 3D data. Any ideas how to achieve the desired result?