FME Form

I have an attribute that contains a string with 1 or more comma separated integers. The range of integers is 1 to 13. Here are some example values:102,3,57,8,9,103,25,6I need to replace each integer with a text value that I've looked up from a table such as an Excel file. I know how to use the DatabaseJoiner to look up values, but I'm not sure how to process a list of lookup values. Ideally, I'd like to sort the integers before looking up the text values. For example, "3,2" would be "2,3" before the lookup. I'd also like the option of separating the text values with a new line character instead of comma. Is what I'm trying to do possible with FME Desktop?

Hello! I have not been able to figure out to generate polygons from the roads that are of intresest. What I need to do is to generate a polygon from all points that are within 3000 meters from "from_point". That park work fine. But when I try to genereate the surface it doesnt follow the lines good enought. It's to generalized. Please se the PDF to see what I mean.  How do I generation the surface so they follow my routing better? For this task is very important because the roads are filtered only to use safe roads to my target group. With the results I get now from hullaccumulator sometimes points will be inside the polygon even tough they should not be.  Only the points that has 3000 meters or less should be included in the surface. Can anyone help me? Best regardsJesper

Hi all, I am trying to filter and extract rows from dataset A based on partial and exact match to values of dataset B. Dataset B will be different each time I run the workbench.B is actually a subset of A, generated from a separate query as part of another process. So There will always be an exact match, but there may or may not be partial matches. Where partial matches are found it will be in the form of a suffix to the ID (eg ‘v1’ at the end).My reading of this forum suggests there are two issues that make this filter more complicated: 1. dataset B is an output of another query so the values will always vary2. I need to extract instances of partial matching as well as exact matching. example:dataset A (n=4000)IDMRR_1234v1MRR_1234v2MRR_1234TR_5678TR_5678v2FG_9876 dataset B (same table structure at B, n<20)IDMRR_1234TR_5678 i wa

 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? 

I have created a workspace which has a prompt for user parameters, as I want the user to be able to run the workflow on different sets of data. The workspace reads in a set of CSVs which have identical schema, performs some transformations and then writes the data out into a single CSV. The process works for what I want it to do. The problem is when the prompt comes up to run and I choose a different set of CSVs, these CSVs have the same schema as each other but not the same schema as the previous set of data. The attributes that are used in the transformations are the same but other attributes are different and this data does not get read in. I want the reader to read in the new schema each time, but it always retains the schema from the first set of data I used to set up the reader. How can I fix this?

I'm running a workbench which contains several SQLExecutors that queries an Azure SQL database. When running the workbench we get an alert from Microsoft Defender for Cloud saying that "An application generated a faulty SQL statement on database XXX. This may indicate that the application is vulnerable to SQL injection". When looking into the case, I can see that the query raising this warning is from FME:  SELECT * INTO #fme_tempAdoDataTypeTable_spatialReader FROM ( select CustomerID, Name, PostAddress_Address1 from Customer where UPPER([Name]) = 'Hans Hansen' and UPPER(PostAddress_Address1) = 'Gates' vei 69' ) AS customQuery WHERE 1=0 Does anyone now why this warning occurs? Is it normal that FME triggers these?

Hi, I've configured a FeatureWriter to dynamically write feature classes to an ESRI Geodatabase, but I need to be able to write different feature types to different databases. I've configured the FeatureWriter to get the connection file from an attribute, but it only uses the first connection file attribute it receives, it doesn't change connection based on the attribute value of the incoming features. Is there a way to get it to do this, or do I need to setup a writer for each possible database connection?

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,

Hello, I am trying to create a report using the HTMLReportGenerator, for this case I want to show some maps according to an attribute they have, so I use the Group Processing option in the transformer by that specific attribute, but the output is just one map and a bunch of errors in the console. They say that "Map container is already initialized." or if I change all the global variables (var) that the report creates for scoped variables (let) the error says "Identifier 'map' has already been declared". Any ideas on how I can use this transformer for plotting multiple maps on a single page? Thanks.

I have a powershell script see below (that I want to convert for use with FME). I just can't seem to find a suitable way to do it. Been around FME for a while but newish to API integrations. I have an application ID and a secrete key to be used with this.Any assistance welcome.---------------------------------------------------------------------------------------------------------# Get authorisation$requestHeaders = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"$requestHeaders.Add("Content-Type", "application/json")$requestBody = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"$requestBody.Add("ApplicationId", "xxxxxxxxxxxxxxxxxxxxxxxx")$requestBody.Add("ApplicationSecret", "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx")[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls -bor [Net.S

Is it not possible to run an external python39.dll ? It seems the error is FME Supports Python 2.7 and Python 3.6 to 3.8 ? However when choosing the interpreter I assumed that it would be using the "External evnironment"?

I have to read several shapefiles that are in a second level zipped file. As an example:C:\\compressed1.zip \\compressed2.zip\\ layer.shp I get to reach the first level but when I try to reach the second level, FME gives me failures.Any idea? Thank you very much

Hi Gurus, How can we connect HANA DB using SSO? As per help available https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/sap_hana_nonspatial/add-sap-hana-connection.htm it tells you to specify the user name & password which is basic authentication. How can we use the SSO to connect to HANA DB. We already have many products like tableu or SAP BO they already connect using SSO. Thanks,Ajay

I'd like to learn how to extract end nodes (as opposed to nodes at intersections) from a list of nodes coming out of the TopologyBuilder. I'm only putting in a few alignments that intersect in the TopologyBuilder. I've seen some similar questions here but there wasn't enough detail in the answers for me to catch on. An example workflow or screenshot would be great.  

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 s

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

Hello all, I am trying to create a report header that is an image (left justified), some text (Centre Justified) and another image (right justified) but can seem to figure it out.  The images remain constant but the text will change as I want to create a "map book" series based on an attribute. My guess is that I need to add it as CSS but just need some direction as that is not my forte 🙂 Cheers Dean

I would like to try and create a map series using HTMLReportGenerator that will contain a map and a table where the user can select a feature in the table and the map zooms to the selected feature (or a new map is displayed) with the relevant information. Is this possible?

Hello, I have a satellite raster in GeoTIFF format and am trying to generate a grey8 image for selected RGB colours. Similar to what is in the attached image. Above is the RGB satellite image and below is a grey8 image for the selected RGB values with a "falloff" or "threshold value" similar to the photoshop selection filter.  I tried RasterExpressionEvaluator and the

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)).   

I am trying to write from Excel to Azure. The writer table has no primary key as it is just a staging table and doesn't need one. FME will not allow me to write to it unless I set a primary key. Azure lets me write to the table within the server so it seems like it is only FME requiring a primary key. How do I get FME to write to a writer with no primary key? This is the error message (I am not creating a new table):Microsoft SQL Server Non-Spatial Writer: Failed to create Azure table 'dbo.test_survey' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column And these are the settings

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