Transformers

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?

Hi, I am trying to find the nearest river to points and then merge rivers attribute into points attribute. I am using neighbourhood finder, but in my results I see same values for the rivers attributes merged into the points.

How can I count by an attribute?  For example, start with:AttributeAABBBC Want this:AttributeCountA1 A2B1B2B3C1 Thanks for your help!

I am working on exporting our facility GIS floorplan data to IMDF format. I have been following along with all the tutorials, sample data, and workbenches for Victoria (which is all awesome, thanks)! But I can't figure out how to obtain the scale, rotation, and translation parameters for the georeferencing steps (here). Apple had previously helped us convert old CAD data to IMDF and gave us the GeoJSON they created. Our data is shifted from their data by between 1-2 meters across the facility. It doesn't seem to be a translation alone, but more of an affine transform. I am able to correctly adjust our facility to the data Apple provided in ArcMap using the Spatial Adjust tool, but I can't seem to figure out how to get the scale, translation, and rotation parameters to feed into the IMDF workflow. I don't want to have to maintain a shif

Hi,I have a little calculation problem:I want to @sub(A1,B1) and write the result (72) at A2. Next step A2-B2 (72-18)--> result (54) at A3... and so on. The dataset must be flexible, because the input is not only 3 rows long.Thank you for your help!

I have a grid that I want to label by quartered section. the picture in blue is how they appear in arcmap. picture in black is the requested way. I am trying to use FME to transform the grids labels but I need to open the final product in arc. My real question is, which transformers would help with this outcome?

I'm going through the FME Server Authoring training, and in one exercise it had me start projects that would run pretty much indefinitely, then cancel them........ but there's no cancel button. I know it's supposed to be in the top right corner, that's all the documentation, but it's not there. I can't keep doing anything now because I can only have the one job running at a time in the first place (so I've got another few things in the queue I also can't cancel). When I first start a job, I get the "cancel" button on the confirmation page, and it works... but it's too late for that on these infinity-projects. So... help? Why don't I have a cancel button? And what do I do?? (Note: I am not admin, and the one person who probably is admin is at the Esri conference for the next week ie it's just me with server access currently)(proof attached just for fun) 

Hi, a bizarre thing is happening in a workspace i have (FME(R) 2019.0.0.1 (20190415 - Build 19246 - WIN64)). I am reading in coordinate data (long/lat) from an Excel sheet, and creating vertices using VertexCreator. When I choose to run the entire workspace, the VertexCreator doesn't create the vertices in the assumed coord system and therefore subsequent spatial queries fail. However, if I choose to only run the workspace to the VertexCreator, the points have all been geocoded correctly. I have tried inserting a Reprojector but still it doesn't work.Any help would be most appreciated. It has only started to happen today. 

I have a workflow with some raster resampling and also some raster coercing (back to point data) and I end up having coordinates like this: Also, when I want to write a raster (using Aircom Enterprise writer) I get this warning.Enterprise Plugin: Invalid raster cell size: 99.99999999888921 by 99.99999999339829All my input coordinates and raster cell sizes are Integer numbers, so there must be some internal stuff going on that makes these numbers like this. I found this article: https://www.safe.com/blog/2018/09/fme2018-tolerance-evangelist179/But I couldn't find out how to makes all coordinates integer. Any idea how this could be achieved?

I need to use GeoTIFF Writer with compression method: Deflate.There is no such option on the list. I'm not very familiar with rasters but it seems to be rather popular method.Please help me with this problem.RegardsGrzegorz