Transformers

Hello, How can I remove all blank lines from an attribute values. Blank lines are as shown in next screenshots Thank you very much.

Encountered an issue with the DateFormatter in 2016.1I'm reading a date/time from an Oracle DB and using the DateFormatter to set the destination date format as FME Date (%Y%m%d) using automatic detection on the source date format. However,every date is returned as invalid.If I set the source explicitly as %Y%m%d%H%M%S it works fine.If i copy and paste a DateFormatter from a 2015 workspace, it works fine with exactly the same data input.Is this is known issue, all the dates are valid and auto detection worked fine previously?

I'm trying to transform a Revit file, also using his IFC file, into a CityGML format file. After TestFilter is being used to get the different parts of the building, i have to preserve the hierarchy between the openings of the building, the walls and then the windows and doors.At first i'm using the Openings as the requestor in the Transformer FeatureMerger and the result Walls from TestFilter as the supplier. Then the merge from the first transformer is being used as the supplier to a second FeatureMerger and the result from TestFilter, Windows_Doors, is set as the requestor.The thing is, although i get all the possible merged features from the first FeatureMerger, the second will list all the features into UnmergedRequestor and UnusedSupplier.Should i change anything in the geometry of the windows_doors factor or is it something completely different from what i'm thinking, that is actually missing?

Hi,I have an SQLExecutor that uses some Public Parameters in the WHERE condition. If the user leaves the Parameter blank then the query look for blank "" fields. How can I dynamically control what goes into the WHERE condition, so when the parameter is blank we exclude that condition?Thanks

I have signs along a road network and need to add a measure value attribute. I have gotten as far as Measure Extractor with valid measure values. I can't figure out the next steps. I can't use the ID field in Feature Merger as it does not know which segment belongs to which sign.

Hi,3D Tiles Writer writes default values of baseColorFactor, metallicFactor, roughnessFactor and emissiveFactor. How Can I change their default values ? Is there any Material Transformer in FME?

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