Transformers

Hi,I'm just getting into adopting 2018 for my daily work.One thing immidiatedly annoys me in 2018, a feature that's been changed since 2017:Whenever I try to select a number of transformers inside a bookmark, using a selector rectangle, the bookmark moves !!!How do I turn this "feature" off ?I cannot really see why this (default) behaviour has been changed. The need to select transformers in a large bookmark outweighs the need to move a bookmark by clciking in the canvas, imho. Selection inside a bookmark has almost been made annoyingly cumbersome, Ctrl-Clicks and starting the rectangle selection outside the bookmark seems to be the only options now.Does it have something to do with the new collapsable bookmarks ?Cheers

Has anyone has success reading in either numeric or decimal data types from Red Shift?I am using 2018.0, and after successfully connecting to the Red Shift database, I cannot see any fields that have a numeric or decimal data type.I can see double precision and float types successfully.

I would like to know how I can do conversion of a map of characters, texts where I have different or special characters with accentuation.

HelloIs there a way we could copy only the schema ( table name and related attribute ) no data into another database, SQL server, and Postgres, multiple table at once Thanks

I have a dataset with a local origo. It is based on UTM 32N.  I have been supplied with the seven parameters used for transformation into regurlar UTM 32N.Reading the FME documentation, I have tried to add a custom transformation using 7PARAMETER method, but I cannot access it from FME.  The closest I get is the Csmapprojector, but it is not cooperating: I cannot use my defined transformation as the local coordinate system is not defined.  (Having the parameters for the transformation already, this should be irrelevant - as it is in other software I used before). Trying to create a custom coordsys also isn't bringing me very far.  For some reason, if I have my custom Coord I cannot see my custom transformation.  And vice versa. From my MyCoordSysDefs.fme:COORDINATE_SYSTEM_DEF CustomerLocal.UTM-32N        \   DESC_NM    "Local for customer based on UTM32N" \   SOURCE     "Customer"                           \   GROUP      Project

I am trying to do a -75 puffer on a polygon but due to the problem in the title I can´t get any further. Does anyone have any tips to make the bufferer work?

Hi allI have an attribute whose values are all written in PascalCase, for example "PleaseHelpMeOutHere".I'd like to add a space at any capital letter, making a more readable string "Please Help Me Out Here". I don't need to preserve the original attribute.To make it a little more complicated, some attributes have more than one capital letter, which I'd like to preserve (except for the last capital, which denotes a new word). For example "SOSHelpMeOutHere" becomes "SOS Help Me Out Here"My guess would be that using a StringReplacer with Regex would work, but Regex is a foreign language to me. I could always use a PythonCaller, but I'd prefer to avoid that if possible. Thanks

Howdy,I need to split a memo field (WrkDesc) that is over 2500 characters into several fields that are 255 characters or less (WrkDesc1, WrkDesc2, WrkDesc3, etc). Right now I laid out a bunch of SubstringExtractors which each grab a different section of the text (0-254, 255-508, 509-762, etc) and it works fine. However it seems like I should be able to do this within a single transformer like AttributeSplitter.In the AttributeSplitter help it says "Alternatively, instead of using a delimiter character you can provide a string in the format #s#s#s, where each number is the length of the substring you wish to extract."The way I interpreted that statement, for Parameter> Delimiter or Format String I inserted this: 254s508s762s1016s1270s1524s1778s2032s2286s2540s2794s and generated a list named _listW

Hello,I am attempting to modify the "" to fit our workflow. I've got it almost working, except there seems to be a scaling issue. The primary change is that we use DGN more than DWG. The buildings, ortho and terrain are shown, but the buildings seem to be scaled differently than the orthophoto. When I output a collada file, the buildings sit where they are supposed to over the ortho. I also have a geometry issue, so I had to pipe the "rejected" output to the PDF, which worked fine, except for the scaling issue. Below is a link to the test data. Thanks for any help!!!https://drive.google.com/file/d/1nXF1B4kNjoyH_ij2HTUImWgfMguORVfB/view?usp=sharing

I'm reading an ArcSDE polygon layer (British National Grid), running it through the Aggregator, then writing to a TDE. But I get a warning in the log "TDE does not support geometry on feature". I can't see much in the way of parameters to change to try and fix this. Any ideas? FME 2018.0.1.0 (20180518 - Build 18310 - WIN64)

I have an arbitrary rectangle I need to subdivide into equal tiles. I would like to optimise the number of tiles according to the following constraints in order of priority: The original rectangle will always be an integer number of unitsThe maximum area of the tile is 12 units squaredAll tiles should be equal in dimensionsPreference for compact tiles (closer to square)Preference for tiles to be 8-9 units squaredPreference for tiles to be integer unitsPreference for fewer tilesThoughts on how to calculate the number of horizontal and vertical tiles given the size of the original rectangle?

Does the FME preserve network flow direction when reading and writing features that are part of a geometric network?   I'm trying to setup a workbench to push updates from one SDE to another.  The feature classes I'm trying to update are part of a geometric network and the flow direction that has been setup in the source database is something I want to be available in the destination database.  Unfortunatley, during my test the flow direction I set in the source data did not come over to the destination data.  Instead the line had indeterminant flow.  I'm using ArcSDE Geodatabase  readers and writers, and the feature type is setup as complex_edge and simple_junction(same as what is defined in my SDE).  Is there something I'm forgetting to configure?  Here's how I setup a simple test:  -Create a feature dataset in SDE -Create a line feature class and a point feature class in that SDE -Create a geometric network

Hello, I work with FME 2018 and I have generate a simple model with this version. Is possible to save models .fmw in 2016 version? I would need to open this models in 2016. If not, I could generate it again using 2016.Thanks,

The RasterExpressionEvaluator has, as far as I can see, no examples in the help file. How do you correctly format a condition such as @if((A[0])>300 && (A[0]<0), 3000, A[0]) or @if((A[0])>300 || (A[0]<0), 3000, A[0]) where the values between 0 and 300 should be 3000, and otherwise unchanged. The above expressions give an empty result. Is it maybe an idea to insert example expressions in the help file?Also, I am aware that RasterCellValueReplacer can also do this, but the options in this transformer are very limited, and I am looking for something more flexible.thanks,

Hello,I need to merge attributes of polygon to polyline that contains that polyline (polygon can contain whole polyline or just one part of it) I am using SpatialRelator with test Requestor contains Supplier as shown in image below.Problem i have is that this test merges attributes from polygons that only contains start point of polyline. Is there any other way to merge these two features? In case that polyline goes over more than one polygon it's enough to merge attributes from any of containing polygons. Blue line is polyline. With SpatialRelator polyline gets attributes of polygon 2353 but it needs to get attributes of polygon 28 or 30.

I have a dataset in Oracle. This feature class has a text-field with the following information in: 3/7/2017 1:34 PM: Object picked up by User 22/27/2017 4:50 PM: Object closed by User 32/21/2017 4:49 PM: Object picked up by User 22/20/2017 2:39 PM: New object by User 1 Where date, time and User are variables.So the next information is also in the attribute table, but at another object But I can also have the next information in the attribute:3/7/2018 1:34 PM: Object picked up by User 62/29/2018 4:50 PM: Object closed by User 41/27/2018 4:49 PM: Object picked up by User 91/18/2018 2:39 PM: New object by User 8 I would like to filter just the date where User 2/ 9 picked up the object for he first time. In the case above 2/21/2017 and 1/27/2018.

After joining two datasets on A_Field1 = B_Field1, I want to check that A_Field2 = B_Field2. I don't need to include Field2 in the join as I will be dropping B_Field2 before the Writer. It's just to catch mismatches that may be down to typos, for example.I can do this in Tester (A_Field2 = B_Field2), which correctly finds 2 mismatches out of 68,090 features.In AttributeValidator, I thought this might work:Attributes to Validate = A_Field2Validation Rule = InRule Configuration = B_Field2This matches 134 features, but rejects the rest. On the Readers, one field type is Integer while the other is Text. Could this explain it? But I thought the field types are effectively discarded once the data is read in...? And in any case, Tester works.Am I doing something wrong in AttributeValidator, or is its behaviour different from Tester?

I've been trying to create isochrones from a grid of points (shp, 1000m apart) that have the total journey times already associated with them (number format). I tried a 3D forcer and contourgenerator, but I just can't get it to work. I've popped a screenshot below. I'd be most grateful for some tips.Thanks!Renee

Does anyone have any best practices when writing to DWG-files. Using DWGStyler - grouping objects, setting colors and placing text - legends - multiple maps - infographics etc? And using templates.

Hi Im snapping a large dataset of complex polygons with donuts to remove overlaps and such, I tried the sliver remover but it takes forever and eventually crashes with no real reason why in the log, I've tried allsorts of validation to fix this but still have the problem with sliver remover crashing. So now Im using the snapper, but the problem I have is some of my really thin polygons snap to themselves creating degenerate geoms, is there a way to do segment snapping but don't snap to self?

We are giving an internal presentation next week about FME (Server) and how we use it in the organisation. Audience are the BI SAP and Informatica teams.Is there something sexier than the 2 min demo out there? e.g. https://www.safe.com/how-it-works/I'm afraid the monotone computer voice will put people to sleep.Something like @daleatsafe's video of turning on the lights at the new Safe building.

Hi,I've added a new Excel-writer (it happened also with the existing one). Now I choose the Excel-writer on the Feature type-Parameters-Panel and FME breaks down.???Is this bug already fixed in a newer Version of FME2017? I can't use FME 2018, because we work with FMEServer 2017.Thanks, Frauke

Hi all, I have a roads shapefile that is a polygon. When I convert it to a DWG using FME it comes in as a series of blocks. I have a few things that I need to do. Explode the blocks so that they aren’t polygons any more. I’ve tried: geometry coercer and deaggregator but neither of these explode the blocks.I need to be able to style the file as follows: BlueWeight 0.5mmA particular dash line type. I have created a polyline in a dwg with the style I want and used DWGStyler to select it but I can’t seem to get it to work, does the layer in the template and the layer that is to be written have to be the same name? Thanks

I am trying to connect 3d Faces together that overlap in 2d. But connect together perfectly in 3D. They are geological layers. The Topology builder certainly tells me which triangles connect to their nearest neighbours. I'm stuck on how to then create a "network_ID" based on this column. It would have to somehow iteratively connect the shin bone to the knee bone to the thigh bone etc..Any help much appreciated.

I have four LOD1 files (.xml), which present four parts of a city, how can I put these four parts together? I guess I should use a transformer, but which one? Thanks!