Skip to main content
  • EN

Best Answers

10389 Posts
A
aviveiro
asked in Data
Flatten File

I've got output from 3 statscalculators coming together to create the following and was wondering how I could 'flatten' it such that that one record exists for each community and <missing> values have a value of zero.So the output would look like the excel image.

102
A
takashi
Celebrity
takashi
asked in Data
How to ask a question regarding XML

How are you doing?I would gladly post answers to XML questions if I could, but some users tend to attach a full or invalid XML document regarding their question, so, honestly, I'm tired from parsing the full/invalid XML to find out the parts which are necessary to understand the question correctly.Could you please add a notification here about how to ask a question regarding XML? If there were such a notification, I could prompt that in my comment or answer. e.g.How to get a quick answer to your question on XMLIf you want to know how to extract specific values or parts from XML, how to modify some parts of XML, or how to filter features based on values within XML, it's recommended that you post XML fragments which are simplified to understand your requirement quickly.Extract your interest XML fragment from the source XML document with the XMLFragmenter.Convert the XML fragment to a Pretty-Print (human readable) one with the XMLFormatter.Using a text editor such as Notepad++, si

132
takashi
Celebrity
C
chriseisinger
asked in Transformers
Expose zipfile filename attribute

I am very new to FME, so apologies if I'm missing something obvious. . .I am trying to expose the filename of zipped FGDBs in a reader that uses a wildcard (i.e. *.gdb.zip). I want the filename of the zipfile, which is different from the underlying FGDB name in this case. Exposing the name via fme_basename or fme_dataset attributes does reveal everything from the FGDB nicely, but it does not appear to reveal the zipfile filename (which makes sense).So, any ideas how one might expose the zipped file filename when the reader is using a wildcard?Thanks for any help.-Chris

91
C
A
andyew
asked in Transformers
Spatially mangled AutoCAD file for spatial conversion

Folks,We have an AutoCAD file that has been treated very badly. Originally it was LatLong projected GIS data but a contractor with no idea about spatial data exported the data as simple CAD coordinates and scaled the CAD by 200K to get into some sort of reasonable scale.We're trying to work out how to transform the CAD back into LatLong. We tried defining a custom projection with a scale of 0.000005 but we're getting errors saying FME can't start the projection engine.In simple terms 1. the drawing is in a known spatially damaged state2. If we could scale the drawing by 0.000005 the drawing would be in a plane expression of LatLong3. We then need to somehow tell FME how to deal with this Sorry for the odd post but we're having a lot of trouble with this.Thanks in advance.

132
A
G
geochoice2017
asked in Data
Raster KmZ

Hi guys,How would you retrieve attributes of raster KMZ file.In Google Earth, you see the actual attributes of raster kmz file, but in FME when reading it, it does not show them.Any ideas appreciated.ThanksDavid

323
fmelizard
Safer
surbhi
Contributor
surbhiContributor
asked in Data
ArcGISOnline Router time units?

I wanted to confirm that the unit of measuring time while using ArcGIS Online Router (Total_TravelTime in Routes) is minutes.

102
surbhi
Contributor
W
willemmatthews
asked in Data
csv to las

Hi, I have to convert a .csv file to o .Las file.

3442
fmelizard
Safer
wolters
Contributor
woltersContributor
asked in Data
PointOnRasterValueExtractor vs Point Shapefile

I want to know the value of a raster at specific points using the Point on RasterValueExtractor. Inputs are a raster and a point geometry shapefile (generated in another FME workspace).I simply connect the raster and point shapefile in the PointOnRasterValueExtractor (they have the same coordinate system), where they should be connected. Yet it gives the following error:PointOnRasterValueExtractor_2(VectorOnRasterOverlayFactory): Invalid point feature or feature with non-point geometry encountered. Only vector features with point geometry are currently supportedAre point shapefiles not supported? Do I need to transform my point shapefile in some way before using it for the RasterValueExtractor?

273
wolters
Contributor
wolters
Contributor
woltersContributor
asked in Transformers
Using vector to mask raster (VectorOnRasterOverlayer)

I have a large binary raster (1 band, values either 0 or 1) that I want to mask with a polygon shapefile (which contains 1 attribute column, id, with values 0). I was thinking of using Vector on Raster Overlayer for this. However the output file is the original raster, without changes. Am I using the VectorOnRasterOverlayer correctly?

913
wolters
Contributor
adriano
adriano
asked in Transformers
Passing a table to the attributeExploder but keeping specific attributes unexploded

I am trying to create a workflow to normalize a table with potentially thousands of columns while maintaining the id column. This would be an easy solution if the AttributeExploder allowed you to specify a column (or columns) to keep unexploded. Since this transformer does not allow this, a workaround I have come up with is to use the AttributeExploder with the option in the transformer to "keep all attributes" and then use an attribute keeper transformer to keep the "id", "_attr_name","_attr_value" columns. This would generally solve the problem but since there is thousands of columns, if we use the "keep all attributes" option in the AttributeExploder the workbench performs exponentially slower to complete (it will go from taking 2 hours to complete, to 40 hours to complete). Is there potential workaround which can solve this problem within a more reasonable processing time?  

1345
adriano
J
jennamkdavis
asked in Integration
Read file path locations for all layers in an ArcMap MXD file

Hi there,Is there an FME tool that can output all the file path locations for layers that are saved in an ArcMap MXD file? If so, what is the tool called?Thanks!

852
J
N
n543
asked in Transformers
DateFormatter Data Interoperability 2017.1

Hi,I have just updated Data Interoperability to 2017.1 and have noticed the DateFormatter transformer has been removed with no sign of either of the new DateTime transformers...any ideas how I can get the new transformers? Or at least get back the DateFormatter? Thanks

146
H
takashi
Celebrity
takashi
asked in Architecture
Is it possible to deny changing password of an FME Server user?

I'd like to publish a user account of an FME Server under my management, in order to allow some clients (Desktop users) to try FME Server quickly even without signing up either FME Server Trial or FME Cloud. However, I don't want to allow them to change password by themselves. Is it possible?

102
david_r
Celebrity
T
thiru
asked in Transformers
Dissolve multiple, unconnected lines into one line feature

I have numerous individual lines that do not share nodes or endpoints. I want to aggregate all into one object. So far, I have tried unsuccessfully with TopologyBuilder, LineJoinerThis is the equivalent of ArcGIS Dissolve (Lines) - Allow Multi-part featureInput: Many line objects Output: Single object

1132
T
F
fariyafarhad
asked in Transformers
Saving FME Server Topic as an attribute value (FME Server)

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}": "[

81
F
D
dbaldacchino
asked in Authoring
FME Server - Direct URL result page

Hi,I am trying to take advantage of the Direct URL feature. In my use case, I am including links in messages such as emails, where if the user clicks it, it runs a workspace on FME server with the correct parameters that calls a REST API to create a new project on a particular server. The user gets a summary screen in a web browser that simply reports whether the workspace ran successfully or not, but does not relay any other information. It also asks the user to read the logfile for more info., but there are no logfile links on this page. Here's an example in FME Server 2017.1: In the above case I added a Terminator so that if the feature comes out of the <Rejected> port of the HTTP caller, the workspace stops and results in an error. In this case I tried to create a project that already existed. Now the workspace does have this exact information in the response body from the server that it interacted with, but we have no way to route this information to the resulting summar

433
G
R
robbie_botha
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, 

2209
olivier
Contributor
E
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

137
E
F
frank
asked in Data
How to read csv (dynamic) and write csv (dynamic) with filename plus postfix?

I want to read csv files with different schemas but with some attributs which are part of all csv files:file1in: attribute1, attribute2, attributeA, attributeB, attributeCfile2in: attributeD, attributeE, attribute1, attribute 2, attributeF, attributeGThen I want to do some processing and write the files with some additional attributes to new files:file1out: attribute1, attribute2, attributeA, attributeB, attributeC, attributeX, attributeYfile2out: attributeD, attributeE, attribute1, attribute 2, attributeF, attributeG, attributeX, attributeYFile names for output are the filenames of input with additonal postfix like "_transformed":<filename1in> => <filename1in>+"_transformed" (<filename1out>How can I do this? I have tried to use a csv writer with dynamic properties but then I get resulting filenames of "CSV". If I change the feature type names from "format names" to "file names" in the csv reader, then I get the fil

1182
F
S
sscholer
asked in Data
SDE Connection files fail following an upgrade of ArcMap from 10.4 to 10.5

I have tried using the old SDE connection file and created new SDE connections. Both fail when using the FME reader Esri Geodatabase (ArcSDE Geodb). The following is the error message I receive:================================Opening the Geodatabase readerThe ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects callFME has checked out an Esri license. The product checked out is 'Advanced'Installed ArcGIS version is '10.4'Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147209112'. The error message from ArcObjects is: {FDO error: -2147209112}Please ensure the connection parameters are correct (server=`gisnas1', instance=`sde:sqlserver:gisnas1', user=`***', password=`***', database=`Cadastral_SDE', version=`sde.DEFAULT')A fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'GEODATABASE_SDE' from 1 datasets. Th

912
fmelizard
Safer
A
aarcra
asked in Data
Create new Google Sheet in a specific folder...

Hey all,Just wondering if anyone has figured out how to write a brand new google sheet to a folder?I have the following file and folder directory structure:My Drive/My Drive/Statistics/My Drive/Statistics/2017 <---googlesheetI want fme to create the google sheet, '2018' in the "My Drive/Statistics/" folder automatically (without user intervention), but no matter if I include the string "My Drive/Statistics/" or the folder ID & "/" , it always writes the new sheet to the root of My Drive. If the Google Sheet already exists, this is not a problem.

82
fmelizard
Safer
juliarozema
Contributor
juliarozemaContributor
asked in Data
FME integrating with a ticketing / service desk type application

Is FME already capable of working with a Service Desk / Ticketing type application?  Right now I am researching applications that I could use to manage emails & tickets (tasks). An idea (or hope) I have is for a user to email a zip file to a ticketing system, and then FME Server could be triggered to work along side the ticketing application to do some work with the zip file. We currently don't have a ticket management system, and so I am open to suggestions. Some cloud applications that I have seen online are: Zendesk, Freshdesk, or Freshservice.Thank you for your time,

684
juliarozema
Contributor
R
rohan
asked in Data
Using FeatureReader with generic output causes ListElementCounter transformers to be invalid.

I have a FeatureReader for WFS. Because I want it to work with any WFS source I have parameterised the Dataset and "Feature types to read" fields and set the output to Single Output port.This means that I have to use the Generic output port.Further down the workspace I have some transformers that do logging. I have a ListBuilder followed by a ListElementCounter, so I can log the number of records returned by the WFS service. I also have an UpdateDetector with the same arrangement.Before I started using the generic output port, everything was OK. But since I have used the Generic port, some ListElementCounters are showing problems. (The one connected to the WFS reader and also the one connected to the Unchanged port of the UpdateDetector. Others are OK.) The ListAttribute fields are showing up as red and they don't seem to be able to read the _list{} attribute that should be supplied by the ListBuilder.If I run the workspace, it seems to still work, but of course I get a w

1054
R
J
jacque
asked in General
FME 2017 crashes when done and when closing

I have a lot of scripts that all write to point feature classes in a 10.4.1 SDE Database in SQL Server 2012.  The source comes from one of 3 databases types, SQL 2012, SQL 2014, or Oracle 11G.  They all are the same as far as errors go so either it's my SDE or FME itself.I even inspected everything I could and on a few I did get error while running and cleared up those small data issues, but they all produce the same error codes on crash dialog box I show at the bottom of this post when I close the Inspector app.I have tried to redo from scratch a few of my scripts but they ALL are crashing like I show below.  I am using the latest version 2017.7.27.17725, I had 2017.7.27.17539 and it did the same exact thing and I thought upgrading would do the trick, but no....  I have redone all my readers and writers, fished through all my data and data types, redone queries, redone my writer feature classes in my SDE, and even filtered the coordinates to fit in the state because we are using UTMs 

217
J
Z
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.

1576
takashi
Celebrity

Badge Winners

Show all badges

Community Stats

31,819
Posts
120,857
Replies
39,451
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.