Transformers

I like using the automatic feature definition in the writer - attributes are defined automatically based on input. Sometimes I wish I could influence the type and width (string length, field width) of the attribute within my workflow, to ensure the attribute is written out correctly. I know I can switch to manual feature definition and change it there but that makes things harder. I've tried a number of transformers but I could not find any that would influence how the automatic setting interprets the attribute. Does anyone know of a way to do this?

I have several years of data and I would like to remove the overlapping between years and for that I' m trying to perform a clip using a custom transformer and a loop while groupping them using the variable YEAR as group by (see below).  For the first clip (i.e. the year 2000), I'm going to use data_Clippee of 2000 as input for clippee and data_Clipper of 2000 as input for clipper and this will give for the outside Output_Outside_2000.For the second clip (i.e. the year 2000), 'm going to use data_Clippee of 2001 and Output_Outside_2000 as input for clippee and data_Clipper of 2001 as input for clipper and this will give for the outside Output_Outside_2000.AT the end, I will have my last result that will be a union of data_Clipper of 2012 and Output_Outside_2011.   I have exported the customed transformed to an external fmx file but I can't define input user parameters of that fmx with the variable YEAR. What should I do to fix this so that the expression @Variable(YEAR)

Hi, I'm having a customer transformer with a group by linked on an attribute:Every feature that enters the Custom transformer (it has 3 input ports) has a value for that attribute.I'm under the assumption that the custom transformer operates as follows:reads all features, process features with value A first, next switches to value B and as last value C.However in my workspace, the custom transformer processes all features in 1 go, regardless of the group settings:(I've added a logger in the beginning to indicate on which group it's working and it's logging all 3 a few seconds apart, while the CT needs to work a few minutes on group 1 and again a few minutes on group 2 etc).Am I under the wrong assumption on how the group by should work for the custom transformer? Or am I overlooking something? Also noticed that I can't assign a attribute anymore to the group by parameter:

Whenever I run data to the ESRI feature service writer (update), it updates the data with the relevant fields correctly but for some reason geometries are now not appearing when viewing the data in ARCGIS. Has this happened to anyone else before? Screenshot below

Morning,I have a group of LiDAR point clouds which were classified in several classes.Unfortunately the client only wants the point clouds classified into 4 groups.How can I regroup several classes into the 4 classes I need? Example (class 1-2-3-4-5 to become class 1, class 6-7-8 to become class 2, 9-10-11 to become 3 etc etc)

FME 2022 Workbench is showing 'Error in Translation' after a successful Translation (See Screenshot). The Data Inspector window doesn't open after the translation. Is there a bug in FME 2022 causing this?What can I do to work around this issue?The log file is available on request.

Hi,  I am new to FME. I am having below error with one our jobs. I am not sure what is causing the issue because it is intermittent.Today it will throw an error the next day it is okay. *I have remove the structure of my table* 7239 Processing attribute 2 for LEAN or LEAN_AND_MEAN usage7240 Processed 2 elements with mode CLASSIC7241 Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE Projects.[Assets] Provider error `(-2147217900) CREATE TABLE permission denied in database 'TT'.'7242 Microsoft SQL Server Non-Spatial Writer: Failed to create the destination table for feature type `Projects.Assets'7243 A fatal error has occurred. Check the logfile above for details7244 ... Last line repeated 2 times ...7245 2022-12-09 05:03:02| 7.6| 0.0|ERROR |7246 A fatal error has occurred. Check the logfile above for details7247 2022-12-09 05:03:02| 7.6| 0.0|ERROR |

I have two separate Route Feature Types and a bunch of Point and Line events. The Route features share a common alignment (on top of each other), but they have different measure values. For illustration purposes, think of them sort of like different units stored in the geometry measures, but without any sort of equation to be able to easily convert between the units. My plan was to overlay the Route sources to get a more granular set of lines with nodes wherever a node exists in either source, and with multiple measures named by the source it came from. Once I have that combined geometry, the event translation should be as simple as generating the dynamic segments based on the first route, dissolve the lines and read the second route measures from the feature, to get my translated event. In the example below, I rename the measures for each source before sending them in to the LineOnLineOverlayer but the output lines only have 1 of the 2 source measures. I also tried Intersector, but th

Hi Community,I'm trying to convert MBTiles Raster format SQLite into ESRI File Geodatabase Raster. I have run the FME workbench from the above formats (default values) and it has created an output correctly, However the MBTiles contains much greater coverage that the resulting ESRI File. Am I missing some sort of parameter to ensure that all coverage is created rather than just a section of it? RegardsNZ

I want to make sure objects resulting from the AreaOnAreaOverlayer are wider than 5 cm. For this I use a Tolerance value of 5 cm. In some situations however, it moves the border of objects more than that value (around 20 cm) where I would expect it would just create an object of 20 cm wide. I'm using FME 2021.1 build 21619. See the attached template for the data, the situation occurs near the red arrow:

I'd like to create a WB that is capable of QR code batch production to a PDF suitable for printing. The input would be a spreadsheet containing the QR codes (text) in a column. I have the QR Code Generator but not sure how to enable it to write multiple codes. Does anyone have experience with this or recommend a B build?

We have a unique number 0 and 00 to identify paying customer.I set (0 and 00) in the AttributeFilter but both values end up on either 0 or 00 depending on wich one in the list comes first.What am i missing here? or should i set up a tester instead for each number or text value? /Tim

Hello! I am using GeometryReplacer to convert a CSV file with a column containing WKT geometry. The column in question has the name "GEOMETRI, LINJE" and contains a linestring. When using GeometryReplacer, the result is a point with a point that seems to be the centre point of the coordinates of the linestring. As an example, the string LINESTRING (280696.375713613 6653063.17617913, 280698.536236071 6653059.93539544, 280707.427616957 6653067.91270913, 280704.353027305 6653070.5718137, 280696.12642256 6653063.17617913) converts to a point with coordinates 280701.671, 6653065.356, neither of which appears in the original linestring string. The coordinate system used is ETRS89.UTM-33N, which I set using a CoordinateSystemSetter before the GeometryReplacer. All of the LINESTRING () WKT-geometries become points. Does anyone have any insight as to why this happens and what I can do to make sure that GeometryReplacer produces the expected linestring instead of a point? Thanks!

 IMX Writer: Detected in invalid table names 'RoofSurface'. This writer expects only specific table names. Please add a new IMX writer to see the valid table names I guess it has something to do with the original tables from my citygml. but how to tackle this issue? 

I would like to combine lines on the attributes in column A OR B OR C and so on. The "combine on attributes" is an AND condition. What would be the cleanest workaround to achieve this?

When I run the tool the "Band 0" values are staying the same after the reprojection transformer is run, any tips to get the new values for "Band 0"?

I see how I can create a geometry using a creator where I can specify the geometry parameters. For example, creating an Clothoid by specifying Start X, Start Y, Direction etc. But these are all values that must be hand entered. How can pass these values into an "inline" Creator to set the geometries accordingly? I see 2DArcReplacer etc but not one for Clothoids. Is there a GeometryReplacer of sorts that would let you specify the type of geometry desired and which incoming attributes to assign to the relevant Geometry Parameters?

I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

Hi, This question is linked to a previous question I posted on the community, about the number accuracy of the Esri ASCII GRID writer of FME. Please see that question for more details and screenshot, but a quick recap of it; when I created a dummy raster with Real32 interpretation, in which an original pixel value would be '0.0250313',the rounded pixel value would become '0.025',but the Esri GRID File seems to convert to Real64 interpretation and stores the value as '0.02503128908574581',whereas I would like the rounded value '0.025' to be written to the file. I noticed that this could save up to 50% in the file size. I suppose that this item is related to the Floating Point Precision and String Formatting in FME. Now I have been investigating some options for an efficient workaround to this question. I.e. to be able to create Esri ASCII Grid files that don't write out pixel values with 16 decimal values. I came up with two methods, but I think they

In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

Here is the background. Esri uses subtype/domain objects in its GDB implementation instead of native RDBMS' relational tables with foreign key constraints. The result is often "nu-disciplined" databases from the RDBMS standpoint. I hope to create relational tables to protect data assets by extracting all the domains in our GDB.

Is there a way to read and use AutoCAD's SHX Fonts with FME? I need to be able to read in a DWG, determine the font used and recreate a map, currently trying to use the PDF Writer, using the original AutoCAD SHX font.Using the PDFStyler I can choose / define a Windows Font but can't figure out if and how the AutoCAD Fonts can be defined.  

Hello FME community, I'm trying to delete or merge some layers of DWG files and write them back as DWG files. during the transformation I lose my blockreference and the blockreference is written as a polyline. I would like to know how the blockreference can be written as a block reference. the first picture refers to properties in the source and second shows properties after transformation.   

Hi All, I'm trying to identify whether a coordinate system in DWG is set to a User Coordinate System (UCS) or a World Coordinate System (WCS). Essentially want to query this in a tester transformer. Thanks in advance for any help!

Hi, I have an attribute "descripion" which contains some html code:<figure class="bs-special-article-teaser-image bs-asset--full bs-asset--square" id="SP-NjExNTY5NjMw"><div><div class="[ js-bs-lazy-image-loading ] [ bs-fixed-size__content ]" data-noscript><noscript><div><img class="bs-fixed-size__content" src="/tourismus/rundgaenge/stadtrundgang_stationen/Burgplatz287.jpg.scaled/586dd9dd596cf8b34ecc51781c490af2.jpg" alt="Burgplatz"/></div></noscript></div></div><figcaption class="bs-asset__caption"><span class="bs-asset__caption__copyright">© Braunschweig Stadtmarketing GmbH/Frank Sperling</span></figcaption></figure> <p class="bs-paragraph"> Der Burgplatz ist ein Ensemble von hoher geschichtlicher und kultureller Bedeutung. Seit dem 9. Jahrhundert lag hier der Fürstensitz der Brunonen. Herzog Heinrich der Löwe hat den Burgplatz im 12. Jahrhundert zum Zentrum der welfischen