Transformers

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

Hey FME'ites,I'm having issues trying to bring over a georeferenced JPG to an esri raster GDB. The long story short is I have a folder filled with different images that had been georeferenced in ArcMap. I wanted to migrate all of it to a raster GDB. I'm attempting this on just one JPG to start; a simple JPG reader and Raster GDB writer. I do not set a CRS on the reader or writer because the supplemental georeference file should take care of that. The workbench outputs successfully and the image has the correct coordinate system, but the image is nowhere near its correct destination and it is at a tiny scale. Does the JPG reader not correctly read the supplemental .jgwx georeference data file? Thanks for your time.

Hi,I'm making to convert .TAB file to .mbtiles, but I got errors :MBTILES writer: Failed to obtain raster from feature. Only features with raster geometry are expectedA fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details Could you please tell me why? Thank you

actually what I am trying to do is reading two GDBs one with updated values and one having old entries. Suppose in GDB 1 there are entries like 1,2,3,4and 5 and in updated GDB2 the entries are like 1,2,4,& 6. So I don't want to create new GDB I just want to add entry 6 in GDB1 and remove entry 3 & 5 from GDB1. For finding out the change I have made use of Change detector but after that when I am trying to insert it in the GDB I am able to update just one feature type at once but not all feature types

Hallo everybody, Thanks to fme user @erik_jan i made my first FME model converter for rd coordinates.I use AttributeReprojector too do the job but i dont know what coordinate system i have too use.my source coordinate system is Netherland-RDOld- 2008. that seems right because it gave me the same x,y (111114, 566230) coordinate as the original file. I want too convert it too 53.08111, 4.73228 coordinates but i dont know what destination coordinate systeem i have too use. I try different things but didnt get the desire result. My attempts to google it, search on this forum was without results. So i hope i can put the question here so somebody can help me with it.Greetings,Charaf  

Hi All,  I am currently trying to load in some raster tiles that I have downloaded from the European Space Agency in FME. I have already successfully displayed them in ArcMap and are in a D_WGS_1984 projection. FME does not seem to recognize the spatial reference as it cannot display them in the visualizer and when any transformers are used, they seem to turn them upside down and out them at the origin of any projection that they are set to.  Has anyone else found this problem before who could maybe help out or is this just a problem that is unique to the dataset I am using?  Many Thanks

Hi,  I have a set of vector grids in FGD, I want to overlay these on some rasters. I have managed to achieve this but I want to make the grid slightly transparent, I have tried adding 0.4 after the third colour value but that doesn't seem to hold when I run it through VectorOnRasterOverlayer. Has anyone got any other ideas on how to achieve this?I have attached my workbench so far.  ThanksBGrid_ADD.fmw

The expansion of FME into the local government space has grown beyond spatial solutions, leading FME to become the enterprise solution of choice. We are excited to announce that pricing for population-based pricing as a subscription model is now available on our website. Please note that this is an additional offer and we are not removing the FME purchase option. If you have any questions, please reach out to your Channel Account Manager, or find more details on our blog post.

Hey good people of FME and beyond,I have hundreds of MapInfo workspaces that need their Coordinate System converted from Irish Grid to ITM. All associated tables which make up each workspace have to be updated also. Is there any way to read in a MapInfo workspace to FME and update?At present the only way to do it is batch convert the tables and then rebuild the workspaces individually.Would value any ideas?Thanks all,Irene