Skip to main content
  • EN

Best Answers

10389 Posts
oliver.morris
Contributor
oliver.morrisContributor
asked in Transformers
FME Cloud API return Zip file

Hi,I have some JSON GET requests working AWS API Gateway and an FME backend thanks to @GerhardAtSafe and @stewartharper for the youtube videos and github repo. The next step is to offer up zip files. The workbench streams a small zip file and I am now trying to get this working through the AWS API Gateway. I have added application/zip for the content type and got the gateway to support application/zip binary. When I try to make the call though I only get an empty zip file - although the FME job does run successfully and a file is created. I suspect it is because the body mapping is incorrect. There is some information for images here:https://aws.amazon.com/blogs/compute/binary-support-for-api-integrations-with-amazon-api-gateway/Does anyone know what I should put in the body mapping template for the integration response?Many Thanks,Oliver

444
stewartatsafe
Safer
D
david_prosack88
asked in Transformers
Feature Compare Validation

Good afternoon all!I am having a problem with developing a QA/QC process for some CAD data. The ultimate objective is to compare the layers within the CAD files against base layer names located in a spreadsheet (i.e Elevation Contours, Houses, Lights, etc). I think the best way to do this is using Python. I have tried transformers but they only look at the data that is being run. I'm new to FME Python and I'm kinda lost so far. Any assistance would be great!Thanks! David

144
danilo_fme
Evangelist
A
Anonymous
asked in Data
PowerPoint Writer and Transformers Documentation

I was interested to see the new PowerPoint writer and transformer for FME 2018, but I cannot find any documentation on these items. Is there any?

63
debbiatsafe
Safer
A
aquamarine
asked in Authoring
Slow performance speed in workbench containing Custom Looping Transformer

Hi,I have a FME 2016.1 workbench that contains a Custom Loop transformer and within that I also have a PythonCaller with some Python Code.The workbench outputs the expected result but it takes over an hour to run. I need it to run ideally in less than 20 minutes.I have attached some screen shots of the main workbench and the custom transformer. Does anyone have ideas on things I could do to speed this up?Thanks,

485
A
kartemann
kartemann
asked in Authoring
PythonFactory failed to load python symbol `FeatureProcessor'

Hello,I'm trying to use an external python library, Paramiko to perform some SFTP functionality. I am attempting to use a PythonCaller to run some python that I know works outside of FME. I have python 2.7x64bit installed. I'm running FME 2017.1x64 bit. My python interpreter is set as below:Here is the PythonCaller configuration:Here is the python script:And here is the error:I'm sure i'm goofing up something simple. Thank you for your help!

16092
kartemann
pflegpet
Contributor
pflegpetContributor
asked in Data
Automating WFS download

Hi, I would like to create a workflow to download and merge vector data from a WFS. The city of Vienna provides building footprints in shape format via WFS. Due to the large filesize it is recommended to reduce one download to a tile of 2x2 kilometers or smaller. As I need the complete dataset I try to create a workspace to download all tiles with getfeature requests (e.g. https://data.wien.gv.at/daten/geo?service=WFS&version;=1.0.0&request;=GetFeature&typeName;=ogdwien:FMZKGEBOGD&outputFormat;=shape-zip&SRS;=EPSG:31256&BBOX;=2748,341794,4516,343209) and then merge the tiles into a File GDB. Is it possible to dynamically create the request by inserting the necessary bounding box coordinates and then merge data directly out of a ZIP file. Thanks for any help.

774
pflegpet
Contributor
E
edhere
asked in Transformers
Update phone numbers based on Excel file (RegEx, AttributeManager or FeatureMerger?)

Hi all,  I have to bulk update a whole bunch of phone numbers. The current format is ten digits, starting with a 0. I need to convert these numbers to area code + local number.The area code is either three or four digits followed by a dash (-).  The area codes are stored in enclosed file "PhoneUpdating" The input and output phone numbers are in "PhoneOutput"  What I'd like FME to do:When the first three or four digits in the "Phone" column match with the thee or four digits found in AreaCode: then replace these with the data found in AreaCodeUpdated. (output examples in green)  Example files:Thanks again, Ed

113
takashi
Celebrity
stevenjh
Contributor
stevenjhContributor
asked in Authoring
FMEServerJobSubmitter failing in published workspace

I'm trying to run the 'FME Server Workflow Management' workspaces and running into a couple of issues running 'chain_job.fmw' depending on how I reference the server itself in the Web Connections settings.1. Web Connection configured as same domain I publish against (eg http://site.company.com)running chain_job from desktop and calling the three published workspaces runs fine.running the published chain jobs errors with a web pages content<title>Notification: DNS Failure</title><h1>This Page Cannot Be Displayed</h1>The host name resolution (DNS lookup) for this host name( site.company.com ) has failed. The Internet address may be misspelled or obsolete,the host ( site.company.com ) may be temporarily unavailable,or the DNS server may be unresponsive.Date: Tue, 20 Feb 2018 16:22:11 AEDT<br />Username: <br />Source IP: 99.99.99.99(this was the machines IP)<br />URL: POST http://site.company.com.com/fmerest/transformations/comm

383
stevenjh
Contributor
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Rename MS/SQL table names from MapInfo file names ?

Hi,I've been given a set of 20+ MapInfo tables, of which most have a period (.) in the file names.I need to convert these tables into MS/SQL, but this presents a problem, since periods are no-go in MS/SQL, and I need to control the schema.I'm trying to write using a dynamic writer, but I simply cannot figure out the combination of parameters, that'll allow me to replace the periods with underscores before writing into the database. No matter what I do, I loose the connection to the "schema", and nothing gets converted.Please help me out. This ought to be a no-brainer, but I'm stumped.Cheers.

254
david_r
Celebrity
R
robertdbuckley
asked in Data
Is there anyway I can use the rasterCellcoercer to write directly into an xyz file?

I am creating xyz files from a DEM Raster using the RasterCellCoercer to create a point feature containing heights from the DEM. I am writing first into an ESRI geodatabase, and then using the coordinate extractor to write X,Y,Z fields to a CSV file then renaming it to *.xyz.Is there maybe a more straight forward way of doing this? Could I cut out the ESRI Geodatabase and write directly from the RasterCellCoercer into a xyz?

791
takashi
Celebrity
M
maliodpalube
asked in Data
DWG to SHP

Hello,  I am trying to make a Shape file from my DWG. I am trying to use only one layer from DWG because that is all I need. Basically I am trying to close all the polygons in that layer, and calculate their area and to write their area in shp. I am not getting a good result and I have no idea what could be the problem.Also, I was wondering if I can get a result written in form of "P= "number" m2". Now I am getting this from screen shot.

597
pratap
Contributor
M
maliodpalube
asked in Data
SHP to Raster

Hello, I am trying to make a raster from two SHP files. It is a bit specific so I would like to ask you if maybe somebody has any good idea what is the best idea how to solve this.  I am having two input Shape files that have multiple attributes. In one file, I first want to take only two classes from one attribute (ROADS: Motorway and Residential) and give them specific thickness, all the others can be normal width. (I was wondering if the best way to solve it is Tester ---> AttributeCreator).After that, I would like to prepare that for printing. Best way would probably be transforming it to raster. (MapnikRasterizer???) I would need to specify the window that I want to be printed and I know that it can be done with MapnikRasterizer.  I am looking forward to all good ideas and suggestions how to solve this.Thank you all in advance!

61
owen
T
trydlinge
asked in Transformers
Python caller issue/ Grouping points into tiles

!HiI am trying to use this python script which would be very helpful for me. I have a huge amount of data from a WFS which needs to be tiled in a good way. @takashi had a very good code, but I can’t get it to work in 2017.10.154 edition (the version I have).I have a test file with more than 2000 points and I want tiles with 230 points each.I have python installed on my computer and I am using the python caller.I get error messages:” FME Configuration: No destination coordinate system setPythonFactory failed to load python symbol `FeatureProcessor'Factory proxy not initialized f_4(PythonFactory): PythonFactory failed to process feature”Why is that?Any suggestions?/Regards, Tobias

112
takashi
Celebrity
peteralstorp
Contributor
peteralstorpContributor
asked in Data
Excel corrupt file resulting from using an Excel .xlsm template

Here's a tricky one. We're using an excel marcro-enabled (xlsm) file as a template and in the script we're populating it with various info from textfiles and more. When we try to open the resulting Excel file with Excel (2016) the file doesn't open. We're getting an error message saying there's something wrong with the file and would you like to try to fix the errors? The offered fix isn't good enough. I'm thinking this might have to do with the xlsm-format or maybe it's a language issue. We've had help from SAFE resaving the file and then this would sometimes remedy the situation. Anyways, this is just to check if anybody has encountered the same problem and have any ideas as to what in the excel template can cause this error. We have macros in the file and from what I can gather no other strange things.Thankful for any suggestions.

492
peteralstorp
Contributor
E
edhere
asked in Transformers
How to merge features?

Hi all,  I'm having issues merging two Excel files - I have tried FeatureMerger but I'm not getting any results.  I have a "main file" that contains a feature "POI_SHORT_NAME".  I also have an "abbreviations" file containing the same feature "POI_SHORT_NAME"  What I'm trying to do: When the postalcodes in both files match then the POI_SHORT_NAME from the abbreviations file should be written to the main file.  Cheers,Ed

224
E
philippeb
Enthusiast
philippebEnthusiast
asked in Transformers
Extract Excel schema automatically

Hello,Is there a way to extract the schema automatically from an Excel file when FME Server runs the scheduled workbench?People who drops the Excel files doesn't change the fields though, only the sheet name.Thanks.

1013
fmelizard
Safer
H
hadhafang
asked in Data
BIM to GIS Basic Tutorial

I am trying to go from an IFC fil to cityGML in accordance with the BIM to GIS (Basic) | IFC LOD 100 to LOD 2 CityGML tutorial. I am currently tying to replicate all the 4 steps within my own workspace with my own readers. However in step 3 "Set Attributes and traits" my AttributeCreator doesn't work and I find the tutorial lacking in showing how to set it up.So how do i setup my transformers in step3?Both the AttributeCreator and the GeometryPropertySetter

482
fmelizard
Safer
S
shahsamkit
asked in Transformers
Does FME support reaching Geosoft Grid files with extension .grd ?

https://pubs.usgs.gov/of/2004/1258/Data/grid_facts.txtThe magnetic and gravity grids are available in the following formats: 1. Geosoft OasisMontaj (*.grd, *.grd.gi) binary format 2. Grid Exchange Format (.gxf) (an ascii grid transfer format) 3. ESRI Spatial Analyst (.flt, .hdr) binary format

601
daveatsafe
Safer
nrich_defra
Contributor
nrich_defraContributor
asked in Transformers
Group points into squares

(I'm using FME Server 2011)  hi FME'ers,  I have a whole bunch of points, millions, and I want to create a grid of squares/rectangles (bounding boxes) covering the points so that each grid feature contains roughly the same number of points.  I'm then going to use this grid to set of a whole load of fme server jobs to process the points - so am using the squares as a way to split up the process into managable chunks, by passing in the min/max x/y values to my 'worker' workbench.  I've split this job up so i'm dealing with 10k chunks, so want to divide this 10k square into smaller squares (or rectangles) based on the density within the square.  I also want to reduce the number of jobs I create on the server, so only want to break up the tiles when they are over a certain point count - say 5000, and group them to between 3000-8000 say.  so in the picture below, I want all the green /amber tiles grouped together (but only if they form another square or rectangle

9618
T
O
oliwerurban
asked in Transformers
How to insert a character inbetween the string with different lentgh?

Hello.I need to insert a dash into a phone number after first  digit. I know how to do it using attribute manager and text editor only  if the length of the number is always the same. In this case is not. Is there a code I can put instead of "X" to indicate the rest of the value? If I will put fixed number the outcome is incorrect because of mentioned before different string length.Maybe there is other way?Thanks,Cheers

2602
O
S
stysiakaleksand
asked in Transformers
Aggregating 3D polygons based on a common ID, results in corrupted geometry.

Hi  I have a 3D city model made out of individual polygons. Polygons forming one building have a common ID (also attr like Type: Wall, Roof). I need to combine/merge/aggregate together shapes beloning to each building. The output should be a shapefile or multipatch.   I tried using Aggregator in combination with Dissolver and Sorter but data looks fine only in FME viewer. I try to use it in ArcGIS Pro, CityEngine and also in Microstation but data is completely distorted.  When I load non-aggregated data in ArcGIS Pro it works fine. But the problem is it has to be combined before I can use it for my project. Any idea what could be wrong or what other ways I could use?This is my setup And this is the result when viewed in ArcGIS Pro Here's sample data, maybe sth is wrong with this data?

892
S
E
edhere
asked in Transformers
How to trim string length to max. 35 characters?

Hi all,I'm looking to trim a string to max. 35 characters. Actually 34 characters and ending with a "." to indicate the string has been shortened. What transformer can I use? Or does this require some RegEx?Thanks,Ed

2415
E
arekpierchala
Contributor
arekpierchalaContributor
asked in General
Running the FME Server System Services

HiI want to use FME Server to work with data from Database (DB1) and Fileshare (FS1) and transform them and place in Database (DB2) and Fileshare (FS2). All Source and Destination resources are located on different, separate machine. Do I need to run FME Server services (FME Serv App Server, FME Serv Core, FME Serv Database, FME Serv Engines) on such user account which has an access to all resources DB1, FS1, DB2 and FS2?

61
david_r
Celebrity
arekpierchala
Contributor
arekpierchalaContributor
asked in Architecture
FME Server services - is there any required order of services restarting?

Hi There are 4 sevices on FME Server - FME Server Application Server, Core, Database, Engines. Is there any required order of services running, e. g. when the whole machine is restarting?

1651
david_r
Celebrity
gerryjames
Contributor
gerryjamesContributor
asked in Data
Create AutoCAD block with Aggregator but maintain layer of individual features

I have created a workbench that transforms DGN cells to AutoCAD blocks. In this process I am trying to set a feature to the defpoints layer but when I aggregate to a block it puts all features on 0. Is there a way to keep that defpoints layer when aggregating?

353
gerryjames
Contributor

Badge Winners

Show all badges

Community Stats

31,820
Posts
120,854
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.