Transformers

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

Hi thereMy first post here, so be gentle. I have made FME workbench to calculate different kind of attributes from DWG file (line lengths, areas etc.) and export the results to Excel file. The idea is that the workbench calculates the chosen things from DWG file and distributes them according to the divider area. Calculating part is working like a charm, but I have a problem with arranging results to form I want. It is hard to explain (in English what I mean, so here is the picture that hopefully explain what iam looking after. I have spent way too much time to solve this problem by myself, so I am more than happy if someone could push me to right way.Thanks in advance!

A client at the FME World Tour in Singapore has the following questionIf I have 2 rasters (jpegs) of same image BUT different resolution and scaleWhat would be the process in FME Workbench to align them@darkspatiallord @brianatsafe

Hi allI have been tasked to try to autogenerate 4 districts based on the values of a number of points that fall within a polygon boundary.Basically I have to split a polygon into 4 parts where the sum of a number value of the point dataset is a close to equal as possible.I cant upload the real data as it is sensitive but I have created a polygon dataset and a point dataset500 random points inside a box polygon. The points all have an attribute called "value" that is also a random number.Does anyone have an idea for a workspace that can split the polygon in the box shape file into 4 coherent parts where the sum of the points falling withing the split polygons are approximately equal?Best Regards Morten

Hi all,I think I have a quite simple question here. But i'm stuck in my thoughts.I have a dataset (see left table in picture below) and I want to have an overview of which numbers are in a certain cluster. Does anyone have some hints for me?Thanks in advance!

S3-connector - what happened? Do we have a murder case - its gone?

I want a polygon that contains all points per group. (postcode)BUT the polygon may NOT contain points from another group.I want the maximum area. but it must not overlap.I have used the HullAccumulator but I get an overlap with that.the red line is what i want.

Hello FME community,I am quite a beginner with FME and I have point shapefile includes country names. Each country name divided into 2 parts and the 1st part ended with (-).How can I combine a country name and remove (-) in the following list?To this:For each name sometimes 1st part sorted at end, for example Camb-Does anyone have any ideas or potential solutions?@takashi @david_r @jlutherthomas @egomm @mark2atsafe

I've received this error -- Implicit NAD27<->NAD83 grid shifts may not be performed until Canadian or US grids are chosen -- running a workbench in FME Server that contains a CSMapReprojector reprojecting from NAD83 to NAD27. I remember choosing the US grid shift when installing workbench on my desktop, but don't recall an option for choosing this when installing FME Server. I think some information is given on how to rectify this in FME Server in the log file, but it is not adequate for me. 

I am supplying a list of 113 list attributes from a ListBuilder to a ListConcatenator How do I get this to concatenate into one long string with comma separator characters.My Results output is just    

I have two separate flows for a process as shown below (upper and lower). These two flows are separate but it is required that the lower workflow must be executed after the upper workflow has executed. To handle this, I have created two separate workbenches for each flow and i am calling the second workbench after the upper workbench has been run. Is there any way, I can merge these two workflows in a single workbench and have control on which workflow executes first?