Transformers

 I tried with the transformer "substringextractor" but I remove the "1" from my thousandth when there is no comma at the beginning.  I saw that there was a transformer "LastSectionOfStringRemover", maybe it exists for the beginning? 

Hi, How can I format a string with leading zeros (eg. seven zeros) through the "Format" string function in text editor?For example, in attribute creator, I want to create a new attribute which takes input id field (e.g. its value 5), and I want to return 00000005.The screenshot below better elaborates my case. Any help is highly appreciated.Hani,

I would like create a MSWord document that includes a table that has 3 columns. The first two columns are just attributes, but the third should be a thumbnail image, whose path is stored in an attribute.  I can use the MSWordStyler to generate a table, I can also use it to add the pictures. What I haven't been able to figure out is how to add the pictures in the 3rd column of the table.

I have the xml file relating to a Geocortex Essentials site, from which I'm attempting to extract elements as FME features. However, I can't even get beyond parameters > elements to match, as I get this error: It seems to infer a format error? (I'm entirely new to XML, btw), but this site is functioning ok. Any ideas? Many thanks

Hi, I was asked to write a raster of an Digital Terrain Model to an Esri ASCII Grid file. However, the aim of the end user was to maintain a precision of 3 decimal values for the pixel values, so that the file size would not get too large.  To illustrate the question I created a short sample workspace.A visual preview of the RasterNumericCreators result is shown below;At the red dot (row,col) = (0,2), we can see that the pixel value is equal to '0.0250313' (using a ~'data value encoding' of 'Real32'). After the RasterCellValueRounder, we see that the value for this specific pixel is changed to '0.025' (as desired);However, when I write out the Raster to Esri ASCII Grid, and open the result in a text editer, I see the following (only first rows/columns shown);Specifically, the indicated pixel is written out with a value of '0.02503128908574581'. For this dummy file, the file size is 9.54 kb. If however I manually update the raster file so that the

I am trying to use the looping functionality to calculate the cumulative sum of values to match a certain value (budget). Those that are less or equal to that value are saved out as output and those that don't match should go to the loop and be processed again till all the features are processed. Any idea to make it working. Thanks

I am currently trying to extract the dominant value from a given row and populate a field with the dominant value from one of the dominant fields while associating it to another value in another field.  This is how to interpret the table in general.AreaCount1 is the count for area one in AreaName1 field.AreaCount2 is the count for area two in AreaName2 field.so... on and so forth. For example:For UniqueID 10 the dominant attribute from the six AreaCount columns is 1736 (see image below). I am able to extract the dominant value by creating a new DominantValue field and applying this math function @max(@Value(AreaCount1),@Value(AreaCount2),@Value(AreaCount3),@Value(AreaCount4),@Value(AreaCount5),@Value(AreaCount6)).   The math fucntion provides me with 1736 as the dominant value from AreaCount3 (highlighted in the image above). Now... I am trying to associate the dominant value with the AreaName that it is associated with. So for UniqueID 10 that has a dominant value of 1736 the dominant

Hello everyone. I know there might be not too many using the DatasmithWriter (since I didn't find any question about it here yet). But I hope maybe someone can help or has an idea. I'm using the DatasmithWriter and got a surface that has a raster placed with the AppearanceSetter. This Raster has an Alpha Value (it's a branch, so everything around is meant to be transparent).When I write the DatasmithFile it tells me Raster could not be written (nothing more).When I remove Alpha Band it works, with Alpha it doesn't.I read Details about Datasmith, it says 32Bit, Alpha8, Int8.This is all the case for my Raster so im running out of ideas what might be the problem. Thank you in advance for any hints.

I'm reading in data from a filegdb which has an attribute of type float. I'm then writing the data to an ArcGIS Portal featureservice which has an attribute type of double. The data is read into fme with a type of 32 bit real and a value of 77.56, when this ends up in the Portal featureservice this ends up with a value of 77.55999756 Now I think I understand where the 77.55999756 comes from as if you convert 77.56 to 32 bits of binary and back again you get 77.55999755859375 But what I'd really like is for the double field to end up with a value of 77.56 (77.56000000000000227373675443232059478759765625) . Now i can achieve this by converting the attribute to a string and then to a 64 bit real value in FME before sending as an update to the writer. This then returns a value of 77.56 when i read the data back into FME which matches the value in the gdb. It also matches what would happen if I went into the portal front end and manually added the 77.56 value The question is, is

I have a date being read in from a SDE geodatabase. It is in M/D/YYYY. I have the user input a year. I want to test it against the year in the table and only select the years that match. Is it possible to parse out the year in the tester or do I have to add in a DateTimeConverter Transformer to change the format?

HI !i'm starting using FME 2018 and i would like to do something very special i don't know if i can do it ? So,i want to match two table with one attribute but sometimes this attribute is not the same in both.exemple :Table 1 : "restaurant le Bistrot" Table 2 :"auberge le bistrot" the special key word are not always at the same place. my first idea was to separate every word from one of these table in list with attributesplitter and using a "tester" searching at least 2 word from lists for making a match with my first Table but that doesn work. even with "matcher" do you know if my request is possible ? thanks !! Charles.

Hi,I would like retrieve the date of a Excel file (in the reader). The date write in the Windows explorator.I would like write this date in a field 'version' of my new file (in the writer)Thanks a lot, 

Hello,I am trying to execute below plsql statement using SQLExecuter.But the declared variable (mId) is not populating select statement "mId" value. DECLARE mId number;BEGIN  select MAX (id) INTO maxId from @Value(table);  insert into @Value(table) (ID,@Value(columnsStr)) VALUES (mId, @Value(ValueStr));END; /FME_SQL_DELIMITER / Expected output during execution: insert into table1 (ID,name) VALUES (10, 'test'); FME Output during execution: insert into table1 (ID,name) VALUES (mId, 'test');  Thanks,G 

I have set up job routing rules and I want to test that the routing rule is working fine. I have added CPU%, Memory Peak Usage, and Queue in Display Column on the grid, but there seems to be a lack of functionality on the grid or I am missing something basic.  Usecase: I want to see all the jobs which finish within 2 mins, use < 20% CPU, use <2GB memory. and want to make sure they all were assigned Micro queue. -> I am trying to filter by queue but filtering by queue is not an option.-> Grid is configurable to hide and show columns, but I can't sort by columns or add any kind of calculated field in the grid.  Is there any easy way to export this data to excel? I tried dashboards but they don't have the fields I am looking for, maybe if someone who understands the database schema of the FME server can guide us I can get help from our FME Author to adjust the workspace/dashboard to include these extra fields & filters to make administration little bit easy. I am o

i have read this article and it is useful for me ,what am i looking for but i am not sure ,how could i let feature reader to work . https://community.safe.com/s/question/0D54Q000080hQidSAE/pick-up-latest-file-from-folder-location i have found one latest file that i am looking to from sampler , but how could i open this file to check the data inside and extract attributes .the file format is excel  1. As your source, use a Directory and File Pathnames reader. 2. A Sorter that sorts descending on path_modified_date. 3. A Sampler that only lets the first feature pass. 4. A FeatureReader where Dataset is set to path_windows. this is parameters that i did for feature reader , should i change something ?

Per the TopologyBuilder documentation Generate List From Input Faces Gives the option to create a list on the Node and Edge output ports that relate to information from the input faces.  However when attempting to do so in FME 2021.2, the attributes are show on the canvas, but are not present when the Node output is inspected.Why isn't the _faces{} list propagated onto the node like is to the edge?

Hi, I have some buildings and I will remove internal walls.So for this I use surfaceonsurfaceOverlayer and tester to identify internal walls. That is working in most of the cases. Nevertheless I have a few buildings where the outer wall is removed like this: Maybe someone has similar problems?Is there a way to do a further check if wall lies on the building outline? If this is the case we have to keep this wall!How can I avoid this kind of problem?Thanks in advance 

I have about 2000 line segments that need to be aggregated based on a specific field. First I sort them based on the order they are supposed to be merged in, then I aggregate them if there's more than 1 segment. This results in about 1100 multipart polylines (not all of them are multipart, and some are just made of 1 segment, but others can be made of up to 12 segments).  This works really well for my output data, and the lines are all merged correctly. However, at a closer look, my elevation profiles don't make sense. It appears that even though the segments are in the correct order, some of the segments have a different orientation of their neighboring segment, i.e. one is going North to South, and the next is going South to North. Hopefully the attached diagram can help illustrate this.   I've tried many different transformers to try and fix this without updating the underlying dataset, but I'm not sure if there's a way to fix this in FME? Is my only option to fi

Hi, I have a file with several lines that contain information about a unique record. However only line 01 has the unique information about the property. The remainder of the lines have further information about the property and start with different numbers. The row with the main information always starts with a 01. Subsequent rows have a different number. Can someone please advise how I would add the unique reference in the example below in the second field in line 01 (19633154000) to all the rows below until you get to the next row with line 01. Many thanks. Eg01*19633154000*10870539000*0335**45-47****YORK ROAD02*1*Ground*9002*9*First*1804*12801*17163059000*7648136000*6955*WILKINSON BUSINESS PARK02*1*First*3802*3*First*0.0002*4*First*Kitchen*105*10*0**0*+0

Hi,I have polygon data of different lots of land from a city. The goal is to figure out if any two polygons together are bigger than a predefined value. That means I need to merge two adjacent polygons together, test their size and repeat that process with all other adjacent polygons. (Let's say a lot has 6 neighbours, that means I need to check 6 different combinations) This need to be repeated over the whole dataset (around 5000 polygons).The problem is I don't know how to merge the polygons individually. I tried different methods with NeighborFinder, SpatialFilter, etc. but none of them yielded the results I needed.Thanks for any input!F

In old version we just put the scripts in C:\\apps\\FME\\Python if we need to get them in Python Caller.How do we do it in the new versionsThanks

When I export a 3D solid to dwg I get a Polyface mesh instead of a 3Dsolid.How do I get 3Dsolids? 

Is it possible to filter out a single attribute value from data. I am trying to map pit data and although I have streamlined relevant pits using buffer and clipper I still have useless pits which have the same attribute value ie. 2 pits, B pits, and C pit

FME folks, We have been using FME Server's new event driven automation with great success. Our FME server workspace creates a nice HTML report page when executed and is attached to a notification email upon successful completion of the task. We were just wondering if it is possible without much modifications to simply use the HTML report in the email body instead of using plain text? While I have read and seen some FME workbenches that uses html in creating the email body, our intention is to present the HTML report created to simply appear as the email body when sent out. Any inputs regarding this topic will be greatly appreciated. If not possible now, may be it will be a good 'new idea' for future. Best wishes,Deep Bhari 

Do Cached Values not work in the Tester in Workbench 2019.1? I have 'enable feature caching' on and I see the values for inspection with each step, but when I add a Tester with an attribute I don't see the option 'Cached Values' or 'Select value'.