FME Form

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?

Welcome to another hot (off the press) edition of What’s Up Wednesday.  Esri UCIf you’re spending the week at the Esri User Conference, be sure to check out our escape room built by Dmitri for your chance to win a $200 USD Amazon gift card.  Free FME TrainingThere is still time to sign up for the Integrate Data with the FME Platform which is happening next week from July 21st - 22nd, 2021 at 9:00am - 1:00pm PDT. While you’re thinking about training you can also sign up for the following free courses:Publish

Hello FME'ersHere is the weekly roundup of FME news. Community Activities: NOW LIVE!In case you weren't aware, we are improving connections in our community with a series of ongoing events - and the first of these is now LIVE! There will be a webinar and blog to cover all of the events, but for now, be aware that an FME Geoguessr group is now live. Geoguessr is a game of geography, where you are "dropped into" a location and asked to guess where it is.  Then you get a summary of your results, with how far away you were:  To play regularly you

I need to write to a single excel file with multiple sheets using a template. I've created a template with multiple sheets formatted as I need them but when I write to excel, it will only write one of the sheets and leave the others blank.

 We have dozens of FME 2020 workspaces that use this capability that are now failing in FME 2021 because the parameter is not available to the Python Caller.

As per the title, what does the FME Hub TestSuite for custom transformers do? The only documentation i've found is here, and basically says it runs on an Linux Envhttps://community.safe.com/s/article/fme-hub-best-practices-and-guidelines Is there any more information that can be shared on how the transformers are tested, what (data) is used to test them? EDIT: Just re read that page and it says it runs a Test Workbench that is supplied. So is that all that it does? As a user, is there visibility of these test workbenches? In some instances it would be helpful to see how the transformer is being used

Can you update the attributes of a feature without having to upload the geometry to a AGOL hosted feature service? For example, we have a feature service with about 80 features where the geometry for each feature is huge. We want to do daily updates to the attributes and the geometry never changes. There is a work around where you have a non-spatial table and use hosted dynamic joins, but is a little awkward.

It seems that the writer wrongly rounds the values ​​of seconds greater than 59. Using DB Browser to query the result:  Could it be a bug? 

I attended last week's webinar on metadata and was happy to hear of the xsd-drive XML reader and writter. I've been attempting to modify the cap:alert demo to write a flavor of ISO19115.     XML Validation: Starting schema validation for 'c:\...\output\tmp.xml'The uri-map document 'C:\Program Files\FME\xml\urimap\gml_aixm.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_citygml.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_inspire.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_sosi.xml' is being used to map from URI to URIThe uri-map document 'C:\Program Files\FME\xml\urimap\gml_urimap.xml' is being used to map from URI to URIXML Validation: Fatal Error in 'c:\...\output\tmp.xml' on line 1, column 39: 'invalid document structure'XML Validation: '0' warning(s) found.

I have a raster in coordinate system EPSG:25833 (ETRS89.UTM-33N). The coordinate system is saved with name ETRS_1989_UTM_Zone_33N in GeoTIFF and Esri Shapefile, but in ECW with name NUTM33. The coordinate systems are the same, only with different name.I have viewed the properties with Esri ArcGIS. The different coordinate system names are in ArcGIS no porblem, but in the software GeODin Maps.How to do it to write coordinate system name ETRS_1989_UTM_Zone_33N into the ECW file?