Transformers

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

Hello FME-rs,I am wondering if it is possible to run FME as in Commandline with the source and destination dataset and other parameters from within GE Smallworld Magik?TxSRG

Hallo everybody, This will be my first model. I have seen the power of FME and i want too learn it.My first problem that i want to solve in FME is;  i have a excel file contains x,y rijksdriehoek coordinates i want to convert it too gps location.Can somebody help me with a model or tell me what handler i can use to get the desire results. The output should be a column with gps coordinates in excel. Thank you for your time and helpGreets,Charaf from the Netherlands

Using a S3Connector on our FME2019 desktop using an authenticated S3 connection I get the following message.I have Cloudberry connected to the S3 bucket on this same machine and it works using the same authentication details.Could it be our authenticated firewall proxy? Or is it something else?

Hello,I am trying to update a square footage attribute on a room within an Enterprise Asset Management (EAM) System using web services. The new square footage is coming from a revised AutoCAD file.Here is my workflow so far. I read in the AutoCAD file and use the room values to construct XML to hit a GET web service for each room. I then extract the FLOORAREA attribute using a XML Fragmenter and compare this FLOORAREA value with the AREA attribute in the AutoCAD records to find the differences. When a difference is found I want to take the AREA record from the AutoCAD file and update the FLOORAREA attribute within the XML responseBody. I have looked at several posts and examples on here but I am a complete beginner at Xquery. I am not sure what I am doing wrong.After the FLOORAREA value is updated, I then have to reformat the XML within the responseBody so I can send it along to the SYNC web service and update EAM.I have attached a FMW with only the relevant portion of my ETL in hopes

hello,   anyone knows if Geostationary satellite view projection or Geographic view is supportedd in FME Desktop (maybe under other name?)

A csv file has 4 fields containing date time data. Those fields starts with Datum in their name.I want to convert the date to another format using the date time converter.With the date time converter you can select muliple fields that you want to convert. That is not working in my workspace. If i select them seperatly (one by one) there's no problem. If i select 4 fields then i have wrong results.Does someone know what's wrong? test_datetimeconverter.fmwCSV.csv  

Hello everyone. I've been challenged with providing an FME Server workspace that parses all or some of the the Summary Stats info from the jobs log file in order to post it in a Slack and email notification.My specific question is how can I ensure that the correct job_id log file is called once the workspace completes on the server? These server workspaces are several that run independent of one another from the same repository to update a PostGIS table with updated records.I currently have a workspace that successfully parses the Features Written and Number Records Added Summaries, but it's being ran against an older log file from the Desktop. I'd like to have Server recognize a new job id log file, call that file into this published workspace, parse the necessary info, write it to a MSWord template or templated email message, and send out as an update notification.*I understand that Python is probably the best practice to perform this workflow, but outside of Python and u

Hello,I have previously used InLIneQuerier to join FileGDB connections without issue, but am having trouble when using with Oracle connections. When running the query within the transformer in order to test i keep getting the 'Database Not Specified' message as per screenshot. In the example below all i have done is attached just one connected Oracle table to the transformer, and then used the Generate button just to test if this can do the most simple of queries and I am still getting this error message.Any thoughts on where I could have gone wrong?Thanks,Robin

Hello Everyone,I have a folder full of georeferenced image files that was done in ArcMap. It includes the image type (png/tiff/jpg) and other files that has the georeference data in it like the .aux.xml and .pgwx. Would it be possible to have FME move all of this data to a GDB? I'm not sure how this works with the multiple files associated with one image.

This has happened to one of our users: crazy transformer labels, reader names and writer names. I never have seen anything like it. I don't think FME 2019 is playing well with the System Registry of something .Anybody else see this or know a remedy for it?

I am having trouble understanding how to create polygon geometries using the JSONTemplater.  I have a JSONTemplater that takes my features and creates a GeoJSON structure that I am using. Below I outline my 2 templates (root and sub ((image 1 & 2))) where I set up the structure. My issue is when it comes to the geometry of the GeoJSON file.Currently, since I could not figure out how the XQuery geometry functions worked, I tried to incorporate a geometryExtractor that feeds the geometry as an attribute. The problem with this method is that it reads that as a string value, and I cannot figure out how to read it as a literal object.  Root templateSub templateouput of geometryExtractorJsonTemplater output

I would like to know if it is possible to convert a plain image (e.g. JPEG, TIFF) with no geo references to a GeoTIFF by using FME Desktop. If yes, how would I do that. I found only the option in inspect resources, but what I want is to add the geo reference to that image.

Hello, I try to clipp a tiff (dtm) with 1 shape with 1 plygon. Why do I get a clipped tiff but uniformly grey ? (I am under FME 2012 SP4 ).I followed the video https://vimeo.com/45706487 which is exactly my case and my version ...Thank you

Hello! I´m new using FME. I have a question about RasterBandSeparator. I have used this transformer in a FME process and it appears the next error:RasterBandSeparator_<Rejected>(TeeFactory): RasterBandSeparator_<Rejected>: Termination Message: 'RasterBandSeparator output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''RasterBandSeparator_<Rejected>: Termination Message: 'RasterBandSeparator output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''A fatal error has occurred. Check the logfile above for details