Transformers

Hi everyone,I’m hopeful somebody here will have seen this behaviour before and can help me to understand what’s going on. I’m getting an error when trying to decode some Base64 documents that have been read out of a system but I’m not sure why and I’m not sure I can easily create a sample workflow to demonstrate it, as I’ll explain.The task is to extract specific documents form an API connected to a document management system. I’ve been able to create a workflow that will identify the required document IDs and then extract the documents into feature attributes for me.The document data that is returned to me is in Base64 format. When I post the output data into an online conversion as a test, it is converted into a usable image (in the case that I tried). From this I assume that all other documents will work similarly.When I pipe that output into a BinaryDecoder and ask it to decode the Base64 attribute, it throws an error complaining about the input.When I copy the Base64 code and add

Hello. I have three line vectors in SHP format (Red, Yellow, and Green). All of them are 100% overlapping in plan, but some are shorter than the others.Which transformer should I use to remove the overlapping area from the Green line that intersects with the Yellow line, and from the Yellow line to remove the overlapping area with the Red line? Please refer to the sketch below.I tried with Clipper but it didn’t work. Thanks in advice! 

As per my knowledge, FME does not supports reading Multi-part Annotation features from Geodatabases (File or Enterprise).Is there a way or workaround to handle reading and writing Multi-part Annotation features?

Hi All, I have a list of data features like thisName   Phone Number   CitySmith   123-456-7890     New YorkBob      987-654-3210     HustonIn addition, I have a single lookup feature like thisCompany   Idxyz             123I would like to merge the lookup feature into the list of data features like thisName   Phone Number   City             Company   IdSmith   123-456-7890     New York    xyz             123Bob      987-654-3210     Huston       xyz              123 I thought I can use transformers FeatureMerger or FeatureJoiner to do this. However, since I don’t have a common attribute to compare, neither of them works. Can anyone help me on this issue here? Thanks,-John

Hi All,I’m working on a workbench to help my team with some geo-processing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand.I have included a FeatureReader transformer at the beginning of the workflow to read a GDB containing cadastral polygon data. This is an User Parameter in the workbench therefore the user will be including the input.The GDB should always have the same fields/order, any variation in the scheme...the tool will fail,How can I check and inform the user at the beginning of the process that the scheme doesn’t follow the standard GIS schema?I was think about the SchemeScanner or ChangeDetector...but open to suggestionsHere is a very basic screenshot that shows two FeatureReaders → Features To Read (Only Schema), 

Hello everyone ,i am currently working on Lidar data , i am reading a set of points from a json file and creating vertices based on the coordinates.here is how the json file containing the Lidar data looks like :  (a bunch of (x,y) set of points)in order to make use of FME point cloud specific transformers i need to convert these points from point geometry to Point cloud geometry , any idea on how i could do that ?Thanks in advance

Hi, I‘m stuck at a simple point. I want to make the AttributeKeeper filter from @Value or a User Parameter which is created by the AttributeCreator. Is it possible? I don't find a solution.The goal is to get more attributes late in a row: test_2,test_4,_test_x in the AttributeKeeper from the AttributeCreator/User Parameter.  

Hello, I have these dataArea Category Date A  Medium  202301 A High 202305 B Medium High 202306 B Medium High 202305 B Medium High 202304 B Medium High 202303 B Medium High 202302 B Medium High 202301 C Low 202306 C Low 202305 C Medium 202304 C Low 202303 D High 202306 D Low 202305 D Low 202304 D Low 202303 E High 202306 E High 202305 E High 202304 E Medium High 202303 E Medium High 202302 E Medium High 202301 I want to count the categories that occurred 3 or more times consecutively per area. So something like these Area Category Count Same category consecutively >3 A    0 B Medium High 6 C   0 D Low 3 E High 3 E Medium High 3  I am not sure how to do it in FME. Thank you!

Hello, I have an issue with trying to use the Microsoft Word Writer. As far as I understand, I can build my Word document using multiple MSWordStyler transformers, and depending on the order of these, the document will be built differently. For example, if the “heading” goes in first, it will be at the start of the document, but if it goes in last, it will be last in the document. I have 2 MSWordStyler transformers, one table and one paragraph. I want the table to be first and the paragraph last. I got my desired result, but when I later saved my workspace my paragraph now ends up first and the table last. The order of which FME is reading the transformers has also changed. If I understand correctly FME runs the transformers in the order they appear in the Navigator, and you’re supposed to be able to change the order. I can’t do this though? I don’t get the option to move transformers up or down. I’m also supposed to be able to get the option to “Set connection runtime order” when I ri

When i use the python caller i get a translation successful, but it gives no output.I'm not very good at python, so do any of you have an idea what i did wrong? 

I am creating a geodatabase where I have buildings and all the corresponding rooms; however, when I import it into arcGIS pro, I am unable to select based on floor level. I checked the written data in fme, and all the rooms and floor levels are in the attribute table, but are merged onto one “layer”. Is there a transformer I could use that can make each floor level seperate from one another in the geodatabase? I tried using attributesplitter, attributefilter, etc. Thank you in advance!

Hello! I currently have a stored procedure in MSSQL that takes in some parameters and inserts into or updates a SQL view. I’m using a SQLExecutor transformer to run that stored procedure, passing in the feature attributes from FME as parameters for the procedure. The code in the transformer looks something like this:EXECUTE [schema_name].[procedure_name]   @id = '@Value(id)'  , @name = '@Value(name)'  , @description = '@Value(description)'And the stored procedure looks like this:ALTER PROCEDURE [schema_name].[procedure_name] @id nvarchar(100), @name nvarchar(250), @description nvarchar(250)ASBEGIN IF ((select count(*) from [schema_name].[view_name] where id=@id) =1) BEGIN UPDATE [schema_name].[view_name] SET name = @name, description = @description WHERE id = @id END ELSE BEGIN INSERT INTO [schema_name].[view_name] VALUES (@id, @name, @description) END Generally this works, but some of my attribute values (eg name and description) are long blocks of text with various s

Can i get the Publish parameter as Parameter input of the transformer?I want to customize this parameter in order to display or hide ports of Customer Transfomer.   

Hi All,I’m working on a workbench to help my team with some geoprocessing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand. I have included a FeatureReader at the start of the workflow to select a GDB containing Polygon data then I was able customise the tool to with a User parameter read the GDB and give the user the option to select the feature layer. That works fine.The challenge now is that I would need to provide the user with the option to select the relevant fields based on the Generic port, How can I set up the User Parameters to allow the user to select the relevant fields to include in the analysis? Here are some screenshots of the feature reader as well as the Parameter Preview:  

Hi,I am trying to use FME 2023 version to convert OBJ into Cesium 3DTiles.While the conversion is successful, I notice that it causes our application to becomes sluggish, and it also consumes alot more resources. The application I am using is Luciad (https://dev.luciad.com/) and the software vendor has given the following feedback after investigating the Cesium 3D Tiles data:1. The number of .b3dm tiles generated are too few, resulting in each .b3dm being to "heavy" for loading & rendering.2. No sufficient number of "level of details" To demostrate that, I created a small sample and uploaded to https://drive.google.com/file/d/1FYMHx977zB_NAJa74nqMfmLvlMqWKPog/view?usp=sharing.1. Large .b3dm files    a. The .obj that I convert to Cesium 3D Tiles has 330K triangles.    b. Only 2 .b3dm files were created. But it should have at least 33 .b3dm files (330K/10000) since I am using 10000 for Maximum Number of Triangle Faces Per Tile (see 3dtiles_setting.png)    c. It seems like the FME 3DT

Hello, the problem is the following. I have a duplicateFilter attached to 2 different featuresTypes, which have an attribute in common. I would like, however, that when there are duplicates, the features of a certain type remain in the unique port. In other words: when there are duplicates, I always want the pair of the copy that goes to unique to be of a certain feature type, always the same, and to be able to control it. Any ideas? Thanks, Pol

Hello,I’ve researched this a bit now, and most folks point to the Generalizer, maybe Thin No Point.  However, I’m not concerned about distance away from other vertices (parameters of Thin No Point), rather I’m only concerned with removing vertices that fall in a straight line under the original line.  In other words, remove vertices that don’t change the shape.  These vertices could be 1 foot away from an adjacent vertex or 1000’ feet, doesn’t matter. I’m more or less looking for a algorithm that checks whether each vertex is on-line between it’s neighbor to the left and neighbor to the right.  If it is on-line, then remove, if not, keep.  I realize that there would need to be some tolerance parameter (angle or distance offline) due to rounding, but can accept that fact. Any ideas what transformer or Generalizer parameters to choose to best achieve this?Thank you,Tyler

I need some help with this problem below. As seen below the lines have diffrent attribute ID’s 1,2 and 3. The lines 1 and 3 are moving correctely as a offet 10 meter from their first location, as seen in the picture to the left. But line number 2 are not moving as an offset, as it is an exit ramp with different attributes than line 1 and 3. I want line number 2 to move with line 1 and 3, so they are connected in the same way as the right picture, meaning same direction and shape. I already have a dataset as the right version and my first thought is to create a point layer with start- and endpoints of each line and make them always connected as line 1 and 3 are moving. How should I solve this problem as easy as possible. I have a large roadmap of these lines and problems, so this is just an example.  

Attached are simple FME-Workspaces from version 2017 and FME-Form with GeometryPropertySetters and Aggregators and the xml outputs. The 2 workspaces are exactly the same.FME 2017 writes the aixm Marking Element Geometry as expected, but FME-Form does not - the MarkingElement Geometry Feature is missing (Workaround is to use XML-Templater).Any idea, is this a bug?

Hi All,I’m getting the following error in the FeatureWriter transformer:A field type of 'number(20,version;1;cell_border_formatting;NO;text_alignment;NO;cell_protection;NO)' was specified, which is not valid. Please check the documentation on the Reader/Writer for information on valid field types...the normal GDB writer works perfectly fine with the same data...I had a look into the field types but couldn’t find the error,Any ideas?

I wish to extract a sample from a table where each attribute from some field should be represented x times. For example see below where x is 1, and the fields I want to sample from are House, Priority and Injury. Input:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand3        Ron      Gryffindor  Low        Head4        Cedric  Hufflepuff  High       Chest Output:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand4        Cedric  Hufflepuff  High       Chest

Hey.I need to count the number of characters in all text fields of my dataset.Any simple way to do this to avoid using multiple StringLengthCalculator ?

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25        What steps do I need to take to get this done? Thanks in Advance ! 

Hello,I have two questions about the HorizontalAngleCalculator transformer. 1) I simply need the AutoCAD Angle property of a line as shown below. Is HorizontalAngleCalculator the best transformer to use?  Or, better yet...is there a way to expose this property in the reader?2)  The install message for the HorizontalAngleCalculator says it’s not not created by Safe Software, but rather by “safe-lab” implying Safe Software Lab which is kind of confusing. Can someone clarify what this means and whether the transformer is trust worthy?Thank you,Tyler

Hello,I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database.I have tried to find an example online doing something similar but I had no luck.I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.