Transformers

Hello,I'm having difficulty getting the String Formatter to work for me (I'm confident this is the right transformer I need to use.) I am trying to convert values stored as a number such as "23.012" to text in the following format: "000.0000". The destination output being "023.0120".I'm sure it's incredibly easy, but I've had a play about with it and I'm getting nowhere.Would be massively grateful for any help.Thanks!

Hello,I am working on input datasets having different schemas. In the end of my translation, I have to inspect obtained results. I had therefore to use a testfilter and 3 (AttributeManagers + Inspectors) as shown in the screenshot. The attributes managers perform some schema mapping depending on input features (this include removing and adding attributes) Is there a way to reduce the amount of used Attribute managers and Inspectors ? My workspace is getting really big and I need to optimize it.Thank you very much.

I'm doing some data conversions using FME Workbench through Data Interoperability, and I'm having issues with the JSONTemplater. I am grabbing a field from a json that contains more json, and I want to leave it unaltered as part of my template. the fme:get-attribute XQuery alters the contents, and fme:get-json-attribute returns an error stating that the data does not contain any JSON text when it does.My template expression: {    "annotations": fme:get-attribute("annotations"),    "initialStepId": fme:get-attribute("initialStepID"),    "initialStepName": fme:get-attribute("initialStepName"),    "steps":fme:get-attribute("steps"),    "displayGrid": fme:get-attribute("displayGrid")}And an example set of data for the annotation field:"annotations" : [ { "position":"299, 109, 171, 77", "text":"This is an annotation." } ] Comes out like this with get-attribute... \"annotations\" : \"[ { \\\"position\\\":\\\"299, 109, 171, 77\\\", \\\"text\\\":\\\"This is an annotation.\\\"             

I am new to FME, so pardon the basic nature of this question. But I am trying to normalize my data.Standardization of names, such as Chevrolet to Chevy. Remove a leading " " and change the case of words.Here is what I have done:It seems logical to me, but my output doesn't get applied to my excel:Any help would be appreciated.Thanks,

I need to do some interpolations to create nice terrain models for the architects at my office. The TINGenerator isn´t enough in this case. I tested a script in R that makes an idw interpolation. My input data is pointcloud lidar data and my output/end result in FME should be a vector surface to use in cad or sketchup. I am using the lidR library in R.Should I make a raster output from RCaller first and then create a terrain model? Do I need more librarys in R? My R script is : library(lidR) las = readLAS("C:/R/win-library/3.5/lidR/extdata/Topography.laz") dtm1 = grid_terrain(las, method = "knnidw", k = 6, p = 2 ) plot3d(dtm1) The plot in the end wouldn´t be useful in this caseHow should I apply the code in RCaller with pointcloud as input and vector terrain model as wanted output? Other transformers after the RCaller could be useful?Tobias

HiI want to do something like this in FMEOriginal TableAgeNumber0-10510-201020-30230 plus4Create new attribute with range values or group values in Name field by ranges.NameNumberRange0-1050-2010-20100-2020-30220 plus30 plus420 plusThe only way I can think of is to use Attribute Creator and use conditions to set up each category range. I am hoping there is an easier way of doing this.Andrew

In FME what is the diffrence between composite-surface and multi-surface? As far as I can tell when reading the description they do pretty much the same thing. How do they diffrientiate and why would I use one rather then another?

I have a submitter workspace that should call a child workspace.The logfile says it does, however the child workspace never shows up in the job log.The log of the submitting workspace saysFMEServerJobSubmitter(ServerFactory): http://xxxxxx:8084 - Running workspace 'gdp_import2k_worker.fmw' in repository 'Geoportal'...FMEServerJobSubmitter(ServerFactory): http://xxxxxx:8084 - Job #0 submitted  This "Job#0" raises my suspicion - is there something going wrong, maybe with user permissions or the like? 

Hello everyone I have 3d lines of similar height, clipped in 2d by a line with another z-coordinate. I need to put vertexes at the intersection of the lines but on the Clipper line. I would be grateful for your susuggestions.

I have a geotiff image feeding a rasterToPolygonCoercer. I need to assign the value of the output polygons based on the input raster palette and value. How do I feed the MapInfo TAB writer the correct color from the RasterToPolygoneCoercer?

I would like to extract the value "Version" or "version" (it differs from version to version :x ) from an XML. Usually I do this with a XMLFragmenter but XML is case sensitive so i need to do it twice and aggregate it. I think it can be done easier using XQuery but having a hard time to get it to work. So my questions are:1. How to extract the value Version or version using XQuery from the next piece:<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Leveringsinformatie xmlns="http://www.kadaster.nl/schemas/klic/leveringsinformatie/v20180418" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:gml="http://www.opengis.net/gml/3.2"> <version>2.1</version></Leveringsinformatie>2. How to learn XQuery?

HiI need to expose all hidden attributes in generic way (different attributes are created from different dataset).1. With AttributeExposer I can select specified attributes. How to expose them dynamically? Is there any "magic" way to do that? '*' or something?2. How to determine by Python Script that attribute is hidden or not?

Microsoft SQL Server Spatial Reader: Connection failed. on SQL Executor even though a Reader with the exact same parameters works without issue.

I have a (4KB) png file I want to convert to a vector grid. I want each pixel in the raster to be its own cell in the vector grid.I am using RasterCellCoercerOutput Cell Geometery: PolygonsExtract Band Values As: AttributesExtract Nodata Values: YesMy question is how do I transfer the colour values of the raster to attribute values in the vector?

I have one file which contains over 500 points. I would like to use the transformer "Neighbor Finder" to count neighbors (points) for each point with 50 meters. How do I do that? Thanks so much in advance.

I'm trying to merge different raster features to one image using the overlap value option in the RasterMosaicker. My end goal is to merge these images based on how the look in RGB. The order of the layers is done using the sorter just before the merge. Using the transparency is key because you need to see the different layers when there is "a NoData pixel"The problem i'm facing now is that the NoData values differs with each raster or even that some rasters do not even have a NoData value (even do it should). For the last situation i want to translate the raster a bit so the can be used for a NoData value of 255. By visual inspection i could see that that only the withe (r=0,g=0,b=0)colour needs to be replaced with transparency.My first step is converting all 255 values in RED8, GREEN8 and BLUE8 to 254 so 255 is freed. For the next step i would like to do covert only the RED8, GREEN8 and BLUE8 values of a pixel that all three have the 0 value to 255. I tried using the RasterCellValueRe

HyI nee to connect opposite vertices within certain distance tolerance and then calculate the middle point off the connected lineThxFrancesco

Hello, The below translation aims to take regional address points and regional buildings layers and extract a certain study area based on a buildings polygon. I then try to use another spatial filter to link the address points to the buildings polygon it is located within. However I am struggling to find a way of saying 'IF address point is within polygon then take the property address and apply it to a new attribute in the building polygon'. Does anyone have any suggestions on how to link this together?

Hello,I am trying to get the elevation using a NeighborFinder. I get this error:IFMELine was given an index beyond its current range (see workspace in attached)And I get 'nan' for the elevation. Any idea why?

How do I convert geographic coordinates to UTM in FME. I have not found anything simple, I do not believe that the FME does not do it simply.thank you

I have couple workbenches processing bulk updates each night of which the point data is in NAD and the users would like the eastings/northings for the relevant state plane added as attributes.I created this transformer attached where I flow in the lat/lons, aggregate them based on the rounded coordinate to run the next transformer in a grouped by parallel processing which intersects with state plane polygons and then does the project to E/N before converting back to NAD.It's still slow - anyone have any ideas how to speed this up or do it differently?

In the DEM to TIN generation there are several steps:1.Point Selection2. TriangulationMost algorithms use Delaunay triangulation, and I am OK with that for now, but as far as the point selection I am wondering if anyone has implemented anything else beside VIP and Heuristic --- I am interested in the specific algorithm(even pseudo-code) of the Skeleton Method detailed by Dr. Fowler and Little.

I need to anonymize lat/long of crime data that I am publishing to my city's open data portal. My colleague created a ArcGIS geocoder that takes all the addresses in our municipality, rounds to the 100 block, and then creates points in the middle of the block. All my attempts using FME geocoder have failed. I'm using the REST URL and specifying the address fields but I don't get any output from the Geocoder. Prior to using the Geocoder, I had the Vertex Creator set up to handle X/Y points, reprojecting to the apporpriate format, etc. The only issue was that it was showing exact addresses. Looking for examples of using the Geocoder and/or insights into further transforming lat/long after it's extracted.

Hi, everyone, I've got two versions of a FGDB polygon feature class(original and revised), I'd like to use ChangeDetector two find the differences between them. But the output result was very odd, some added or deleted polygons looked exactly and had seem attributes. I only created a topology dataset to fix overlaps and gaps in revised data, I figureed this is issue. Then I tried the same workflow with my backup data. As expected, I got less output through added and deleted port, and most odd results were not there any more.I browsed FME Knowledge Center about ChangeDetector and I find this question is most likely the reason caused my problem. But all my data are stored in FGDB not SDE. And all FGDBs have same parameters which are default.Further more, my data is stored in longitude and latitude, if a CoordinteRounder is needed I'm not sure how to set the precision parameter.

I have a CSV file as a source to Reader with multiple fields/datatypes but there are some invalid records in it. Is there any translator to remove the invalid records before writing it to destination dataset. By Invalid records i mean - Mismatch in datatype, datalength.