Transformers

I have a set of polygons which has been clipped at one point in time. I would like to dissolve them back together but only along the path originally used to clip them. I don't want to dissolve all polygons touching each other. My approach so far has been to locate the edges of the polygons I would like to remove and I have marked those in the image below (I have the markings as features). I don't have a common ID on the polygons I would like to dissolve, so I haven't found a way to group the polygons to dissolve them in that way, since one polygon might have more than one marker attached. How can I achieve what I have outlined below?Reference:

Hello, I have several publications in FME Server that are monitoring for incoming emails. The publications are subscribed to different topics. I am making a master log (in SQL) of all incoming emails for all the topics. When I start the monitor for a topic in FME Server, I get this sample JSON notification output:{ "email_publisher_subject": "[this is the subject]", "email_publisher_sent": "Fri Jun 30 14:41:19 EDT 2017", "email_publisher_content_type{1}": "text/html; charset=\\"iso-8859-1\\"", "email_publisher_from": "testemail@gmail.ca", "email_publisher_content_type{0}": "text/plain; charset=\\"iso-8859-1\\"", "ws_topic": "Document_Incoming (EMAIL)", "email_publisher_received": "Fri Jun 30 14:41:32 EDT 2017", "email_publisher_to": "destination_email@gmail.ca", "email_publisher_content{0}": "[

 Pretty simple question here.  I know that you can read zipped shape files by simple changing the extension to .zip in the advanced file browser. However, I tried this with .gz and had no success. Is there another way I can do this?   I’m using FME 2015 32x.     Regards, 

I have a set of dynamically segmented lines, from a dynamic segmentation workspace I set up. The problem is, I have so far over 2 million dynamic segments, and I would like to extract measure values (Beg_measure, and end_measure) for each of these dynamically segmented sections. These dynamic segments are generated by overlaying (using a lineonareaoverlayer) a bunch of environmental data on a set of lines (Rivers, land_types ETC) and the lines are segmented at each point where the data changes. The source linear dataset has measures on them, but I'm having trouble generating the measures for the dynamic segments. Any suggestions or contributions are welcome. Thanks in advance for your help.

Hello,I am new to FME, and I am trying to understand a script made by someone before me. The major issue I have right now, is that the result from an extrusion (originally from shp files) is creating objects with several faces, for both in and out normals :  It looks like this :The process leading me to this looks like this :Of course, I would like to get rid of the inner faces, any ideas on how to do this ?Thanks in advance

Hello,I am working on a workflow that extracts GEO data from an ESRI GEO database to a GEOJson file that has to be imported into Socrata. The issue I encounter is that my (in FME generated) GEOJson file apparently doesn't apply to the GEOJson standards.Checking this file on geojsonlint.com I mostly get errors that features don't follow the right-hand-rule or GEOJson structure errors. (type member required)Importing this GEOJson file into Socrata goes wrong. (But when I import the GEOJson into QGiss and save it again as GEOJson there is no issue importing this into Socrata.) I've been debugging and testing for a while now but can't figure out what I'm doing wrong. I can only think about 2 things. Am I using the Orientor correctly?I use the OrientationExtractor to determine the orientation. Then I use a Tester to get only the left-hand-ruled features. With a the Orientor I convert these left-hand-ruled features to right-hand-ruled ones. Settings of the Orientor are: O

I want to encode the polyline format, which I get from Google Maps Directions API.The decoding works according to a specific algorithm:https://developers.google.com/maps/documentation/utilities/polylinealgorithmA JavaScript code for that is on this website:https://stackoverflow.com/questions/40877840/google-maps-api-draw-a-route-using-points-of-a-polylineHow can I execute this JavaScript Code with JavaScriptCaller in FME 2017 (FME2017.1.2.0)?I have used JavaScript Mode: Node.js (Technology Preview)var fme = require('fme');var fmeobjects = require('fmeobjects');var a = require('https://maps.googleapis.com/maps/api/js?libraries=geometry');// To be executed for each feature.fme.on('feature', (feature) => {    fme.output(feature);});// To be executed after all features// have been received.fme.on('end', () => {    });This error occurs:module.js:471    throw err;    ^Error: Cannot find module 'https://maps.googleapis.com/maps/api/js?libraries=geometry'    at Function.Module._resolveFi

Hi, I'm trying to install floating licences on the server with Windows Server 2003. It's too old and FlexLM downloaded from the Safe's webpage doesn't work. Do you have any idea where could I find Flex Server compatible with Win Server 2003? Thanks in advance!

Hi,I created a geodatabase from SQL database. I have to create a workbench that the user will be able to edit the SQL database and apply the changes to the geodatabase by using the workbench. I am trying to detect the differences between SQL table and the related feature class which have the same data, but UpdateDetector, ChangeDetector, or Matcher do not give the correct answer. I also change the lenient geometry matching and treat blank value as different from missing attribute. No difference. What is wrong?

I have a workbench where I am attempting to take data in NAD83CSRS_UTMZone17N and reproject it to NAD83_UTMZone17N using the CSMap Reprojector. I have a installed a grid shift file (.gsb) supplied by a provincial agency in FME Options > Coordinate Systems > NAD83_to_CSRS. However, when I run the workbench I don't get the correct output. I know the transformation is not working as I can do the reprojection in ArcToolbox and my parcels do not shift.I am wondering if there is something else I'm forgetting to do?NAD83_to_CSRS GX_NAME: NAD83_to_CSRS EPSG_NBR: 1843 EPSG_VAR: 1 SRC_DTM: NAD83 TRG_DTM: CSRS DESC_NM: Canadian Spatial Reference System (NAD 1983 CSRS) SOURCE: Service New Brunswick INVERSE: Yes MAX_ITR: 10 CNVRG_VAL: 1e-9 ERROR_VAL: 5e-8 ACCURACY: 1.5 MIN_LNG: -82.5925 MAX_LNG: -54.2675 MIN_LAT: 42.79375 MAX_LAT: 64.75625 METHOD: GRID_INTERP GRID_FILE: NTv2,Inv,V:\\Data\\External_Agencies\\Teranet\\CSRS_GridShiftFile\\ON83CSv1.gsb FALLBACK:

Dear FME community.I've two datasets :Table 1Col1Col2Col3AnullnullnullnullnullABnullABCTable 2Col1Col2AArt of theaterBBlizzardCCute rabbitWhat I want is to transform Table 1 in : Col1Col2Col3Art of theaternullnullnullnullnullArt of theaterBlizzardnullArt of theaterBlizzardCute rabbitI began to use FeatureMerge but it seems to be "heavy artillery" for a little problem.What is the best process for resolve this ?Thank you for your help.

I have 1000 LAZ files and need to create a grid of the extents including the file name attribute. What would be the easiest method do carry this out?

Hi !I have dwg/dng data with elevation so they are 3D polyline or polygons. Those elevation is taken by stereomapping solution. Now i want compare those elevation to airbone lidar data in same area. Any good idea, how to do that ? Buildings footprint should be quite ok, so also roof what i want compare is ok in x,y, but i think that there is some mistake by z.

Hi,What would be the equivalent in FME of the ArcGIS "MergeAggregate" function which allows to merge polygon features based on a specified distance and field values?Thank you

Hi is there a way to get the maximum inside rectangle from a polygon? I need the rectangle with the biggest area. Is there a transformer in FME to do this? Or can anyone give me perhaps the python-code to get this rectangle? thanks for your help

Hello, I try to solve one problem with autocad object data reader, but Im still unsuccessful :-(I have one DWG created in FME through Autocad object data writer and I have to open this DWG in another workspace. If I load DWG via autocad object dat reader in workbench, all features are loaded, but WITHOUT TEXT entities, which are part of the block. If I load the same DWG only in inspector, I can see all features including text entities inside block. Can somebody help me please? Why autocad object data reader in workbench is not able to read text entities of block?I attached also some screenshots.Thank You so much!Lubo

Hi,I need to exclude all XML attributes beginning with "questionnaires.que_ans"The following XML is being return from - HTTPCaller - XMLFragmenter -Many thanks. questionnaires.que_ans{0}.ans (encoded: utf-16) questionnaires.que_ans{0}.ans_value (encoded: utf-16) questionnaires.que_ans{0}.que (encoded: utf-16) questionnaires.que_ans{1}.ans (encoded: utf-16) questionnaires.que_ans{1}.ans_value (encoded: utf-16) questionnaires.que_ans{1}.que (encoded: utf-16) questionnaires.que_ans{2}.ans (encoded: utf-16) questionnaires.que_ans{2}.ans_value (encoded: utf-16) questionnaires.que_ans{2}.que (encoded: utf-16) questionnaires.que_ans{3}.ans (encoded: utf-16) questionnaires.que_ans{3}.ans_value (encoded: utf-16) questionnaires.que_ans{3}.que (encoded: utf-16) questionnaires.que_ans{4}.ans (encoded: utf-16) questionnaires.que_ans{4}.ans_value (encoded: utf-16) questionnai

I'm just a newbie with fme and I'm having very basic problems when working with transformers.First off, I want to connect several readers to the input Root port of XML Templater. The transformer shows no error when I do it, but when I run the workspace it does generate an error since only the data of one of the inputs is taken into account but the root template needs values from both inputs.Working with sub templates is not an option for me as I will never really know what elements in my xml template will take values from one or another input. I have no control on the key-value pairs present in each json input.

Hello,I have a project that involves creating maps and custom outputs with the HTMLReportGenerator and would like some help with GeoJSON. I am utilizing custom code to add a second geojson layer to the map. is there a way to take an imported file (ex: ESRISHAPE) and convert it to geojson inline (maybe as an attribute?), and then use that geojson output(text) as a parameter in my custom code.Edit:A good example of a perfect geoJSON output is how the HTMLReportGenerator converts both attributes and geometry to geojson.

Hello, I'm attempting to extract strings from a text file that comes after specific key words. I only need to extract the X,Y coordinates from the text but I need to preserve what values they correspond with. In my example these are well points and I will need to keep the location for each one. I have the following keywords:GEOLOGIC FIRST TAKE POINT:BOTTOM HOLE LOCATION:LAST TAKE POINT (TIV):I only need the X,Y coordinates that come after these key words, but I'm having trouble getting my regex expression to pull the X,Y data following each key word as there is text in between I don't need. I've attached a sample of my data below. FIRST TAKE POINT / GEOLOGIC FIRST TAKE POINT: WORDS IN BETWEEN WHAT I WANT TO EXTRACT X = 5,498,257' Y = 789,958' LAT LONG LAT LONG (NAD27) (NAD83/86) LEGEND: (PSL) - PROPOSED SURFACE LOCATION (PP) - PENETRATION POINT (FTP) - FIRST TAKE POINT (GFTP) - GEOLOGIC FIRST TAKE POINT (LTP) - LAST TAKE POINT (BHL) - BOTTOM HOLE LOCATION (r)

Hi,I am trying to do a spatialJoin between a records table with lat, lon coordinates that lives on AWS Redshift, and a shapefile that lives on my local PC. The final goal is for this join to then be imported into tableau and visualize the data as a choropleth map showing number of records per shape.However, for some reason this is failing for me and I have no idea why.Below is the ETL diagram:As you can see no output is going to inspector called PointsOnShape - suggesting that no point found any match with the shapes. I have plot the points and shapes on tableau and there's definitely overlap.ShapeOnPoints Inspector shows also no overlap, and gives an error:On the other hand the RejectionsIns shows a clear error: INVALID_POINT_GEOMETRY_VERTICES. But I have no idea how to handle it or what I may be doing wrong.This is just part of my ETL workflow because ideally I'd write this data to redshift and then consume it in Tableau but wanted to start by fixing this issue.Thanks! 

HiI have a csv file with lines that relate to each other purely by the order they appear in the file. So all the records with a record type "1" are the main record and the lines below with 2, 3, 4 or 5 record types relate the record above with the type 1. There could be any number of lines below and you only know when you get to a new record because you get a new record type 1. I would like to assign a new field with a common ID to the lines that refer to the same property. So in the first example the 8 lines would have a common ID and then the next 3 lines a different ID.1 106 London road 2 Ground2 Ground2 First1 104 London Road2 Stores3 Offices1 Retail4 Car ParkingAny help gratefully received.ThanksRuth

I need to create a list (or repository) of all the unique words in multiple data sets attribute tables. I was able to create a list of all the unique attributes, but now I need to go one more level and break out those attributes into individual words.For example, let's say my unique list of attributes are:The Dog The Cat Bird Three DonkeysI need to take that list and create this list with it: The Dog Cat Bird Three DonkeysDoes anyone know how I might achieve that?Thanks.

Hello, Is there any way to use SystemCaller to call on the terminal of a remote server?We have FME server hosted on a computer. We have another program hosted on a Google virtual machine. It is a linux based machine and I run a couple of simple commands there. I would like to be able to do that using FME Server.Thanks.

Hi,Is there a way to replace a point (Origin was from a point cloud) with a symbol from a DWG file?And I also want to scale the symbol in x, y and z with values from a attribute from the point.For example the attached And the output format can be a Shape or DWG file.Best regards,Jonas