Transformers

I need to add an attribute with a running counter to each row in a CSV-file. However, by using @Count() or i.e -4400+@Value(L_SAG_PK) or other similar attribute values, it seems to stop working when the resulting value exeeds 127. How do I generate bigger numeric values.

I am using the GeometryReplacer with the "OGC Well Known Text" Geometry Encoding. The Geometry Source is "CIRCULARSTRING(@Value(StartX) @Value(StartY),@Value(MidX) @Value(MidY),@Value(EndX) @Value(EndY))". It nicely creates curves from the StartXY, MidXY and EndXY coordinates. But 5% of the curves show the remainder of the curve, not the curve as it is defined by the input coordinates. What is the reason? 

Hi,  I have a diffcult time grasping the differences between FME Cloud and FME Server.  Mainly I want to use REST API to interact with FME Cloud via web forms but I can't seem to get anything to work 100%.  I trying to duplicate some of the upload examples on the demo page and it seems I must be missing something. https://playground.fmeserver.com/demos/  

Hello,  I have an attribute that has values like this (the attribute itself is RegEX expression):^[1-9]{1}[0-9]{1-3}[1-9]{1}[0-9]{5-7}$In this attribute I want to replace all - that are within {} with a ,  I tried using the String replacer by first selecting all curly brackets with dashes, like this : \\{\\d-\\d\\}And then replacing it with this:\\{\\d,\\d\\}But of course it does not work cause you cannot replace with regex.  Any ideas?  Thanks ! 

We often re-segment our Road Segment data (polygons) with GPS collected points. The points do not necessarily fall within the polygon. Is there a way to split the polygon with the point data? The image shows the result I'm after.

I am trying to use FME to remove road allowances from a feature with multiple polygons, I've tried sliver remover and dissolve with no success Please refer to the attachment for a picture of one feature that has gaps between ploygons. I would like to remove the gaps and just have one ploygon per feature.

Hi,We are getting new hardware. Our production FME server from 2013 has just 4Gb RAM.Our idea is 28Gb RAM, 4 cores, 56 Gb storage SSD for OS, 250Gb second SSD disk for FME Server installation, data such as the database and repositories and the temp scratch folder. It will be an on premise virtual machine based - sizing I have based on the D12 Azure sizing. We are an electric and gas utility with 2 engines for our FME Server. We are running predominately jobs in and out of Oracle Spatial / SDE. The FME Server is not used at the moment for Smallworld to Oracle conversions. This is carried out by the Smallworld Sync manager product.Anything you would change with the specification?Thanks,Annette

Hi,We have recently added a second FME Server for acceptance and to test upgrades etc.For now I have restored a backup of production content to the acceptance server.My idea is first create the workspace in acceptance and then bring it into production by changing parameters using named database connections or the path to the SDE connections. The acceptance workspace will be the principal workspace that is edited first for changes and then just pushed to production. Pretty straight forward. Are there any other best practices that we should be aware of? I see that there is limited Git Hub integration. https://knowledge.safe.com/questions/57930/publish-workflows-from-github-to-fme-server.html We are going to implement Git Hub via Team Foundation Server in the future but it appears you can just check the history and not overwrite a workspace. Do people store 2 versions of the workspaces in Git (one for acceptance and one for production)?We have 3 teams using the FME Server so it wil

DonutBridgeBuilder transformer works fine when output is a file geodatabase but it does not create correct polygons when output is a feature class in the enterprise geodatabase. Any idea?

I'm facing a strange situation in v2017.1 I have a fairly complicated JSON Templater, using several sub-templates, joining several inputs on a "group sub-features by"The output have most sub-templates outed as "None", and as I watched it processing, I realized the JSON Tempater started outputting some features even before receiving a single input from some of the sub-templates inputs streams. (those are quite longer to process, retrieving several additional data from the database, then using python to pivot some data and generate list of json elements itself to nest in the main json) How is that even possible ? Is it not waiting for everything being provided to it like any other junction transformers ?

I have pointcloud data for a group of buildings ( see screenshot).I would like to convert the pointcloud into a 3d model which can be used in a CAD System. The rooftops need to be converted to extruded polygons. Could anyone briefly give some ideas regarding how to do this? I have already tested the model created here on the FME youtubne channel (https://www.youtube.com/watch?v=_HCkyrS3ukY) and got some pleasing results, but the model uses simple flat polygon geometries for the rooftops. I would like to somehow create sloped roofs derived from the pointcloud. Any help would be much appreciated.

Hello everyone,I have two software that accept geometry in two different format. Software A uses WGS84 and B uses GDA94. I need to translate geo data on the fly between two system (e.g. A SQL trigger exists that updates record in other system's database table when data is updated and vice versa).I want to know how can I convert geo data from one format to other using *within SQL*. I cannot use FME Desktop and FME API since that would require solution to work outside SQL Server.Any help is appreciated, thanks in advance.Regards, Bhargav

I've figured out how to get the vertex info (Coordinate Extractor for Vertex (0) & vertex (-1)) but there doe snot appear to be a simple way to do this. What I am looking for is functionally similar to NeighborFinder. I'm in the telecom industry & I have fiber that is running down a line of poles At each end of the fiber I need to get the PoleID for the nearest Pole & add it to FromPole & ToPole fields. If NeighborFinder would work off of vertex references or X/Y Attributes it would be simple BUT it does not so I need some help.Any Ideas - preferably using native FME 2017.1 only

I created a matcher workbench to compare street attributes from two feature classes, but am getting different results when I open the feature class in catalog/map and csv vs in the inspector. It seems like there are many duplicates. Unsure why this is happening? I have the output as a feature class and csv.

Hello,I am working on a workspace where there are multiple blocs of transformers performing tasks I want to extract the output number of features from each bloc and store it somewhere (some kind of variable or parameter of it's possible), then write in the end of the log file of the translation the output number of features resulted from each bloc with some of my personnalized text. Which transformers should I Use ? Thank you very much

I would like to create drainage network from an  integer DTM input.                     Following the steps:   Fill - Fills sinks in a surface raster to remove small imperfections in the data. Flow Direction - Creates a raster of flow direction from each cell to its steepest downslope neighbor. Flow Accumulation - Creates a raster of accumulated flow into each cell. A weight factor can optionally be applied.  Corrected the mistakes of the DTM , need to extract the drainage network 

I am new to FME/GIS and using FME 2015. I have a current layer of polygons and a new layer of polygons. I am comparing the layers to determine changes. I am using AreaOnAreaOverlayer to get a new set of polygons with the merged attributes. This worked well until I received a dataset with a slight shift/offset in the polygons between the layers that is not visible when looking at them layered on top of each other. The layers look like the polygons overlap exactly and would result in one new polygon for each overlap. But instead, the AreaOnAreaOverlayer is generating a lot of new small polygons for the border around the polygons. This runs for a long time. Is there any suggestions on how best to handle this type of situation to prevent all of these new polygons from being generated?

As a part of a study project, two different data sets are to be compared (official data and free data). The comparison is modeled successfully (see image below).In addition, I would like to produce an overview that shows me which categories of a data set are in the wrong category of the other data set >> like a advanced Confusion Matrix.For this I use currently the StatisticsCalculator, which gives me the name and the feature count of the "wrong" categories. I would like to expand this list attributes by the total amount of the area (sum(area_category[i]).The result, a list with the contents .name, .count and .areaSum should be to output as XML file.I do not get these two steps modeled without further help. Are there any suggestions?  Thanks in advance Greetings from Mainz (Germany)

Hi,I use PythonCaller to reconnect lines that were splitted before, if some conditions are met.#self.LastFeature --> a line I collected before#GivenFeature --> a matching line that I want to connect to first featureself.LastFeature.getGeometry().appendLine(GivenFeature.getGeometry())Both ends meet, but the "LastFeature" doesnt change its Geometry.Can you explain, why and how to solve this? Do you have a link or search words?Thanks in advance.Andreas

Hi All,  I am using the StatisticsCalculator transformer to, obviously, get statistics on a set of attributes for a group of records. However, I am running into an error that I have never seen before and I have used the StatisticsCalulator multiple times for the similar workspace data flows. See error below:  Python Exception <NameError>: global name 'xformer' is not defined@Python failed to execute function `StatisticsCalculator.summarizeStatistics'  StatisticsCalculator_UnneededInputNuker: @Python execution failed  StatisticsCalculator_UnneededInputNuker: @Python execution failed  My research on this issue only produced mentions of this Global Name error when inputing a custom transformer or using Python caller. This is coming from a transformer from within the FME library. Has anyone experienced a similar issue and found a resolution? Happy to provide more context on my workspace if needed.

Hi all,  I am trying to merge two different datastreams into one using attribute ranges.  I have one stream that has a Attribute count (lets call it  A), it has values of 1,2,3,4,etc.  I have another stream (lets call it B) that has a Minimum Value and a Maximum value as well as some other attributes. I am trying to merge the two stream together where the first streams value (A) is between the Maximum and minimum value range of the second stream.  In other words if A = 5 and B's value range is min = 2 and max = 6 (and also contains other attributes like TYPE, CLass,etc.) i want  to merge A with B and keep the attributes other than the range attributes. IF A falls between the range of B  i want to get the attributes associated to that range.  I need yo be able to do this dynamically as it is a large dataset and manually entering in the ranges into any of the attribute range mappers is not an option.  Any thoughts? Thanks in advance for your help.

Hi there,I have 2 "road" datasets and would like to know how I could confirm whether a record from one dataset is a exact match (spatially) of a record from the other dataset??

I'm wondering how to clip my water polygon shapefile within the boundaries of one polygon within a larger dataset. I have an Admin Boundary shapefile and a Waterbody Shapefile. Instead of clipping the waterbody with the whole Admin Boundary dataset, I'd like to clip any of the water that falls within only the top half of the polygon specified in the screenshot. The FID is 23 for the polygon of interest that I would like to clip. Any help would be appreciated, thanks so much.Alex

I'm trying to copy all DGN cells inside of clipper shape which is on level 60 however, all cells have been changed to lines,shapes and other types. Is there a way to keep them as cells

HiI have a MapInfo SQL Select query which I save off as a table and I would like to do the same query as an FME workspace. When I create the MapInfo writer to save the table it save the file with the 4 filename extensions (.tab, .dat, .id and .map) whereas when I save the SQL Select query from MapInfo there are only 2 filename extensions (.tab and .dat). What I would like to know is it possible to save the FME MapInfo file with the .tab and .dat file extensions.ThanksAndy