Transformers

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?

We are trying to set up a nightly read of two separate folders in a OneDrive location to get a list of the files in the directories.  There are several thousand files in each directory.  Sometimes the routine will run and report less than 500 records and then when you immediately run it again it will read all of the 5,000+ records.Is there something I am not aware of on the OneDriveConnector that would be causing it to give such wildly differing results.  I am so accustomed to consistent, bulletproof results when running FME routines that unpredictable, inconsistent results is quite disconcerting.We are needing to write an inventory of files to SQL Server to use for linking in a GIS system.

I have got an excel sheet and there are some cells with just colour and i don’t wish to include them for analysis purpose / output . Without any edits in Excel sheet (eg. add some kind of numeric or standard text for colour cell etc.) i wish to remove or exclude. I also don’t wish to depend on any other column or cell value to filter rows with ORANGE colour cell  I WANT to remove / exclude entire ROW that has yellow colour in cell in Column NCR Ref   

Hello everyone,please, I try to solve one issue, that Im not clear, if FME is able to do that. Is there any way how to migrate data from VPTK (ESRI´s vector tile package) to PBF file? Thanks a lot!Lubo

Is it possible to, if I have two point datasets that both intersect a polygon dataset, filter out the points that both intersect the same polygons ? I was using spatialrelator but it only takes one point dataset at a time; i want to see which polygons are intersected by both point sets at once. Hope that makes sense. Please helpme out, thank you!

Hi All,I’m having some issues to filter raster pixels by the band expression using the RasterExpressionEvaluator tranformer,What the expression to select the pixels with the following band combination B(0)=64; B(1)=128;B(2)=104? I have used the following settings but hasn’t worked: Any ideas please? :)

I’m wondering if there is a way to add vertexes (point) to polylines at a certain distance. Lets say I have a .shp layer with several polylines. I also have a table with “errors” that have occurred somewhere on these polylines. The table have the following attributes:Column 1: Line name (containing the names of the polylines in my .shp layer)Column 2: Distance measured from XXXX (containing names of stations that connect to the polylines, this is where the distance is measured from)Column 3: Distance (km) So basically i know the exact point from where the distance is measured from, I know which polyline the error has effected, and I know the distance. Can I automatically map this out? 

Hello, I want to know how to use PointOnAreaOverlayer for a layer with more than 1 polygon.I have a polygon shapefile for Canadian provinces and a point shapefile for Canadian addresses. Both have the Province name attribute.I want to check if all points that fall in a polygon have the same name as a polygon. For example, I want to check that all points in Alberta have the province name, Alberta. I used the Grouped By Province name, but it did not work.I appreciate your assistance with this transformer or any suggestion for this test.