- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,751 Posts
51,003 Replies

When you subscribe we will email you when there is a new topic in this category

12751 Posts

asked in Transformers

Can I read shape files dat are gzipped (.gz)?

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,

1449

6 years ago

nanblogfmeParticipant

asked in Transformers

Generate Measures for dynamically segmented lines

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.

170

6 years ago

mickael

asked in Transformers

Extrude from surface creates 3D objects with both in and out normals which are overlapping

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

390

6 years ago

ejs

asked in Transformers

Issues creating GEOJson file for use in Socrata.

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

6 years ago

gtitzContributor

asked in Transformers

How to execute JavaScript Code with JavaScriptCaller?

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

680

6 years ago

joannamadrjas

asked in Transformers

FlexLM for Windows Server 2003

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!

150

6 years ago

canerakinContributor

asked in Transformers

Update Detector SQL Database and FGDB

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?

6 years ago

chris_rmwContributor

asked in Transformers

CSMap Reprojector Problem

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:

560

6 years ago

geo-xParticipant

asked in Transformers

Question on multiple joiner

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.

6 years ago

robertdbuckley

asked in Transformers

What is the simplest way to create polygons from the extents of a LAZ file?

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?

110

6 years ago

nikopetterisalo

asked in Transformers

Compare dwg/dgn data elevation to lidar data elevation, specially roof

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.

6 years ago

bergeronfrank

asked in Transformers

Merges polygon features based on a specified distance and field values

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

610

6 years ago

michaels

asked in Transformers

maximum inside rectangle from an polygon

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

980

6 years ago

lazarlubomirContributor

asked in Transformers

Autocad object data reader - Inspector vs. Workbench text entity problem

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

110

6 years ago

ccdcpublic

asked in Transformers

XMLFragmenter - Exclude Attributes

2514

6 years ago

dms2Contributor

asked in Transformers

XML Templater with multiple inputs

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.

180

6 years ago

zacharya

asked in Transformers

GeoJSON inline conversion

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.

1110

6 years ago

ngstokeContributor

asked in Transformers

Extract specific text after key words

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)

2933

6 years ago

dfernan

asked in Transformers

Spatial Join that can be visualized in Tableau

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!

130

6 years ago

hamir001

asked in Transformers

Connect lines without common ID by order in file

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

6 years ago

mikeinhamiltonContributor

asked in Transformers

Converting Unique Values into Individual Words

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.

6 years ago

fariyafarhad

asked in Transformers

SystemCaller to call on a different system?

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.

180

6 years ago

bigjonas69

asked in Transformers

Replace point with symbol from a DWG?

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

1580

6 years ago

rjrobinson2005

asked in Transformers

limiting output file size

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?

600

6 years ago

nindalf

asked in Transformers

How to snap lines to node depending on attribute?

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.

430

6 years ago

Page 347 / 511

Badge winners

albineprohas earned the badge Welcome Back
andyliuhas earned the badge Student (Grey)
_fabian_has earned the badge Teacher (Bronze)
akesoderqvisthas earned the badge Teacher (Grey)
deepakkumar7250has earned the badge Student (Grey)

Show all badges

30,463: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.