Transformers

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

I'm attempting to process 1,000's of Mastermap native Gz files in to TAB format. As the maximum file size for standard Tab files is 2Gb is there a way to get FME to split output in to multiple 2gb files?

Hi, I have a geometric topology with nodes and lines. Some lines have not the right end coordinate and are therefore not "connected" with it's node (shown on the left side). I'm looking for a solution to "snap" somehow the lines to the respective node depending on the line-attribute Node_Reference (shown on the right side). Is there a matching transformer available? For example: the red node has the attribute Name: ID_1. The blue lines has an attribute Node_Ref: ID_1. I would like to replace the end coordinate of the blue lines (nearest end of the line) by the coordinate of the matching node.

How do I set an attribute value in attribute manager that does not include quotations once I load it into Smallworld?

Hi,Has anyone looked into logging to a Gibraltar Loupe logging service ?My company is currently looking into creating a central logging facility for all our applications and services, and FME conversions are not exempt from this.It may be converting normally generated FME logs, or preferably, logging directly inside the workspace, e.g. by using a PythonCaller or a a custom transformer.Any insight on this issue is most welcome.Cheers Lars

What is the best method to remove 75+ attributes from a file with 500 attributes? Is there a way to use a list of the attributes 75+ attributes to parse from the 500?

I am parsing a very large xml file. After using the XML reader, my intention is to widdle down the data by using a series of constraints before writing to a database. I first tried to do this by stringing together multiple attribute filters, however I was unable to get my results from the first attribute filter transformer passed to my second, etc. Documentation suggests the Test filter would be a better route anyways. Despite knowing that my data satisfies the query statements (I tested this in another environment) I have added to the test filter transformer, I cannot get the transformer to pass any data through.I have also tried to achieve the same task via stringing together testers, as well as stringing together test filters (1 statement a piece). Does anyone know why I cannot get this to work? Thank you ahead of time for addressing this post.