Transformers

I want to apply color to 3D features via FME attributes.To my disappointment I found that AppearanceSetter does not allow attribute values for color setting. AppearanceStyler does however.Problem now is I have to split my stream of features in order to get one stream with the features, the other stream with the appearances so I can use the AppearanceSetter to finally apply the appearances.Do I need to create unique Ids for each feature in order to get this working properly, or is there an easier way to do this ?Any reason why AppearanceSetter doesn't allow me to do this directly ?Thanks for any hint

I have a pipeline featureclass from SDE that I would like to create points on top at every 100 feet. I've tried Snipper, LineDivider, etc but not getting desired results. Thoughts?Thank you

Hello,I created a workflow that takes several FGDBs into a directory and dynamically exports them as Geojson files with their jsonschema, and it works well. But ...The result for attributes with a type "date" is something like "20180205152004" (which is, I suppose, the string in the FGDBs files)What I want is a rfc3339 format like "2018-02-05T15:20:04".As my files do not have the same structure, I would like to be able to detect any attribute of type "date", to modify it so that it respects the standard rfc3339.Of course, if I could know what are the good attributes I could use the DateTimeConverter!All my efforts remained vain. Does anyone have an idea?

My actual project is to read layers dynamically and set schema before writing it into target database. Just to understand how schema mapper works, I used schema mapper between layer and target database. I passed csv file with source field name and desired destination field name. When I ran the workspace the output has all the fields of the input. Please see the attachements for better understanding.

I am trying to convert an image I have that is in TIF format to a JPG format. I've done it before but just forgot the path. If anyone has any suggestions of tips please let me know thank you!

I am accessing a web service that returns the date/time attribute (OldTime) in the following epoch/timezone format: 1352984400000+1100. The format is Milliseconds+hours. I have successfully created created the following workflow:1) Split the attribute using "+" 2) Expose the _list{0} and _list{1} values3) Create new attribute to hold milliseconds to seconds EpochNoZone: @Evaluate(@Value(_list{0})*0.001)4) Create new attribute to hold time zone hours to seconds called TimeZone: @div(@Value(_list{1})*60*60,100)5) Create new attribute called NewTime which is the sum of EpochNoZone and TimeZone. NewTime now contains the epoch time in seconds.6) Finally, feed the NewTime attribute into the DateTimeConverter using the Input Format: %s$ 7) NewTime will now hold the value 20121116000000 - correct time in %Y%m%d%H%M%SHowever, it would be much simpler if I could feed in the initial OldTime attribute into the DateTimeConverter transformer with the following input format: %s + %HIs it p

i have two sets of data: a lidar point cloud and dgn files with some 3D lines/polylines.How can i check if these lines are close (lets say within 4 m from surface)/under/touches the surface created with pointcloudsurface?

I have dissolved line feature which I have to cut down from the administrative boundary I used line Dissolve areas and a tiler (with fix seed coordinate) are in Clipper port and the administrative boundary areas in the Clippee port, Clipper type (multiple clipper), no group by. Now it running very slow and showing Performing low-level intersection at phase #1... 100% doneFinished clipping group 22 / 4558have anyone any suggestions?

How can I convert a csv file in lat/long data into an Esri Shapefile that is BNG easting/northing?

Hi Community,   I have an issue using RegEx in the TestFilter. This is what I do:    It never returns any result.  However, when I use the StringSearcher to do the same, The RegEx works well:    Any idea what I'm doing wrong in the TestFilter? According to this article: https://knowledge.safe.com/articles/Error_Unexpected_Behavior/Regular-expressions-that-work-in-one-parameter-fail-in-another, the implementation is indeed different. However, the two websites for testing RegEx mentioned in the article resolve the RegEx well.  How should the 'Right Value' be defined in the TestFilter?   best regards,  Jelle

Hello everyone,I have a problem with coordinate transformation with data in citygml format with LoD2 and to write to another citygml file. I use CsmapReprojector, define transformation parameters XFORM_DEF and nothing. My input data is in EPSG:31277 and that is Gauss-Kruger projection and it is deprecated. I want to transform data to EPSG:4326 or 3857 or 32634 on WGS ellipsoid because i want to use 3DcityDB import/export toll. Data in input projection:and after transformation i get this:

Hi everyone,I'm trying to compare 2 PostGIS spatial table (points representing airports) to detect changes. When there's a change in geometry, the change detector works great. But when there's a change only on an attribute in a raw, I can't find it!In fact I can find it if I select the right field name in the parameters (because I know wich field has been changed in my test). But it doesn't work when I select all attributes, which is the real situation. I need to detect changes on tables with unknown atrributes updates. Match geometry is always set to "none" in this case beacuse I want to check changes only on attributes. I've also tried to combine CRCcalculator, feature merger, update detector, tester, etc. but even for a very simple test - only one non-geometric attribute in a raw changed between the 2 tables - I can't find a way to make this change appear in a transformer output...Any help would be very appreciatedThanks!

I am running FME 2017.1 build 17725 on macOS High Sierra 10.13.3.I cannot add "DateTimeConverter" transformer to a workspace -> the application bails out.Tried multiple things: I re-installed FME (the latest build), etc - the issue still exists. I was wondering if anyone observed similar behavior. Kind regards,Alexander

Hello FME-Community,I am working with FME desktop 2017 and LiDAR point clouds. I have selected a certain number of LiDAR points that intersect with a polygon (shape). All these points belong to class 5 (tall vegetation), but I would like to reclassify them as class 6 (buildings).   I have not been able to find any tool that makes this reclassification. Could you help me or give me an idea?Thank you very much. 

I have been trying to label contour lines as a learning exercise into FME. I am starting to get my workspace more or less dialled, and am now trying to straighten out the last quirks. Have a look at the "600", "200" and "500" in the middle of the image. The Labeller has placed them at unfortunate spots, and they are rotated away from the general direction of their contour lines. It would look much neater if they where placed along a straighter stretch of their respective lines. How could I achieve this? I imagine that this would be quite resource intensive for a larger area? So method efficiency should probably be a consideration?

I have written an FME workbench hosted on FME Server that will be called by the Informatica application.The Informatica team want a logging mechanism via an Oracle non spatial table. The columns in the table areworkbench_id (published parameter filled by Informatica job call)workbench_name (fixed value - e.g Clipper_Perf_POC)run status (1 = run started, 2 = run success, 3 = run failed) They want to insert a log message at the start and a second log message at the end of a workbench..  What is the most elegant way to do this - start up and shutdown scripts, fmeserverjobsubmitter (aka workspace runner)? Is it worth adding the fme server job id to the table...the workbench_id parameter filled by Informatica is not very informative for further investigation within FME Server.Any tips would be appreciated.  

We are rebuilding our entire GIS analysis platform and are trying to map our exisiting processes to something better.We receive ArcGIS model builder scripts from our Asset team that have no FME experience. Currently they are scheduled using Windows Task Scheduler. One suggestion in the team was to load these model builders as ArcGIS Server geoprocessing services and then use FME Server to call/schedule the geoprocessing service.Can FME Server start an ArcGIS Server geoprocessing service? Would it be better to export the model builder scripts to python and use the PythonCaller transformer within FME itself?Is anyone using either of these methods?

Hello FME-Community,I am working with FME desktop 2017 and with a raster layer of altitudes. I would like to obtain a new raster layer from the previous one, which shows a range of altitudes between 100 and 200 meters. I am new working with FME and I still have not been able to find a tool to perform this operation. Could you help me or give me an idea?Thank you very much. 

Hi there,I'm using the Coordinate Extractor tool to extract the elevation values at the beginning and end of a line so that I can calculate the slope of the line. To identify the starting coordinate of the line, I'm using coordinate index == 0 and to find the ending coordinate on the line, coordinate index == -1. However, I'm confused as to whether the first coordinate on the line refers to the left- or right-most coordinate on the line.   Since I'm looking at the slope of lines, it's important to know whether the elevation associated with the first coordinate references the right or left hand vertex of the line because it would indicate the direction of the slope; for example, if the first coordinate is defined as the left-most vertex of a line and is higher than the right-most vertex of the line, I would be able to say that the slope of the line moves downward left to right.For context, I'm creating a map where I'm trying to identify the slope along vario

Dear experts, I have a dwg-file wich is told to be in RT90 5 gon W. I have not been able to position it right though, but now I think I have localized the issue. It seems like the two first digits of all the coordinates are missing. Therefore, I would like to add 6200000 and 1400000 to the coordinates. How is this done? I have tried to set up a new coordinate system with the right parameters but I just cant get it to show up in the coordinate system gallery? Is there maybe a better way?Thanks.

Please look at the image for better understanding and help me to solve this problem. Thanks in advance.

Hi,I am doing an update task where I need to update dataset A with the new lines from dataset B. Dataset B includes all of the lines that are already in dataset A plus a number of new lines. I am using a spatial filter to filter out just those lines in dataset B that are not in dataset A. In the spatial filter I am using "Filter Equals Candidate" as the test. My expected result is that the new lines would fail that test and appear at the Failed port, however all lines fail.When I do a select by location in ArcGIS with the selection method set to "identical to the source layer feature" and reverse the selection I get the correct new lines.I can get the spatial filter to output the data in the correct way (based on my test in ArcMap) but only if I add a coordinate rounder to both input features with the precisions set to 3. This however changes the output data making it inaccurate.Is there anyway I can achieve what I need to do using the spatial filter without introdu

I have trail data from two different sources and am trying to figure out where they overlap, and where they don't. There is any combination of A, B or A+B. Where the trails do overlap they misalign ever so slightly. I have tried two different methods but have not yet got satisfactory results out of any of them. Most promising so far seems to be Buffer plus the LineOnAreaOverlayer. My gripe here is that it creates small gaps, see arrows, where a small piece of a segment that does not actually overlap gets registered as an offender. The red is the outline of my buffer, the greens are coupled lines and the blues are singles.  How can I keep the blue segments intact? All incoming segments have ID's, so maybe there is a way to rebuild them from that? It does feel like a slightly cluttered method that would also problems elsewhere. Some places the trail goes from A to B to A+B and back to B - and so on. Any ideas on how I could get this to work?Just as a side note: I began with a Anc

Applies to FME Workbench 2017.1If you apply a select statement on a DataReader (in this example MS SQL Non Spatial), it misreads the SQL if there are embedded comments, treating everything after the first comment as a comment, hence producing wrong result.My Sample WorkspaceHere is my workspace (a simplified version to illustrate the problem). I used a DataReader and a SQLExecutor to show the inconsistency in number of records read, resulting from incorrect parsing of SQL statement on the DataReader. Both the DataReader and SQLExecutor have the exact same select SQL. The correct number of records should be 98,792.DataReader select statement configuration:After I press OK and go back into it, looks like this:And now the SQLExecutor configuration:The SQLExecutor has the same SQL as above, yet produces the correct result. The Editor dialog automatically detects that it is SQL and gives the appropriate syntax highlighting (whereas the DataReader dialog doesn't).Conclusions:The Data