Transformers

Hi All,I am updating few values in ArcSDE Geodatabase (in flat table) using FME workbench but its giving an below errorerror : Error while retrieving an ArcObjects update cursor for the table/feature class 'gis.xxx'. The error number from ArcObjects is: '-2147220652'. The error message from ArcObjects is: {}Stack  : FME workbench 2021.1 , ArcSDE Geodatabase, Flat table ,MS Sql Server Workbench screenshot :  Error message :    Feature writer properties Till now tried below : Us

Hi!I have to extract data and write it into excel sheet. I got to the point where I have the information ready but I need to delete missing values and move the features so the table looks different. I add an example.This is what I get:DaysMonthsCity<Missing>March<Missing><Missing>March<Missing><Missing>MarchParisMonday MarchParisWednesday <Missing>ParisSaturday<Missing>Paris<Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing><Missing> And this is what I want to write into my writer. DaysMonthsCityMondayMarchParisWednesdayMarchParisSaturday

I am working to compare the geometry of two datasets and I am specifically interested in doing so with Vector Tolerance. For some testing purposes I have tried two different transformers to do so, namely the ChangeDetector and the Matcher. I added them in the same workspace with the same input data. For both I only checked the geometry (not the attributes), with the settingsMatch Geometry: 2D Lenient Geometry Matching: No Check Coordinate Systems: No Vector Tolerance: the same user parameter, e.g. set at 0.5 or 0.1. Always the same though.When looking at the documentation the vector tolerance seems to have to work the same for both transformers (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/changedetector.htm &

Hi all, Yesterday this worked fine, but today its returning ‘{ "success": 0, "errorMessage": "API Limit Reached!" }’ in _reponse_body column? What do I need to do to resolve this issue? Thank you in advance!

In ArcGIS Pro a TIN can be created using the “Create TIN” tool. The usage notes of the tool say that it should be avoided to use a geographic coordinate system when creating the TIN, as the Delaunay triangulation might not work correctly when the coordinates are in angular units.The “TINGenerator” transformer in FME does not provide such a usage note in the documentation. Does this mean that the “TINGenerator” transformer can create a TIN without problems when the input dataset is in a geographic coordinate system or is it also recommended here to reproject the input data to a projected coordinate system first?

Hi All,I am new to the FME Software and have a small question related to NeighborFinder.We have points and contour tables in Arcsde Geodatabase. We are finding points near contour by providing specific distance say 20 in neighborfinder In actual case distance is varies  like in some cases nearest contour is at 30 , some contours at 40 etc. How do I tell to neighborfinder that select a point which is near by contour having distance in between 10 to 40 ?. In SQL if we use between operator then we are getting values so similar I want to use this for neighborfinder Below is the screenshot :    What I tried so far : Creating Custom parameter  On Web found below useful post

Hi,Unfortunately i cannot provide the test data due to confidential data. I also cannot encode/dummify the data because then the issue no longer occurs. It is likely related to the large amount of data being processed. What I can include is the image you see here. My question is: how can the following happen? Is this a bug? I merge two flows, both have a lot of attributes. Requestor is 1.9m features. Supplier is 6k features. Supplier has only in ~1% of cases a value for attributes ‘X’ and ‘Y’ - the other 99% is <missing>. But supplier also has a lot of other data and attributes.After merging, for attributes x and y a lot more values are found. They are chinese or japanese characters. They are supposed to be numbers or english words.. Also I think they are getting also values from other attributes entirely, but then the actual value instead of random chinese or japanese characters. How is this happening?  I am sure that: t

I am using customer transformers in a work space, but they are converting a string value to integerThe values are 002 and 003, they need to stay this way for the http calls inside the custom transformer but are getting converted to 2 and 3 (without the 00)As read from dbAfter entry into the custom transformer​​​​Any thought on how to prevent this?I would like to have to avoid having do something in each custom transformer to revert the values back to the strings 

Hello,I'm having trouble converting shp file to City Gml, can you please help?

Hello, I have an input dataset, that has numerous fields which are Null, and only a handful of fields that are useful. I want to completely remove the attribute fields that are Null, only leaving the useful data. Input is a geo-package, and output is a file geodatabase. I have actually achieved the goal to 90% but have hit a snag, which this post is about. The geopackage has numerous layer I am doing this for, but for this post I will focus on the OBSTRN layer. My current work flow is:Reader (OBSTRN) > NullAttributeMapper (Sets Nulls to Missing) > SchemaScanner (Removes Empty Attributes) > Dynamic Writer The dynamic writer settings: Feature Class/Table Name: fme_feature_typeGeometry: From Schema DefinitionSchema Source: “Schema from Schema Feature”Schema Def Name: fme_feature_type_name

Hi all,   I am relatively new to FME, it would be greatly appreciated if someone can shed some light on a couple of problems I can't seem to figure out.  1.  Is there a transformer similar to the attribute filter transformer but would enable me to route unique value to the output port dynamically? I understand that I can using the import value function to bring in the unique attributes values, but sometimes I would only like to only filter a portion (which could be about 50 unique values) of the total number of unique values.  Inputting the required attribute value manually is laborious and prone to mistakes.   What I would like to achieve is a 2 step dynamic filter of features, each feature has a Local Government Area (LGA), and a Suburb (suburb is a subset of LGA) attribute. Depending of the first LGA filter (ideally a check box list), the second transformer would route filtered features with unique suburb attributes to an o

Hello everyone,I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench. However, I am encountering a couple of issues:Warning about inheritance relationship: The output gives a warning indicating no inheritance relationship. I have used AttributeMerge to add gml_parent_id, but the system does not seem to recognize it.<GML_2 Writer> - '12482' orphaned features found, XML comments representing these features will be present in the output file: <!-- orphaned feature - parent id:'...', id:'...', type:'...' -->Geometry export issue: It does not export correctly after setting up the geometry. In the Inspector, the data appears as a table without geometry.Additionally, the original dataset complies with the CityGML 3 standard, and its geometry's encoding is Name (encoded: UTF-

Is it possible to get the minimum pixel value, per pixel, in a multiband raster? Rasterstatisticscalculator seem to only do single bands. But what I want is to find the minimum value of a pixel in a raster of 20+ bands.  Thank you

Hi folks,In my situation, I am using JSONExtractor but the JSON queries differ between the testing and production environments. Rather than creating and maintaining two separate FME scripts, I prefer to define the target attributes and JSON queries in a database. This way, the correct configuration is used based on the environment's database.However, the challenge is that multiple rows of configuration records are retrieved (with target attributes and JSON queries as table columns). Is there an example that shows how to convert these database records and assign them to the JSONExtractor in a generic way?Thank you very much!

How to assign RED colour to this cell in final output of EXCEL file. Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file,     this is default OUTPUT  This is how I WANT 

We’re currently experience FME 2 minute+  freezes when we add an Esri GDB reader to a workbench, then press the ellipses to browse to the location.  This only happens in the dialog if we have selected Esri Geodatabase (File Geodb) as the Format.  We have found a work around of pasting the GDB path into the dialog box but we still experience a 30+ second pause when we hit Parameters/Tables.  This takes a substantial time to load. The issue is decreased when a gdb reader is added to a brand new workbench.   

Hey there,I’ve been struggling with a geometry problem. Here’s the thing :)I’m merging two datasets of building polygons. Both come from SDE geodatabases and both appear fine in Esri ArcMap and ArcGIS Pro.When I put theses geometries through a PointOnAreaOverlayer, some polygons, when written to a file geodatabase have weird behaviours in ArcMap and Pro.Their contour draws OK but they don’t fill ! 🤣 The way I solved the problem was by using a GeometryExtractor before the PointOnAreaOverlayer and GeometryReplacer after it. To me this is weird, eventhough I know there are problematic geometries in there. Besides, I tried to solve the problem with a GeometryValidator but that create many more errors. 🙄 If you have any insights about this, I’ll be happy.

I am trying to dynamically join a bunch of datasets to a lookup based on the layer and a specific attribute name and attribute value. I'm currently doing this with an attribute exploder to get the attribute name and value, but the amount of features it's creating is causing a problem when I come to spatially join it to a feature class using a spatial relator. Any suggestions?

Hello,I’m trying to connect hundrets of feature types to different transformers (see screenshot). Connecting them via “Feature Type Connections” window only works if you have a clear mapping/names for your input ports. Connecting them by hand is way to slow and error-prone.I’m sure there must be a better way. Many thanks in advance.

hello experts,I am trying something that to some of you may be quite simple so I hope one of you is able to help me out.All i am trying to do is to append/add the value cnt from the inlinequerier to the existing excel file.I am trying to write the cnt value into the count_of_errors value where the incoming feeder name is the same as the destination one (in excel file).thank you,fb

I am trying to decode attachments from my layer in ArcGIS Online into a JPEG, and it keeps failing. I tried the workflow in this article (using BinaryDecoder then go into RasterReplacer), but I get an error saying BinaryDecoder (TextEncoderFactory): Invalid Base64 character '137'. Next I tried the workflow in this other article (using just the RasterReplacer) and set the format to JPEG / JPEG2000. Doing that results in the records being sent

I am creating some attributes dynamically, which are then present but unexposed. I will not know the names of these attributes in advance. How do I expose them so I can do some downstream processing with the attribute values? I can’t use the AttributeExposer since I don’t know the attribute names in advance.

I have a 3D buffer that I want to clip with a 3D object. If I use the 3D clipper then it will be only clipped in width, but not in depth. Any solution for this problem? 

Hello,I have the JSON string format like this “[[{"name":"Column1","value":"Value1"},{"name":"Column2","value":"Value2"},{"name":"Column3","value":"Value3"}], [{"name":"Column1","value":"ValueA"},{"name":"Column2","value":"ValueB"},{"name":"Column3","value":"ValueC"}]]”And I would like to convert it to table like:------------------------------------------------Column1 | Column2 | Column3Value1    | Value2     | Value3ValueA    | ValueB    | ValueC Is there any transformer can help me to do so?

I’m trying to dynamically add a suffix to all attributes in two Excel files. The suffix will come from the last 10 characters of each Excel file (fme_basename), which is the date the file was produced. I have not been able get this to work using the BulkAttributeRenamer. When choosing the Action “Add String Suffix”, only constants appear to work. I’ve tried using the Text Editor to dynamically create the suffix in the String dialog. I’ve also tried creating the suffix beforehand with an AttribuiteCreator and choosing it for String. Neither work. I’m using FME Form 2023.2.0.0 (Build 23764). Any insight or advice?