Best Answers

Hello FME community !I've a treatment with MDB destination and I would like to ZIP this MDB at the end of the WorkBench but with a size specification.For the moment, I used this article and the result is a unique ZIP file so fat.What I want is (like 7-zip) to divide this file in different volumes with a userdefined size.In the better world, I would like before this operation to send an e-mail with this ZIP file.Can you help me ?Thank you.

I want to group polylines together depending on x, y and z. Neighborhood Aggregator only seems to take into account XY. The 2D perspective snip shows the lines in 2D. Neighborhood groups polylines together regardless in they are far apart in 3D (as the second snip shows).

Hi,We 100+ years of rainfall data that we would like to find 3 consecutive days where the rainfall is greater than 50mm after a certain date. I can do this in Excel but I can't for the life of my figure out how to do it in FME. Does anyone know if it is possible?In excel adding three consectutive days rainfall is pretty simple =SUM(F2:F4) and fill down the column.Cheers,Dale

I need to extract a variable amount of characters from a string and would like some help.I have an attribute in the following format:id-Structure-1.1.13.1.6.1I need to extract the first 4 numbers (1.1.13.1)Where it's get tricky, is that each number can have a value that may varies between 1 and 6000so it's possible to see "id-Structure-1.5474.768.322.22.12" where I'd like to extract (1.5474.768.322)Any help would be much appreciatethanks

Hi,I want to use Scheme(Anyformat) for reading WFS structure, it is working fine for excel, csv,shapefile, FileGeodatabase and even ESRI FeatureService but not WFS.I want to use generic reader, so I have to use this reader for all of them and I know FeatureReader can read WFS without issue.Has anyone had this problem ? Any solution ?Regards 

Hi everyone, I have two data setsOne contains many catchment areas and their sizes (calculated)The second has the total area of all catchments (Calculated)I need to join these two so that I can then use an ExpressionEvaluator on them to determine percentages. How do I do this if they do not have a common attribute to join on? I tried a FeatureMerger assigning them both a value of 1 as I thought I read somewhere that that would work... but can not find that article again :-(Thanks!Iris

Hi, when I apply the sliver remover after an areaonarea-overlay I noticed that arcs get dissolved. I would like to remove slivers but keep arcs as arcs. Repair method is set to "longest boundary". It seems even arcs get dissolved (turned into line segments) for areas/arcs where there is no sliver.FME 2017.1 Is that behaviour as designed? Did not find anything about in documentation. Thank you, Rob

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

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

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?

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,

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!

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.

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

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

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.

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?

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.

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!

!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

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.

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

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.

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

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