Transformers

Hi All,  I searched for quite a time, but could not find an answer...  I have some 3D solids (and some 3D surfaces) in FME. I would like to cut/split these ones using a line which is contained in a horizontal plane... I thought that creating a vertical plane with this line (which intersects the solid/surface) would be some kind of way to proceed  I know that solids can be cut using a clipper (but using another solid... not a line, nor a vertical plane).  Would anyone have a clue on how to do that (where to begin...) ?  Thanks a lot !

Hi guys,  A newbie here! I have the following question/problem:  I have to geometries sources, I have a geojson file with a specific geometry (this is an house with 4 corners, 5 coordinates), the second dataset is a city dataset that contains land parcels. The challenge is now to compare the two sources and become as outcome the affected land parcels, with affected land parcels I mean those parcels where the house is placed/located.In the first picture you can see what i did so far, i parsed the geojson file and I extracted a geometry, in the second source i extracted the land parcels geometries and adapted the coordinate system (LL84). In the second and third picture you can see both the graphics, so it works very well. Now i should "only" compare the geometries and get the affected land parcels.  Thank you in advance for your help!   

I want to make Areas Group bei Attribute POP. By making Lines and Buffer, you only get bad Areas.Close Areas like red Handskizze. Group bei POP. 3 Areas POP1 2 POP3 

I am trying to simplify a road network, turning many parallel roads into a single line. Is there a way to do this?

Hi, Simple question. Im trying to expose the X and Y coordinates from a line in a cad file.  Tried attribute exposer but its not reading when I export text file. Here is sample file. 

Hello,I would like to combine any overlapping/touching lines into one long simple geometric line.So far, what I could obtained is an aggregated geometry doing thisIntersectorNetworkTopologyCalculatorAggregatorAFter this task, I would like to extract the starting and ending vertices of the resulting lines and it fail when I used the VertexRemover because the resulting geometry is a multiple geometry (multicurve).Any ideas?

Hi folksI do encounter a problem when draping ECW appearance on a TIN generated from ERS datain fact the PDF result is white .... i attach the workspace i have no experience in this question, I only followed articles on FME knowledge center and try to success.

I have a workspace that I'm migrating from FME Workbench 2015 to FME Workbench 2018 and whenever I pick the Python interpreter ESRI ArcGIS Desktop (Python 2.7) it crashes, while it runs with no problems on the 2015 version. I tried disabling all transformers with python code and custom transformers, but FME keeps crashing. When I switch to the regular Python 2.7 interpreter it runs but I need the ESRI one for the shutdown script. Are there compatibility issues with this interpreter in the 2018 version?

Update: The technical issues have been resolved, thank you for your patience!--We are currently experiencing technical issues with our Salesforce CRM and as a result are not able to respond to open and new support cases. New support cases can still be submitted via our web form, but our response will be delayed.We apologize for the inconvenience.Thank you for your patience! 

@username: Greetings, I am trying to figure out how to complete a FME equivalent of an Oracle 'spatial join' where I read an address point feature class table, and for each record in this table extract a roofline polygon feature (based on joining an attribute 'Roof_GISID') with all associated attributes populating in the roofline dataset.. For those rooflines that are not addressed I would need this to be pulled into the final dataset as well. I have been using the FeatureJoiner transformer and can successfully seem to walk the tables and pull all associated polygons, but the attributes from the address points do not populate. Effectively what I am trying to achieve is denormalized dataset (flattened out), that a user of ArcGIS can query a stacked set of polygons and see all associated addresses without needing to use the 'Relate' option. I am using the Data Interop extension of FME in ArcPro 2.2. thanks!

Hi. How I can extend line to the point of intersection?THis is how it look now. I wont from the connected line to make polygon. Thanks!        

DateTimeConverter transformer will convert this date type 20190114000000.000However I also have null attributes so it rejects the data on reaching the first null value.I have tried using Attribute Manager and the @DateTimeParse function but keep getting this error  AttributeManagerIfValueDateParse: '%Y' was successfully parsed, then failed to parse '-%m-%d %H:%M:%S'AttributeManagerIfValueDateParse: Failed to evaluate expression '@DateTimeParse(20190114000000.000,%Y-%m-%d %H:%M:%S)'. Result is set to null. Does the function not support this date format?

I have a CAD file that has bearings of a line on one layer, distances on another and then the lines themselves on another. I have created a workbench that brings in all three layers, plus others, and then writes the lines out with attributes of the bearing and distance. I am using the NeighborFinder to get the bearing and distance closest to the line but when I write them to the output I am getting double the features that I was hoping for. As shown in the second image I am getting a line feature for each bearing and a separate one for each distance. Is there a way to just get a single line feature with both attributes on it? 

Hello community, I was using the GeographicNeighborFinder until now without a problem. Today I wanted to automate the process even more and suddenly the GNF does not match anything even if (by running the old way), it does match a few hundred items.  The things I changed: Instead of loading 2 excel files as readers -> I obtain the 2 excel files in FME: -the first one by doing a join in between 2 excel files (like a VLookup - I was doing this manually until now); -the second one via database query (I was manually updating an excel query until now);  Although with the Inspector I see the exact rows and columns I had (and would have) in the desired Excel file, the GNF does not seem to like it.  It would save me a lot of time if I could just do it as I have tried now.  Can anyone tell me where I got this one wrong?  

Hi,I upgraded R version to 3.5.1 as well as its libraries. Unfortunately I ran in to the same sqldf error message again that I encountered sometime last September 2017 when I was using R 3.2.I know Liz advised me that the solution is to install R libraries as Administrator, but then I realized that this would be a challenge for FME/R users every time R is upgraded, which happens almost every 6 months.Question is: Is there a workaround such that the FME Desktop or RCaller transformer could be configured to access packages or libraries from a specified path, regardless of whether they are installed as a client/user or Administrator?Please advise.Thanks, Wilfredo

hello, I am currently running fme build 2019.1.0.0 and I am having trouble figuring out the exact cause of my "translation failed". I believe the translation fails when more than 2000+ line feature enter the "TopologyBuilder" transformer. I am working on a new computer and I updated to 2019.1, so i am unsure if it is a bug or, perhaps, I have something within system environment that is tripping-up FME Desktop.I am trying to find the longest path of a Three-Phase Electric Line (overhead & Underground primary) to the substation feeder (dynamicprotectivedevice). Ideally, I want to manipulate the data so I can find the longest line by tracing upline from point-feature (dynamicprocteivedevice) to the end any line segment that doesnt have line features on both end. This is the first workspace of this nature I have created, so I am not too sure how to approach it. I use the topolgybuilder to find vertexes that are the end, and have no connection. I narrowed it down to

Hi,I have to area on area overlap the source polygons (shapefiles) with the data I am retrieving from 5 different SQL database connections. The shapefiles can be from the whole world and so be the database connections depending on which one to connect to. But, I would only want to read the data from the table where the source polygon exists and not the whole world.Let's say, I have the shapefile of France and Mexico and Canada, I would only read the databases(one or multiple) from these countries and not waste time in reading the whole world and then AoAO. Also, I am using workspace parameter, so no enable/disable the connections.I tried using the choice(multiple) parameters but couldn't work through.Any ideas about it. Attaching connections. Thanks. 

Hi All,How would I go about creating a circle where the perimeter passes through all three vertices of a triangle? I've attempted to use the Minimum Spanning Circle Replacer, but this creates a circle based only on the longest side of the triangle.Any ideas would be greatly appreciated.Thanks

Hi All,I am doing the geometry extraction of polylines using the geometry extractor with encoded polyline option and storing this in a dbf file formation. later part of my process is using this dbf file to replace the geometry and use this further for processing and then finally upload this on geoserver. During geometry replacer process few of the feature are getting rejected with error msg "@Geometry: Unable to replace the geometry from attribute '_GEOMETRY'." not sure how i can resolve this error .Can somebody suggest how i can resolve this ? Thank you in advance.

Hello everybody,I´m trying to find a way, how user can define source file for SchemaMapper. It´s all about editing source file for SchemaMapper on user side and then he will run a workspace.But, my main question - is there any way, how user can edit mapping file (with adding of new columns) and then incoming features will be automacally mapped? And is there any way, how can user choose a mapping file? I checked that at choosing mapping file, there is no possibility to set source mapping file as parameter. Do You have any idea, how to dynamically change SchemaMapper transformer?Thank You so much!Lubo

I need to read Oracle/MSSQL SDE, I'm wondering what's fast if I need to read Geometry and Attributes (ArcSDEQuerier vs SDE Reader vs FeatureReader)?Or is this not about speed and how Reader vs Transformer is used in a workspace that I'm understanding?

With FME Server 2019, I'm using a workspace that runs fine in FME Desktop, which uses a Published Parameter used with a regex select in an Oracle query. If i try to use the default '^\\w' parameter value with Automations, it is changed to '^w' before running in FME Server. Is there a problem using the '\\' character?

Default units when writing to FBX is cm (according to the logfile). I need to write to meters. I have tried using the Scaler, Affiner etc, but the "header" of the FBX still gets written as cm. I also tried to write to ASCII FBX and see if I could scale up the file afterwards - but with no luck. Now I tried to create a new coordinate system that is a copy of an existing one - but with units cm instead - to see if this "tricks" FME to think it is already in cm - even if it is in meter.The issue is that the opening software (Navisworks) seems to try to convert the geometry but not the material/texture/raster-coordinates. Anyhow it might be usefull to be able to write to m instead of cm.

I am using a sorter in 2019.0 right after a FeatureJoiner. I have two fields where all the values are changed after the Sorter. I create the fields using the sub() function in an AttributeManager before the join and sort. Many of the values are null. On the other side of the Sorter they're numeric with a maximum of 255 (telling). Anyone else observed this? If I run the Sorter prior to the Joiner I do not see this error. I'm sorting on a couple of other fields, and neither of the fields that are being updated.

Hi,I would like to replace the texts in my excel list (possibly also different formats).for example:in Python it looks like this:in Attribute "street"def replace(field):if"straße" in field:return field.replace("straße", "str.")elif"Straße" in field:return field.replace("Straße","Str.")elif"strasse" in field:return field.replace("strasse","str.")elif"Strasse" in field:return field.replace("Strasse","Str.")elif"ä" in field:return field.replace("ä","ae.")elif"ö" in field:return field.replace("ö","oe.")elif"ü" in field:return field.replace("ü","ue.")else:return fieldwhich transformer should I use, and how? I have no experieces with it.Thanks