Transformers

Hi all, I am new to FME and I am trying to solve the following problem: I have a set of 24 .shp. Each shp comes from the buffer line, and each has more than 50,000 characteristics. Each one contains polygons and donuts. When I read it together, I have a lot of polygons and holes overlapped.I have to dissolve the shp set because I need the fused surface of the buffers clearly, without overlays.Although I have tried to dissolve it by different methods such as extracting holes, dissolving and adding holes afterwards, or dividing the data set with a tiler and dissolving it based on groups (row, column), the output is never what you expect, having filled holes or partially undissolved areas. I think the dissolver does not work properly because there are too many overlaps, holes in a single feature and holes between features -from reading the entire set .shp in a single reader- I have attache

Hello folks, I am wondering whether there are any tools that can help me clip one 3D city model with another? This might be unusual thing to do, but its for analysis purposes (thesis). I want to substract one from another and vice versa to see differences between the two. Both files are in Shape format. Any way I can do that in FME?

Hi, I'm trying to use point data from a shapefile to accurately place 3D objects (obj) in their correct geographic location, and then outputting the collection to FBX.I based my approach on the response by @takashi to the following forum question: Adding a 3D model and Geo-referencing it with multiple XY pointsIt seemed to work really well. However, when comparing the final FBX model to other 3D layers the markers seem to be in the wrong location.Input from QGIS matches FME 2D Inspector output pictured below.FBX Output in Unity (visualised below against other map layers exported from FME as 3D objects).

Hello Team, Present I am working on the following version of FME:-FME(R) 2015.1.1.0 (20150715 - Build 15515 - WIN64). Is there any possibility to do ZIP Archiving with existing version? When i tried Zip Archiving transformer it is asking for upgrade. So which version of FME supports Zip Archiving?Thanks...

Morning All, I have 4 equal polygons next to each other and i need to label them A,B C,B. Im struggling with my lists. They currently have no attributes My approach is to create a center point for all of them, to get the x and y. Then A should be the one with the smallest X and smallest Y, then B should be the Largest X and smallest Y etc etc. i get the inside x,y for all then build a list from them then sort the list by inside x but struggle from here. im unsure how to a list by two values ,ie x and y. i have tried list indexer, list exploder.  Thanks Steve point for each polygon then look for the [polygon with the smallest X and Y, this = A, The smallest X and

Hi, we are trying to use a hullreplacer (FME2017.1) to get a concave hull. When we feed it with polygons, it crashes the engine, even the polygons pass the GeometryValidator. The alpha parameter does not seem to have any effect on this behavior. However, when we chop the polygons into points, it comes with nice polygons. Any similar experiences on this?

hello guys i am finding a solution to join excel files related to stations on highwayseach excel file had the specific data for stations ( 1- shops 2- car services 3- motel,toilets etc) including coordinates for each related service.there is no unique id for station on which i can join them except the coordinates.each station has 3 to 4 points having attributes for services.and the distance between points varies as per accuracy on the device some time it comes within 50 meters and some time more than 100 meters according to the area of stations.i tried the buffer in arcgis but it not covers all and some time if the distance between two stations less joins the two stations as one is there any way i can join points related to each station with out having overlap and not joining stations from one side of road to the other side as some time there is station on both sides of the road infront of each other..also i want

 Hi together The initial situation is as follow: The relation between column TR and column LTG is 1:n. Every value in the column LTG need to get a unique code independent from TR. The CODE also has to be unique per TR.TRLTGCODEA1?A2?B3?B1?C1?C3? I would like to get follow result (the code has to be unique per LTG and order is not importent): TRLTGCODEA12A21B31B12C12C31   

HiI have a workbench (), where I am reprojecting to WGS84, adding grids and text and clipping to a grid index. After the clip I was getting black borders, but I set this data to nodata and this fixed the problem when looking at the rasters in GIS software. However, in windows explorer the black borders can still be seen. I understand this doesn't effect the data, but it doesn't look good when sending the data to others. Is there any way I can remove these black borders in windows explorer. ThanksB

Hi all, I have a road network and I would like to combine them if the road is same, as in the following image . It works perfectly fine with LineCombinerHowever lines like in the images are getting combined but I do not want to combine those as there is an intersection. I can fix it with TopolgyBuilder but I want to keep the corresponding id. So therefore i was wondering if there is a way that LineCombiner does not combines if there is intersection like this?

I've got a few questions around the use of Python within an FME2017+ process and the possible scenarios.There seems to be a few ways in which I might need configure some Python to run in FME and I'm trying to understand all of the options. There are quite a few articles on the Knowledge Center but a few are getting a little long in the tooth now and several seem to suggest that things have changed in recent versions of FME and I think that's because there were some fairly significant underlying changes around 2012 or so.FME installs a build of Python that allows you to run some scripts. It seems to install 2.7 and 3.4 and 3.5 libraries (as per the Help>Options) but I can only find \\fmepython27 and \\fmepython35. Is 3.4 part of 3.5? Presumably if I use the option 'FME Python 2.7' it's using the FME installed Python interpreter?If I wanted to create a Python script that FME and another application like ArcGIS needed to use, presu

Hello there! I have spent, no joke, over 5 entire work days trying to achieve this result, and....... I still haven't. Considering it's not actually a priority in the slightest and that I clearly can't leave well enough alone, I'm finally giving in and joined this community to see if one of y'all can do it for me (in much less time)...I am trying to create... a network of neighboring points. The input is a shapefile of buildings' center points (with a starting point designated via parameter); the desired output is these same points, with an attribute putting them in an order that is essentially:A) Point AB) The nearest point to point AC) The nearest point to point B, excluding AD) The nearest point to point C, excluding A and BE) The nearest point to point D, excluding A, B, and C...and so on. Find the nearest neighbors, with exclusion -- the nearest point that is not already the nearest point to one earlier up

Hello, I have a workspace to export fme configuration from fme 2016. I tried backup but for some reasons it didn't work and that's why I wont to read fme configuration and export it to ffs file just to have a backup. Everything works fine for all feature types except for:   This one is quite big and I get an exception after 10 min of running:  2019-07-15 09:38:03|   2.6|  0.1|ERROR |FME Server Configuration : Unable to connect to FME Server, please verify the provided URL and ensure that the target server and its REST service are running.  The error was `Connection reset'2019-07-15 09:38:03|   2.6|  0.0|FATAL |The below feature caused the translation to be terminated2019-07-15 09:38:03|   2.6|  0.0|INFORM|FME Session Duration: 10 minutes 51.4 seconds. (CPU: 1.2s user

Paid_Services11.xlsx( my problem is i have an excel which is about the survey of stations, in some stations there are 3 restaurents and some had 4 restaurents and some only 1, but in survey form we gave questions for maximum 10 restaurents in mdc giscloud.when we export the data in excel it shows all 10 restaurents fields even if they filled for less . i want to remove the fields with no attributes.. sample file is attached .. thanks

Is there a way to determine the number of pages in a pdf other than reading them all as prf_page_metadata and sampling the last feature? Some of my pdfs are over 5000 pages, and this seems inefficient, especially as this information appears in the Document Properties in Acrobat.  Setting the Parameter Pages to Read to -1 produces an error.

Hello,For a project we are looking into building several workspaces/token-based apps that can be run on FME Server. Due to strict security requirements we have to make sure that either compressed files are rejected or are handled in a safe manner.As I understood FME 2018 and older decompress the zip file first to a temp folder, then using the extracted files to read the data (into ffs), this potentially exposes the file system to malicious files from the zip.Upon being read, the data is extracted and used just as if it were a normal dataset. FME is able to read data stored directly in an archive file, or within sub-folders. archive_files_reading.htmNotable New Features 2019.0Automatic DecompressionRead your compressed data files directly in FME without having to decompress them first. Another barrier has been taken down!FME 2019

I'm using a SpatialRelator with default settings (Generate List = checked, Merge Attributes = un-checked).A polygon class serves as both (Requester and Supplier) to identify polygons containing others within the class. This works perfectly well.The issue is on the attribute level: Each requestor attribute that has a <null> value is filled with a not <null> value from one of the suppliers. All not <null> attributes of the requestor remain unchanged as expected.It seems the SpatialRelator performs an attribute merge even if 'Merge attribute' is unchecked.I tried 'Merge attribute' with conflict resolution 'use requestor' as mitigation. But even then requestor <null> values are filled with non <null> from the supplierIs this a bug or intended? If intended is it documented anywhere? regardsKlaus FME Desktop 2017.1.1 and FME 2018.1.1.1 build 18578 W

I have a dataset, where one of my columns is a 'pack date', unfortunately some of the values within this column are null.I am trying to use Conditional Value within the attribute manager to give a dummy date wherever a null value appears in my table.So far I have:If Pack Date ATTRIBUTE_VALUE_NULL as my test condition.How would I assign an attribute value of, say 01/01/1990? Thanks,Tom 

I am trying to transpose data. I already read some posts about how to transpose a table using FME. But I am not able to get what I want.I have the following table within FME:I want to transpose the data so I get the following format:So I don't need my column names. This is just an indication for myself.Does anybody know which transformer(s) I need to use?

Hello,I have two columns in a Excel sheet "Year" and "Range" with more than 2000 rows. I would like to compare those 2 columns and see if the Year is truly in the Range or not. For example:Year Range 1650 < 1920 1964 1961 - 1970 1970 1961 - 1970 2001 2001 - 2005 1963 1971 - 1980 2015 > 2014 1923 1920 - 1940 1978 1981 - 1990  Thank you in advance for your returnBest Regards

I have a continuous raster with cell values between 0 and 100. I want to reclassify these values to 5 classes:For example everything between 90 and 100 should have the new cell value 1.I do not know how to extract the cell values to make them accessible for the conditional comparison. In the screenshot you can see my current approach. The problem is @CurrentAttribute() which is the wrong choice to extract the cells.What's the correct way to extract the cell value? 

I have FGDB file with 200 attributes. But i want to split the parts and insert them into oracle table.Split 1 : First 70 (1-70)insert into oracle.Split 2: Second 60 (70-130) records insert into oracle.Split 3: remaining all are insert into oracle.Here the oracle tables are different. I need the suitable solution for this.How can i do this by using FME workbench. In real time data there are lacks of records are there we need to insert step by step.

I need to split a regular hexagon into equal parts: 2, 3, 4, 5 or 6. Is there any tool or combination of tools to do this kind of task?

Hi, I have the dgn file.that consists of polygons and text(Like Prj) i want to convert that into .shp format. create the new attribute like name. that name include the shape (polygon also). what transformer used for that. how can i convert that

i have the DGN file. it consists of 85 polygon 85 texts.it was filtered by geometry filter(area,text).the text are assigned to individual polygons. i want to convert it into ESRI shape file. if the attributes have the text string that was matched to polygons. if i click attribute that shows the corresponding polygon. how can i convert? anyone can help?