Transformers

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.Any suggestions welcome.

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                              \   PROJ       UTM          

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 _listWkDescHowever 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 25

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 in the dataset that includes the point and line layers. 

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