FME Form

I have path_windows for all dwgs in a folder. I could get AutoCAD file OR Civil3D files, I won't know that. How would I get results which I canIs it Civil3D or AutocadGet version for Civil3D. With the top autocad feature reader I figured out how to get the autocad version already, even when I have 2 files with a civil 3d features(these are now included in my tests but should be excluded from my result). I want to only get one result per file, autocad or civil AND the version per type. I tried many things but I cannot find a way to get "there are ciivl these are autocad" not all Civil has pipes network for example so the sum of civil types isnt a guarnateed solution.Current results: Top Feature Reader is Aut

Hi, Is there a transformer that will take a table of OS Grid references of varying length/granularity and create a feature class of grid square polygons for them?

Hi there, so I have two column of data.​The column "Test_FloorNumber_Begin0" should have sequence of 0000, 0001, 0002, 0003 - the largest number of the input, or 0999. ​The second column "Test_FloorNumber_Begin1" should have sequence of 1000, 1001 - the largest number of the input, or 1999.​The sequence should start from 0000/1000 to the largest number from the input data. So I want to use FME to find out the missing number and output it. In this case 0000 to 0003 and 1002-1003 are missing.​Please help me as I want clueless on how to work this out.​Thank you very much.

I am using Bufferer to create a 4 foot buffer around right-of-way polygons. The tool works for 99 percent of the areas but I am getting a few random missing polygons as shown in the screen-shots below. I did find if I change the Buffer Distance one area will generate correctly; however, the issue occurs somewhere else. Areas: Buffer with missing polygons:Any Ideas how to fix this. Buffer works fine in ArcGIS for the same features.

Hi Community, I am trying Attribute reprojection transformer in FME to convert New Zealand Transverse Mercator Projection (NZTM) coordinates into WorldGeodetgic System 1984 (G1762) as per the attachment. However it is not showing my location of interest in my GIS software. Any suggestion on this. Regards, 

I am using the ACAD writer to convert GeoJSON to a CAD file. The issue I'm having is the ACAD Writer seems to be creating a bunch of empty layers named d_y_00, d_y_01, d_y_02 etc. that aren't in the GeoJSON I'm passing. The layers that are in the GeoJSON are written to the CAD file and work perfectly. The issues is I can't seem to figure out where these layers are coming from or how to remove them.

I have two FeatureMerger transformers fed by a single AttributeManager that outputs two string Attributes - one containing a GUID and the other a mixed-case name. The two FeatureMergers are identical, matching the GUID so that the corresponding name gets inserted into their respective Features. Oddly, one FeatureMerger converts the names to uppercase. So I did the obvious thing: blew it away and copied the properly-working FeatureMerger - only to see the copy convert to uppercase as well. The names enter (the Supplier port) in mixed-case and come out (the Merged port) as uppercase. The Requestor ports of both FeatureMergers are connected to the Merged ports of previous FeatureMergers, which themselves successfully merged two mixed-case Attributes into Features with (only) uppercase Attributes. So what is making FeatureMerger convert to uppercase? Edit: Replacing the "uppercase" FeatureMerger with a FeatureJoiner makes

Hi, does anyone know how to write input data to one "block?" I have input data - 8 frequency values (pic1), which are written to the dataset as individual "blocks" (pic2), but I need to write frequencies to one "block" ( pic3 ) Thanks a lot

I dynamically write tables (Soruce: PostGIS) with, as well as without geometry attributes into ESRI Shapes . The Writer for Esri Shapefile format generates entire shapefiles (shp, shx, prj, cpg, and dbf) even for tables without geometry attributes. However, these may not be  read correctly by ArcCatalog. For geometry-less tables, it would be better to have a dbf-file only! Is there any option for the Writer to avoid writing such entire shapefiles for geometry-less tables?

I have some polygons as streets (streetname) and many pipes which lay mostly inside the street polygons. Using the line on area overlayer I can get pipe attributes on the street polygons. But I would like to cut the polygons where one pipe ends and the next one starts.Another approach would be to cut polygons where pipe attributes change...is it possible?

I have a workspace which uses input user credentials to do stuff. I also want the workspace to work during testing by using System environment variables. This is working great for things like DBNAME, HOST, PORT etc where the user inputs are strings (text user parameters). I can simply just enter in ${PORT} for example and FME will look for a set environment variable. Where I'm having trouble is with the password. I can't do the same thing for the password so I've created a simple scripted parameter which first checks if there is a user password set and if not try and see if there is an environment variable. In most cases it works well, however, I've discovered that some special cahrachters are getting encoded by FME - So something like @ becomes '<at>'. Does anyone know a way to 'decode' these encoded strings. Ideally it'd be done in the scripted parameter, however, if it has to be done in the workspace so be it.Short from using

Hello,is it possible to run from fme system call (or python caller) and don't wait for the result?

Hi I have a lot of small geotif tiles. I need to mosaic them together as geotif in specific zones.  I tried the standard compression which is jpeg. The problem is that some zones are to large for the compression method. I get this error: "GEOTIFF writer: Failed to write the output file using JPEG compression. The raster is being written with a tile size of '29005' rows by '82874' columns, whereas the maximum number of rows or columns that JPEG compression can handle is 65500. Please reduce the tile size if writing a tiled file, or reduce the size of the raster" So I'm thinking I only need to change the compression method. I tried all the other compression methods and I always get the same warning: "GEOTIFF writer: Existing value for creation option 'INTERLEAVE' was 'BAND'. Overwriting with the new value 'PIXEL'GEOTIFF

Hello,I am trying to populate a value into "_overlaps" using the PointOnAreaOverlayer Transformer but all the data keeps being Rejected.This works fine when both Readers are consuming Oracle Spatial but I think the issue may be because my Point data is non-spatial?Tried the 'Reprojector' Transformer but had no effect. The View with the Point data contains a SHAPE field therefore should contain geometry but the FME non-spatial reader does not contain the field and I cannot pick up the data using a spatial reader.I may be pursuing the wrong process here?!Thanks in advance. 

I am encountering an error where my clipped raster data is not being written to the designated output folder . I am using FME Workbench 2021.1. I was following the Raster Clipping workflow here. However, I must be making a mistake when adding the writer and working with the settings. Perhaps I was a bit confused as to how to set the writer and parameters. There error I received was something like FME file not accessible. Unfortunately, my FME crashed and closed before I could copy the error I received. I'm hoping someone can guide me through adding a writer. I am trying to clip ~3000 geotifs to a shapefile file of Ottawa, On. and fan out by Ward name. Thank you   

Hello All,I have an AutoCAD drawing that has small circles (polygons) sitting over the intersection of two or more lines. The lines finish at the edge of the circle but I need to extend each of the lines to the centre of the circle so I can then create polygon features from the lines. The resulting line from circle edge to centre needs to be merged with the original line i.e. not just create a new line segment.Any ideas would be very much appreciated.   

The thing I want to do is for example to when AGOSLAG(pic 1) = Kodvarde update AGOSLAG to the text Kodlang(pic 2). Then I want to do the same thing for MALKLASS, HKL. I have serveral tables in excel and they all start with the number 1.  I've tried with databasejoiner but could only update 1 attribute at the time there. I have about 20-30 attributes that need to be updated.  What is the best way to solve this problem?  best regardsJesper

OK I give up - help me!This is my first attempt to use the PythonCaller (since FTPCaller can't yet download directories or accept wildcards).  I've cobbled together some Python to retrieve a directory listing from an FTP site which I want to output (probably as a list) so I can generate the name of the file I want to download and pass it to FTPCaller.I've done a whole lot of Googling but I can't fix this error on the feature.setAttribute line:2016-10-12 17:46:48|   1.9|  0.1|WARN  |Python Exception <TypeError>: not all arguments converted during string formatting2016-10-12 17:46:48|   1.9|  0.0|WARN  |Traceback (most recent call last):  File "<string>", line 30, in inputTypeError: not all arguments converted during string formatting2016-10-12 17:46:48|   1.9|  0.0|ERROR |Error encountered while calling method `input'2016-10-12 17:46:48|   1.9|  0.0|FATAL |f_32(PythonFactory): PythonFactory failed to process f

Basically I need to create new edit version from sde.default and need to compare one arcsde geodatabase layer(copy layer) to another layer (source layer). Any changes in the source layer will be written to the copy layer. Copy layer is a versioned layer and the source layer is not versioned.

I remember a demo/webinar about FME Server showing workspaces exploding in VR/AR - but can`t seem to find it. Anyone?

Hi All,I'm trying to read a MicroStation v8 dgn into FME Desktop 2020.1 and most of it is coming through fine, but some line strings which are classed as dimensions are not coming through successfully. Here is the dgn file (note the element type is dimension, why I don't know!): And this is the output i get when reading in FME:Instead of the line I get a point and part of an arrow but that's it. No pertinent warnings and no errors at all, any ideas what I might be doing wrong (other than asking the CAD person to redo all of the leader lines)?Dan

Hi, I have two polygon layers (Layer 1 and Layer 2). Layer 2 contains a subset of Layer 1 polygons i.e. one polygon of Layer 1 can contain 1 to n polygons of Layer 2 (Image). Each polygon in Layer 2 needs to be uniquely identified by using two attributes: ID of Layer 1 and pol which represents the number of Layer 2 polygons within one Layer 1 polygon (image). How to create a pol attribute?

Hi, is it possible that FME does not honour geography types for SnowFlake? SnowFlake should be able to store geometry as WKT / WKB / EWKT / EWKB or GeoJSON. Currently (FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) only GeoJSON seems to be supported. When I try to specify a different format, FME keeps on writing GeoJSON format geometry.I tried specify it in the JDBC connection parameter GEOGRAPHY_OUTPUT_FORMATI tried specify it in a pre-write SQL statement ALTER SESSION SET GEOGRAPHY_OUTPUT_FORMAT='WKT'Any ideas? Or file a support case? Love, Helmoet.

Hello​Is there any experience or feedback using FME (including fms server) in conjunction with a classical SAP bi architecture where the database house is BW4hana. For the front end part we use Sap analytic cloud.​Thanks for all information or tips and trick​

I'm very new to FME and sorry if my question is stupid.There are some JSON data containing objects with multipolygon geometry on a single spline 256x256 with integer values of (x, y) as you can see in following example (just part of whole file of course) {"HotspotMetaData":{"id":162011,"RenderedGeometry":{"type":"MultiPolygon","coordinates":[[[[0,231],[-3,228],[-9,233],[-6,236],[0,231]]],[[[1,227],[-1,225],[-6,231],[-3,234],[1,227]]],[[[3,224],[0,222],[-3,228],[0,230],[3,224]]],[[[8,229],[9,225],[0,222],[-1,226],[8,229]]]]}},"hintContent":"40 km/h","unit":"kilometers per hour","description":40}See on JsonEditorOnlineAs I can see it is very similary to GeoJSON except that "Rendered ...", but! First of all FME say me "There is no ge