FME Form

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

I'm looking for documentation going over how FME Desktop checks out an ESRI license. So lets say we have 10 standard ESRI licenses in our license pool. Then one user has ArcMap/ArcPro open, taking up one of the 10 and leaving us with 9 licenses available. If FME Desktop was ran with ArcMap/ArcPro open, would FME take up one of the available licenses, or does it just need to verify the license is valid? Would we still have 9 ESRI licenses available or 8? **I'm also only referring to workspaces that actually require an ESRI license I've reviewed this page, but wanted to be sure I'm understanding how it works with the ESRI licensing.https://community.safe.com/s/article/required-arcgis-license-types-for-fme-geodatabase 

So I just got my toes wet with customer transformers and loops. Fascinating. For the first time the worlds of programming and FME seem to really come together here in my mind. Limitless potential.I put together a custom transformers that takes a bunch of point features, then identifies a certain point, pops it out into feature holder and feeds the rest of the points back to the start of the loop. Essentially, this allows me to put these points in any order I would like for further processing, using my own business logic.Now, this works great for one set of points. What if I have 10K points and would like to use my custom transformers on batches of these. I can split them out in to groups/stream using an AttributeFilter but how do I connect that to the custom transformer? I could certainly connect each stream to a copy of the transformer but that would be crude and crazy clutter. Is there something like a FeatureHolder or some other trick - some form of GroupBy - before

i have big workspace and i would like to devide it to two workspaces so i want to put readers , inputs at first workspace then connect them to the second workspace .readers oracle spatial and non spatial How could i achieve that ? thanks in advanceFME 2018

In writing DXF when lines are output I use autocad_width and autocad_linetype in combination with a DXF Template file in order to get the desired output styling for 2D lines. For 3D lines this doesn't work and 3D lines are output in some default manner. As I am not an expert with DXF/DWG and only create such files with FME could somebody help me out with the following questions:Is it possible to style 3D lines in any way ? Thickness, dashed, etc.If NOT: what do people usually do if 2D and 3D lines are coexistent and should be combined in the same output file, while the 2D visual appearance matters and should be used also for 3D lines? At the moment the only way to cope with 3D styling deficiencies seems to be double 3D line layers, in order to have a 2D and seperate 3D copy force one layer to 2D and style it as usualoutput the redundant 3D layer as is in order

Hi We fly over cities with a lidar. So we have multiple las files of a city. Because they don't start and stop on the city boundary we need to clip these files.  It's a super simple workbench, but it runs for 8 hours on average. Depends on the city offcourse. I think it has a 50% chance of succes. We get 2 types of errors. The first one that says there isn't enough disk space or we don't have the right privileges.The other one is that one of the files could not be written because the data is corrupt. Altough if we don't change anything and run it again it completes with succes. So we don't know what the actual problem is, maybe the network... So If we don't know how to solve that, we can at least try to get a better chance of succes.  Would it be quicker to first select the files that actually intersect with the city boundary and only send those through the

Welcome to FME news so hot you could fry an egg on it. (Well not really, we’re just experiencing a crazy heatwave, but the news is still hot off the press)  We’re OfflineJuly 1st and 2nd the entire Safe office will be offline. We’ve extended our long weekend as we’ve been working hard to get the 2021.1 release ready. We’ll be back on Monday!  2021.1 ReleaseSpeaking of the release, tune in on Tuesday, July 6th at 8am PDT to catch Don and Dale highlight all the great features that will be in 2021.1. Then download a copy for yourself!  FME 32-bit Windows Continued SupportBased on factors both internally

I am trying to convert a CAD text dataset to Esri geodatabase annotation keeping font size and font type. Everything is ok except that the final result is shifted upper left. How can i keep the original text position?