Transformers

Hi there, so I have two column of data.​The column "Test_FloorNumber_Begin0" should have sequence of 0000, 0001, 0002, 0003 - the largest number of the input, or 0999. ​The second column "Test_FloorNumber_Begin1" should have sequence of 1000, 1001 - the largest number of the input, or 1999.​The sequence should start from 0000/1000 to the largest number from the input data. So I want to use FME to find out the missing number and output it. In this case 0000 to 0003 and 1002-1003 are missing.​Please help me as I want clueless on how to work this out.​Thank you very much.

I have two FeatureMerger transformers fed by a single AttributeManager that outputs two string Attributes - one containing a GUID and the other a mixed-case name. The two FeatureMergers are identical, matching the GUID so that the corresponding name gets inserted into their respective Features. Oddly, one FeatureMerger converts the names to uppercase. So I did the obvious thing: blew it away and copied the properly-working FeatureMerger - only to see the copy convert to uppercase as well. The names enter (the Supplier port) in mixed-case and come out (the Merged port) as uppercase. The Requestor ports of both FeatureMergers are connected to the Merged ports of previous FeatureMergers, which themselves successfully merged two mixed-case Attributes into Features with (only) uppercase Attributes. So what is making FeatureMerger convert to uppercase? Edit: Replacing the "uppercase" FeatureMerger with a FeatureJoiner makes no difference. Nor does removing the AttributeManger's

Hi, does anyone know how to write input data to one "block?" I have input data - 8 frequency values (pic1), which are written to the dataset as individual "blocks" (pic2), but I need to write frequencies to one "block" ( pic3 ) Thanks a lot

I dynamically write tables (Soruce: PostGIS) with, as well as without geometry attributes into ESRI Shapes . The Writer for Esri Shapefile format generates entire shapefiles (shp, shx, prj, cpg, and dbf) even for tables without geometry attributes. However, these may not be  read correctly by ArcCatalog. For geometry-less tables, it would be better to have a dbf-file only! Is there any option for the Writer to avoid writing such entire shapefiles for geometry-less tables?

I have some polygons as streets (streetname) and many pipes which lay mostly inside the street polygons. Using the line on area overlayer I can get pipe attributes on the street polygons. But I would like to cut the polygons where one pipe ends and the next one starts.Another approach would be to cut polygons where pipe attributes change...is it possible?

Hello,is it possible to run from fme system call (or python caller) and don't wait for the result?

Hello,I am trying to populate a value into "_overlaps" using the PointOnAreaOverlayer Transformer but all the data keeps being Rejected.This works fine when both Readers are consuming Oracle Spatial but I think the issue may be because my Point data is non-spatial?Tried the 'Reprojector' Transformer but had no effect. The View with the Point data contains a SHAPE field therefore should contain geometry but the FME non-spatial reader does not contain the field and I cannot pick up the data using a spatial reader.I may be pursuing the wrong process here?!Thanks in advance. 

I am encountering an error where my clipped raster data is not being written to the designated output folder . I am using FME Workbench 2021.1. I was following the Raster Clipping workflow here. However, I must be making a mistake when adding the writer and working with the settings. Perhaps I was a bit confused as to how to set the writer and parameters. There error I received was something like FME file not accessible. Unfortunately, my FME crashed and closed before I could copy the error I received. I'm hoping someone can guide me through adding a writer. I am trying to clip ~3000 geotifs to a shapefile file of Ottawa, On. and fan out by Ward name. Thank you   

Hello All,I have an AutoCAD drawing that has small circles (polygons) sitting over the intersection of two or more lines. The lines finish at the edge of the circle but I need to extend each of the lines to the centre of the circle so I can then create polygon features from the lines. The resulting line from circle edge to centre needs to be merged with the original line i.e. not just create a new line segment.Any ideas would be very much appreciated.   

The thing I want to do is for example to when AGOSLAG(pic 1) = Kodvarde update AGOSLAG to the text Kodlang(pic 2). Then I want to do the same thing for MALKLASS, HKL. I have serveral tables in excel and they all start with the number 1.  I've tried with databasejoiner but could only update 1 attribute at the time there. I have about 20-30 attributes that need to be updated.  What is the best way to solve this problem?  best regardsJesper

Hi, I have two polygon layers (Layer 1 and Layer 2). Layer 2 contains a subset of Layer 1 polygons i.e. one polygon of Layer 1 can contain 1 to n polygons of Layer 2 (Image). Each polygon in Layer 2 needs to be uniquely identified by using two attributes: ID of Layer 1 and pol which represents the number of Layer 2 polygons within one Layer 1 polygon (image). How to create a pol attribute?

I'm very new to FME and sorry if my question is stupid.There are some JSON data containing objects with multipolygon geometry on a single spline 256x256 with integer values of (x, y) as you can see in following example (just part of whole file of course) {"HotspotMetaData":{"id":162011,"RenderedGeometry":{"type":"MultiPolygon","coordinates":[[[[0,231],[-3,228],[-9,233],[-6,236],[0,231]]],[[[1,227],[-1,225],[-6,231],[-3,234],[1,227]]],[[[3,224],[0,222],[-3,228],[0,230],[3,224]]],[[[8,229],[9,225],[0,222],[-1,226],[8,229]]]]}},"hintContent":"40 km/h","unit":"kilometers per hour","description":40}See on JsonEditorOnlineAs I can see it is very similary to GeoJSON except that "Rendered ...", but! First of all FME say me "There is no geometry". Ok, I can live without it. But I see no way how to access that multi-array of coordinates. I got all of that &qu

So I just got my toes wet with customer transformers and loops. Fascinating. For the first time the worlds of programming and FME seem to really come together here in my mind. Limitless potential.I put together a custom transformers that takes a bunch of point features, then identifies a certain point, pops it out into feature holder and feeds the rest of the points back to the start of the loop. Essentially, this allows me to put these points in any order I would like for further processing, using my own business logic.Now, this works great for one set of points. What if I have 10K points and would like to use my custom transformers on batches of these. I can split them out in to groups/stream using an AttributeFilter but how do I connect that to the custom transformer? I could certainly connect each stream to a copy of the transformer but that would be crude and crazy clutter. Is there something like a FeatureHolder or some other trick - some form of GroupBy - before we get to the cu

I am trying to convert a CAD text dataset to Esri geodatabase annotation keeping font size and font type. Everything is ok except that the final result is shifted upper left. How can i keep the original text position?

It seems that the writer wrongly rounds the values ​​of seconds greater than 59. Using DB Browser to query the result:  Could it be a bug? 

I attended last week's webinar on metadata and was happy to hear of the xsd-drive XML reader and writter. I've been attempting to modify the cap:alert demo to write a flavor of ISO19115.     XML Validation: Starting schema validation for 'c:\...\output\tmp.xml'The uri-map document 'C:\Program Files\FME\xml\urimap\gml_aixm.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_citygml.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_inspire.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_sosi.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_urimap.xml' is being used to map from URI to URIXML Validation: Fatal Error in 'c:\...\output\tmp.xml' on line 1, column 39: 'invalid document structure'XML Validation: '0' warning(s) found.XML Validation: '1' fatal error(s) and '0' error(s) in 'c:\...\output

I have a raster in coordinate system EPSG:25833 (ETRS89.UTM-33N). The coordinate system is saved with name ETRS_1989_UTM_Zone_33N in GeoTIFF and Esri Shapefile, but in ECW with name NUTM33. The coordinate systems are the same, only with different name.I have viewed the properties with Esri ArcGIS. The different coordinate system names are in ArcGIS no porblem, but in the software GeODin Maps.How to do it to write coordinate system name ETRS_1989_UTM_Zone_33N into the ECW file?

I am using a dgn file and printing it to pdf. Bentley's textNodes don't work correctly in my conversion and I would like to convert all textNodes to texts before writing to pdf. How can this be done in FME?

Bye! How can I color lines that cross 3D objects? I would like to color each line green before it crosses the 3D object, and the piece of line that is beyond the 3D object red. Thanks

I have a lot of files with different coordinate systems. However, coordinate extractor only works to get a coordinate system of a file. Is there a way to get a list of coordinate system names of multiple files in different formats (shp, tab, kmz..)

As a note, we can do this in QGIS using the Topological colouring.

I have to POST JSON bodies to web api, but first I have to compress json by gzip compression. How could I do that?

Dear FME community,I have a question concerning the creation of a web feature service. On the following web-page (https://community.safe.com/s/article/how-to-create-a-wfs-service-using-fme-server) I have seen a tutorial on how to create a web feature service. Here a SpatiaLite-file is loaded into the workspace to create the web feature service. I have a geojson-file with some 2D geometry in it. It contains a tile-grid made out of polygons. Is it possible to either convert this geojson into a web feature service or create a new tile grid with labeled tiles? It would also be nice if one could hover over the tiles to highlight them in a different color. The whole web feature service should have a very small file-size so that the web-map does not take very long to load.  Thank you so much in advance for your help! With kind regardsChristian

I tried to use TwilioSMSSender to send a web link text message to my mobile. The text message was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0&find=260819MKY1 . However, the text message was always cut off by the ampersand “&”, which means my text message received was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0 .Any suggestions will be appreciated. Thank you.

Hi experts,I want to read the TAB file but with WHERE statement to filter the number of records that I want. It could not perform and run into errors like below. Could you help to indicate where I did wrong. THanks. I had tried without "" for the fields name, treating the values like string and not string.Performing query against MAPINFO_EXTENDED dataset `C:\\QV\\MapData\\PARCEL.tab'UniversalReader: Unable to emulate search type 'fme_all_features' because fme_where is requestedFeatureReader_2 (QueryFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details