Transformers

Morning,I would like to create a UUID in my workbench as a parameter and call it at various points through my workbench. The issue I have is that currently it keeps generating me a new UUID every time I call it. I am using the @UUID() function.Is there a way to populate the parameter once and persist it thoughout the workbench so I can use it in filenames, database table names etc. Many Thanks,Oliver

Hello, Firstly apologies if this question has already been posted. (or something similar)I have an aerial photograph of a large industrial site as a raster dataset in a gdb and the buildings on that site as multipatch.I am trying to apply the photograph as a texture on the roofs of the buildings in the multipatch.So far I have successfully used the planarity filter to separate out the roofs, applied a UUID to each roof level. I have then used these roofs to clip the raster of the full site to create individual rasters for each roof with the UUID associated with that roof.My issue is when I come to apply the texture back to the roof.I have tried to use an AppearanceStyler and then an AppearanceSetter along with a GeometryPropertySetter, but I keep getting the following error"fme_rejection_code (string): MISSING_REFERENCEE_KEY"Below is the current configuration I have

Hi All,I have a shapefile that consists of polylines (some lines are curved) and I want to calculate new attributes for the start, end, and middle xy coordinates for each line. The final results should be the original geometry but with 6 new attributes.Note that the middle coordinates need to be on the line, not the bounding box.Any thoughts on how to best accomplish this task?Regards,Michael

The TestFilter does not indicate an error (in FME 2018.1; build 18502, win64).Normally an error is indicated by a red icon on the transformer However, when I use the testfilter and something is wrong I do not see this red icon. When I look at the "TestFilter parameters window" I still don't see that something is wrong. I need the look at the "Test Conditions window" to see what is wrong. This is indicated by the red row (see image below). It would be helpful if the icon would turn red and if you could see what is wrong in the "TestFilter parameter window".Would it be possible to implement this?

Hello,we are having a problem trying to read a MongoDB collection using a FeatureReader. We are reading a large database and only require data which falls within a bounding box. The FeatureReader constriants for MongoDB include a spatial filter - but selecting one creates the following warning:`MONGODB' does not support querying by spatial predicate, but supports envelope queries.It also advises that equivilent results will be performed by FME locally, but this does not work. Envelope queries are supported, but it takes a huge amount of time.If MongoDB does not support spatial queries within FME, can anybody suggest an alternative to the Envelope query, which seems to take much longer than should be necessary.Thanks 

Ciao a tutti. Sto cercando di convertire un DWG con layer scritti in russo in shapefile.FME Data inspector mi mostra i testi in cirillico, mentre l'esportazione in SHP mi sostituisce tutti i caratteri con punti di domanda.Ho provato a usare tutte le combinazioni possibili con lo strumento AttributeEncoder senza risultati

I want be able to replace part of a generic table name with the current table name in the SQL statement within the sql transformer.for example <LAST_YR_RIN_SCHEMA> with R_2017_01_01is this something that can be done in the workbench?i was told to use a private parameter but that wouldnt work and also to use a creator followed by attribute_creator followed by the sql_executor which is also not good as i only want to replace part of the table name not the entire name as shown in screen shot above.thanks for your suggestions.

I created a custom coordinate system using FME's online tool and placed the resultant files in the proper local FME folders. I can select these new coodinate system but when I try using them in a workbench, FME crashes hard when it accesses the new coordinate system. Something seems wrong with the new CS and is confirmed when I try to check the properties of it in the Coodinate System Gallery. What looks suspicious is the Ellipsoid value is missing. I used the ESRI WKT to define the parameters in the online tool and filled out all of the other empty boxes with the exception of Source.

Hi, I was wondering if it is possible to spatially sort (or even group) line data based on direction of flow? I work for a waste water company and we are required to send out extracts of our GIS data (as a spreadsheet) to our contractors so they can clean the sewers. Currently the data is not sorted in any logical order, ideally it would be in an order they could actually follow when in the field and do continuous runs of cleaning when possible. The screenshot below is an example, with some suggested ordering for each section (though there would be multiple acceptable orders): I don't know if it would be beneficial to group the data prior to trying to sort it? The order of the groups wouldn't matter too much, its just more to ensure the data always starts upstream in that group.

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.