Transformers

I have a dwg circa 1998 that contains among other things contours and spot elevations. All of these features exis in 3d within the dwg I have confirmed this using AutoCAD viewer as well as the FME inspector. The only place I see the elevation value is in the coordinates section in FME Inspector. I would like to covert these features to a shapefile and capture the elevation as an attribute but don't know how to expose this elevation value. 

Hello everyone, I have a street centerline dataset and I would like to identifying where there are T intersection (3 centerlines intersect at same point). Here is the image and I would like to find the highlighted lines. Thanks in advance. Best,

please see below the json response from a httpcaller transformer.  I want to extract the items (only id and type attributes are interested) and format them to new fme features with 2 separate fields id and type. I have tried JSONFragmenter (setting like below). However the output gives me a flat table with 704 records (352*2) like below. How to output a table of 352 records with two fields id and type?{"total": 352,"start": 1,"num": 352,"nextStart": -1,"items": [{"id": "5c6729ea37f84ffbb9ece1f428d83bf4","owner": "Admin","created": 1425413285228,"modified": 1547658596161,"guid": null,"name": null,"title": "World Population Density","type": "Map Service","typeKeywords": [6 items],"description": "","tags": [5 items],"snippet": "World Population Density data service provided by ESRI","thumbnail": "thumbnail/World_Populations.PNG","documentation": null,"extent": [2 items], 

I'm new to FME. Just upgraded to FME2019 and since then seems that stability issues have multiplied. Workbenches that worked fine, not crash in the middle of the process. Most of the issues seem to be related with temp files. Provably FME is trying to go through temp files stored in the previous version? Are there any recommendations you would make in order to prevent these errors from happening? Maybe making a clean-up of FME temp files?

Hello,I have an external code in PythonCaller that generates a segment_id for each feature. and I would like to understand what it is doing exactly and what does the  if (feat_i*self.sampinv) % self.count==0.0 expression mean. It looks likedef close(self):             group=0        for feat_i in range(len(self.feat_list)):            if (feat_i*self.sampinv) % self.count==0.0:                group+=1            self.feat_list[feat_i].setAttribute('segment_id',group)            self.pyoutput(self.feat_list[feat_i])

Hi all,I'm quite new with FME, so I hope you can help me. I would like to change the value of multiple rasters. I know you can do that for one raster, but I have a lot of rasters (>200). Is there a way to this?I'm using FME desktop 2018.1.Many thanks in advance.Kees

Hello, I'm using sampler to reduce the output. If some parameters are set then I want to only read n rows and then move on with processing without reading all the rest. I know that in feature reader there is option to set: max features to read but then I perorm some polygon filtering so there is a chance that if i set it to 1000 then 0 features will be stored because none is inside filter polygon. Sampler works great but problem with it is that after sampling first n records it still keeps on reading new features but it forwards it to notSampled port.  So is there any option that would stop reading more features after reaching given number?

Hi, I'm trying to expose attributes from a JSON file using JSONFragmenter and it's working perfectly fine for all attributes except one which is stored in [] brackets. This is an example of how the JSON is structured:  [{"id":"5cad42","nummer:"697582","name":"place name","position":[51.51146259999999,11.5696619],"status":false}]  And once I have exposed the attributes I see all values except "position" value is missing, so I assume it has something to do with the [] brackets.  These are the JSONFragmenter Parameters:  Should something be changed here? I know it must be easy :) Thank you! Cheers,Linda

FME Server 2018, running distributed engines, mix of 32 bit and 64 bit. What I am seeing is that the some features when reprojected (using ESRI Reprojector NAD83 to North_America_Albers_Equal_Area_Conic or using the FME Reprojector Read from feature (ll-83) to say UT83-N for example, a few of the resulting coordinates are different about the 9th decimal place (from what i have seen only the Y coord gets tweaked) . Not enough to really mean anything, but enough to cause a different CRC value or for the ChangeDetector to see them as different. Any thoughts on why 64 bit Engine might result in very slightly different coordinate values ?

 HI there. I'm fairly new to FME and very new to the 2019 version. I know that ChangeDetector has undergone a revamp and so I have replaced my updateDetector transformer with it. I have read that you can use an optional feature in the Parameters box which will generate a list of the changes that have been detected between datasets. I've added a List Name but i'm unsure where to view this list? Does anyone have any ideas? I've checked in the attribute table for the Updated output layer but there is nothing in there. Thanks for your help!

Hello, is there a way to finish job under given condition before processing all features? I know that there is terminator but when job is started from job submitter then probably result will be on failed port while it is a completely valid situation. Thanks for help :)

Hi there,I'm trying to convert a set of shapefiles to DGN (microstationV8) format. I do have a Seed file which I can specify in the writers. However, I'm not sure how to actually read the seed.Truth is, I don't quite understand what attribute relates the source data to an entry in the seed file. My mind says that if the seed has an entry for a blue line classified as "motorway", I still need to specify what in my shapefiles qualify as "motorways".Is it perhaps based on the name of each writer? Or am I misunderstanding these DGN seed files completely?What I do understand is the the Seed functions as a template. Still, as with any template, there must be some kind of attribute that dies the seed to the designated feature.Any help on the topic will be greatly appreciated.

I need to create a heat map that splits up square polygons into all of their overlapping portions and attributes each with a count of how many overlaps there are.First I ran a dissolver and assigned IDs to each region:And then I ran an AreaOnAreaOverlayer with a Group By assigned to the IDs for each region. This meant that the polygons were only compared against other polygons that they might actually intersect rather than everything in the whole world. From this I got a count per box which I can use to create a heat map:The problem is that in the Middle East region of the map, there are so many polygons (~14,000) that the AreaOnAreaOverlayer is failing long before it has managed to process all of the polygons in that area. This means that this is the only area for which I cannot create a heat map. Going forward, it might be that there are far more polygons than that that all overlap so potentially this problem is going to get even worse.Does anyone have any tips on how I can create a

Does any know of a method of finding all 'kickbacks' within a polyline or polygon dataset, and then repairing/removing these?A kickback is defined as:The internal and external angles between two segments are less than the set parameter in degrees e.g. 45 degreesThe distance between the external spike and the external polygon boundary and the internal spike and the internal polygon boundary is less than the set parameter in metres e.g. 10mFME has a transformer that deals with Spikes, but I cannot see an equivalent for kickbacks.Thanks in advance

Some of my team attended the World Tour in Austin yesterday, and we wanted to share some of the AR presentations with our directors. Are these available anywhere? The AR leveraging the indoors mapping for intraoffice route finding was especially interesting.

Hi all, I have a JSON file. Each object in the file has the coordinate of the start and end point of a line. I would like to transform it to geojson file with linestring. Any ideas how can i do this? Example:{        "cityName" : "Brussel",        "endPoint.x" : "4.31888222694397",        "endPoint.y" : 50.79171001911163,        "startPoint.x" : "4.3186622858047485",        "startPoint.y" : 50.79149007797241 }Best

Hi! I'm new to work with Autocad and SVG-files in FME. I'm trying to convert 500+ Autocad-files to SVG-files and most of the SVG files get correct. Attached is a workspace with an Autocad-file that doesn't get correct. Open the Autocad file in Autocad to see how it should look like. Why does the SVG get incorrect, and is there anything I can do to get it correct?  Best regards, Ken Karlsson

Is it possible to keep the order of the query fields when you get the attributes using 'Populate from SQL Query...'? I use it very often and the attributes are ordered alphabetically instead of the order in the query.Thank you

I am trying to use the 2DEllipseReplacer, with the same minor and major axis properties but different rotation angles(30 vs 60). The output received doesn't look right. Please see attachments for more details on parameters being used and result received. Thanks in advance for inputs and suggestions to fix this issue

Hello All, I am using API for retrieving data, post call need be formatted to specific format I have used template to create and upload by post call in HTTPCaller. Template created from ESRI Shapefile it is working fine. The problem that everything is being loaded into the JSON upload body. But i would like it to be split by e features before it hits the HTTPCaller. If the count is limited it is working but with heavy data API get overloaded so I would like to hit one by one does any one have solution how could I can be done please find attached FME Workbench for reference.  

Hi,I have a big workspace that can potentially stop at different steps because the workspace is going through multiple readers and some of them can have no features.Is there a way to execute a SQL script whenever the workspace is stopping ?The goal of this script is to check some integrity rules in the database (Postgres).Maybe the python shutdown script could do that but maybe there is a simpler way.Thank you for any help.

I'm trying to create a word doc report containing photos and tables for each feature in a points shape file. I've managed to get 1 photo and relevant table per feature using MSWordStyler transformers and grouping/sort to pass in order. But some features have 2 photos which I'd like to display side by side (above the table). Can anyone advise? Thanks Chris

I have an existing FME 2015 workspace that writes records to a PostgreSQL database.With FME 2015, it writes 2626 records to the database.With a FME 2018 workspace i count with SQLcreator the number of records in the PostgreSQL database using the next SQL statement. Select Nspname AS SchemaName, Relname, ReltuplesWHERE Nspname NOT IN (' Pg_catalog ', ' information_schema ') AND Relkind = ' R 'ORDER BY reltuples DESC; It returns as result 2626 records Now I open that same FME2015 workspace and save it as FME2018, I run that workspace again and it writes again 2626 Records.Only, when I run workspace with the SQLcreator again, it returns as result only 1000 records. In both cases, the PostgreSQL database has the correct number of records, only if they are written with 2015 The SQL statement gives the correct number of records and if they are written with 2018 then the SQLstatement gives a wrong number of records. Does someone know what i do wrong?

@steveatsafeGood morning,I am having issues with writing to our Azure Database. We have a bunch of features that have correlating Ids. The objective is to find the latest and greatest feature(s) based on a uuid that is assigned to each feature and the features that relate to it. The SQL query I wrote before worked up until now. Now I receive this error message "com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting from a character string to uniqueidentifier." Unsure why all of sudden this is happening.  DECLARE @aprt_id INT = $(Arpt_ID), @address_id UNIQUEIDENTIFIER; ;WITH idetails AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY venue_id ORDER BY record_id DESC) AS recency FROM airport WHERE ARPT_ID = @arpt_id ) SELECT @address_id = address_id FROM idetails WHERE recency = 1; SELECT * FROM airport, dbo.[building] as building, dbo.[utility_pipe] as utility_pipe WH

I am trying to add a custom transformation from Romanian national projection to WGS84.I have added the .gsb file and the XFORM_DEF to MyCoordSysDefs.fme and the horizontal transformation works with CSMapReprojector.I tried adding a Vertical transformation but I keep getting the error:Couldn't open file named C:\\Program Files\\FME\\Reproject\\GeoidHeightGrids\\World\\..\\..\\GridData\\WW15MGH.GRD.CS-MAP Reprojector: Unable to load geoid height grid 'C:\\Program Files\\FME/Reproject\\GeoidHeightGrids\\World\\Egm96-Wgs84.gdc'Reprojector: Could not create reprojection engineI tried a custom GRD file and that doesn't work either. The same error:Couldn't open file named C:\\Program Files\\FME\\Reproject\\GeoidHeightGrids\\Romania\\..\\..\\GridData\\Romania\\EGG97_QGR.grd.CS-MAP Reprojector: Unable to load geoid height grid 'C:\\Program Files\\FME/Reproject\\GeoidHeightGrids\\Romania\\EGM96_QGR1.gdc'Reprojector: Could not create reprojection engineI tried using th