Transformers

Hi all I 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 _listWkDesc However the output is a single list element _listWkDesc{0} with a copy of the memo fields entire original text. I had expected to see a bunch of list elements each with 254 character's

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 units The maximum area of the tile is 12 units squared All tiles should be equal in dimensions Preference for compact tiles (closer to square) Preference for tiles to be 8-9 units squared Preference for tiles to be integer units Preference for fewer tiles Thoughts 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 in the dataset that includes the point and line layers. Lines will be complex edges, a

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 2 2/27/2017 4:50 PM: Object closed by User 3 2/21/2017 4:49 PM: Object picked up by User 2 2/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 6 2/29/2018 4:50 PM: Object closed by User 4 1/27/2018 4:49 PM: Object picked up by User 9 1/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_Field2 Validation Rule = In Rule Configuration = B_Field2 This 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: Blue Weight 0.5mm A 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!

Hey! I have created a workspace that downloads a zip file containing a shp everytime the data has been updated. I now want to compare the shp in the zip file with the older shp on a ArcSDE database to see if a column has been added or removed. I have tried using a FeatureReader to read the shp in the zip but I don't know how to do the comparising step. The goal is to get notified via the Emailer when the tables has been changed(not indivudal values). What is the best method?

Hello there we get this shapefile, the project EPSG is correct but it not in the right location, it should show in Saudi Arabia we used all reprojection transformer available but it didn't work anyway to fix it The shapefile is only sample data from the WFS we are reading Thanks

How can I draw a circle with center coordinate (X,Y) and the radius value using FME

I couldn’t figure out the best practice to Convert a file from AutoCAD to GIS and then derive a new feature classes based on a specific layer fields In the ArcGIS, for example this sort of work is done as shown in the following model How could I preform the same work by using FME work bench? Thanks Rawan

I am generating a 3d pdf file. I have draped a tif file over terrain and then draped polygons for the same area. The fact the entire tif drapes to the terrain and each polygon drapes over the terrain seperately creates offsets between the raster and vector. Is there a transformer to resolve this? Perhaps I can merge the building polygons so they drape to the surface as one feature? I'm unsure what transformers will help me acheive this?

I have created a number of workspaces that end up in a FME Server project that will finally run on a different machine. My question is: How can I specify FME Server connections for example for FMEJobSubmitter or FMEServerLogRetriever that can run in the new server environment without knowledge of accounts and passwords on the target machine? For database connections this is easily possible, but I have found no way to do this with the connections in the aforementioned transformers.